Sync Shopify B2B Prices with Airtable

AirPower makes it simple to manage and sync your Shopify B2B catalog prices with Airtable. Shopify stores B2B pricing at the variant level and inside specific B2B catalog price lists. AirPower brings this data into Airtable so you can edit prices in a spreadsheet-style workflow — then sync changes back to Shopify whenever you’re ready.

Create a sync profile

1. In your Shopify admin, open AirPower.
2. Click Create Sync.
3. Choose Shopify → Airtable if you want to fetch existing B2B prices.
4. Pick the Airtable base where B2B pricing should sync.

A sync profile defines what data syncs, in which direction, and from/to which table in Airtable.

Ensure products and variants are mapped

B2B prices in Shopify belong to variants, not products. Even products with only one option always have a variant behind the scenes.

Before B2B pricing can sync, you must map:

1. Products → a table in your Airtable base
2. Variants → a table in your Airtable base

AirPower will enable B2B pricing only after variant syncing is configured, because variants are required for pricing data.

Configure B2B price lists

Open the B2B Prices section in the sync profile. AirPower will automatically detect your Shopify B2B catalogs and price lists.

For each B2B price list, you may see fields such as:

• Fixed B2B price
• Fixed B2B Compare-At Price
• Relative B2B price (Shopify → Airtable profiles only)
• Relative B2B Compare-at price (Shopify → Airtable profiles only)

Each field can be mapped to a column in the Variants table. If the column does not yet exist, AirPower will offer to create it.

Sync Shopify B2B prices to Airtable

Shopify does not push updates for B2B prices to AirPower automatically. Because of this, B2B prices must be refreshed manually.

On your dashboard sync card, click Trigger manual sync task, then select Sync Market and B2B Prices.

This refresh fetches:

• International market prices
• B2B catalog prices

Once the sync runs, Airtable will show the latest B2B price list values in all mapped fields.

Update B2B prices in Airtable

With your B2B price lists now in Airtable, you can:

• Update fixed B2B prices by editing the mapped columns
• Use formulas to apply bulk price adjustments
• Identify missing B2B pricing
• Group or filter by price list, collection, vendor, product type, or tags

None of the updates you make in Airtable go live in Shopify until you trigger an Airtable → Shopify sync.

Sync updated B2B prices back to Shopify

To push B2B pricing updates back to Shopify:

1. Enter the new price into the mapped B2B fixed price column.
2. Run an Airtable → Shopify sync.
3. AirPower updates Shopify with your fixed B2B values.

To remove a B2B fixed price and return the variant to its default (relative) B2B pricing:

1. Clear the corresponding cell in Airtable.
2. Run an Airtable → Shopify sync.
3. AirPower removes the override from Shopify.

You’re ready to manage B2B pricing

By mapping Shopify’s B2B price lists to Airtable, AirPower gives you a clean, scalable way to edit complex pricing structures. Use Airtable’s formulas, views, and filters to manage hundreds or thousands of SKUs — then push updates to Shopify in a single sync.