Accessing Order CSV Imports
The CSV import tool can be accessed from the Import & Export menu.
|Import Behavior||The import type to run. The following operations can be performed:|
Change Order State/Status
Update Order Attributes
|Order Lookup Column||The field used to retrieve the order. By default, only order_increment_id is available. Order Increment is the Order Number, typically formatted: |
Custom Order Attributes marked as "Is Unique" can also be used.
The Order State Status import tool uses a CSV file with three columns in the following format.
There should be one order per row.
|order_lookup||The value used to retrieve the order. Before beginning the import, you can choose which field to use by changing the Order Lookup Column value. By default, the order_increment_id field is used. Custom Order Attributes that are marked as "Is Unique" can also be used.|
|state||The state of the order. Must be all lower case|
|status||The status code of the order. Must be all lower case|
State/Status Update Limitations
The step in the overall order workflow that the current order is in. States cannot be moved to lower levels. For example, a Completed order cannot be moved back to New
The status must belong to the state of the order. You can view/add statuses from the Orders > Order Status Settings page.
After configuring the import, click Check Data to validate the file contents. Any errors will be displayed and require the file to be re-uploaded after the fixes have been applied.
Once all data has been validated, click Import to start the import.
Updated 12 months ago