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:

SheetSync takes the first route so you do not have to. The function and the theme extension ship with the app.

What you need

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:

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

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

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