Order Attribute Update Import
This importer enables you to update Order Attribute Values of an existing order.
![](https://files.readme.io/9a0af77-image_36.png)
1. Configuring the Import Tool
Total size of upload files must not exceed 1024M
![](https://files.readme.io/5bb2206-image.png)
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: 100000111 Custom 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.
![](https://files.readme.io/9f36193-image.png)
Once all data has been validated, click Import to start the import.
Updated 6 months ago