· DataEase · Tutorials · 2 min read
Bulk Delete Customers from Shopify
Remove many customers at once by marking them with the DELETE command and importing via DataEase. (Shopify will block deletion for customers who have orders.)
Steps:
1. Export Customers
In DataEase → New Export → Customers. Include at least: id, email, phone, and ordersCount (or an equivalent “has orders” field). Use filters to narrow your list.
2. Target only deletable customers
Prefer exporting OrdersCount = 0 (or HasOrders = FALSE) to avoid rows Shopify won’t delete. If you exported everyone, filter in Excel to keep only rows with zero orders.
3. Edit the file
Keep customers you want to remove and set command = DELETE. • Matching: Prefer id. If using email or phone, make sure they’re unique and current.
4. Import & validate
In DataEase → New Import → Customers, upload the file, map columns, and run Validation. Review the “Validation Status” column—rows with orders will be flagged and won’t be deleted.
5. Run the import
After completion, download the results and confirm the deletions.
Tips
- Customers with orders cannot be deleted by Shopify. Alternatives: tag them, disable/mark as inactive, or use Shopify’s data erasure/anonymization where appropriate.
- Deletion is irreversible—keep a backup export before proceeding.
- Deleting a customer removes their addresses and tags associated with that profile.
Minimal CSV (example) / Delete by ID:
| id | command |
|---|---|
| 123 | DELETE |
Minimal CSV (example) / Delete by email (ensure uniqueness):
| command | |
|---|---|
| [email protected] | DELETE |