Price lists
How it works
You create price lists, then assign them to customers through customer groups. When customers sign in to your store, they see the prices you've set for them.
Pricing source
Price list
Customer group
Customer
| Type | How it works | Best for |
|---|---|---|
| Automatic | You choose a price list to start from, such as your Shopify prices, and lower or raise it by a percentage, such as 50% off. Every product gets a price. | A simple B2B pricing structure based on percentage discounts |
| Manual | You upload exact prices for your product SKUs by CSV, or edit them on a product's page. Only the SKUs you upload get a price. | Precise pricing, where you need control over every price a customer sees |
| Integration | A backend system such as an ERP, PIM or CRM sends price data to SparkLayer automatically. | Prices that are already managed in another system |
You can combine them: an automatic list at 50% off retail can also hold exact prices for a few products.
Prices are always shown net (excluding tax), and tax is added at checkout. To show prices with tax included, see tax-inclusive price display. If your store's own prices include tax, see If your store's prices include tax before you set up automatic pricing.
Create a price list
Start with an empty price list, then add its prices. Before you start, check that:
- Every product you sell to B2B customers has a unique SKU in your store. Prices are matched to products by SKU.
- Those products are active in your store, not drafts. SparkLayer only imports prices for active products.
- You know the currency of the prices. You need one price list per currency.
Pricing > Price lists
Walk through a working copy of Pricing > Price lists, step by step. Nothing you do here changes your store.
To create a price list:
- Go to Pricing,Price lists (opens in your SparkLayer Dashboard in a new tab) and click Create price list.
- Under Details, enter a Name, such as "Wholesale GBP".
- Check the Handle (or ID). It's filled in from the name. You can change it now, but not later.
- Choose a Currency. You can't change it later either.
- Under How this list sets prices, choose Work prices out automatically for a percentage off your store's prices, and set the rule (see Set up automatic pricing). Or choose Only the prices I upload.
- Optionally, add a CSV file of SKU prices under Exact prices for specific SKUs (Prices on a list with only uploaded prices). You can also do this once the list is created.
- Click Save in the save bar at the top of the page.
More detail
- Not sure which to choose? Work prices out automatically is quickest if your B2B prices are a set percentage off your retail prices. Choose Only the prices I upload if you already have a spreadsheet of trade prices: products not on the list show as unavailable to its customers. An automatic list can still hold exact prices for some SKUs.
- Work prices out automatically needs another price list to start from. If there isn't one yet, it's unavailable and the new list starts on Only the prices I upload.
-
Rather describe it? Click
Describe it instead
at the top of the form and tell
Ask Sparkie
what you want, for example
Create a price list 25% off retail for museum shops. It drafts the list for you to review before anything is created. - If you've connected a backend system such as an ERP to SparkLayer, only create price lists by hand if they aren't imported from that system.
The new price list appears on the Price lists screen. Next:
- Add any exact prices you didn't add when you created it: upload prices by CSV.
- Assign the price list to a customer group, so customers see it.
Price list settings
The price list page has the cards Details, How this list sets prices and Exact prices for specific SKUs (Prices on a list with only uploaded prices). Once the list is created, a Used by card shows which customer groups use it.
Every setting on the page
| Setting | What it does |
|---|---|
| Name | The name shown in SparkLayer, for example "Wholesale pricing". It must be unique. Customer groups choose the list by its name. |
| Handle (or ID) | The list's unique ID, for example wholesale-pricing. It's used in bulk CSV uploads, customer pricing and the API. It can't be changed once the list is created, and shows as text when you edit the list. |
| Currency | The currency of the prices in the list, for example GBP. Like the handle, it can't be changed once the list is created. |
| How this list sets prices | Work prices out automatically: every product gets a price, worked out from another price list. Only the prices I upload: only the SKUs you upload get a price, and other products show as unavailable to the list's customers. |
| Start from | The price list an automatic list works its prices out from, for example Shopify Price (USD). |
| Change | Lower it by or Raise it by a percentage, or Keep it the same to use the prices you start from as they are. |
| Percentage | How much to lower or raise prices by. |
| Exchange rate | The fixed rate to convert prices at, for example 1 USD = 0.79 GBP. Only shown when the list's currency differs from the list it starts from. See Set an exchange rate. |
| Exact prices for specific SKUs (or Prices) | The list's SKU prices: Upload CSV, Download CSV and Edit a product's prices. See Add manual prices. |
| Used by | The customer groups that use the list, and its place in each group's order. See See which customer groups use a price list. |
If you're on the Basic plan
Basic includes 3 price lists. If you save a 4th, you'll see Basic includes 3 price lists. Click Try Starter free to start a 14-day Starter trial with unlimited price lists, or click Not now and delete a list you don't use. See Your plan and usage.
Set up automatic pricing
An automatic price list works out its prices from another price list and a percentage, so you don't set each price yourself. It's the quickest setup when your B2B prices are a set percentage off retail.
- Create or edit a price list. Under How this list sets prices, choose Work prices out automatically.
- In Start from, choose Shopify Price, or one of your other price lists.
- Under Change, choose Lower it by or Raise it by, and enter the Percentage. For example, to take 50% off, choose Lower it by and enter
50. - If the list is in a different currency from the one it starts from, enter the Exchange rate. See Set an exchange rate.
- Check the summary under the rule, then click Save in the save bar.
The summary puts the rule in one sentence, with an example price. For a USD list 20% below Shopify Price, it reads 20% below Shopify Price, then "For example, US$100.00 becomes US$80.00. Prices follow the source when it changes."
More detail
- Shopify Price is the Price field on a product in the Shopify admin: the price your regular customers see on your store. When you change a price in Shopify, your automatic price lists update too. Manual prices don't change.
- Start from groups your lists under Platform price lists (such as Shopify Price), Manually created price lists and Integration price lists. A list that works its own prices out automatically can't be a starting point.
- An automatic list can also be based on the Shopify Compare-at price, but not on Cost per item.
- To use the prices you start from as they are, for example to copy them into another currency, choose Keep it the same.
- A decrease can be between 0% and 100%, and an increase between 0% and 500%.
- If your store's prices include tax, adjust the percentage for tax.
- On other platforms, you start from that platform's product price.
An automatic price list covers every product
An automatic price list always applies its percentage to all your products. You can't limit it to some SKUs, a brand or a collection. To price only some products, use a list set to Only the prices I upload: upload a CSV with a sku and a price for just those products, or set them on each product's page. To add more SKUs later, upload a CSV with only the new ones. If a group has both kinds of list, the order of its lists decides which price wins. For discounts by brand, see Move brand discounts from another wholesale app.
To set an exact price for a few products on an automatic list, upload them by CSV under Exact prices for specific SKUs on the list's page, or add the list to the variant on its product's page. The Type column then shows how many prices it holds, for example Manual (12) next to Automatic.
Set an exchange rate
If the price list is in a different currency from the list it starts from, Exchange rate appears under the rule, and prices are converted at the rate you enter. For example, for a GBP list 20% below Shopify Price in USD, enter 0.79 after 1 USD =. The summary then shows the converted price: 20% below Shopify Price, converted to GBP, "For example, US$100.00 becomes £63.20."
More detail
- A new automatic list needs an exchange rate to save, and so does a list whose Start from you change.
- A list saved without an exchange rate converts at the live exchange rate, and its summary says so. Enter a rate to fix it.
- If the price list is in the same currency as the list it starts from, there's no exchange rate to set.
If your store's prices include tax
SparkLayer treats the prices in a price list as net (excluding tax), and adds tax at checkout. An automatic price list takes its percentage off your store's own prices. So if your store's prices include tax, the result still contains tax, and tax is then added again at checkout. On Shopify, set your percentage, check the tax rate under Adjust pricing to handle tax and click Adjust pricing once: it rewrites the percentage with the tax taken out. Each click adjusts it again, so click it only once. The section appears when Change is Lower it by or Raise it by, for lists that start from Shopify's price or compare-at price.
To work it out by hand, find the percentage to lower prices by:
- Take your discount from 100. For 20% off: 100 − 20 = 80.
- Divide that by 1 plus your tax rate. With 20% VAT: 80 ÷ 1.2 = 66.67.
- Take the result from 100: 100 − 66.67 = 33.33. Choose Lower it by and enter
33.33.
Worked example: 20% off, with 20% VAT
| Price | Amount |
|---|---|
| Your store's price, including 20% VAT | £120.00 |
| Net price (excluding VAT) | £100.00 |
| What you want trade customers to pay: 20% off the net price | £80.00 + VAT |
| Lowered by 20%, the price list price | £96.00 + VAT (20% off £120, treated as net) |
| Lowered by 33.33%, the price list price | £80.00 + VAT |
For trade prices with no discount, only the tax taken out, lower prices by 100 − (100 ÷ 1.2) = 16.67%.
On Shopify, your prices include tax when Include sales tax in product price and shipping rate is turned on at Settings,Taxes and duties (opens in your Shopify admin in a new tab). If it's off, your prices are already net and you can enter the percentage you want as it is. If your Shopify store uses line item tax (specific tax rates per SKU), automatic price lists don't take this into account.
On other platforms, the same applies whenever your platform's product prices include tax.
Add manual prices
A list set to Only the prices I upload holds the exact prices you set for each SKU. Choose the tool that fits the job:
| To | Use |
|---|---|
| Add or update prices in bulk | Click Upload CSV on the list's page, or Upload next to the price list at Pricing,Price lists (opens in your SparkLayer Dashboard in a new tab). See Upload prices by CSV. |
| Change a few prices | Edit the product's prices at Pricing,Products (opens in your SparkLayer Dashboard in a new tab). |
| Set price breaks by quantity (for example buy 1 for $10.00, buy 5 for $8.00) | See Quantity pricing. |
You can add exact prices to an automatic price list too. That way you automate most of your pricing and still set specific prices for some products.
On the list's page, the Exact prices for specific SKUs card (Prices on a list with only uploaded prices) shows how many prices the list holds. Each quantity break counts as a price. It has:
- Upload CSV, to add prices from a CSV file. An upload adds to the list, it doesn't replace it.
- Download CSV, to download the list's prices. It shows once the list has prices.
- Edit a product's prices, which opens Pricing,Products (opens in your SparkLayer Dashboard in a new tab). See Edit a product's prices.
Send prices from another system
If your prices are managed in a backend system such as an ERP, it can send them to SparkLayer automatically through the SparkLayer API. This is available on the Pro and Enterprise plans, and is usually set up by your developer or integration partner. Some systems have a ready-made integration that does this for you.
Assign a price list to customers
A price list takes effect once you assign it to a customer group. This is how you decide which customers see which prices when they sign in.
- Go to Companies,Customer groups (opens in your SparkLayer Dashboard in a new tab) and click the group's name. To set prices for every B2B customer, click Edit on the Base customer group card instead.
- Find Price lists. If it's under Inherited rules, click + Override next to it (on the base group, + Customize) to move it up to Customized rules.
- Choose a price list. To add another, click Add price list.
- Click Save in the save bar.
More detail
- You can also choose a price list when you create a group, in the Create customer group window.
- Reset next to a customized rule hands it back to the base customer group.
-
Or describe the change to
Ask Sparkie
, for example
Use "Trade 20%" for Trade, and approve the draft. - See Customer groups for everything else a group controls.
Which price list wins
A customer group can have several price lists, numbered in the order you add them. When a product is in more than one of them, the first list wins. As the group page puts it: "If a SKU is in more than one list, SparkLayer uses the first list it's in." So the order of the lists is their priority.
For example, if ABC-123 is $10 in price list 1, $8 in price list 2 and $12 in price list 3, customers in the group see $10. A product that's only in list 3 gets its price from list 3.
- Put the most specific list first, such as a key account's prices or a clearance list, and a broad list like "Wholesale 30% off" last. A broad automatic list prices every product, so lists after it only count for products it can't price.
- The order is the one shown in the group's Price lists rule, at Companies,Customer groups (opens in your SparkLayer Dashboard in a new tab).
- Prices from outside the group come first. A customer's own price lists, set with customer pricing, and a company's or location's price list, replace the group's. See What overrides what.
If a customer sees the wrong price, check the price list order on their group first. See A customer gets prices from the wrong price list.
See which customer groups use a price list
Open the price list from Pricing,Price lists (opens in your SparkLayer Dashboard in a new tab). The Used by card lists the customer groups that use it, with its place in each group's Order, for example:
- Its only price list
- List 1 of 2, so this list's price wins
- List 2 of 2. An earlier list's price wins for SKUs on both.
Click View to open a group. To add or remove the list, edit the group. If no group uses the list, the card shows No customer group uses this list, and customers don't see its prices: click Go to customer groups to add it to one. The card shows customer groups only. To check whether a company or location uses the list, open its page.
Prices for one company or customer
Customer groups set the prices for most buyers. When one business or person needs something different, set their prices at a lower level:
| For | Do this |
|---|---|
| A company or one of its locations | Choose a Price list on the company page or the location page, in SparkLayer. |
| One customer | Give them their own price lists, or an extra percentage discount, on their record in your store (on Shopify, in the Shopify admin). See Prices for one customer. |
For the whole job, step by step, follow Give a key account their own prices.
Once your price lists are set up and assigned, you manage them from the Price lists screen.
The Price lists screen
Pricing,Price lists (opens in your SparkLayer Dashboard in a new tab) is where you manage every price list. It lists them in a table, with Bulk upload and Create price list at the top.
| Column | What it shows |
|---|---|
| Name | The price list's name, with its handle underneath (for example "Handle: trade-20"). Click it to edit the list. |
| Currency | The list's currency, such as USD. |
| Type | Manual (n): a list with n prices set by hand. Automatic: a list with an automatic rule. An automatic list with prices set by hand shows both. |
Each row has an Upload button, for uploading prices by CSV, and a ⋯ menu.
The ⋯ menu
| Menu item | What it does |
|---|---|
| Upload CSV | Uploads prices to this list. See Upload prices by CSV. |
| Download CSV | Downloads the list's SKU prices as a CSV file. It's unavailable for an automatic list with no SKUs set by hand. |
| Edit | Opens the list's settings. |
| Edit with Ask Sparkie | Opens Ask Sparkie with a prompt to change the list, such as Increase prices on "Trade 20%" by 5%, for you to review and approve. |
| Clear | Removes every SKU price uploaded to the list. See Clear or delete a price list. |
| Delete | Deletes the list. See Clear or delete a price list. |
Tips and shortcuts on the screen
- A tip banner appears at the top of the screen when something needs attention, for example "Trade has no price list, so those buyers see retail prices." or "Trade 20% isn't used by any customer group yet." Click Fix with Ask Sparkie to get a ready-made fix to review.
- The Common tasks card links to the usual jobs: create a price list, change prices on a list, set the price of one product, choose who sees a price list, and upload prices from a spreadsheet. Under it are prompts for Ask Sparkie to draft each change for you.
- In the Shopify app, there's also a tip to ask Shopify Sidekick which customer groups use a list. See Shopify Sidekick .
Edit a price list
- Go to Pricing,Price lists (opens in your SparkLayer Dashboard in a new tab) and click the list's name (or Edit in its ⋯ menu).
- Change the Name, how the list sets prices or its automatic rule. The Handle (or ID) and Currency show as text, because they can't be changed.
- Click Save in the save bar.
The same page has the list's SKU prices and the customer groups that use it: see Add manual prices and See which customer groups use a price list. The More actions menu at the top of the page has Edit with Ask Sparkie, Download CSV, Clear and Delete.
Stop an automatic list's rule
To keep only the prices you've uploaded to an automatic list, choose Only the prices I upload under How this list sets prices. A warning appears: The automatic rule stops when you save.
- If the list has uploaded prices, only those stay, for example "Only the 3 uploaded prices stay. Every other product shows as unavailable to these customers."
- If it has none, every product shows as unavailable to the list's customers. Upload prices first.
To keep the rule, choose Work prices out automatically again before you save.
Clear or delete a price list
Clearing empties a list but keeps it; deleting removes it.
| Action | What happens |
|---|---|
| Clear | Removes every SKU price uploaded to the list. On an automatic list, the automatic rule stays. Confirm with Clear prices. |
| Delete | Deletes the list. You can't delete a list while a customer group uses it, or while another price list starts from it: This price list is still in use shows what to change first. This can't be undone. Confirm with Delete price list. |
Both are in the list's ⋯ menu at Pricing,Price lists (opens in your SparkLayer Dashboard in a new tab), and in More actions when you're editing the list.
Tax and discounts
For how tax is calculated on B2B orders, see Tax and shipping.
To add promotions on top of price lists, use Discounts (Starter plan and above). They apply automatically or with a coupon code, for all customers or specific customer groups. They include an amount off an order, and you can give more off as the quantity goes up with one discount for each threshold.
Show "price on application"
To show "Price on application" instead of a price, so customers contact you for one:
- Leave the product out of the customer's price lists. With no B2B price, it shows Unavailable instead of a price and quantity box, and can't be added to the order. This needs price lists set to Only the prices I upload, because an automatic list covers every product. To do it for one group whatever its price lists, make the variant un-sellable for that group instead: see Hide variants or make them unavailable.
- Rename "Unavailable". At Storefront,Options,Translation overrides (opens in your SparkLayer Dashboard in a new tab), add overrides for
pdp.messaging.un-sellable(product pages) andproduct-card.messaging.un-sellable(product cards), for examplePrice on application. See Change the "Unavailable" message.
More detail
- The new text shows wherever a product has no price, including products missing from a price list by mistake. Check your other products have prices first: see Why a product shows Unavailable.
- To let customers ask for a price, use the Quoting Engine: your sales reps can add price on application (POA) products to a quote and set the price.
Troubleshooting
Why a product shows Unavailable
B2B customers see Unavailable instead of a price and quantity box when SparkLayer has no price it can use for them.
| Cause | Fix |
|---|---|
| No B2B price for the SKU on the customer's price lists. This is the most common cause. | Add a price for the SKU, by CSV or on the product's page. If B2B customers shouldn't buy it, hide it from them with the free B2B Catalogs app and the b2c-only tag. |
| The automatic list's pricing source is empty for that variant. For example, the list is based on the compare-at price and the variant has no compare-at price, so there's nothing to take the percentage from. | Fill in the field in your store, then wait a few minutes for it to sync. |
| The SKU in the price list doesn't match the product, because of spaces in the CSV or a SKU that's changed. | See If prices show as Unavailable after an upload. |
| The product isn't in SparkLayer. Searching at Pricing,Products (opens in your SparkLayer Dashboard in a new tab) finds no product. | Publish the product to the SparkLayer Wholesale sales channel, and check it's Active. See Add prices for a product that isn't found. |
The variant has been made un-sellable on purpose, with sell: false in its sparklayer.settings metafield. | Remove the setting if customers should be able to order it. See Hide variants or make them unavailable. |
Your store might not say Unavailable. If your theme or the pdp.messaging.un-sellable language string has been changed, the same state can show as Out of stock, or as a message such as "Contact us to order". Check the causes above before you look at stock.
A free product from a discount needs a B2B price too. If the free SKU has no price on the customer's price lists, it shows as Unavailable in the cart.
If prices show as Unavailable after an upload
An upload can look successful and still match nothing. Two things cause this:
- Spaces before or after a SKU.
ABC-123(with a space) doesn't matchABC-123. Clear the price list (⋯ > Clear), trim the spaces from the SKU column, then upload the file again. In Excel or Google Sheets, theTRIMfunction removes them. - SKUs changed in your store after the upload. The price list still holds prices for the old SKUs, so the products with new SKUs have no price. Upload the prices again against the new SKUs. See Upload prices by CSV.
FAQs
Straight away. Price changes in your platform update automatic price lists in SparkLayer instantly.
Yes. Upload a CSV file with only the SKUs and prices you want to set, with Upload CSV on the list's page (see Upload prices by CSV), or add the list to the variant on its product's page.
No. The handle and currency can't be changed once a price list has been created. Create a new price list instead.
See Pricing FAQs for common questions about price lists, and the troubleshooting guide for ways to solve common issues.
Next steps
Last updated