Data Sanitization

Deletion Tutorials

Step-by-step masterclass on safely purging Shopify historical sales data. Warning: Deletion is permanent and non-reversible.

1. Download CSV Template

Your CSV file must include an order_id column containing the order numbers exactly as they appear in Shopify (e.g., 1001, 1002, or #1003).

This ensures that the correct orders are deleted without affecting other orders.

Bulk Delete Template

Includes the required 'order_id' column header.

2. Safety & Reversibility

  • Export Before Deleting: Always perform a backup. Export your orders from Shopify Admin before running bulk deletion jobs.
  • Download Reports: Always download the session report *before* starting a new session. Starting a new session clears the current dashboard logs.
  • Non-Recoverable: API `DELETE` calls purge data permanently. There is no trash bin.
  • Data Dependencies: Deleting an order also wipes associated financial and fulfillment records.

3. CSV Deletion Format

Use a simple one-column CSV. The app automatically maps these to internal Shopify IDs.

order_id
#1001
1002
REC-555

Export Orders for Bulk Deletion from Shopify

Steps to safely isolate and delete multiple orders:

  1. Open your Shopify admin and navigate to the Orders section.
  2. Use filters to locate the specific orders you want to delete.
  3. Select all relevant orders and assign them a unique tag (e.g., delete-jan-orders).
  4. Filter your orders list by that tag to double-check that only the intended orders are selected.
  5. Export the tagged orders from Shopify.
  6. Copy the order numbers from that export into our Bulk Delete Orders CSV template.
  7. Upload the completed CSV template to our app to delete the orders in bulk.

4. Manual ID Cleanup

If you only have a few orders, you can also enter order numbers manually in the text field on the dashboard instead of using a CSV.

Separate IDs by commas, spaces, or new lines. The app pre-validates if these IDs exist before triggering the deletion.

5. Delete orders by tag

Premium Feature

Delete multiple orders instantly by selecting one or more tags. This helps you quickly clean up test orders, outdated records, or bulk data without manually selecting each order.

Preview Feature Included

The "Delete by Tag" tool includes a Preview Matching Orders step. You can review the first 50 matching orders to ensure your tags are correct before triggering the permanent deletion.

Benefits

  • Delete hundreds of tagged orders in seconds
  • 🧹Quickly remove test, duplicate, or unwanted orders
  • 🎯Target specific groups of orders using tags
  • Save time compared to manual deletion
Note: Delete orders by Tags is a premium feature available exclusively on Professional and Scale plans.

6. Handling Failures & Reports

Recent Deletion Sessions

At the bottom of the Deletion dashboard, you will find the Recent Deletion Sessions table. This tracks all your bulk deletion attempts in real-time.

Status Tracking

Instantly see if your bulk job is Completed, Failed, or Queued.

Live Metrics

View exact counts of Total, Success, and Failed order deletions.

Downloadable Reports

Click the Download button next to any session to get a CSV report of exactly which orders failed and why.

Tip: If an order fails (e.g., "Order is locked by another app"), you can simply fix the issue in Shopify and re-upload the failed rows.