Get Excelify now
Get Excelify now

How to bulk cancel orders on Shopify

Cancel Shopify Orders in bulk|Export Orders for cancelling|Export Orders to be cancelled|Open file for cancelling Shopify orders|Updated file for cancelling Shopify orders|Imprt file to Cancel Shopify Orders

There may be times where you need to bulk cancel a batch of Shopify orders. Often in these situations, time is of the essence and you need a quick way to deal with hundreds, or maybe even thousands of orders in one go. Luckily, the Excelify App is here to help make this process as quick and easy as possible. The following tutorial explains how.

To Cancel Shopify Orders, do the following steps:

The step-by-step process:

  1. Export the Shopify Orders you want to bulk cancel.
  2. Delete Columns you will not need for the import.
  3. Update Command and Cancel columns.
  4. Save and Import.

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

1. Export the Shopify Orders you wish to bulk cancel

The first step would be to export your data.

In the Excelify app Home page, create new Export.
The app will open a new export page where you need to select “Orders” entity and “Basic Columns” sub-checkbox.
No need to select any other order data.

1 - how to bulk cancel shopify orders with Excelify excel csv import export

You can also apply filters by pressing the “Filter” button.

For Advanced Excelify users, you can also open the “Advanced” tab and export only fields listed in step #2.

To start the export press “Export” button.

2. Delete columns you will not need for import

In the exported file you would have all Basic Columns from the Order.

Since we do not need all of them then you can completely delete all columns, leave only the following columns in your Excel file

    • ID
    • Name
    • Command
    • Cancelled At
    • Cancel: Reason
    • Cancel: Send Receipt
    • Cancel: Refund

Open file for cancelling Shopify orders

Update Command and Cancel columns.

      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. Set the “Cancel: Send Receipt” column to TRUE if you want the customer to receive the e-mail notification about the Order cancellation.
      5. Set the “Cancel: Refund” column to TRUE if you want to refund the whole Order when cancelling. If you don’t set it to TRUE, then it will not get refunded automatically. To refund partially, you can set up the Refund columns and rows as explained in this tutorial.

Updated file for cancelling Shopify orders

4. Save and Import.

Go back into the Excelify app.

Import the file with the orders you want to bulk cancel back into Shopify.

 

Imprt file to Cancel Shopify Orders

Good to know