Archive and Unarchive Shopify Orders in Bulk

Archive Shopify Orders in Bulk

To Archive existing Shopify Orders:

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:

  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