All WooCommerce orders can be imported with a specific status using the Order, Coupon, Subscription Import Export plugin by selecting Order as the post type, mapping the status field to the desired value during column mapping, and completing the import. This ensures every imported order is assigned the same predefined status.
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.

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.

Here is the list of all the order statuses along with their values in the column: status.
| Order statuses | Values in column: status |
| Pending Payment | pending |
| Processing | processing |
| On hold | on-hold |
| Completed | completed |
| Cancelled | cancelled |
| Refunded | refunded |
| Failed | failed |
| Draft | draft |
- 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.

Comments (2)
Jan
July 12, 2023
I have a list from our partner who resell our service. So I want to import many order to the same customer. How or where do I specify customer in the import so that I get all the orders sorted under the same customer in WP/Woocommerse?
BR / Jan
Vineetha
July 13, 2023
Hi Jan,
Thanks for reaching out! To get all the orders sorted under the same customer, you just have to specify the customer email in the customer_email column during import.