Cancel Shopify Orders in Bulk

Cancel Shopify Orders in bulk

To Cancel existing Shopify Orders, do the following steps:

Note that this will not replace the orders – this will truly update the existing ones.

  1. Export the Orders you want to cancel – don’t include any other detailed columns unless you absolutely need them, so you have nice one row per order in the export.
  2. Delete all the columns and rows, leave only the following columns in your Excel file:
    • ID
    • Name
    • Command
    • Cancelled At
    • Cancel Reason
  3. Update the Excel file columns with data:
    1. Set the “Command” column values to “UPDATE“.
    2. Set the “Cancelled At” column values to whatever date (it doesn’t matter what date it is because orders will anyway get cancelled with today’s date).
    3. Set the “Cancel Reason” column values to one of the following: customer, inventory, fraud, declined, other. You can leave this empty, then the app will assume other by default.
  4. Import the file with the orders you want to cancel.

Good to know

Easy repeat import from your supplier data feed using Google Sheets

Repeat import from supplier data feed to Shopify

Here you will see an easy trick how you can import to Shopify from any of your supplier files or data feeds.

Set it up once, and then repeat it easily manually or even automatically at any time intervals.

Short summary:

  1. Set up the new Google Sheets document.
  2. Make two sheets there: “Data” and “Products”
  3. Import your original file from your supplier to the Data sheet.
  4. Make the formulas in the Products sheet to take the data from Data sheet.
  5. Import

Now, each time you get the new file from your supplier, you can just re-import it in the Data sheet and your Products sheet will update.

Also, if your supplier gives you the link to download your file, you can use the Google Sheets formula =IMPORTDATA(…) to import that file automatically from the supplier link.

If your mapping from your supplier file is straight forward, you can use the =QUERY(…) function to grab the data from Data sheet, just assign the names to the column using the LABEL clause in the QUERY function.

How to adjust the Inventory Quantity for Shopify Products

Adjust Shopify Inventory Quantity

You can now import the quantity adjustment of the Shopify Product inventory by importing the delta (difference) number.
So, in case you received a new shipment to your warehouse of additional x items for each product, you can just import that x number as an adjustment for your products and variants.

There is the new column in the Products sheet for that “Variant Inventory Adjust“.

If you are importing the “Variant Inventory Adjust” values then, of course, you cannot import the “Variant Inventory Qty” number – as that wouldn’t make sense to set and adjust the quantity at the same time.

For example, if you need to adjust the inventory quantity for some products, you can import the columns:

  • ID
  • Handle
  • Variant ID (or Variant SKU, or Variant Barcode, or Options columns)
  • Variant Inventory Adjust

or, if you want to just update by SKU, you can import the following columns:

  • Variant SKU
  • Variant Inventory Adjust

And you can combine the columns – fill the values for some variants in “Variant Inventory Qty” and for some the “Variant Inventory Adjust”.

Here’s one way the import file can look:

Shopify Adjust Variant Inventory Quantity import

Read more about the columns in the Products Columns Documentation.

Archive and Unarchive Shopify Orders in Bulk

Archive Shopify Orders in Bulk

To Archive existing Shopify Orders, do the following steps:

Note that this will not replace the orders – this will truly update the existing ones.

  1. Export the Orders you want to archive – don’t include any other detailed columns unless you absolutely need them, so you have nicely one row per order in the export.
  2. Delete all the columns and rows, leave only the following columns in your Excel file:
    • ID
    • Name
    • Command
    • Closed At
  3. Update the Excel file columns with data:
    1. Set the “Command” column values to “UPDATE“.
    2. Set the “Closed At” column values to whatever date (it doesn’t matter what date it is because orders will anyway get archived with today’s date).
  4. Import the file with the orders you want to archive.

To UnArchive existing archived Shopify Orders, do the opposite steps to archiving:

  1. Export the Orders you want to unarchive.
  2. Delete all the columns and rows, leave only the following columns in your Excel file:
    • ID
    • Name
    • Command
    • Closed At
  3. Update the Excel file columns with data:
    1. Set the “Command” column values to “UPDATE“.
    2. Set the “Closed At” column values to empty.
  4. Import the file with the orders you want to unarchive.

The Orders which have the Closed At value as empty, will get unarchived.

Good to know

Update Tracking Numbers for existing Orders in Bulk

Update Shopify Order Fulfillment Tracking Numbers in Bulk

To bulk update the Tracking Numbers of existing Shopify Order Fulfillments:

  1. Export the existing Orders with Fulfillments using the Excelify app – to Excel or CSV file.
  2. Edit the file so that you just keep the columns and rows that you want to update:
    • Keep in that file just the Orders you want to update tracking numbers for.
    • Keep just the following columns:
      • ID
      • Name
      • Command
      • Line: Type
      • Fulfillment: … columns
    • Change the column values:
      • Change “Command” column value to “UPDATE”
      • Change the “Fulfillment: Tracking Number” column – fill with your tracking numbers.
      • Optionally, if you want, you can fill in the other Fulfillment columns.
    • Keep just the rows where “Line; Type” is “Fulfillment Line”.
  3. Import that file with the Excelify app back – it will update your existing orders, and update the Fulfillments of those Orders to set the numbers that you need.

