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:
- Ordinary automatic discounts cannot read customer tags. A discount created through Shopify's Admin API has no customer targeting at all. Tag-aware pricing exists only for discounts backed by a Shopify Function, which is developer work plus a theme extension — not something you configure.
- Native B2B targets companies, not tags. Shopify's own B2B is genuinely good, but it works by assigning a catalog to a company location, so trade customers have to exist as companies with locations that your staff maintain. We walk through that in how to set up Shopify B2B.
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
| Route | Plan needed | How a customer qualifies | Second 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:
- A cell that is not a number is rejected. It is never read as zero — a typo cannot quietly turn into a free product.
- A price of zero, or one at or above the retail price, is kept but flagged, so an accidental markup does not reach your customers unnoticed.
- Write prices as plain numbers, like
1250.00. A currency symbol or a thousands separator is rejected rather than guessed at, because a comma means a decimal point in some countries and a thousands separator in others, and reading it the wrong way would price a product at a fraction of what you meant.
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