If your prices live in a spreadsheet, you don't have to type them in. Import them into a price list or as own prices, then check a few buyers before you tell anyone. This article covers Import, Check a price, Set minimum margin and Export on the Prices page.
Plan: every plan. Who can do it: editors, approvers and admins. Set minimum margin is for Admins.
Import prices
Go to Prices and click Import. First choose Where should the prices go?
- Into a price list: saved in Shopify, so the same prices apply on orders in the app and at checkout. Use this in most cases.
- As own prices: kept in the app, for orders you approve here. Use this for another wholesale pricing app's export.
Into a price list
- Pick the Price list.
- Click Download this list (or Download every product for all your products). You get a CSV with the columns sku, barcode, product, retail price, price, minimum, maximum, pack size, volume breaks and currency.
- Change the prices in your spreadsheet and save it as CSV.
- Drop the file in and click Import into the list.
You can also open a list from Prices → Price lists and click Import prices there.
How the file is read:
- Products are found by SKU, or by barcode when there's no SKU.
- An empty price puts the product back on the list's % off.
- A column the file doesn't have keeps what Shopify has now, so a file with only prices leaves minimums alone.
- Volume breaks are quantity:price pairs separated by ";", like
24:8.90; 48:8.40. They need the product's own price. - Products set by an own price are skipped. Change the own price instead.
- Prices are in the list's currency.
The result says how many products were saved in Shopify and lists any rows that were skipped, with the reason (for example "no product with SKU or barcode "FC-12"" or "the minimum isn't a multiple of the pack size").
As own prices
- Choose As own prices.
- Prepare a CSV with one rule per row: buyer (company name or external ID) or group, sku (empty for all products), price or percent off, and optionally min qty, start and end dates. For example:
buyer,group,sku,price,percent off,min qty,start,end
Oak & Fern,,FC-12,8.25,,12,,2026-12-31
,Cafes,,,30,,,
- Drop the file in and click Import own prices.
Importing the same file again updates the prices instead of adding them twice. Only the first 5,000 rows are read.
Check a price
Check a price tells you what a buyer pays for a product at a quantity, and which step decided it.
- Go to Prices and click Check a price.
- Pick the Buyer, the product and the Quantity.
You see the price ("$9.50 each"), where it comes from ("From their Shopify price list", "From the buyer's own price…"), and the retail price, price list price and location. If no price is found, an order line for that product would be flagged.
<!-- screenshot: prices/import-and-check-prices-2.png — Check a price with buyer, product, quantity and the answer -->Compare every buyer's price
Below the check, Every buyer's price for a product shows what each buyer pays now for one product, lowest first, with Off retail, Margin, where the price comes from and the units they bought in the last 12 months. The summary shows retail, cost, and the lowest, typical and highest price. Use it to spot a buyer who pays far less than everyone else.
Set a minimum margin
- Click Set minimum margin at the top of the Prices page.
- Enter your Minimum margin, for example 35%. Leave it empty for no warning.
- Save.
Prices that leave less than this margin (worked out from the product cost in Shopify) are marked in amber, and prices below cost in red, on price lists, on buyer pages and in the comparison. Your agent's notes also list own prices that are below cost.
Export
Click Export at the top of the Prices page to download every own price as a CSV. To export a price list, open it and use Download this list in its import window.
What your buyers see
Nothing changes for buyers until you import. After an import into a price list, buyers on it get the new prices at checkout straight away, so check a few with Check a price first.
Good to know
- Moving from another wholesale pricing app: export its price list to CSV and import it here. Other apps' prices can't be read directly.
- Margins need a cost on the product in Shopify. Without one, margin shows "—".
- Buyers paying in another currency are shown in that currency and left out of the lowest, typical and highest.
If something goes wrong
- "No SKU or barcode column": the file needs a column named sku, code, item code, barcode, UPC, EAN or GTIN.
- "Buyer not found": use the company name exactly as in Shopify, or its external ID.
- "SKU not found in Shopify (discontinued?)": the product was removed or its SKU changed.
- More fixes: Prices and checkout problems.