Home > Docs > Import Orders and Coupons

Import Orders and Coupons

Last updated on July 22, 2025

If you own a busy online store, it is common for you to receive a huge number of orders each day, and coupons are potential tools for marketing your store products. The free version of the Order / Coupon / Subscription Export Import Plugin for WooCommerce helps you import/export all your orders and coupons from one store to another efficiently and quickly.

To import WooCommerce orders/coupons:

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

Import Orders

Step 1: Select a post type

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

Select Post Type - Import Order
Select Post Type – Import Order

Step 2: Select an import method

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.
  •  Advanced import:Imports data after a detailed process of filtering/column selection/advanced options. This file can be saved for future use.
Selecting import method
Selecting import method

Step 3: Map import columns

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.

Map Import Columns
Map Import Columns
Expression to change the format of the order date.
Change order date format using Expressions

Evaluate field

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.
Expression
Expression
  • Click on Step 4 to proceed.

Step 4: Advanced Options/Batch Import

On reaching Step 4, the following window will appear. From here, one can import in batches and link products using SKU instead of Product ID. One can either Skip or Update the entry if an order exists in the store.

Advanced options/ Batch import
Advanced options/ Batch import
  • Save the template file for the future (if needed).
  • Click on Import to finish.

Import Coupons

Step 1: Select a post type

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

Post type - Coupon
Post type – Coupon

Step 2: Select an import method

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.
  •  Advanced import:Imports data after a detailed process of filtering/column selection/advanced options. This file can be saved for future use.
Select import method - Coupon
Select import method – Coupon

Step 3: Map import columns

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

Map import column - Coupons
Map import column – Coupons

Evaluate field

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.
Evaluate Field - Coupon
Evaluate Field – Coupon
  • Click on Step 4 to proceed.

Step 4: Advanced Options/Batch Import

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 the coupon exists in the store.

Advanced Options/ Batch Import - Coupons
Advanced Options/ Batch Import – Coupons
  • Save the template file for the future (if needed).
  • Click on Import to finish.