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
    • Cancel: Send Receipt
    • Cancel: Refund
  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. Set the “Cancel: Send Receipt” column to TRUE if you want the customer to receive the e-mail notification about the Order cancelation.
    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.
  4. Import the file with the orders you want to cancel.

Good to know