Bulk Delete Orders From Your Shopify Store

You can use the Mixtable Spreadsheet Editor app to make bulk edits to your Shopify store.

In this case, to delete orders in bulk, you can follow these steps:

Step 1: Sync Shopify orders to Mixtable spreadsheet editor

Once you install and open the Mixtable spreadsheet (spreadsheet), you can use the pre-built orders spreadsheet and work in the Orders (no line items) worksheet, which will load your orders into a Mixtable spreadsheet:

The Orders (no line items) worksheet contains the following columns:

• Order #
• Shopify ID
• Email Address
• Created At
• Total Price

Optional: Another way to delete orders from your Shopify store is to add a new Worksheet integrated with Shopify Orders data.

In an existing Mixtable spreadsheet, click the (+) button to add a new worksheet.

The Shopify worksheet options are broken down by the data type you want to sync (e.g., Products, Orders (no line items)). Select Orders (no line items), and it will be immediately added to your spreadsheet.

Note: You’ll see that when you connect Shopify orders to Mixtable, the data will immediately start populating with any existing data from Shopify into the spreadsheet.

Step 2: Select the orders you want to delete

Once that is confirmed and you see the order data in the spreadsheet, select the rows for the orders you’d like to delete, just like you would in Excel - by clicking on the row header and dragging the mouse to cover additional row headers.

Step 3: Delete the orders

Next, right-click on one of the selected row headers (the row header shows the row number). In the menu that opens select the Delete object in Shopify menu option.

You’ll now see a dialog show up, confirming that you want to permanently delete the selected orders in your store. Once you confirm, Mixtable will notify Shopify, asking it to delete the orders. Once the deletion is done, the orders’ data will be removed from your worksheet.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.