You have a handful of trade customers. You want them to log in and see their own prices — not a discount code they have to remember, and not a separate wholesale store you have to keep in step with the retail one.

This guide covers doing that with BSS B2B Solution applying the pricing and SheetSync building it. If you are on the SheetSync Unlimited plan, you may not need BSS at all — see wholesale pricing by customer tag, where SheetSync charges the prices itself.

Why "customers with this tag pay this price" is not built in

It seems like it should be a setting. It is not, and there are two separate reasons:

Native B2B is available on every Shopify plan. What stays behind the Plus paywall is scale: unlimited catalogs and assigning a catalog straight to a company location. On other plans you get up to three catalogs, through Markets.

The three routes, honestly

RoutePlan neededHow a customer qualifiesSecond app
Native B2B catalogs Any plan, but unlimited catalogs and direct assignment are Plus Belongs to a company location No
SheetSync wholesale pricing SheetSync Unlimited Carries a customer tag No
SheetSync + BSS Any SheetSync plan, plus a BSS subscription Carries a customer tag Yes, BSS

This guide is the third row. It is the right one when you already run BSS, or when you are not on the SheetSync Unlimited plan.

Where SheetSync fits

BSS applies the pricing. It is not where you want to build the pricing — typing several hundred wholesale prices into any app's interface is miserable, and there is nothing to check your work.

SheetSync gives you the price list as a Google Sheet: every variant, its current retail price, and an empty column for the wholesale price. You fill it in with formulas, a paste from your supplier's file, or whatever you already use. Then SheetSync generates the import file BSS expects.

One thing worth knowing up front

This is the only part of SheetSync that does not write to Shopify. Every other tab pushes your edits into the store. The BSS route produces a file you upload to BSS — so pressing Push to Shopify anywhere else will never touch your wholesale prices.

How it works, start to finish

1. Install BSS B2B Solution

Install BSS B2B Solution from the Shopify App Store.

Use the code BSSAFP484 when you sign up.

2. Tag your trade customers

In the Shopify admin, tag the customers who should get wholesale pricing — wholesale, or whatever suits your store. The tag is the whole mechanism: tagged customers see the price, everyone else sees retail.

3. Create the price list in SheetSync

Open the B2B Pricing tab in SheetSync and create the spreadsheet. You get one row per variant, with its product name, variant name, SKU and current retail price, plus three Tag and Wholesale Price pairs.

Put the tag from step 2 and a price on the rows you sell at trade rates. Leave a row blank to exclude it — blank means "no wholesale rule", not "free".

The pairs are what make this flexible: price the same variant at 80 for wholesale and 70 for distributor, and SheetSync produces two BSS rules from that one row. You are not limited to a single wholesale tier.

4. Generate and import

Press Generate BSS Import File. SheetSync validates every priced row first and tells you what it found:

Fix anything it reports, generate again, then download the generated tab as CSV and import it in BSS.

Changing prices later

Refresh from Shopify to pick up new variants and current retail prices — your wholesale column and settings are kept. Edit, generate, re-import. BSS replaces the rule rather than stacking a second one on top, as long as the rule name stays the same.

If you use native B2B catalogs instead

SheetSync manages native catalog pricing too, and that one does write straight into Shopify. The B2B Pricing tab lists the catalogs your store already has, and the sheet gets a price column for every catalog plus three volume-tier pairs each.

That needs a catalog assigned to a company location, which means you have set up Companies. Our setup guide walks through it, and bulk editing catalog prices covers the sheet.

Disclosure

BSS B2B Solution is a separate app from a separate company, with its own pricing. The code above is a referral code, and we may earn a commission if you subscribe through it. We recommend it because it is the approach we would use ourselves on a store that is not on SheetSync Unlimited — not because of the commission, and the SheetSync side works identically whether you use the code or not.

Common questions

Can SheetSync set wholesale prices in Shopify directly?

Yes, on the Unlimited plan, where SheetSync writes the prices into Shopify and charges them at checkout through its own discount function with no second app. This guide covers the other route: if you already run BSS B2B Solution, or you are not on Unlimited, SheetSync builds and validates the price list and generates the file BSS imports.

Do I need Shopify Plus for B2B wholesale pricing?

No. Shopify's native B2B is available on all plans, but unlimited catalogs and assigning a catalog directly to a company location remain Plus features, and other plans get up to three catalogs through Markets. Tag-based wholesale pricing, whether through BSS or through SheetSync itself, works on any plan and needs no company structure at all.

Why would I use BSS rather than SheetSync's own wholesale pricing?

Two reasons. If you already run BSS, its price lists are where your pricing lives and SheetSync feeds them rather than competing with them. And if you are not on the SheetSync Unlimited plan, the BSS route works on any SheetSync plan.

What happens if I mistype a wholesale price?

SheetSync validates every priced row before generating a file. A cell that is not a number is rejected with an error rather than being read as zero, so a typo cannot become a free product. Prices of zero, or at or above the retail price, are kept but flagged as warnings.

Does SheetSync write to Shopify in this setup?

No, and this is the one part of SheetSync that does not. The B2B tab produces a file you import into BSS, so pressing Push to Shopify elsewhere in the app never touches your wholesale prices.

Can I price the same product differently for two customer groups?

Yes. Each row carries three tag and price pairs, so one variant priced at 80 for wholesale and 70 for distributor produces two BSS rules from a single row.

Build the price list where it is easy to build

SheetSync gives you every variant and its retail price in a Google Sheet, checks your wholesale column, and generates the import file. Seven-day free trial, no credit card.

Try SheetSync free