Home > Docs > Order / Coupon / Subscription Export Import Plugin for WooCommerce > Import All WooCommerce Orders To A Specific Status

Import All WooCommerce Orders To A Specific Status

Last updated on September 13, 2023

Using the Order, Coupon, Subscription Export Import for WooCommerce, you can easily import all orders to a specific status. To import all WooCommerce orders to a specific status:

  1. Select the post type as Order.
  2. Select an import method.
  3. During mapping, map the column status with a specific value.
  4. Use advanced options and click on Import to finish.

Consider a sample CSV having orders with different order statuses as shown below. And, you want to import all the orders to a status value completed. During the import process, map the status value as completed and click on Apply to finish.

Sample of WooCommerce orders with different order statuses

Steps to import orders to a specific status

  • Step 1: Select the Post type as Order.
  • Step 2: Select advanced as the import method. You can use the pre-saved template if you have one.
  • Step 3: Map the import columns. To import all the orders with the status Completed, set the value as completed for the column field status. Click on Apply as shown.
Setting the value as completed for the column field status
Setting the value as completed for the column field status

Here is the list of all the order statuses along with their values in the column: status.

Order statusesValues in column: status
Pending Paymentpending
Processingprocessing
On holdon-hold
Completedcompleted
Cancelledcancelled
Refundedrefunded
Failedfailed
Draftdraft
  • Step 4: Select the required advanced import options, configure batch import, and schedule imports if necessary. This action will import all the order statuses with the value Completed.

For a step-wise procedure of import, refer to How to import WooCommerce Orders.

Sample of WooCommerce orders with specific order status
Sample of WooCommerce orders with specific order status