· 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:

idcommand
123DELETE

Minimal CSV (example) / Delete by email (ensure uniqueness):

emailcommand
[email protected]DELETE

References