Archive and Unarchive Shopify Orders in Bulk

To Archive existing Shopify Orders:

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

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.
Delete all the columns and rows, leave only the following columns in your Excel file:
- ID
- Name
- Command
- Closed At
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).
Import the file with the orders you want to archive.

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

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

If you need to delete the Shopify Orders, you can do it like explained in this tutorial.
If you need to bulk Cancel or UnCancel your Orders, do this same procedure, just instead of “Closed At” column, set the date for “Cancelled At” column. And you can add the “Cancel Reason” as well. See more about the possible values in the Orders documentation page, Update Orders section.