Bulk Edit Shopify B2B Company Locations

The Company Locations worksheet in Mixtable allows you to view, edit, and sync Shopify B2B company location data, including billing and shipping addresses, contact details, and payment terms. Each row corresponds to a unique Company Location in Shopify, which is ideal for merchants managing multiple offices, stores, or distribution points under one B2B customer.

You can get started with the pre-built Companies template, which includes both Companies and Company Locations worksheets, or you can manually add a Company Locations worksheet to an existing spreadsheet.

Option 1 - Start with the Pre-Built Companies Template

1. Click the Create Spreadsheet button.

2. From the available templates, select Companies.

   

3. Mixtable creates a new spreadsheet containing:

   • A Companies worksheet with your B2B companies.
   • A Company Locations worksheet with all related location data.

4. The template automatically loads your existing Shopify company and location records.

Once loaded, you can:

• Review address, payment, and contact details.
• Edit existing data directly within the spreadsheet.
• Export the data for analysis or reporting.
• Sync updates back to Shopify when ready.

Option 2 - Add a Company Locations Worksheet to an Existing Spreadsheet

You can also add a Company Locations worksheet manually to an existing spreadsheet.

1. Click the + button beside the worksheet tabs

   

2. Select Shopify data worksheet, then click Continue

3. Select Company Locations

4. Select the fields to include and drag column headers to arrange their order, then click Continue

   

5. Choose Load everything or Only rows that match rules

6. Click Create Worksheet

Your new worksheet will now display all company location records synced from your Shopify store.

Working with Company Location Fields

Each row represents one Shopify company location. Common fields include:

• Billing and Shipping Details: Address, City, Country, Province, and Postal Code
• Payment Terms: Payment terms name, deposit percentage, and due-in-days values
• Company Association: Company ID and Company Name
• Contact Info: Billing recipient, phone, and email fields
• Order and Currency Details: Orders count and currency used

Add Company Location metafields

You can map Shopify Company Location metafields to columns and update their values in bulk:

1. Select an empty column or insert a new one. Empty columns have a non-green header; a green header means the column is already linked to Shopify data
2. Click the button in the column header
3. Select Metafields
4. Choose the Company Location metafield definition you want to map
5. Click Save Column
6. Enter or paste your metafield values
7. Click Sync to Shopify to publish the changes

For more information about defined and custom metafields, see bulk edit Shopify metafields.

Syncing Updates Back to Shopify

When you’re ready to apply changes:

1. Review your updates in the worksheet.
2. Click Sync to Shopify.
3. Mixtable will automatically update the corresponding B2B company locations in Shopify.

Summary

• Start with the Companies template to instantly create linked worksheets for both companies and locations.
• Or manually add a Company Locations worksheet to any spreadsheet.
• Edit Company Location information right within Mixtable spreadsheet
• Sync your changes to Shopify at any time.

With Mixtable, managing your B2B company locations, from billing addresses to payment terms, is as simple as working with a spreadsheet.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.