Schedule Order Import At Regular Intervals For A WooCommerce Store

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.

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

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. 

• From theOrder fields listing, one can map the required single field with the column. Then select the corresponding mapping.

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

• Click on Step 4 to proceed.

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

• Click on Import/Schedule to finish.

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

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

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

3. Now click on Import/Schedule and select Import. Now the orders are imported ‘X‘ hours.