AirPower
Bulk edit 
Shopify B2B prices with 
Airtable
Every B2B catalog price as a column on your Variants table. Change wholesale prices for hundreds of variants at once, then send them to Shopify. Available on the Plus plan.
5‑day free trial, then from $35 a month. Billed through Shopify.
Built for Shopify
Shopify admin 3.8 billion Shopify records synced since 2019 for brands like these
B2B price fields you can edit in Airtable
Each B2B catalog price you add becomes its own column on the Variants table. Fixed prices go both ways. Relative prices are calculated by Shopify and stay read only.
| Area | Fields | Into Airtable | Back to Shopify |
|---|---|---|---|
| Fixed B2B price | A fixed price for the variant in one B2B catalog Set up B2B prices | ||
| Fixed B2B compare-at price | A fixed compare-at price for the variant in one B2B catalog | ||
| Relative B2B price | The price Shopify calculates from the variant's base price and the catalog's adjustment | Read only | |
| Relative B2B compare-at price | The compare-at price Shopify calculates for the catalog | Read only | |
| Base prices | The variant's own price and compare-at price, on the same Variants table Variant fields |
B2B catalog prices need the Plus plan. Shopify does not send price changes as they happen, so download Market and B2B prices from the Sync's settings to pull fresh values. A Sync that runs on a schedule also refreshes them on each run.
From Shopify to Airtable and back
Two Syncs do the work. One brings your B2B prices in. The other sends your edits to Shopify.
-
Bring your prices in
On the Variants tab, open the B2B catalog prices card and click + Add B2B price for each price you want. Save, and AirPower downloads the prices.
-
Edit in bulk
Filter a view, then paste or fill down fixed prices across hundreds of variants. Clear a cell to remove that fixed price.
-
Click Sync now
Use an Airtable to Shopify Sync with the same Variants table. Each row is matched to its variant by the Shopify ID column, and fixed prices are written to the B2B catalog.
Set up Variants first. B2B catalog prices are set up on the Variants tab and stored on the Variants table. Add Variants to the Sync before you add a B2B price. B2B price setup
Shopify admin or Airtable for B2B prices
Shopify's bulk editor and CSV files already handle some B2B prices edits. Here is what changes when you work in Airtable.
| Task | In the Shopify admin | In Airtable with AirPower |
|---|---|---|
| Export catalog prices | Catalog CSV exports include only products with fixed prices. | Fixed and calculated prices for each catalog are columns on the Variants table. |
| Import catalog prices | Catalog CSV imports need Option1 Name and Option1 Value columns for every product, even products without variants. | Rows match by Shopify ID, so you edit prices without preparing extra columns. |
Shopify details from the Shopify Help Center: creating catalogs.
Common B2B pricing jobs
Step-by-step guides for wholesale and catalog pricing.
“We run a furniture e-commerce with ~7,400 variants and use AirPower as the backbone of our Airtable PIM…”
B2B price questions
More answers in the help center, or email team@airpowersync.com.
Which B2B prices can I change from Airtable?
Fixed B2B prices and fixed B2B compare-at prices. Relative prices are calculated by Shopify from the base price, so they come into Airtable as read only.
How do I remove a fixed B2B price?
Clear the cell in Airtable and run the Airtable to Shopify Sync. AirPower removes the fixed price from that catalog, and the catalog's adjustment applies to the variant again.
Do B2B prices update in Airtable on their own?
Not as they change. Shopify does not notify the app about price changes. Click Download next to Market and B2B prices in Settings > Download data, or use Download now on the dashboard sync card. A Sync that runs on a schedule also refreshes them on each run.
Which plan do I need?
B2B catalog prices need the AirPower Plus plan. Click Upgrade to AirPower Plus in the B2B catalog prices card on the Variants tab to unlock it. The card then lists the B2B catalogs set up in your Shopify store.
Related features
Try AirPower on your own store
Install it from the Shopify App Store, connect an Airtable base, and run your first Sync today. Free for 5 days.