Cleaning out a Shopify store manually can be extremely time-consuming and error-prone. DataEase makes it easy: export your data, prepare delete actions for each entity type, and remove everything in bulk with validation—all while following the correct order of operations.
🎯 Goal
Clean out a Shopify store by removing (or archiving, where deletion isn’t possible) data across key entities using CSV/Excel and DataEase.
⚠️ Important Limits from Shopify
- Live orders cannot be deleted — only canceled (archived)
- Customers with orders cannot be deleted until orders are unlinked or canceled and the customer is no longer referenced
- Deletion is irreversible. Always keep a full backup export before you begin
📋 Recommended Order of Operations
- Orders — Cancel (archive) live orders; delete Draft Orders
- Customers — If needed, first unlink customers from orders (guest orders), then delete customers without orders
- Companies (B2B) — Delete company, then its contacts/locations (or delete line-items directly)
- Products & Variants — Delete products (removes variants/media) or delete specific variants
- Collections — Delete manual/automated collections you no longer need
- Content — Delete Pages, Blogs/Articles, Comments, Menus
- Catalog extras — Delete Discounts, Redirects, Files, Metaobjects, Translations (per resource/locale)
Tip: Use filters (date ranges, tags, Collection ID, Inventory locations, etc.) to target exactly what you want removed.
🔧 How to Delete / Archive by Entity
Orders (Live)
Action: action = CANCEL (archives the order)
id,actiongid://shopify/Order/123,CANCELDraft Orders
Action: command = DELETE
id,commandgid://shopify/DraftOrder/789,DELETEUnlink Customer from Orders (Optional Prep)
Action: command = UPDATE and clear customerId (makes a guest order)
id,command,customerIdgid://shopify/Order/123,UPDATE,Customers
Rule: Customer must have no linked orders
Action: command = DELETE
id,commandgid://shopify/Customer/555,DELETECompanies (B2B)
Company row: command = DELETE
Contact/Location lines: itemCommand = DELETE (when removing line-items specifically)
CSV (company):
id,commandgid://shopify/Company/111,DELETECSV (contact or location line):
id,topRow,itemCommand,contactIdgid://shopify/Company/111,FALSE,DELETE,gid://shopify/CompanyContact/999Products (Deletes Variants & Media)
Action: command = DELETE
id,commandgid://shopify/Product/123,DELETEVariants (Keep Product, Remove Specific Variants)
Action: variantCommand = DELETE
variantId,variantCommandgid://shopify/ProductVariant/111,DELETECollections
Action: command = DELETE
id,commandgid://shopify/Collection/222,DELETEPages
Action: command = DELETE
id,commandgid://shopify/Page/333,DELETEBlogs & Articles
Articles first, then blog (or just delete the blog if your workflow supports cascading)
CSV (article):
id,commandgid://shopify/Article/444,DELETECSV (blog):
id,commandgid://shopify/Blog/445,DELETEComments (on Articles)
Action: command = DELETE
id,commandgid://shopify/Comment/556,DELETEMenus (Navigation)
Action: command = DELETE
id,commandgid://shopify/Menu/777,DELETEFiles (Settings → Files)
Action: command = DELETE
Note: Deleting files that are referenced by themes/pages will break images/links
id,commandgid://shopify/MediaImage/888,DELETERedirects
Action: command = DELETE (ID required)
id,commandgid://shopify/UrlRedirect/999,DELETEDiscounts
Action: command = DELETE
id,commandgid://shopify/DiscountAutomatic/1234,DELETEMetaobjects
Action: command = DELETE
id,commandgid://shopify/Metaobject/abc,DELETETranslations
Action: command = DELETE per locale/value (removes translations from the resource)
CSV (remove FR translation):
resourceId,command,[fr] valuegid://shopify/Product/123,DELETE,💡 Best Practices
- Back up everything: Run full exports (Products, Variants, Collections, Customers, Orders, Draft Orders, Discounts, Redirects, Files, Metaobjects, Blogs, Articles, Comments, Pages, Menus, Translations, Companies)
- Start with a small sample, validate, review the results, then scale up
- Prefer IDs for matching; use handles/SKUs only if unique
- Keep audit files (validation reports + results) for compliance
🎉 That’s it!
Your store cleanup is now complete.
If you run into any issues or have questions, feel free to contact our support team.