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 sync with the retail one.

On Shopify that is harder than it sounds. Here is why, and the two tools we point clients to when they hit this exact wall: SheetSync and BSS B2B Solution.

Why “Customers With This Tag Pay This Price” Is Not Built In

It feels like it should be a setting in Shopify admin. It is not, for two separate reasons.

• Automatic discounts cannot read customer tags. A discount created through Shopify’s Admin API has no customer targeting at all. Tag based conditions only exist for discounts backed by a Shopify Function, which means developer work plus a theme extension, not something you configure yourself.
• Native B2B targets companies, not tags. Shopify’s own B2B feature is genuinely good, but it works by assigning a catalog to a company location. Your trade customers have to exist as companies with locations, and someone on your team has to maintain that structure going forward.

Native B2B is available on every Shopify plan now. 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.

Two Honest Options

Native B2B catalogs make sense when you have real trade accounts with multiple buyers, purchase orders, and payment terms. You will need companies and company locations set up in Shopify, and Plus if you want unlimited catalogs with direct assignment.

Tag based pricing through an app makes sense when you have a wholesale price list and a list of customers who should see it, with no company structure to maintain. It works on any Shopify plan, and for most smaller merchants it is the right answer. The app we recommend for this is BSS B2B Solution.

Where SheetSync Fits Alongside BSS

BSS applies the pricing. It is not where you want to build the pricing. Typing a few hundred wholesale prices into any app’s interface is slow and there is nothing checking your work as you go.

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 in the column with formulas, a paste from your supplier’s file, or whatever process you already use. SheetSync then generates the import file BSS expects.

One thing worth knowing: this is the only part of SheetSync that does not write to Shopify directly. Every other tab pushes your edits straight into the store. B2B pricing produces a file you upload into BSS instead.

How It Works, Start to Finish

1. Install BSS B2B Solution from the Shopify App Store.
2. Tag your trade customers in Shopify admin, for example with a “wholesale” tag. The tag is the whole mechanism: tagged customers see the price, everyone else sees retail.
3. Build the price list in SheetSync. Open the B2B Pricing tab to get one row per variant, with product name, variant name, SKU, current retail price, and an empty Wholesale Price column. Leave a row blank to exclude it from wholesale pricing entirely.
4. Set the rule on the BSS Settings tab: the customer tag, rule name, priority, and which market it applies to.
5. Generate and import. SheetSync validates every priced row first. A cell that is not a number gets rejected rather than silently read as zero, and a price at or above retail gets flagged so an accidental markup never reaches a customer unnoticed. Download the generated tab as CSV and import it into BSS.

When prices change later, refresh from Shopify to pick up new variants and current retail prices. Your wholesale column and settings stay put. Edit, generate, re-import. BSS replaces the existing rule rather than stacking a second one on top, as long as the rule name stays the same.

Why This Is a CTO Question, Not Just an App Question

This is a small example of a pattern we see constantly with non-technical founders: a request that sounds simple (“can our wholesale customers just see different prices?”) turns out to hinge on how Shopify’s discount engine and B2B architecture actually work under the hood. Pick the wrong approach and you end up either paying for Plus before you need it, or maintaining a company and location structure for a handful of trade accounts that never needed one.

Knowing which of the two honest options above fits your actual customer base, before you brief a developer or commit to a plan upgrade, is exactly the kind of decision a fractional CTO exists to make quickly.

Full step-by-step documentation, including how SheetSync validates currency symbols and thousands separators, is in the SheetSync help center.