It is quite common for a busy online store to receive huge amount of orders each day. Migrating all your WooCommerce store orders from one store to another can be dawdling. With the Order / Coupon / Subscription Export Import Plugin for WooCommerce, one can import and export all their orders from one store to another in an efficient and quick manner.
Note: It is advised to migrate the products and users of your store, before migrating orders.
Exporting Orders
To export WooCommerce orders:
- Click on WebToffee Import/Export(Pro) > Export.
Step 1: Select a post type
As a first step, you need to choose the post type as Order.
Step 2: Select an export method
Choose from the below options to continue with your export:
- Quick export from DB
- Based on a pre-saved template
Note: In this option, the template will be listed in the drop down only if you have saved it in previous exports, if you go through the Advanced export, at Step 5 you will get an option to save the template. Once you save that, next time when you want to export a pre-saved template, it will be populated within the drop down.
- Advanced export
Note: You can also save this file as a template for future use.
Step 3: Filter data
Data can be filtered on the basis of:
- Total number of orders to export
- Skip first n orders
- Order Statuses
- Product
- Coupons
- Date from
- Date to
Step 4: Map and reorder export columns
In this step, you can map all the default export columns. The columns can be edited, dragged and reordered if required. If you are exporting the orders via the pre-saved template method, then you can see the names and choices that were last saved.
Here, one can map and reorder the export columns under the following 3 fields:
- Default fields
- Meta(Custom fields)
- Hidden meta

Step 5: Advanced Options/Batch Export/Scheduling
- On reaching Step 5, the following window will appear, from where one can:
- Exclude Already Exported
- Export line items into separate columns
- Export file name
- Choose the Export File Format
- Delimiter
- Enable FTP export
Note: On expanding Advanced options, one can set the number of records that the server will process for every iteration within the configured timeout interval. If the export fails due to timeout you can lower this number accordingly and try again.
- Save the template file(if needed).
- Click on Export and export or schedule the export to finish.
Importing Orders
Download a Sample Order CSV.
Note: Orders and Products are linked using SKU or ID. On import, enable the option: “Link products using SKU instead of Product ID”, to link the products with SKU. Mostly preferred when the Product IDs on the site are different from the Product IDs in the order import file. However, this option is only useful if you have the product SKU.
To import WooCommerce orders:
- Click on WebToffee Import/Export(Pro) > Import.
Step 1: Select post type
As a first step, you need to choose the post type as Order.
Step 2: Select import method
Choose from the below options to continue with your import:
- Quick import
- Based on a pre-saved template
Note: The template will be listed in the drop down only if you have saved it in previous imports, if you go through the Advanced import, at Step 4 you will get an option to save the template. Once you save that, next time when you want to import a pre-saved template, it will be populated within the drop down.
- Advanced import
Note: You can also save this file as a template for future use.
Step 3: Map import columns
In this step, you can map all the standard columns in your CSV/XML file along with meta/attributes/taxonomies and hidden meta columns.
Here, the import columns are mapped under 3 fields:
- Default fields
- Meta(custom fields)
- Hidden meta

To import meta columns, download the Sample meta file.

Evaluate field
During import, when we have to append a value/expression to an existing item, Evaluate field is used. It basically selects/maps any column from the input file and computes the values with expressions and creates output.
- Expression: To manipulate the respective value, any of the operators +*/-()&@ or string constants can be used along with the attributes .
- Input: Select the column from the drop down which has to be modified.
- Output: On the basis of the first record from the input file, sample value will be created.
Note: Columns that have no values in the input file may cause syntax errors if used in an expression.

- Click on Step 4 to proceed.
Step 4: Advanced Options/Batch Export/Scheduling
- On reaching Step 4, the following window will appear, from where one can access various advanced features such as:
- Update Only
- If order exists in the store
- If conflict with an existing Post ID
- Create User
- Link products using SKU instead of Product ID: Preferred when the Product IDs on the site vary from the Product IDs in the order import file.
- Delete non-matching orders from store
Note: On expanding Advanced options, one can set the number of records that the server will process for every iteration within the configured timeout interval. If the import fails due to timeout you can lower this number accordingly and try again.
- Save the template file(if needed).
- Click on Import/Schedule to finish.
You can either import the orders directly into your store or schedule the import using FTP. Once the import is completed, a pop-up will be displayed showing import status which contains the number of successful imports and failed imports (if any).
Know more about the Import and Export methods of order in detail.
- Was this article helpful?
- Yes, thanks!Not really