Price lists let you offer advanced variant-level price overrides based on customer groups. Visitors to your store see the same products, but are shown different prices based on the group they belong to.
For example, a wholesale merchant might offer standard (retail) pricing to all visitors of their store, but also offer special discounted pricing that only certain customers can see and access.
Catalog Pricing vs. Price List Pricing
Price lists work by overriding the Catalog Price defined in your regular BigCommerce catalog.
What is Catalog Price? In price lists, Catalog Price is the price of the product or variant as seen on the storefront before any price list data has been applied. It takes into account Sale Price and any price adjustment rules that are applicable to the product or variant.
Entering data for a product/variant in a price list creates a new "price record". That means that this price list value will override the Catalog Price for that product/variant.
Since some prices are calculated relative to another value, a price list will use a product/variant’s Catalog Price to generate the missing value when necessary.
For instance, if you create new price record by adding a % Discount bulk price tier to a product, the list will automatically use the product's Catalog Price to generate a New Price. Since there is no variant-level bulk pricing in the regular BigCommerce catalog, variant-level bulk price tiers will use the Catalog Price of the variant's base/parent product to generate a variant-level New Price.
Managing Price Lists
Go to Products › Price Lists.
This screen will display all your price lists, their names, how many customer groups they apply to, and their status (live or hidden).
From here, you can create, edit, publish/unpublish, search, and delete price lists.
- There is no limit to the number of price lists you can have.
- A single price list can be applied to multiple customer groups, however, a customer group can only be assigned to a single price list at a time.
Creating a Price List
When you click Create Price List, you’ll first be asked to give your list a name. This is for your reference only and is not shown publicly.
Next, define which customer groups this list will apply to. This determines who sees the prices on this price list. You can change this at any time.
Click Save when done. Your newly created price list will save as a draft, and won't be live until you publish it.
Editing a Price List
In a price list, products are displayed in columns and rows, like a spreadsheet. Each row is a product, and variants are grouped together.
Use the + button to expand or collapse variant rows.
Use the Search bar and Filters button to filter the list down to the products you want to work with.
Columns display name, variation, SKU, and pricing information about each product/variant. Use the Edit Columns drop-down to show/hide columns.
- Product Name (read-only) — This is the name of the product. If it’s a variant, this will show which option values comprise the variation (e.g. Black / Medium).
- SKU (read-only) — The product/variant SKU.
- Cost (read-only) — This is the product’s cost.
- Markup (read-only) — This is the difference between Cost and Catalog Price, as a percentage.
- Catalog Price (read-only) — This is the price of the product or variant as seen on the storefront. It takes into account Sale Price and any price adjustment rules that are applicable to a variant.
- Discount — This is the difference between the price in your catalog and the price in this list, as a percentage. You can also edit the percentage in this box to calculate a new price.
- New Price — The new, calculated price that will be shown on the storefront for customers that belong to any customer group this price list is applied to. You can edit the price in this box, and the percentage under Discount will update automatically to reflect it. If applied at the variant level, it will override New Price set on the parent/base product.
- New Sale Price — This will override the catalog sale price for a product or variant. If applied at the variant level, it will override New Sale Price set on the parent/base product.
- New MSRP — This will override the catalog retail price of a product or variant.
- Bulk Pricing — This field provides a table for bulk pricing (discounts based on quantity). There are three bulk pricing types.
- % Discount — This is a percentage discount that is relative to New Price (or Sale Price if active). Conversely, you can enter the Unit Price to calculate the % Discount value.
- $ Off/Unit — This represents a dollar amount off per unit relative to New Price (or Sale Price if active). Conversely, you can enter the Unit Price to calculate the $ Off/Unit value.
- $ Fixed Amount — This sets the Unit Price for each quantity tier to an absolute, fixed value. This type does not consider any other pricing (like New Price or Sale Price).
- Pricing Summary (read-only) — This field displays the full range of pricing for a product, including all sale, variant and bulk pricing (and bulk pricing on variants).
Publishing a Price List
When you’re ready to make your price list live, change the toggle under Status. This can also be found under the Details tab when editing a price list.
- How are price lists different from customer group discounts?
- Why do some customer groups appear greyed out when creating a new price list?
- How do products with a price range (e.g. $5 - $10) appear on the storefront?
- How do products with a New MSRP, New Price, and New Sale Price appear on the storefront?
- Will the price for products with options always show up as a range in Price Lists in the Control Panel?
- Will the price for products with options always show up as a range on my storefront?
- What is the shopper experience? What do they see? Will they see the discount percentage?
- Can I import?
- Can I change to more decimal points?
- Can a Price List be for a single customer?
- What happens if you have bulk pricing in the catalog and then have Price List price overrides – what does the shopper get?
- Can I add a markup or only discounts?
- Do you support MAP pricing?
- What if my Stencil template was purchased from a third-party theme developer?
- Do you have an API for this?
- What order do products show up in a Price List?
- Are marketing discount rules still retained?
- Can I export as a PDF?
- Who is allowed to edit my Price Lists?
- Will Price Lists be slower with a lot of products?
- How do you handle multi-currency?
- Can I do a category discount?
- How are tax zones represented here?
- Can I edit cost price in the Price List?
- How do I do a storewide discount?
- How would Price Lists work with customer group discounts?
- How does this work with Amazon, Instagram, etc?
- Do I need SKUs to use Price Lists?
How are price lists different from customer group discounts?
- Price lists allow variant/SKU-level pricing.
- Price lists can be saved in an unpublished draft state.
- Price lists are searchable.
Why do some customer groups appear greyed out when creating a new price list?
Greyed-out customer groups are either already assigned to another price list, or are currently using customer group discounts. Customer groups can only be assigned to one price list at a time, and cannot be assigned to a price list and use customer group discounts at the same time (it can use one or the other, but not both).
How do products with a price range (e.g. $5 - $10) appear on the storefront?
It depends. Your theme has to support price ranges, and the feature has to be enabled.
Currently, Cornerstone is the only out-of-the-box theme that supports showing price ranges on the storefront.
How do products with a New MSRP, New Price, and New Sale Price appear on the storefront?
It depends. Most themes will show the New MSRP crossed out with New Sale Price below it and a message showing how much “You Save”. New Price is ignored on the storefront in this instance.
However, Cornerstone and other updated themes are capable of showing two levels of crossed out prices, so it will show both the New MSRP and New Price crossed out with the New Sale Price and You Save message below. See Using Sale Pricing to learn more about how sale pricing appears on the storefront.
Will the price for products with options always show up as a range in Price Lists in the Control Panel?
Not always - options can be added to a product without producing a price range on the storefront. A price range will only be involved if there are different product prices available on different variants either coming from a SKU price, a rule, or otherwise. For example, price adjustment rules on the product could mean that some option selections offer a different final price than others. Similarly, if variants are created on the product then you can set different prices per variant as well as within a Price List. All of these things are considered when determining if there is a “price range” available.
Will the price for products with options always show up as a range on my storefront?
Not always. The Stencil theme being used needs to be setup to display the price as a range if that data is sent. Most themes will be only set to display a single product price even if a range is available, and in this case, the lowest variant price will be displayed. Additionally, in Cornerstone, there is a theme customization setting to enable or disable displaying of price ranges.
What is the shopper experience? What do they see? Will they see the discount percentage?
Only the New Price, New Sale Price, New MSRP and Bulk Pricing column values can display on your shop using the current Cornerstone theme or any Stencil theme that is built to use these values. The Discount percentage column, and all other columns, are not displayed on the storefront, it is there for your convenience.
Can I import?
Not at this time.
Can I change to more decimal points?
You can change your storewide currency settings under ‘Store Setup’ and ‘Currencies.’ Use the ‘more’ menu to edit a currency and you can choose the # of decimal places at the bottom. You can use up to 4 decimal places.
Can a Price List be for a single customer?
Yes. You would have to have a customer group with that single customer in it, and then associate it with a Price List.
What happens if you have bulk pricing in catalog and then have Price List price overrides – what does the shopper get?
As soon as new prices or new bulk prices have been entered into a Price List, all catalog bulk pricing tiers are now ignored. The shopper will be given the Price List pricing for variants that have a new price created and catalog bulk pricing will be ignored for those variants. Bulk pricing must be created in the Price List for it to affect variants that have a Price List ‘New Price’.
Can I add a markup or only discounts?
Yes, you can add a markup by putting a negative number in the discount column, which will generate a higher new price.
Do you support MAP pricing?
We do not currently support MAP pricing on the storefront in Cornerstore, however we support it on the API, meaning we can store this data. We have not yet added it to our CornerStone theme but you could add it yourself. MAP pricing can be set on a variant using a Price List and that value will be sent to the front end when that variant is selected. Your template needs to be updated to read that value and display it as you see fit.
What if my Stencil template was purchased from a third-party theme developer?
If you are using Stencil then you do not need to change anything to utilize Price List pricing. If you apply Price Lists to your store then you will see those prices on the storefront. However, by default, you will likely be missing out on some new pricing behavior related to displaying “sale price”, price ranges, or possibly even an MSRP. You can consult with your theme developer to make an update to utilize the new pricing values you can set using Price Lists. Alternatively, you can modify your template yourself by making a copy of it from the “storefront” > “My Themes” page. This requires knowledge of Stencil and customizing HTML templates.
Do you have an API for this?
What order do products show up in a Price List?
Products show up in Price Lists in the same order they appear in the product list page which is in order of product ID. Product ID is generated when a product is created so they will be in numerical/chronological order (newest first).
Are marketing discount rules still retained?
Yes, marketing discount rules are still retained, and will apply in the cart on top of the prices the customer sees on the product page.
Can I export as a PDF?
Not at this time.
Who is allowed to edit my Price Lists?
You can control your permissions for Price Lists under ‘Account Settings’ > ‘Users’ where you can add Price Lists editing capabilities to any user type or specific user. Only users who have permissions for Customer Groups and Price Lists can edit Price Lists.
Will Price Lists be slower with a lot of products?
Price Lists has been pressure tested with very large catalogs and we have not seen any drastic performance issues based on catalog size.
How do you handle multi-currency?
Currently, we do not have a way to have multiple currencies in a Price List or across Price Lists. Price Lists will consume whatever default currency you have set in your storewide currency settings. We will convert prices from Price Lists to the storefront currency if it is set to a currency that is not the store default.
Can I do a category discount?
We currently don’t support a category level discount, however, you may use filtering to sort by category and apply discounts individually to products in that category.
How are tax zones represented here?
The storefront works in one tax zone at a time. If we are given information at checkout that indicates that a different tax zone should be displayed then any tax displayed at that time will be updated to match the new tax zone.
Can I edit cost price in the Price List?
Not at this time. This column is informational only.
How do I do a storewide discount?
We currently do not support a storewide discount, however, you may copy and paste a discount across all of your products in a Price List, or drag the handle to replicate a price value.
How would Price Lists work with customer group discounts?
Right now you cannot use both customer group discounts and a Price List at the same time for a customer group. You can choose one or the other on the customer group page.
How does this work with Amazon, Instagram, etc?
Price Lists override your catalog price on your storefront and do not affect any of the prices that show up on Amazon or other channels. Those will need to be updated individually.
Do I need SKUs to use Price Lists?
No. However, we believe it is best practice to have a product identifier (other than your product name) that you can use for external channels and other ecommerce practices.