The orders in an e-commerce store require frequent imports. Let’s see the detailed steps to make that happen.
To import WooCommerce orders:
- From the dashboard, 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 Advanced import from the below options to continue with your import. The advanced import option allows us to select a particular column for import. This option will take you through a detailed process of filtering/column selection/advanced options that may be required for your import.

Step 3: Map single field
- From theOrder fields listing, one can map the required single field with the column. Then select the corresponding mapping.
Note: Columns are mapped automatically only if a matching header name is found in the input file. If not the value is left blank. If your input file header does not have exact names or if you need to edit the existing mapping you can simply click on the respective value fields corresponding to each row. Furthermore, you can also assign expressions based on the existing input file columns.
- If the field needs to append a value/expression to an existing item while importing, Click on the transform Icon and enter the expression. It basically selects/maps the particular column from the input file and computes 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.

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 Import/Scheduling
- On reaching Step 4, the following window will appear, from where you can update orders by setting the If order exists in the store option to Update.
- If order exists in the store: One can either Skip or Update the entry.
On updating the existing orders, you can even choose to update the order data even if some of the columns in the input file contain empty values.
- If order exists in the store: One can either Skip or Update the entry.
- Click on Import/Schedule to finish.

You can either import the orders directly into your store or schedule it.

Step 5: Scheduling the import
- Hit the Schedule option, and you will be taken to the cron schedule window as shown below:

The plugin supports two different schedule types:
- WordPress Cron: Upon a visit, WordPress Cron will check to see if the time/date is later than the scheduled event/s, and if it is– it will fire those events.
- schedules your job at the specified time.
- is dependent on your website visitors.
- Server Cron: You may need to trigger the URL every minute depending on the volume of data to be processed.You can use this option :
- to generate a unique URL that can be added to your system in order to trigger the events.
- if you have a separate system to trigger the scheduled events.

Also, the import/export can be scheduled on a daily, weekly, monthly, custom basis. One can also configure the time at which the import has to be scheduled.
- Click on the Custom option, and Enter the interval in minutes. You can also specify the Start time to schedule the import. This will import the orders every ‘X’ hours.

- Now click on Import/Schedule and select Import. Now the orders are imported ‘X‘ hours.
- Was this article helpful?
- Yes, thanks!Not really