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.

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.

Order Export-Step 1

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
  •  Advanced export

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
  • Email
  • Coupons
  • Date from
  • Date to
Export order-Filter data

Step 4: Map and reorder export columns

Here, one can map and reorder the export columns under the following 3 fields:

  • Default fields
  • Meta(Custom fields)
  • Hidden meta
Export order- map and re-order

Step 5: Advanced Options/Batch Export/Scheduling

  • 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
Export orders- Advanced options
  • Save the template file(if needed).
  • Click on Export and export or schedule the export to finish.

Importing Orders

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.

Order Import-Step 1

Step 2: Select import method

Choose from the below options to continue with your import:

  • Quick import 
  •  Based on a pre-saved template 
  •  Advanced import

Step 3: Map import columns

Here, one can map the import columns under the following 3 fields:

  • Default fields
  • Meta(custom fields)
  • Hidden meta

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.
evaluate-field
  • 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:
    1. Update Only
    2. If order exists in the store
    3. If conflict with an existing Post ID
    4. Create User
    5. Delete non-matching orders from store
  • Save the template file(if needed).
  • Click on Import/Schedule to finish.
Import order-advanced options

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?
  • YesNo