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 workbook.

Option 1 - Start with the Pre-Built Companies Template

1. Click the Create Workbook button.

2. From the available templates, select Companies.

   

3. Mixtable creates a new workbook 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 Workbook

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

1. Click the Add Worksheet button at the bottom of your Mixtable workbook.

   

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 Sync Worksheet Changes 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 workbook.
• 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.