Woocommerce выгрузка заказов в excel
This plugin helps you to easily export WooCommerce order data.
Export any custom field assigned to orders/products/coupons is easy and you can select from various formats to export the data in such as CSV, XLS, XML and JSON.
Возможности плагина
- select the fields to export
- rename labels
- reorder columns
- export WooCommerce custom fields or terms for products/orders
- mark your WooCommerce orders and run «Export as…» a bulk operation.
- apply powerful filters and much more
Export Includes
Use this plugin to export orders for
- sending order data to 3rd part drop shippers
- updating your accounting system
- analysing your order data
Have an idea or feature request?
Please create a topic in the «Support» section with any ideas or suggestions for new features.
Про Версия
Are you looking to have your WooCommerce products drop shipped from a third party? Our plugin can help you export your orders to CSV/XML/etc and send them to your drop shipper. You can even automate this process with Pro version .
Скриншоты
Установка
Automatic Installation
Go to WordPress dashboard, click Plugins / Add New , type ‘order export lite’ and hit Enter.
Install and activate plugin, visit WooCommerce > Export Orders.
Manual Installation
Часто задаваемые вопросы
Please, review user guide at first.
Check some snippets for popular plugins or review this page to study how to extend the plugin.
Still need help? Create ticket in helpdesk system. Don’t forget to attach your settings or some screenshots. It will significantly reduce reply time 🙂
I want to add a product attribute to the export
Same order was exported many times
You should open section «Set up fields to export» and set «Fill order columns for» to «1st row only». The plugin repeats common information for each order item (by default).
I see only GREEN fields in section «Set up fields»
Please, unmark checkbox «Summary Report By Products» (it’s below date range)
Red text flashes at bottom during page loading
It’s a normal situation. The plugin hides this warning on successful load.
I can’t filter/export custom attribute for Simple Product
I’m sorry, but it’s impossible. You should add this attribute to Products>Attributes at first and use «Filter by Product Taxonomies».
How can I add a Gravity Forms field to export?
Plugin produces unreadable XLS file
The theme or another plugin outputs some lines. Usually, there are extra empty lines at the end of functions.php(in active theme).
I can’t export Excel file (blank message or error 500)
Please, increase «memory_limit» upto 256M or ask hosting support to do it.
When exporting .csv containing european special characters , I want to open this csv in Excel without extra actions
You should open tab «CSV» and set up ISO-8859-1 as codepage.
Preview shows wrong values, I use Summary mode
This button processes only first 5 orders by default, so you should run the export to see correct values.
Is it compatible with «WooCommerce Custom Orders Table» plugin (by Liquid Web) ?
No, as we provide a lot of filters which can not be implemented using WooCommerce classes. So we use direct access to database/tables.
Can I request any new feature ?
Отзывы
All my custom fields export beautifully!
I have set up numerous custom checkout fields for my orders and this plugin let me configure them for export in record time! Amazingly clean interface and easy steps to add, name, and sequence all the Woo fields for export! Thank you so much. I hope you continue to support this plugin. It's the best I've found.
Very useful plugin and lightning fast support!
Plugin does what it says on the box, works like a charm. I had overlooked something and ran into a problem, contacted support, got a response right away! Amazing.
Great plugin and support
Amazing plugin!
We have purchased the PRO version of this amazing plugin and it's totally worth it. It's a fully featured export suite for exporting information from orders whenever you need and Nothing out there can deliver such a great experience! We use this plugin so that we can automatically export our orders and send them to our shipping courier partner so that we can automatically register the shipments in their system without having to do it manually. We also requested support a few times and have been amazed at the attention, dedication and interest of Alex. His work definitely deserves more recognition.
this is better then pro plug in
I have try i 1 mounth customer export plugin and finally i found this plug in thank you very much for developer and i hope it will free many time 🙂 thank you very much for all
The best order export, trust me. Also, Alex is a legend in support
We have hundreds of thousands of orders and very complex requirements for auditing and accounting. For this, a reliable and exact order export is crucial. The only plugin that offers to export ALL of our required data including refunds with all associated data, coupons etc., is this one. The profile feature makes is very convenient and reliable to setup recurring tasks. What's best: Alex is a beast when it comes to customer support. I wish more vendors would have his dedication. I had two problems, one with refunds, one with paying him for the pro version. When payment hadn't worked, he just gave me the license anyway, trusting that I would pay eventually. And with the refunds problem, he engaged in a days long, intense exchange that included him logging in to our staging site, making test purchases, explaining his findings. He replied within hours, even on holidays. We finally solved the problem. Use this plugin if you want to reward yourself with an easy to use, reliable and exact export. Pay for the pro version if you want to reward Alex for his hard work 😀
Участники и разработчики
«Advanced Order Export For WooCommerce» — проект с открытым исходным кодом. В развитие плагина внесли свой вклад следующие участники:
«Advanced Order Export For WooCommerce» переведён на 3 языка. Благодарим переводчиков за их работу.
With this WordPress plugin you can do Product Import and Export for Woocommerce in Bulk with Excel instantly — Unlimited Simple products support.
Product Update Existing Simple Products with Excel easily!
Product Export for Woocommerce of your Simple Products in Excel by the hit of a button
Data mapping — Drag and drop Excel Columns to Product Fields easily. No More Hassle with CSV’s!
Ajax driven plugin to Import Products, very easy to use. All your data will be implemented on the spot, without any delay or inaccuracy.
The import products and update products features are based on Product Title entered in an Excel Column.
Lastly, import Product Categories tree with excel to later use for your products.
The PRO Version of this wp plugin allows you to do Product Import Export for WooCommerce, Simple or Variable with Multiple Attributes, Product Image & Product Gallery images as well, update products by ID, SKU or TITLE. Moreover, WPML compatibility and multilingual support for product import , Import WooCommerce Subscription Products , Schedule Product Import with CRON Job and create Import Template to Save Time, import Product Categories with their Images, all using Excel!
How to
- Create an excel or use the sample from plugin setting’s page with tou data — 1st row is the heading eg. TITLE, 2nd row will have the product title. Use 1 row for each product. Each Column represents a field to import along with your product.
- Upload the excel file on Product Excel Import & Export for WooCommerce settings page.
- Once you upload, you will see a screen where you can map the data from the excel to the product fields of WooCommerce.
- Click Upload and wait. Product Import in Bulk will function with no hassle!
Supports
- Title
- Post Status — new
- Description
- Short Description — Excerpt -NEW
- Product Category (multiple comma separated)
- Product Tags (multiple comma separated)
- Weight
- SKU
- Regular Price
- Sale Price
- Stock
- Author ID
- Url — Slug
- Virtual
- Taxables
- Tax Class
Extra
Categories/Tags are created along with the Product creation if they don’t pre exist.
If a subcategory/subtag is selected on the excel, parent categories will also be added/selected for the relevant product. NEW: this is configurable!
Lastly, added «wpeieWoo» user capability for admin, you are free to set this capability either programmatically or with a plugin like ‘User Role Editor’.
Video Instructions
PRO VERSION
- PRODUCT IMPORT — SIMPLE & VARIABLE — You can upload simple products with attributes or variables, along with their attributes and their images!
- Import WooCommerce Subscription Products
- Support for WPML WooCommerce Product Translations Import with Excel
- Import / Export Affiliate/External products
- Schedule Product Import / Update with CRON JOB
- Save Template for Product Import to save time
- UPDATE SIMPLE & VARIABLE PRODUCTS — Through WooCommerce Product Excel Importer Premium, users are free to update those products with simple attributes and variables.
- Define which attributes will be used for your Variable Products during Import
- Update by Product ID, SKU or Title. You can easily export get the necessary fields and update back.
- PRODUCT IMPORT — SIMPLE PRODUCTS WITH ATTRIBUTES: add multiple attributes,comma separated, this means you need only one Excel row for each product!
- Update Feature Supports Update by PRODUCT ID — given in the Export Feature! This was you can easily update simple products or variable, along with product variations on the fly!
- FIELDS SUPPORTED: User preConfigured Attributes, User preConfigured Custom Taxonomies, length, width, height, downloadable, download url, download expiry, download limit, virtual, purchase note, crossell ids, upsell ids, purchase note, backorders, sold individually, featured, tax class, tax status, stock status, shipping class
- CUSTOM FIELDS SUPPORT: ACF and other plugin’s post meta fields — YOU CAN ALSO manually set the name of custom field you need to be available for import & export
- Import / Export YOAST SEO Meta Product fields, like META TITLE, META DESCRIPTION
- IMPORTS PRODUCT IMAGES FROM URL — Superb flexibility here also! You can import the product images locally or choose to import them from any URL. Last but not least, you are free to refer to the image name if image exists in Media. Dropbox public folder also suppported to get the image from.
- IMPORT IMAGES IN PRODUCT GALLERY — Do you want to create an image gallery for each product? Now you can do that! You can upload unlimited product images easily by inserting multiple URLs separated using a comma in an excel column.
- Compatible with YITH WooCommerce Color and Label Variations
- Compatible with Additional Variation Images Gallery for WooCommerce
- Compatible with Perfect Brands for WooCommerce
- Compatible with Variation Swatches for WooCommerce
- IMPORTS CUSTOM TAXONOMIES — along with product creation you can import terms for any custom taxonomy which is pre assigned to post type product.
- EXPORT SIMPLE & VARIABLE PRODUCTS. The excel is providing the product or Variation ID, you can choose what products to show based on criteria and also choose which columns — product fields to export
- DELETE PRODUCTS WITH EXCEL — Just like you can import multiple products, you can delete them as well. Deleting is based on ID or product Title.
- IMPORT PRODUCT CATEGORIES with Images: you are able to import multiple product categories individually from product creation along with uploading Product Category Image. This allows you to complete your work a lot quicker, without missing out on important stuff such as e-shop categories.
- DELETE CATEGORY TERMS THROUGH EXCEL FILE
- HTML SUPPORT for PRODUCT DESCRIPTION — directly from an excel column you can right html to import as content for your product description. As simple as that!
- HTML SUPPORT for PRODUCT EXCERPT — directly from an excel column you can right html to import as content for your product exceprt. As simple as that!
- Set Default Attribute Combination for Variable Products
— Last but not least, define which WordPress role will access the plugin apart from Admin straight in settings page
Скриншоты
Установка
- Upload the plugin files to the /wp-content/plugins directory and unzip, or install the plugin through the WordPress plugins screen directly.
- Activate the plugin through the ‘Plugins’ screen in WordPress
- Use the Woo Product Importer menu link, ‘Import from Excel’ Submenu on Products or Submenu on Woocommerce or Settings link on plugins page to use the plugin.
- Upload your excel file (there is a link for a sample excel file) and proceed to data mapping and creating your products.
Часто задаваемые вопросы
How to do product import in excel for WooCommerce?
Add one row for each product and each column will refer to a product field, such as title, description, prices, etc. Example excel provided to download through plugin’s configuration scren.
Can I update the existing products for WooCommerce?
Yes, update is also supported and will be mentioned while uploading. Update is based on Title. If a title entered in an excel column exists as product in your website, this product’s fields will be updated.
Can I add categories with Excel for WooCommerce Products?
Yes, when you add a cateogory terms in excel, this will be created along with the product.
You can add them comma separated in an excel column.
How do i define if a WooCommerce Product is in stock?
By default, leaving stock column blank will create products that are ‘in stock’.
If you need the to be as ‘out of stock’, simple add ‘0’ to stock column and map it through the import process.
Can I add WooCommerce Product images (featured image) / custom taxonomies along with the product?
This feature is available in the PRO Version.
Can I add WooCommerce Product Gallery Images?
This feature is available in the PRO Version.
Can I import Orders, Coupons or Reviews with this plugin?
Can I update by SKU?
This feature is available in the PRO Version.
Can I import / update Product ACF fields or other Custom Fields?
This feature is available in the PRO Version.
The only prerequisite is that you have already created manually a product and pressed ‘PUBLISH’ after you installed and created fields with ACF or other Similar plugin, so that the entry of this custom field exists in the database.
Can I import or export WordPress Users with this plugin?
For such a feature you can use Users Import Export with Excel.
Can I update just Stock and Prices automatically with Cron?
For such a feature you can use Product Stock Manager PRO.
Can I import Coupons and Products Reviews with this plugin?
Is plugin compatible with WPML?
WPML compatibility and multilingual support product import is available in the PRO Version.
Can Other user apart from admin access the plugin?
Yes, we added «wpeieWoo» user capability for admin, you are free to set this capability either programmatically or with a plugin like ‘User Role Editor’
Simply click Quick Export to produce concise, ready to use Excel spreadshseets.
Screen-loads of export fields, filters and options are available to customise each export type, with native export integration for 125+ WooCommerce Plugins.
This WooCommerce export Plugin maintains compatibility with the latest WooCommerce release through regular Plugin updates, we also proudly maintain compatibility with legacy releases of WooCommerce.
Supported since 2012 Store Exporter for WooCommerce is maintained by an active community of store owners and developers providing feature suggestions and feedback.
WooCommerce export types
- Export Products
- Export Categories
- Export Tags
- Export Brands (*)
- Export Orders
- Export Customers (*)
- Export Users
- Export Coupons (*)
- Export Subscriptions (*)
- Export Product Vendors (*)
- Export Bookings (*)
- Export Commissions (*)
- Export Shipping Classes (*)
- Export Attributes (*)
WooCommerce export features
🔸 Toggle and save export fields
🔸 Field label editor ()
🔸 Scheduled exports ()
🔸 Export templates ()
🔸 Compatible with WordPress Multisite
🔸 Compatible with WPML (WordPress Multilingual) ()
🔸 Compatible with WP-CLI ()
🔸 Export to CSV file
🔸 Export to TSV file ()
🔸 Export to Excel 2007 (XLS) file ()
🔸 Export to Excel 2013 (XLSX) file ()
🔸 Export to XML file ()
🔸 Export to RSS file ()
🔸 Export to WordPress Media
🔸 Export to e-mail addresses ()
🔸 Export to fixed filename ()
🔸 Export to remote FTP/FTPS/SFTP ()
🔸 Export to remote POST ()
🔸 Supports external CRON ()
🔸 WP-CLI support ()
See our WooCommerce export Plugin in action
(Thanks to Martha Waugh!)
WooCommerce export filters
- Export Products by Product Category/Tag
- Export Products by Product Status
- Export Products by Type including Variations
- Export Products by Stock Status/Quantity
- Export Products by Featured
- Export Products by Date Modified
- Export Orders by Order Date
- Export Orders by Order Status (*)
- Export Orders by Customer (*)
- Export Orders by Billing/Shipping Country (*)
- Export Orders by Product (*)
- Export Orders by Product Category/Tag/Brand (*)
- Export Orders by Order ID/Invoice Number (*)
- Export Orders by Payment Gateway/Shipping Method (*)
- Export Orders by Coupon Code (*)
- Export Customers by Order Status (*)
- Export Customers by User Role (*)
(*) Requires the Pro upgrade to enable additional store export functionality.
Native export integration with 125+ WooCommerce Plugins
Just a few of the features unlocked in the Pro upgrade of Store Exporter include:
- Export All in One SEO Pack
- Export Advanced Google Product Feed
- Export Product Addons
- Export Sequential Order Number Pro
- Export Checkout Manager
- Export Checkout Manager Pro
- Export Checkout Field Editor
- Export Cost of Goods
- Export Per-Product Shipping
- Export Print Invoice & Delivery Note
- Export Local Pickups Plus
- Export WooCommerce Subscriptions
- Export Checkout Field Manager
- Export Currency Switcher
- Export WooCommerce PDF Invoices & Packing Slips
- Export WooCommerce Checkout Add-ons
- Export Product Vendors
- Export WooCommerce Jetpack
- Import fields for Product Importer Deluxe
… and many more free and Premium extensions for WooCommerce and WordPress.
Применение
- Open WooCommerce > Store Export from the WordPress Administration
- Select the Export tab on the Store Exporter screen
- Select which export type and WooCommerce details you would like to export
- Click Export
- Download archived copies of previous exports from the Archives tab
Поддержка
If you have any problems, questions or suggestions please create a topic here on the Store Exporter dedicated forum.
Reporting security issues
If you are here to report any sort of security issue with this Plugin please use this Report a Plugin vulnerability form.
Disclaimer
It is not responsible for any harm or wrong doing this Plugin may cause. Users are fully responsible for their own use. This Plugin is to be used WITHOUT warranty.
Скриншоты
Установка
- Upload the folder ‘woocommerce-exporter’ to the ‘/wp-content/plugins/’ directory
- Activate ‘WooCommerce — Store Exporter’ through the ‘Plugins’ menu in WordPress
See Usage section before for instructions on how to generate export files.
To export your products, go to All Export › New Export and select WooCommerce Products. Build your product export file by using the drag & drop tool. Run the export, then download your file.
Step 1: Create a New Export for WooCommerce Products
Go to All Export › New Export and choose a post type of WooCommerce Products. To continue, click Customize Export File.
Step 2: Customize Your WooCommerce Products Export File
In most cases, you don't need to export all of your WooCommerce product fields. WP All Export's simple Drag & Drop interface allows you to select the exact fields that you need.
To add a field to your product export, simply drag it from the Available Data section on the right to the column selection area:
Dragging a column out of the selection area and dropping it on another part of the interface removes the column from the export.
WooCommerce Product Export Fields
The available export fields are divided into the following sections: Standard, Product Data, Media, Taxonomies, Custom Fields, and Other.
WooCommerce Standard Data
Standard data is found under Available Data › Standard.
- ID: The post ID, a unique number given to every post in WordPress.
- Title: The title or name of the WooCommerce product.
- Content: A description of the product.
- Short Description: Similar to the excerpt for posts, usually a summary of the content section.
- Date: The date the product was published, in y-m-d format.
- Post Type: The post type being exported, which is product in this case.
- Permalink: The URL of the product.
- Parent Product ID: WooCommerce variable products are attached to a parent product, and this exports the post ID of that parent product (a 0 is exported for products without a parent).
WooCommerce Product Data
More detailed WooCommerce product data is in Available Data › Product Data:
- Sku: A product code used to reference and differentiate products.
- Price: The product's current price, which is the regular price unless the sale price is active and lower.
- Regular Price: The regular, full price of the product.
- Sale Price: The sale price of the product.
- Stock Status: One of several preset values. The default WooCommerce stock statuses are instock , outofstock , and onbackorder .
- Stock: The number of products currently in stock and available for sale.
- External Product URL: The affiliate link for external products.
- Total Sales: Number of times the product has been sold.
- Attributes: This will export the attribute's name, value, if it's is used in variations, if it's visible, and if it's a taxonomy or not. This data is more easily exported in the Attributes section.
- Shipping Class: If configured, it exports the name of the product's shipping class.
If your product has attributes like size or color, they will be automatically detected and added to the Attributes section at the bottom of Product Data.
WooCommerce Media
Images and file attachments associated with your WooCommerce products are in Available Data › Media. Images and files are treated the same by WordPress. There are two sections inside the Media section: Images and Attachments (not shown in the image below due to a lack of space). Both contain the same types of fields:
- URL: The URL of the file or image.
- Filename: The filename of the file or full-size image.
- Path: The path, or location on the server of the file or image.
- ID: The attachment ID of the file or image, similar to a post ID.
- Title
- Caption
- Description
- Alt Text
- Featured: The URL of the featured image
WooCommerce Taxonomies
The categories and tags attached to the products are in Available Data › Taxonomies. By default, there are only two but all custom taxonomies will be automatically detected and available here.
WooCommerce Custom Fields
Custom fields are in Available Data › Custom Fields. For example, data added to Yoast SEO would appear here.
WooCommerce Other
Other, less used product data is in Available Data › Other. This is an incomplete list with only the more important export fields:
- Status: Similar to the post status. The default product statuses are publish , draft , and private .
- Slug: The database friendy name of the WooCommerce product, used in the product URL.
- Downloadable: Whether the product is downloadable or not.
- Downloadable Files: Contains the files for that product if the product is downloadable.
- Sale Price Dates From: When the sale date starts.
- Sale Price Dates To: When the sale date ends.
- Manage Stock: If the WooCommerce product handles stock or not, exports yes or no .
- Up-Sells
- Cross-Sells
- Tax Status
- Tax Class
- Weight
- Length
- Width
- Height
Step 3: Download Your WooCommerce Product Export
After you've configured your product export, click Continue to verify your export settings. When you're ready to run your export, click Confirm & Run Export.
Once the export is complete, you will have two options to download your export file, both shown in the Click to Download section. One is the selected file type for your export (in this case, the default file type of CSV). The other is the Bundle option, which downloads a zip file that contains the export file and an import template. You can use the import template to migrate WooCommerce products to another site using WP All Import.
Here's a quick look at a typical WooCommerce product export:
Advanced Product Export Topics
Exporting to Different File Types
By default, WP All Export exports to a CSV file format. To export to Excel instead, do the following in the Drag & Drop interface:
Note, the Simple XML Feed creates a simple, single-level XML feed of your product data that will work for most cases. If you need something more sophisticated, the Custom XML Feed option lets you fully customize the structure of your XML file (including nested elements), control the names and order of the XML elements, and easily add static data to the feed. For more information on XML, see exporting WordPress data to XML.
Finally, there is a Google Merchant Center Product Feed option that lets you easily upload WooCommerce Products to the Google Merchant Center. WP All Export extracts all of the necessary information from your WooCommerce products to satisfy this feed format, with options to map categories and configure other options that are specific to Google.
Export WooCommerce Products Advanced Options
The Advanced Options panel is found just above the Export Type panel:
Use this panel to control various settings for the export file. For CSV files, these include:
- The field separator. The most common choices here are either the comma or the pipe (I) separator.
- Whether to include header row and column titles in the export.
- Settings for exporting product variations, all of which are self-explanatory.
Excel files only support the produce variations options, while XML files support both product variations options and CData tags.
Filtering WooCommerce Product Exports
Often, a user wishes to export only a subset of WooCommerce products. This subset can be based on product categories, stock availability, or any of the export fields described in the previous sections of this tutorial.
To filter your products, expand the Add Filtering Options panel near the bottom of the New Export screen, then select an Element, Rule, and Value:
In this example, you are setting:
Element = Product categories
Rule = In Product Cat
This is the same as saying, “Export WooCommerce products with a product category of 'classic'."
You can also combine multiple filters. For example, to export products with a product category of "classic" and that are currently in stock, set your filters like this:
Drag & drop even the most complex WooCommerce product exports.
Full support for all WooCommerce product data.
Product variations, custom attributes, price and stock, image galleries, categories and tags, custom fields — everything!
Custom spreadsheets in minutes.
Drag & drop to rearrange spreadsheet columns, combine data fields, and more. Excel files, CSVs, custom delimiters, etc.
XML feeds for any schema, no matter how insane.
Drag & drop to create simple feeds, or build entirely custom feeds using our advanced builder to literally write your feed in XML.
Easily import back to WordPress.
Edit exported WooCommerce product data in Excel and then import the changes, or migrate products to another WordPress site.
Feature-packed, flexible, and dead simple.
Drag & Drop to Reorder Columns
Any XML Structure
Choose between drag & drop and hand-coding to match literally any XML schema, no matter what you need.
Export Huge Amounts of Data
Multilingual Exports with WPML
Powerful Filters
Zapier Integration
Scheduled Exports
Run your WooCommerce product exports automatically on any schedule. Subscribe to our point-and-click scheduling service or set up cron jobs.
Developer Friendly
Write and test PHP inside WP All Export when setting up your WooCommerce product export. Great docs and a powerful API.
Go for a test drive right now.
Frequently Asked Questions
What type of files can I export WooCommerce products to?
WP All Export can export WooCommerce products to Excel files, custom XML feeds, and CSVs with any delimiter.
Are my custom XML requirements too complicated?
Can I export custom WooCommerce product data added by a plugin? What about WooCommerce extensions?
Yes. WP All Export automatically detects all custom fields, categories, and tags created by any theme, plugin, or WooCommerce extension.
What plugins do I need to export WooCommerce products?
To export WooCommerce products you will need WP All Export and the WooCommerce Export Add-On. If you want to import WooCommerce data, you will also need WP All Import and the WooCommerce Import Add-On.
Trusted by over 12,000 customers.
Independent freelancers, top WordPress agencies, and the biggest brands in the world choose us for their data import and export needs.
Читайте также: