Remove Customer from Orders

Unlinking customer records from many orders manually can be extremely time-consuming. DataEase makes it easy: export your orders, clear the customerId field, and import them back to Shopify—turning them into “guest” orders for privacy compliance or customer deletion workflows.

🎯 Goal

Unlink the customer record from many orders at once (turn them into “guest” orders) so you can manage privacy requests or delete the customer profile later.

📋 Step-by-Step Instructions

1. Export Orders (Target the Right Set)

In DataEase, go to New Export → Orders. Include at least:

• id
• name (order number)
• customerId
• customerEmail
• Optionally: date/status filters to narrow results

2. Edit the File

Open the exported file in Excel or Google Sheets. For each order you want to unlink:

• Set command = UPDATE on the order row
• Clear customerId by leaving the cell empty ("")
• (Optional) Keep customerEmail if you still need a contact email on the order; or clear it if you must remove it
• Addresses on the order (billing/shipping) are separate fields—clear or keep them as your policy requires

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

3. Import & Validate

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

Fix any issues flagged in Validation Status (e.g., missing id).

4. Run the Import and Verify

After validation passes, click Run Import to unlink the customers from orders in Shopify.

Once complete, download the results and spot-check in Shopify Admin: the orders should no longer reference a customer (guest orders). You can now handle the customer profile separately (e.g., delete/anonymize if there are no linked orders left).

📝 Important Notes

• This does not delete the order; it only removes the association to a customer profile
• Personal data on the order (email, addresses, notes) remains unless you clear those fields too
• Some orders may be restricted from edits (e.g., locked states). If validation flags them, exclude or resolve first
• To delete a customer profile later, ensure no orders link to it (see our “Bulk Delete Customers” guide)

💡 Minimal CSV Examples

Clear the customer link, keep the contact email:

id,command,customerId,customerEmail
gid://shopify/Order/123,UPDATE,,"[email protected]"

Clear both the customer link and the contact email:

id,command,customerId,customerEmail
gid://shopify/Order/456,UPDATE,,

🎉 That’s it!

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