Order Attribute Update Import
This importer enables you to update Order Attribute Values of an existing order.
1. Configuring the Import Tool
Total size of upload files must not exceed 1024M
| 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: 100000111Custom Order Attributes marked as "Is Unique" can also be used. |
2. Update Order Attributes
The Update Order Attributes import tool uses a CSV file with at least 2 columns in the following format
order_lookup,attribute_code_1,attribute_code_2,attribute_code...
There should be one order per row.
| Column | Description |
|---|---|
| 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. |
| attribute_code_1 | The attribute code to be updated. Order Attributes and codes can be found on the Orders -> Attributes page in the Admin. |
| attribute_code_2 | The attribute code to be updated. Order Attributes and codes can be found on the Orders -> Attributes page in the Admin. |
For example:
| order_lookup | po_number | warehouse_note |
|---|---|---|
| SO10000234 | 1024 | Ship Priority Mail |
There is no limit to how many attributes can be updated per order. Every column after order_lookup can be used to update another attribute.
Deleting Attribute Values
Empty CSV values will not delete attribute values. In order to delete an attribute value, use the value below(include < >):
<DELETED>
3. Running the Import
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 about 1 year ago