Quantity Pricing & Rules
Please note: Quantity pricing is only supported with manual CSV price lists (not automatic price lists). Learn more about Managing Pricing
SparkLayer also supports the option to have tiered pricing allowing you to offer discounted prices based on the unit quantities ordered. Let's use an example:
- For 1 unit of a product, you want your B2B customers to pay $14.99
- For 5 units of a product, the price to pay is be $10.99
- For 10 units of a product the price to pay is $8.99
- etc
The quantity field in the sample CSV file (named qty) lets you define the price the customer pays for that specific quantity of the item.
In order for the CSV file to import your tiered pricing successfully, it must have the following columns:
Column | Details | Required |
sku | The product SKU as set up in your eCommerce platform or backend system | Yes |
price | The unit price for the SKU at the quantity set in column 3 (qty) | Yes |
qty | The quantity of the SKU for the specified price for tiered pricing (see below) | No (defaults to 1) |
Please note When setting up tiered pricing, you must specify a unit price for a quantity of 1. If you want to set up minimum quantities or pack sizing, please see our guide here.
You can also configure tiered pricing manually via The Price Editor tool
On set up, the SparkLayer Product Purchasing Interface will clearly show the tiered pricing to your customers. By default, the tiered pricing will show a 'Savings' amount based off the single unit price of the product (or variant). If you'd prefer for the savings amount to be based off the RRP (i.e. retail price), you can set this via Configurations
When setting up tiered pricing for products that have variants (e.g. colour, size), it's possible to configure how the tiered pricing gets applied.
Type | Behaviour |
Applying across all variants | Default behaviour The tiered pricing will take affect across all variants of the product. For example, if a product comes in Small, Medium, and Large and you've set up tiered pricing to take effect with a quantity of 5, the customer would receive the discounted pricing no matter the combination. e.g. 1 x Small 2 x Medium 3 x Large |
Applying to a single variant | Configuration If you'd prefer to restrict tiered pricing to a specific variant, you can do this by disabling a special setting within the Dashboard. In this example, if a product comes in Small, Medium, and Large, you can set the tiered pricing to only apply to the Large size. To disable this, please click here. |
It's also possible to display the tiered pricing breaks table anywhere on your product detail page. Learn more in Pricing Display
SparkLayer has full support for pack sizing (sometimes called quantity increments), meaning you can ensure customers to always add items to an order in your predefined packs (e.g. packs of 3, packs of 6). Learn more in Quantity Rules
SparkLayer has support for a variety of different quantity product settings including:
- Minimum product quantities at a variant level (e.g. products that have colours)
- Minimum product quantities at a parent level (allowing you to apply rules to the product as a whole. If it has variants, it can apply across multiple variants)
- Maximum product quantities at a variant level
- Maximum product quantities at a parent level
You can learn more about this in Quantity Rules