Skip to main content
A price list is a second set of prices sitting alongside your normal shop prices. It holds the products it covers, what each one costs in each currency, and the rules deciding who gets it. A shopper matching those rules pays the list’s price, and everybody else pays your normal price. Price lists suit prices that follow a situation rather than a customer: what a market pays, what a sales channel charges, or what a case of twenty-four costs compared with a single unit. The rules do the matching, so a shopper does not have to be identified or signed in for a list to reach them, unless the sales channel itself requires an account before anyone can browse. A price list is not a catalog. A catalog is an agreement with named buyers, assigned to a company or a customer group, and it can hide products as well as price them. A price list points at a circumstance instead, reaches anybody in it, and only ever changes prices. Reach for a price list when the price depends on where the order comes from or how much is being bought, and for a catalog when it depends on who is buying. See Catalogs. To manage price lists, navigate to Products → Price Lists in the admin dashboard.
A catalog keeps its prices on the catalog itself, so they will never appear under price lists. The two are managed separately even though both end up as prices a buyer pays.

Reviewing Price Lists

The Price Lists screen, with one active list The list shows one row per price list, with its description under its name. The Status filter narrows the list to any of the four states, and Add filter narrows it by start date, end date, or when a list was created or last updated.
A slot is counted for every variant of every product in every currency as soon as the product is added, so a new list with three products can show a large Prices figure before a single amount has been typed.

How to Create a Price List

Click New price list to open a form with four sections.
  • Name - What your team calls the list, such as the region or arrangement it covers. Shoppers never see it, and it is the only required field.
  • Description - A note for your team on who the list is for.
  • Rules - Who the list applies to. A list with no rules applies to every shopper.
  • Starts and Ends - The dates it runs between. Leaving both empty means it applies from the moment it is activated, with no end date.
Click Create, and the list opens on its own page as a Draft, ready for its products.

How to Choose Who a List Applies To

A price list's page, with its rules, products and schedule The Rules card holds the conditions a shopper has to meet. With more than one rule, All rules must match and Any rule may match decide how they combine. Each kind of rule can be used once per list, so one already in use is not offered again.
  • Market - One or more of your markets. Leaving the box empty applies the rule in every market. A market rule reaches every shopper there, signed in or not. See Markets.
  • Channel - Ties the list to a sales channel, so the same product can cost one thing in your online store and another somewhere else. See Sales Channels.
  • Volume pricing - A Minimum quantity, and a Maximum quantity where there is a ceiling. Leaving the maximum empty means no upper limit.
The pencil beside a rule edits it and the bin removes it, with the removal taking effect when the price list is saved.
Customer group and individual customer rules are not offered on price lists. To give a customer group or a company its own prices, assign them to a catalog instead.

How to Add Products to a Price List

The product picker, with products ticked ready to add
  1. On the list’s page, click Add products.
  2. Search, tick each product you want, and click Add. Products already on the list are marked Added.
  3. Click Save at the top of the page.
Until the page is saved, new products show as New with After save in the price column. Removing one works the same way: the cross at the end of a row strikes it through with an undo arrow beside it, and it is only removed on save. Once saved, every variant of each product carries a price with a badge. Entered means an amount was typed on this list, and Shop price means the list holds no amount for it so the normal price is shown instead. Where quantity breaks exist, a marker beside the price says how many, and hovering it shows the price at each quantity. The Products card, showing entered prices, shop prices and a product added but not yet saved

How to Enter Prices and Quantity Breaks

The Edit prices grid, with a quantity break from 10 units A price list has no currency of its own. A price is entered for each currency you sell in, and a shopper paying in that currency gets that price.
  1. Click Edit prices. A full-screen grid opens with one row per variant.
  2. Choose the currency at the top. The table on the list’s page shows one currency at a time, so this grid is where the others are checked.
  3. Click into a Price cell and type the amount, adding a Compare-at price where you show a crossed-out price.
  4. For a lower price on larger orders, type a quantity in the empty row beneath a product’s first price, then the price for that quantity. The first price always starts at From qty 1.
  5. Click Save prices.
The grid stays open after saving, so you can switch currency and carry on. The header counts unsaved changes, and Discard throws them away.

Quantity Breaks

A quantity break lowers the price of every unit in the cart once the quantity is reached, not just the units above it. Take a product priced at 35.00 with a break from 10 units at 30.00:
  • A shopper with 9 in the cart pays 35.00 each, so 315.00 in total.
  • A shopper with 10 in the cart pays 30.00 each, so 300.00 in total.
Adding the tenth unit makes the whole order cheaper than nine, which is the effect a case price is meant to have.
Two kinds of quantity break are refused, and the list will not save until they are fixed:
  • A quantity with no price against it. Enter a price for the break, or clear the quantity to remove it.
  • A break costing more than the price below it. A buyer taking more should never pay more per unit.
Prices on a list are separate from the prices on the product itself, so changing a product’s own price leaves its price list amounts as they were. See Adding Products.

How to Activate a Price List

A new list starts as a Draft and reaches nobody. Click Activate to start enforcing it. What happens next depends on the dates set on the list. With no start date, or one that has already passed, the status changes to Active and shoppers matching the rules see its prices straight away on the product page and in the cart. With a start date still in the future, the status changes to Scheduled instead, and the prices begin applying when that date arrives. Deactivate switches it off again and keeps everything it holds, so activating it later brings its prices back. Fill in every price you mean to charge before activating. A list carrying no rules, no products and no catalog cannot be activated at all, because it would price nothing.
To verify a price list has taken effect, open your storefront as a shopper the list should reach and look at one of its products. That single check tests the rules and the prices together.

How to Update Prices from a Spreadsheet

Import and Export on the price list’s page move its prices as a CSV file, which is how prices are changed in bulk without working through the grid row by row. Export downloads every price on the list that has an amount. Empty slots are left out. Import takes the file back:
  1. Click Import, drop the file in or browse for it, and set the Column separator your file uses. Download CSV template gives an empty file in the right shape.
  2. Click Continue and match each column to the field it holds. SKU and Price are required, and Currency, Minimum quantity and Compare at Price are optional.
  3. Click Start import.
The result says how many rows were imported and how many failed. An import changes only the prices its rows name, rather than replacing everything on the list. A price whose row is left out of the file keeps the amount it already had, so deleting a row from an exported file does not remove that price. Clearing the Price on a row is what removes it.
Because the minimum quantity is a column, quantity breaks travel as extra rows for the same SKU. The surest way to get a file the import accepts is to export the list first, change the amounts, and import the same file back.

Further Reading