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:
- Select the post type as Order.
- Select an import method.
- During mapping, map the column status with a specific value.
- 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.
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.