Quantity Pricing & Settings
Please note: Quantity pricing is only supported with manual CSV price lists (not automatic price lists). Learn more about Managing Pricing
SparkLayer supports the option to configure quantity pricing (sometimes called tiered pricing), allowing you to offer discounted prices based on the unit quantities ordered by your customers.
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 $10.99
- For 10 units of a product the price to pay is $8.99
This is all possible to set up using SparkLayer's built-in pricing tools.
To get started, you'll need to use the manual pricing upload feature within the SparkLayer Dashboard.
In order for the CSV file to import your quantity 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 quantity pricing (see below) | No (defaults to 1) |
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 example below, we've illustrated how the price for SKU 123-abc changes from a quantity of 1 to a quantity of 5 e.
Please note When setting up quantity pricing, you must specify a unit price for a quantity of 1 even if you don't intend to allow customers to be able to purchase single units (i.e. you intend to set up minimum quantities or pack sizing: see our guide here.)
In addition to using the manual CSV upload to configure your pricing, you can also configure quantity pricing manually via The Price Editor tool, allowing you to make manual adhoc changes if required.
On set up, the Product Detail Interface will clearly show the quantity pricing to your customers.
Please note By default, the quantity 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 quantity pricing for products that have variants (e.g. colour, size), it's possible to configure how the quantity pricing gets applied.
Type | Behaviour |
|---|---|
Applying across all variants | Default behaviour The quantity 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 quantity 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 quantity 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 quantity pricing to only apply to the Large size. To disable this, please click here. |
When using quantity pricing, the unit price for an item will be dependent on the quantity the customer is adding to their order. When calculating the unit price, SparkLayer will take the "requested quantity" and calculate the quantity "tier" the pricing is applicable to.
If the customer has any discounts configured, these will then additionally be deducted from the unit price.
SparkLayer supports the option to configure your pricing with units of measure, allowing you to offer discounted prices based on specific purchasing quantities.
It's a great way to allow customers to order in pre-defined units such as boxes, pallets, or cases. When setting these up, you can then specify how pricing works for these specific units, as well as handle units that 'fall outside' these.
Generally speaking, unit of measure pricing works in a similar way to quantity pricing - customers are essentially buying in quantity and you're giving a discount on the price (per unit). How it differs to quantity pricing is how the "line total" and "unit price" for a product is calculated. Let's use an example:
Unit of Measure Example
You have a product that can be purchased as single units, in boxes or in pallets. To fill a box you require 7 units. To fill a pallet you require 150 units.
- The single unit price for a product is $14.99
- For a box of a product, the unit price to pay is $10.99
- For a pallet of a product, the unit price to pay is $8.99
If a customer is requesting to purchase 320 units of a product, SparkLayer will distribute the requested quantity across the configured units of measure and then calculate the line total and unit price as so:
- 300 units at the pallet unit price: $8.99 * 300 = $2,697.00 (2 pallets)
- 14 units at the box unit price: $10.99 * 14 = $153.86 (2 boxes)
- 6 units at the single unit price: $14.99 * 6 = $89.94
- Line total = $2940.80
- Unit price = Average price across all units = $2940.80 / 320 = $9.19
Please note The unit price displayed will be the average unit price across the total quantity purchased.
Within the Product Detail Interface, SparkLayer widget we will provide a breakdown detailing how the unit price has been calculated and the applicable units of measure.
This will also carry through to the My Cart Interface, ensuring the customer can clearly see how the overall and unit pricing has been calculated.
To get started, you'll need to use the manual pricing upload feature within the SparkLayer Dashboard. In order for the CSV file to import your quantity pricing successfully, it must have the following columns, with the addition of unit_of_measure as shown below.
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 quantity pricing (see below) | No (defaults to 1) |
unit_of_measure | The unit of measure the quantity is associated to. The unit_of_measure value may only be alpha numeric and use hyphens as a separator. For example: box pallet pallet-box | No |
Please note When setting up unit of measure pricing, you must specify a unit price for a quantity of 1 even if you don't intend to allow customers to be able to purchase single units (i.e. you intend to set up minimum quantities or pack sizing: see our guide here.)
You can also configure unit of measure pricing manually via The Price Editor tool simply by adding (or editing) your prices and specifying the unit of measure and the associated unit price.
You may configure language strings for unit of measure. This allows us to pluralise quantities when displaying feedback to the customer. To modify how a unit of measure is translated and pluralised, specify the translation using the key configured for the unit of measure when setting up the price list. For example:
Learn more You can read more about updating language strings that contain dynamic variables.
If you've set up Quantity Pricing & Settings for your products, SparkLayer will by default show this to your customers within the Product Detail Interface.
It's also possible to display the tiered pricing breaks table anywhere on your product detail page by adding a special code snippet to your website. 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