Set or remove the customer on Shopify orders

Sometimes an order in Shopify is missing a customer, or it’s linked to the wrong one. With Mixtable, you can fix this directly in your Orders (no line items) worksheet by updating the Customer email field, then syncing the changes back to Shopify.

This is especially helpful when you need to link past guest checkouts to existing customers, or clean up customer assignments across multiple orders.

Add a Customer email column to your worksheet

If your Orders (no line items) worksheet already has a Customer email column (called Customer Email Address on worksheets made from the Orders and Order Items template), skip ahead to the next section. To add it:

1. Open your Orders (no line items) worksheet
2. To load more Shopify data, click ＋ Shopify data in the header row of an empty column, such as the one right after your last column. You can also choose Column > Add Shopify data… from the menu bar. The field picker opens and asks What should column E show?, with your column's letter in place of E. It lists everything the worksheet can show from Shopify, grouped into sections the way your Shopify admin groups them. Type in the search box at the top, or click a section on the left, to find the field you want.
3. Type Customer email in the search box, or click Customer in the list of sections on the left
4. Click Customer email
5. Click Save Column

Set, change, or remove the customer

In the Customer email column:

• To set or change the customer: Enter the email address of an existing Shopify customer
• To remove the customer from an order: Clear the cell so it’s blank

You can update as many orders as you need before syncing.

Sync your changes to Shopify

1. Click Sync at the top right of the spreadsheet, review your changes in the preview that opens, then click Sync again
2. Mixtable will look up each customer by email and update the order accordingly

Troubleshooting

I got an error that the customer can’t be found

The email you entered needs to match an existing customer in Shopify. Double-check the email address, make sure the customer exists in your Shopify store, then sync again.

Nothing changed in Shopify

Make sure you’re editing the Customer email field (which is syncable) and not a read-only customer field like Customer ID.