To update a few fields for Shopify Orders which are allowed to be updated, you can import tables like this.
|ID||Name||Command||Note||Tags||Tags Command||Additional Details|
|448427851836||#1199||UPDATE||Updated notes||New Tag||MERGE||key: value
If you import the table like this, the app will do the following:
- It will find the existing Order by ID.
- If it will not be able to find an existing Order by that ID, it will try to find it by the Name.
- It will set the “Note” field to “Updated notes”.
- It will add the additional Tag “New Tag” to whatever Tags this Order has (because the “Tags Command” is MERGE).
- It will change the “Additional Details” value of that Order to two key:value pairs that you are importing.
It will not change any other data of that Order, only those fields.
Update only Order Tags
If you import table like this, it will just add (merge) “New Tag” to existing order tags, and will not change anything else.
Update only Additional Details
If you import a table like this, it will update only the “Additional Details” field of those orders you import.
Cancel an Existing Order
|ID||Name||Command||Cancelled At||Cancel Reason|
This import will make that order Cancelled. Although you are importing a date in the “Cancelled At” column, Shopify doesn’t allow to set the specific date when the order shows canceled (you can only export that date). So whatever date you have here, it will get canceled at the moment when you do the import.
Valid Cancel Reasons are: customer, inventory, fraud, declined, other. The default is “other“.
You can cancel only orders that are not started to be fulfilled – if an order has a fulfillment then you will not able to cancel it.
Archive an Existing Order
This import will make that order Archived. Although you are importing a date in the “Closed At” column, Shopify doesn’t allow to set the specific date when the order shows archived (you can only export that date). So whatever date you have here, it will get archived at the moment when you do the import.
UnArchive an Existing Order
When you import a “Closed At” column as an empty value – if your Shopify Order is archived, the app will unarchive it.
Change Customer Contacts
|ID||Name||Command||Customer: Email||Customer: Phone|
|448427851836||#1199||UPDATE||[email protected]||‘+1 1234567890|
This will set the customer E-mail and Phone contact information to those you are importing.
Note that if your Order has a Customer attached to it, it will not update the Customer data in the Admin – just the Order data, and specifically the “Contact Information” block in the Order Admin.
Remove the Customer from the Order
You cannot reassign another Customer to an existing Order. But you can remove that customer from the Order at least.
You can do it by importing this empty column of the “Customer: ID”.
Update Shipping Address
|ID||Name||Command||Shipping: First Name||Shipping: Last Name||Shipping: Company||Shipping: …|
|448427851836||#1199||UPDATE||New First Name||New Last Name||New Company||Any other Shipping fields that you need to update|
You cannot update the Billing Address of an existing Order. But you can update the Shipping address – all its columns to whatever you like.
Update Order – Add Fulfillments
To create new Fulfillment for an existing Order, you would need to import the lines of “Line: Type” with “Fulfillment Line”, and fill in the Fulfillment columns.
if you will not provide any “Line: …” columns, the app will create a fulfillment of all the items you have in the Order.
|ID||Name||Command||Line: Type||Line: …||Fulfillment: ID||Fulfillment: Status||Fulfillment: …|
|448427851836||#1199||UPDATE||Fulfillment Line||All the Line: columns with the line item data that are being fulfilled. This is needed so that the app can find – which lines are being fulfilled.||success||All the other Fulfillment columns with their values.|
|448427851836||#1199||UPDATE||Fulfillment Line||And repeat for as many lines as needed to include all the needed Line Items in the Fulfillment.||success|
Update Existing Fulfillment Tracking Number and Tracking URL
To update an existing fulfillment, you just need to specify additionally the “Fulfillment: ID” values – for those Fulfillments you need to update. You can update all the fulfillment fields, but for the sake of example, here is how you update the Tracking Number and the Tracking URL of the Fulfillment.
Notice that there is no need for “Line: …” columns – just the “Line: Type”.
|ID||Name||Command||Line: Type||Fulfillment: ID||Fulfillment: Tracking Number||Fulfillment: Tracking URL|
If the “Fulfillment: ID” will not be found, the app will create a new fulfillment and will include the rest of the unfulfilled products in it.
Here is the most simple file with minimal columns that you need to import to fulfill one Shopify Order: Fulfill-one-Shopify-Order.
Update Order Metafields
|ID||Name||Command||Metafield: namespace.name||Metafield: …|
|448427851836||#1199||UPDATE||Metafield Value 1||Any other Metafield <namespace> and <name> columns that you need to update.|
You just need to identify the existing Orders, set the Command columns to “UPDATE”, and then include as Metafield columns whatever metafields you need to update.
Read more about Metafields here.
Good to know
- The full list of fields that can be updated for Orders, is here in the documentation.
- You can update in the same import file many orders and any combination of those columns.
- When preparing the import file, remember that you need to call the sheet (tab) of the Excel file “Orders” (or the CSV file as Orders.csv – which can be zipped).