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.

ID Name Command Note Tags Tags Command Additional Details
448427851836 #1199 UPDATE Updated notes New Tag MERGE key: value
key2: value2

If you import the table like this, the app will do the following:

  1. It will 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. It will set the “Note” field to “Updated notes”.
  4. It will add the additional Tag “New Tag” to whatever Tags this Order has (because the “Tags Command” is MERGE).
  5. 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

ID Name Command Tags Tags Command
448427851836 #1199 UPDATE New Tag MERGE

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

ID Name Command Additional Details
448427851836 #1199 UPDATE key: value
key2: value2

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
448427851836 #1199 UPDATE 2018-06-01 other

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

ID Name Command Closed At
448427851836 #1199 UPDATE 2018-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

ID Name Command Closed At
448427851836 #1199 UPDATE

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”.

ID Name Command Customer: ID
448427851836 #1199 UPDATE

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
448427851836 #1199 UPDATE Fulfillment Line 1234567890 1234567 http://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

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).