Get Excelify now
Get Excelify now

Remove Customer from existing Shopify Order

Remove Customer from Shopify Order in bulk|1 - Export Shopify Orders with Customer information|2 - Update Shopify order specific fields||4 - Update Shopify Orders fields in bulk||2 - Update Shopify order specific fields

Now with the Excelify, you can remove the customers attached to the Shopify Orders in bulk.

Typically you might need it when you wish to delete the Customer but it’s linked to the Order, so Shopify is not allowing to delete the customers till you remove it from the Order.

Steps in short:

  1. Export the Orders with Customer information.
  2. From the Exported file delete unnecessary columns. You will only need:
    • ID
    • Name
    • Command
    • Customer: ID
  3. Delete values from the “Customer: ID” column.
  4. Update the “Command” column to value “UPDATE
  5. Save, import and enjoy!

1. Export the Orders with Customer information

First, you would need to export the Orders that you wish to update.

In the export section of the app select checkbox “Orders” and order sub-checkbox “Customers

If needed, you can also apply filters to export only the Orders that you wish to update, by clicking on the ‘filter’ icon.
The list of all possible filters you can also find in our export filter documentation.1 - Export Shopify Orders with Customer information

2. From the Exported file delete unnecessary columns

Since you only will need to remove the customer from the order, then you do not need to include all columns in the file you will be importing.

In this case, we will only need the following columns:

  • ID
  • Name
  • Command
  • Customer: ID

2 - Update Shopify order specific fields

3. Delete values from the “Customer: ID” column

By deleting the values from this column, the app will know to set Customer for this order to nothing, thus removing the Customer from the Order.3 - Remove customer from the Shopify Orders

4. Update the “Command” column to value “UPDATE”

The Command column is telling the Excelify app what you wish to do with the whole order. Since the default exported value is NEW we need to tell the app to UPDATE each Order.4 - Update Shopify Orders fields in bulk

5. Save, Import and Enjoy!

Now you can save the file. Go back to the Excelify app and import the file in the Import section. The app will analyze the file and count how many Orders you are importing.

Press the Import button to start the import.

If you see any Failed items, then after the import has finished, you can download the Import Results file and look into the “Import Comment” column. It will tell why particular Orders has failed. Then you can fix that issue and re-import just those failed and fixed rows again.

What to do next?