How to migrate WooCommerce orders

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.

To export WooCommerce orders:

• Click on WebToffee Import/Export(Pro) > Export.

As a first step, you need to choose the post type as Order.

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.

Data can be filtered on the basis of:

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

• On reaching Step 5, the following window will appear, from where one can:
  1. Exclude Already Exported
  2. Export line items into separate columns
  3. Export file name
  4. Choose the Export File Format
  5. Delimiter
  6. Enable FTP export

• Save the template file(if needed).
• Click on Export and export or schedule the export to finish.

To import WooCommerce orders:

• Click on WebToffee Import/Export(Pro) > Import.

As a first step, you need to choose the post type as Order.

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.

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

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.

• Click on Step 4 to proceed.

• On reaching Step 4, the following window will appear, from where one can access various advanced features such as:
  1. Update Only
  2. If order exists in the store
  3. If conflict with an existing Post ID
  4. Create User
  5. 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.
  6. Delete non-matching orders from store

• 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.