Bulk Remove Customers from Shopify B2B Company Locations

Managing Shopify B2B access often means cleaning up who’s allowed to order under each Company Location. When teams change, accounts are closed, or cleanup is needed, you may need to bulk remove and unassign Customers from Shopify B2B Companies and Company Locations.

With Matrixify, you can quickly unassign Customers from B2B Locations in bulk using spreadsheet Export and Import. This tutorial shows how to Export the minimum data you need, prepare a clean removal file, and import it safely—so you can revoke access at scale by unassigning Customers from Company Locations or bulk removing from the whole Company.

Steps in short

1. Export Shopify B2B Companies with Locations and Linked Customers using Matrixify.
2. Edit the exported spreadsheet
   • Set Customer: Command to DELETE to remove the customer from the Company.
   • Remove value from Customer: Location Role column to remove only from the location but not the whole company.
3. Save the file and import with the Matrixify app to bulk update your Shopify B2B Companies.

1. Export Shopify B2B Companies

Start by generating a focused Companies export that includes just the fields you need to target removals.

In the Matrixify app, create a new export and from Select Sheets drop-down select to export Companies sheet.

Include these essential columns:

• ID and Name – to identify each B2B Company.
• Location: ID and Location: Name – so you can pinpoint the exact Company Location where Customers should be removed.
• Customer: ID and Customer: Email – to identify the linked customers.
• Customer: Command – to manage linked customers within the B2B Company.
• Customer: Location Role – manages Customers role within a specific Company Location.

No further adjustments are needed – you can press the Export button to start the Export job.

2. Edit B2B Companies spreadsheet

In the exported file you will have as many rows as you have Customers linked to the Company. If multiple Customers are linked to the same Location, you will see your file containing multiple rows for that location.

From here you can manage to either remove Customer from the whole Company or remove just from a specific Company Location.

Remove Customer from the whole B2B Company

Customer in the whole B2B Company is managed by using the Customer: Command column.
By default, the value in the column is MERGE. For Customers that you wish to remove from the whole Shopify B2B Company, change the Customer: Command column’s value to DELETE.

This will not delete the Customer from the Shopify store, only remove that customer from the Shopify B2B Company.

Remove Customer from specific B2B Company Location

If you wish for the Customer to remain within the B2B Company, but no longer be linked to the specific Location then you can set the Customer: Location Role columns value to empty.
When importing, the Matrixify app will see that this Customer does not have a Role within Location in that row and thus remove the Customer from the Location.

3. Save the file and import with Matrixify

Once the file has been adjusted as you need, save it and go back into the Matrixify app in your Shopify store. Upload your file in the Matrixify apps Import section.

Make sure that app detects the import sheet as Companies and that the count of Companies is correct. Note that the app does not count rows in the file but actual unique companies.
This is a great, simple safety check before importing to ensure that, due to editing the file, some data has not been mixed up incorrectly.

If all looks correct, press the Import button to start the import and once the import finishes, all those Companies should have been updated as per the edits done in the uploaded file.

Good to know

• See Shopify manuals for more details on Shopify B2B Companies.
• Read Matrixify Companies documentation explaining all columns from the Companies sheet template.
• Check out other tutorials to bulk manage your Shopify B2B Companies.