Where to go from here?

Fulfill existing Orders in Bulk

Fulfill existing Shopify Orders

To fulfill existing Shopify Orders, do the following steps:

Note that this will not replace the orders – this will truly update the existing ones.

  1. Export the Orders you want to fulfill – with Line Items and Fulfillments included in the export.
  2. Delete all the columns and rows, leave only the following columns in your Excel file:
    • ID
    • Name
    • Command
    • Line: Type
    • Fulfillment: ID
    • Fulfillment: Status
    • Fulfillment: Tracking Company
    • Fulfillment: Tracking Number
    • Fulfillment: Tracking URL
  3. If you see many rows per Order (with the same ID and Name values) then use the Excel function to remove duplicates – you only need one row per order.
  4. Update the Excel file columns with data:
    1. Set the “Command” column values to “UPDATE“.
    2. Set the “Line: Type” column values to “Fulfillment Line“.
    3. Leave the “Fulfillment: ID” empty – because you will be creating new fulfillments.
    4. Set the “Fulfillment: Status” to “success“.
    5. Set the “Fulfillment: Tracking Company” to whatever tracking company you are using. The list of tracking companies can be found here in the Orders documentation.
    6. Set the “Fulfillment: Tracking Number” to your tracking number for this Order.
    7. If you have the specific tracking URL, you can set it in the column “Fulfillment: Tracking URL“.
  5. Import the file with the orders you want to fulfill.

Good to know

  • If you don’t have tracking numbers or any other tracking data, you can leave the columns blank, or even not include them in the import.
  • If you have some of the line items already fulfilled then this import will fulfill whatever is remaining unfulfilled items.

Where to go from here?

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

How to bulk delete Redirects from Shopify

Shopify Redirects Bulk Delete

In this tutorial, you will learn how to bulk delete redirects from your Shopify store.

Steps to bulk delete redirects:

  1. Export Redirects from your Shopify using the Excelify app.
  2. Download exported Excel file and open it.
  3. Set Command column values to DELETE for those redirects you want to delete. Remove from the file all redirects that you do not want to delete or don’t want to change so that you import only those rows you want to change in some way.
  4. Save your file.
  5. Import the Excel file to Shopify using the Excelify app.

Good to know:

Import Redirects into Shopify Store

Shopify Redirects Import

In this tutorial, you will learn how to import redirects into your Shopify store.

Those are also known as 301 Redirects – they tell the browser that the URL has permanently moved to another URL.

Steps to import redirects:

  1. To import redirects, create new Excel file and copy column names from the Excelify template file Redirects sheet.
  2. Leave ID column empty, fill in Path column with URLs or paths you want to redirect from, Target column with URLs you want to redirect to, set Command column values to NEW.
  3. Rename the Excel file sheet (tab) to “Redirects” so that the Excelify app knows what’s inside that sheet.
  4. Import the new Excel file to Shopify using the Excelify app.

When do you need Redirects?

  • The typical reason for making redirects – when you are migrating from your old eCommerce Platform to Shopify. Usually, search engines have indexed your old URLs and it takes time to reindex your new site, so visitors will still be sent to your old URLs. Your domain will remain the same, but the path to products or pages will be completely different. Customers also might have saved those URLs in their bookmarks, or there may be precious “backlinks” referring to your site which you don’t want to get the 404 error that page is not found – you want them still to get to the new correct page.
  • Another case for using redirects is, when you changed handles of the products, collections or pages, or any other items, but URLs with old product handles are still in place. To make those URLs working, you can add redirects from URLs with old handles to URLs with new handles, for example, redirect from https://yourdomain.myshopify.com/products/old-product-handle to https://yourdomain.myshopify.com/products/new-product-handle.

Good to know:

  • In the “Path” column you can put the whole URL with the domain like “https://yourserver.com/products/product-123“, or just the path, like “/products/product-123“.
  • Here you can find full documentation on redirects.
  • You may also want to read, How to Bulk Delete Redirects tutorial.

Migrate Blog Posts from WordPress to Shopify

Blog Posts - WordPress to Shopify

This video tutorial shows you step by step instructions how to migrate your Blog Posts (Articles) from WordPress to Shopify Blogs.

Steps to migrate articles from WordPress to Shopify:

  1. Go to your WordPress site, and install the Plugin: All Export.
  2. Export all your WordPress blog posts using “All Export” plugin to the CSV file.
  3. Open the CSV file, save it as Excel file.
  4. Rename the Excel file sheet (tab) to “Blog Posts” so that the Excelify app knows what’s inside that sheet.
  5. Set the column titles of the columns you want to import – copy column names from the Excelify template file.
  6. Import the new Excel file to Shopify using the Excelify app.