· DataEase · Tutorials  · 2 min read

Bulk Delete Customer Addresses

Removing many customer addresses manually can be extremely time-consuming. DataEase makes it easy: export customers with addresses, mark address rows for deletion, and remove them in bulk with validation.

🎯 Goal

Remove many customer addresses at once by marking address rows with itemCommand = DELETE and importing via DataEase.

📋 Step-by-Step Instructions

1. Export Customers (with Addresses)

In DataEase, go to New Export → Customers.

Include:

  • id (customer ID)
  • From the Addresses group: addressId, address1, city, country, zip (add any fields that help you identify the addresses)

Optional: Filter customers by tag, segment, or date to narrow the set.

2. Prepare the File

Open the exported file in Excel or Google Sheets:

  • Keep only rows for addresses you want to remove
  • For those rows set itemCommand = DELETE
  • Ensure the addressId is present (required to delete a specific address)

Tip: Your export may already include the topRow control column. Use topRow = TRUE for the main customer line and topRow = FALSE for address lines. If the main line isn’t required for your import, you can omit it and keep only the address lines with itemCommand=DELETE.

When done, save the file as .xlsx or .csv.

3. Import & Validate

  1. In DataEase, start New Import → Customers
  2. Upload your edited file
  3. Map columns
  4. Run Validation

Review the Validation Status column; fix any issues (e.g., missing addressId).

4. Run the Import and Download the Results

After validation passes, click Run Import to remove the addresses from Shopify.

Once complete, download the results file and spot-check a few customers in the Shopify admin to confirm the addresses were removed.

📝 Important Notes

  • Default address: If you plan to delete a customer’s default address, either set another address as default in a prior step or delete all addresses for that customer
  • Safety: Deletion is irreversible—keep a backup export before you proceed
  • Matching: Customer id + addressId gives the most reliable match. Avoid relying solely on address text fields when deleting

💡 Minimal CSV Examples

Delete a single address:

id,topRow,itemCommand,addressId
gid://shopify/Customer/123,FALSE,DELETE,gid://shopify/MailingAddress/98765

Delete multiple addresses for one customer:

id,topRow,itemCommand,addressId
gid://shopify/Customer/123,FALSE,DELETE,gid://shopify/MailingAddress/11111
gid://shopify/Customer/123,FALSE,DELETE,gid://shopify/MailingAddress/22222

🎉 That’s it!

Your customer addresses are now removed in bulk.
If you run into any issues or have questions, feel free to contact our support team.

Share: