Dashboard
Price Lists

Quantity Pricing & Settings

quantity pricing (tiered pricing) please note quantity pricing is only supported with manual csv price lists (not automatic price lists) learn more about managing pricing docid\ nx9q00ewv kbjxc3tg1ut 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 setting up quantity pricing to get started, you'll need to use the managing pricing docid\ nx9q00ewv kbjxc3tg1ut 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 quantity rules docid\ cmxfrpgjqxfz9vjztvv0d ) in addition to using the manual csv upload to configure your pricing, you can also configure quantity pricing manually via the price editor docid\ fww4oh09nso1 g9txutop tool, allowing you to make manual adhoc changes if required on set up, the product detail interface docid\ jkcjbyuanjzp75i8ul7mt 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 docid\ sbeaoacq a7ffbtatx8bd quantity pricing for multi variant products 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 docid\ nzsx6u dawtzvzsehf4or 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 https //app sparklayer io/configuration/settings/general understanding the unit price calculation 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 unit of measure pricing 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 how it shows to a customer within the product detail interface docid\ jkcjbyuanjzp75i8ul7mt , 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 docid\ efevur a3ycjxuhvrr7t , ensuring the customer can clearly see how the overall and unit pricing has been calculated configuring unit of measure to get started, you'll need to use the managing pricing docid\ nx9q00ewv kbjxc3tg1ut 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 quantity rules docid\ cmxfrpgjqxfz9vjztvv0d ) you can also configure unit of measure pricing manually via the price editor docid\ fww4oh09nso1 g9txutop tool simply by adding (or editing) your prices and specifying the unit of measure and the associated unit price unit of measure language strings 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 / add the below code into the sparklayer core script / translations { en { "unit of measure unit type box" "{uomquantity, plural, =1 {box} other {boxes}}", "unit of measure unit type pallet box" "{uomquantity, plural, =1 {pallet box} other {pallet boxs}}" } }, / end of code / learn more you can languages & international docid\ klrs7wtxn3wncdy8z5zvu about updating language strings that contain dynamic variables display a quantity pricing widget if you've set up quantity pricing & settings docid\ t2ceaosmeohmgzstjcnhe for your products, sparklayer will by default show this to your customers within the product detail interface docid\ jkcjbyuanjzp75i8ul7mt 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 docid\ s vtljborgmnwjjfsmom9 pack sizing 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 docid\ cmxfrpgjqxfz9vjztvv0d minimum and maximum quantities 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 docid\ cmxfrpgjqxfz9vjztvv0d