Bulk Update Orders

Update Shopify Orders

To update a few fields for Shopify Orders which are allowed to be updated, you can import tables like this.

IDNameCommandNoteTagsTags CommandAdditional Details
448427851836#1199UPDATEUpdated notesNew TagMERGEkey: value
key2: value2

Importing table like this, the app will do the following:

  1. Find the existing Order by ID.
  2. If it will not be able to find an existing Order by that ID, it will try to find it by the Name.
  3. Set the “Note” field to “Updated notes”.
  4. Add the additional Tag “New Tag” to whatever Tags this Order has (because the “Tags Command” is MERGE).
  5. 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

IDNameCommandTagsTags Command
448427851836#1199UPDATENew TagMERGE

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

IDNameCommandAdditional Details
448427851836#1199UPDATEkey: value
key2: value2

By importing a table like this, it will update only the “Additional Details” field of those orders you import.

Cancel an Existing Order

IDNameCommandCancelled AtCancel Reason
448427851836#1199UPDATE2018-06-01other

Import of this table 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

IDNameCommandClosed At
448427851836#1199UPDATE2018-06-01

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

IDNameCommandClosed At
448427851836#1199UPDATE

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

IDNameCommandCustomer: EmailCustomer: Phone
448427851836#1199UPDATE[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”.

IDNameCommandCustomer: ID
448427851836#1199UPDATE

Update Shipping Address

IDNameCommandShipping: First NameShipping: Last NameShipping: CompanyShipping: …
448427851836#1199UPDATENew First NameNew Last NameNew CompanyAny 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.

IDNameCommandLine: TypeLine: …Fulfillment: IDFulfillment: StatusFulfillment: …
448427851836#1199UPDATEFulfillment LineAll 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.successAll the other Fulfillment columns with their values.
448427851836#1199UPDATEFulfillment LineAnd 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”.

IDNameCommandLine: TypeFulfillment: IDFulfillment: Tracking NumberFulfillment: Tracking URL
448427851836#1199UPDATEFulfillment Line12345678901234567http://www.dhl-usa.com/content/us/en/express/tracking.shtml?brand=DHL&AWB=1234567

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

IDNameCommandMetafield: namespace.nameMetafield: …
448427851836#1199UPDATEMetafield Value 1Any 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).