You want trade customers to log in and see their own prices. Not a discount code they have to remember, not a second wholesale store, and not a company record for every customer who buys at trade rates.
On the Unlimited plan, SheetSync does this on its own: you set the prices in a Google Sheet, and customers carrying the tag you choose are charged them. No Shopify Plus, and no second app.
Why "this tag pays this price" is not a Shopify setting
It looks like it should be one. It is not, for two reasons worth knowing before you pick any solution:
- Ordinary automatic discounts cannot read customer tags. A discount created through Shopify's Admin API has no customer targeting at all. Tag-aware pricing is only possible through a Shopify Function, which is developer work plus a theme extension.
- Native B2B targets companies, not tags. Shopify's own B2B assigns a catalog to a company location, so every trade customer has to exist inside a company structure you maintain. That is covered in how to set up Shopify B2B.
SheetSync takes the first route so you do not have to. The function and the theme extension ship with the app.
What you need
- The SheetSync Unlimited plan. Any Shopify plan is fine.
- Two permissions, which Shopify asks for when you switch the feature on and at no other time: permission to read your customers' tags, and permission to create one automatic discount.
- The Wholesale prices app embed switched on in your theme, if you want trade customers to see their price before checkout.
SheetSync reads customer tags and nothing else about your customers.
Setting it up
1. Tag your trade customers
In the Shopify admin, tag the customers who should get wholesale prices — wholesale, trade, distributor, whatever suits your store. The tag is the entire mechanism. Tagged customers get the price, everyone else gets retail.
2. Create the B2B sheet
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.
Fill in the tag from step 1 and a price on the rows you sell at trade rates. Leave a row blank to exclude it. Blank means "no wholesale rule", never "free".
Because it is a Google Sheet, the price column can be a formula. =ROUND(E2*0.7, 2) down the column is a 30 % trade discount that you can inspect before anything is written.
3. Switch wholesale pricing on
In the same tab, under Charging these prices, turn wholesale pricing on. Shopify asks for the two permissions, and SheetSync creates a single automatic discount in your store called SheetSync wholesale prices. You do not configure it and you should not edit it by hand.
4. Preview, then push
Pushing shows you every price that would change before anything is written. Nothing reaches Shopify until you approve it.
The checks that run first:
- A cell that is not a number is rejected, never read as zero. A typo cannot turn into a free product.
- A price of zero, or at or above the retail price, is kept but flagged — and a wholesale price above retail is never charged.
- 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.
Every write is recorded in Activity with what it replaced, and anything applied in the last seven days can be undone.
5. Turn on the theme embed
Checkout charges the wholesale price whether or not you do this. The embed is what lets trade customers see it on the way there — on product pages, collection pages and search results, with the retail price struck through if you want it.
In the app, press Turn on in theme, switch on Wholesale prices, and save.
What the customer sees
A tagged customer browsing while signed in sees their own price across the shop. At checkout they are charged it, shown as a discount on the order rather than as a changed line price. That is not a cosmetic choice: outside Shopify Plus it is the only mechanism available, and it is how every tag-based pricing app works, including the paid ones.
An untagged customer sees and pays retail, and never sees that wholesale pricing exists.
More than one trade tier
Each row carries three tag and price pairs, so one variant can be 80 for wholesale and 70 for distributor. A customer carrying more than one priced tag gets the lowest price they qualify for.
A tag you only use on some rows is fine. Rows you leave blank for that tag simply have no wholesale rule.
When tags change
Removing a trade customer's tag puts them back on retail prices without you touching the sheet. SheetSync listens for customer updates in Shopify and clears the wholesale stamp as soon as a customer stops carrying a priced tag.
Adding the tag to a new customer works the same way round: they qualify as soon as Shopify tells SheetSync about the change.
How this compares to the other two routes
| 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 |
Pick native catalogs if you have real trade accounts with multiple buyers, purchase orders and payment terms. Pick this if you have a price list and a list of people who should see it. Pick BSS if you are already paying for it, or if you are not on SheetSync Unlimited.
Common questions
Can SheetSync set wholesale prices in Shopify directly?
Yes, on the Unlimited plan. SheetSync writes the wholesale prices into Shopify itself and charges them at checkout through its own discount function, with no second app and no Shopify Plus. Customers qualify by carrying a tag you choose, so there are no companies or company locations to maintain.
Do I need Shopify Plus for tag-based wholesale pricing?
No. Tag-based wholesale pricing in SheetSync works on any Shopify plan, including Basic. The requirement is the SheetSync Unlimited plan, not a Shopify one.
How does a tagged customer get the wholesale price at checkout?
SheetSync creates one automatic discount in your store, backed by a Shopify Function. The function reads the wholesale price stored against each variant and the tags stamped on the customer, and brings the line down to the wholesale price. It appears on the order as a discount rather than as a changed price, which is the only mechanism Shopify allows outside Plus.
What happens if a wholesale price is higher than the retail price?
Nothing is charged. A wholesale price at or above the current retail price is left alone rather than applied, so a mistyped row cannot raise what a customer pays. Those rows are flagged in the preview before you push.
Can one product have more than one wholesale price?
Yes. Each row carries three tag and price pairs, so the same variant can be 80 for one tag and 70 for another. A customer carrying more than one priced tag gets the lowest price they qualify for.
What happens when I remove a customer's tag?
They go back to retail prices. SheetSync listens for customer updates in Shopify and clears the wholesale stamp when a customer no longer carries a priced tag, so access is removed without you pushing the sheet again.
Does this change my retail prices?
No. Your retail prices are never written to. The wholesale price is stored separately against the variant and only applies to customers carrying a priced tag.
Wholesale pricing, without Plus and without a second app
Set your trade prices in a Google Sheet and let SheetSync charge them. Included in the Unlimited plan, with a seven-day free trial and no credit card.
Try SheetSync free