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 in this worksheet corresponds to a unique Company Location in Shopify — ideal for merchants managing multiple offices, stores, or distribution points under a single 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 Add Worksheet button at the bottom of your Mixtable spreadsheet.

   

2. Select Shopify Data Worksheet.

3. Choose Company Locations as the data type.

4. Select the fields to include and adjust their order.

   

5. Click Add 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

Syncing Updates Back to Shopify

When you’re ready to apply changes:

1. Review your updates in the worksheet.
2. Click Send 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 in 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.