How to migrate WooCommerce orders

Migrating all your WooCommerce store orders from one store to another can be dawdling. The free version of the Order / Coupon / Subscription Export Import Plugin for WooCommerce helps you to import/export all your orders to/from one store to another in an efficient and quick manner.

   To export WooCommerce orders:

• Click on WebToffee Import/Export(Basic) > 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 : exports the basic/standard fields.
•  Based on a pre-saved template : exports data as per the specifications(filters, selective column, mapping etc) from the previously saved file.
  Note: 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: Takes you through a detailed process of filtering/column selection/advanced options that may be required for your export.
  Note: You can also save this file as a template for future use.

Filter data that needs to be exported as per the below criteria.

The column names appearing in this section can be edited if required. The preferred names and choices that were last saved can be viewed on choosing a pre-saved template. One can also move the columns to reorder the arrangement.

On reaching Step 5, the following window will appear, from where one can export in batches.

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

Refer Export orders for detailed step-wise export process.

To import WooCommerce orders:

• Click on WebToffee Import/Export(Basic) > 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 : Preferred if your input file was exported using the same plugin.
•  Pre-saved template : Retains the previous filter parameters and other column specifications as per the chosen file and imports data accordingly.
  Note: 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 4 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 import:Imports data after a detailed process of filtering/column selection/advanced options. This file can be saved for future use.
  Note: You can also save this file as a template for future use.

The column names appearing in this section can be edited if required. The preferred names and choices that were last saved can be viewed on choosing a pre-saved template.

Evaluate field can be used to append a value/expression to an existing item while importing. It basically selects/maps any column from the input file and compute the values with expressions and creates output.

• Expression: Any of the operators +*/-()&@ or string constants can be used along with the attributes to manipulate the respective value. 
• Input: Select the column from the dropdown which has to be modified.
• Output: Sample value will be created based on the first record from input file.

• Click on Step 4 to proceed.

On reaching Step 4, the following window will appear, from where one can import in batches. One can either Skip or Update the entry If order exists in the store.

• Save the template file for future (if needed).
• Click on Import to finish.

Refer Import orders for detailed step-wise import process.

Know more about the plugin setup