Product discounts
Product discounts are applied to individual products, on a per-customer basis. The discounts can be defined by product item or by container.
The original price for the product is based on the Price Tier that has been assigned to the customer. If a customer has been assigned a discount for that product, the original price is shown with a strikethrough next to the discounted price.
To set up a product discount for a customer:
Select the customer from your Customer List.
Head to their Terms & Pricing tab.
Click Add Discount for either Discounts by container type or Discounts by product item.
Discounts by container type
Discounts by product item
You can view or edit these discounts at any time from the customer's Terms & Pricing tab.
Volume discounts
When setting up your price tiers, you have the flexibility to tailor volume-based discounts by price tier allowing you to show different deals for different customer segments.
There are two types of volume discounts:
By minimum basket value
By minimum order quantity
You can then define the container types (eg cans, draught products etc) to the discount to apply to and the discount type. Below are the different discount types you can use and an example of each:
Percentage: Buy 6 cases of cans, get 5% off
Flat (per item): Buy 6 cases of cans, get £10 off per case of cans
You can also have multiple rows of discounts. For example:
Customers will see the available discounts and what they need to add to their basket to receive them when placing an order on your Storefront.
To set up a product discount on a Price Tier:
Select the Price Tier from your Inventory > Price Tiers.
Click Edit.
Click Add volume discount.
Add the criteria for the discount.
You can view or edit these discounts at any time from the Price Tier page.
Volume discounts - in depth
The following section gives a comprehensive overview of exactly how discounts get calculated. It's important to note the exact behaviour when combining different discount types.
Basic calculations
Volume discounts are calculated on a line item basis. The total discount amount is displayed and deducted after the subtotal on an order.
Volume discount: Buy 3 cases of cans, get 5% off
Qty | Product | Container |
| Price |
1x | Pale Ale | 24x 440ml Cans |
| £40.00 |
1x | IPA | 24x 440ml Cans |
| £60.00 |
1x | Stout | 24x 440ml Cans |
| £50.00 |
|
|
|
|
|
| Subtotal |
|
| £150.00 |
| Discount |
|
| -£7.50 |
| VAT (20%) |
|
| £28.50 |
| Total |
|
| £171.00 |
5% Cans discount: (£40 + £60 + £50) * 0.05 = £7.50
In the example above, the customer has 3x can products in their basket. The volume discount of 5% is calculated based on the value of all the products in can format in the customer’s basket.
Calculations based on relevant items
Container-specific discounts, as you’d expect, only apply to those specific containers in your basket. Although the discount amount gets calculated behind the scenes and appears as a discount line item after the order subtotal, when you have a container-specific discount, only the eligible products in those containers will be used in the calculation of those discounts.
Volume discount: Buy 3 cases of cans, get 5% off
Qty | Product | Container |
| Price |
1x | Pale Ale | 24x 440ml Cans |
| £40.00 |
1x | IPA | 24x 440ml Cans |
| £60.00 |
1x | Stout | 24x 440ml Cans |
| £50.00 |
1x | Lager | 30L E-Keg |
| £100.00 |
|
|
|
|
|
| Subtotal |
|
| £250.00 |
| Discount |
|
| -£7.50 |
| VAT (20%) |
|
| £48.50 |
| Total |
|
| £291.00 |
In the example above, we add 1x 30L keg to our order. The total discount amount for the order remains the same as before because only the 3 cases of cans are included in the discount calculation.
Calculations with case sizes
When you have case size rules defined, discounts for your packaged items are calculated based on what you have defined as a ‘case of cans’ or ‘case of bottles’.
Volume discount: Buy 3 cases of cans, get 5% off
Case size rule: 1 case of cans = 24x 440ml cans
Qty | Product | Container |
| Price |
1x | Pale Ale | 24x 440ml Cans |
| £40.00 |
1x | IPA | 24x 440ml Cans |
| £60.00 |
1x | Stout | 12x 440ml Cans |
| £25.00 |
1x | Lager | 30L E-Keg |
| £100.00 |
|
|
|
|
|
| Subtotal |
|
| £225.00 |
|
|
|
|
|
| VAT (20%) |
|
| £45.00 |
| Total |
|
| £270.00 |
In the example above, I swap out the 24x 440ml cans of Stout for 12x 440ml cans. Based on the supplier’s case size rules, I only have 2 and a half cases of cans in my basket, and thus, fall short of being eligible for the volume discount.
Let’s see what happens when I add another 12x 440ml product to my basket 👇
Volume discount: Buy 3 cases of cans, get 5% off
Case size rule: 1 case of cans = 24x 440ml cans
Qty | Product | Container |
| Price |
1x | Pale Ale | 24x 440ml Cans |
| £40.00 |
1x | IPA | 24x 440ml Cans |
| £60.00 |
1x | Stout | 12x 440ml Cans |
| £25.00 |
1x | DIPA | 12x 440ml Cans |
| £35.00 |
1x | Lager | 30L E-Keg |
| £100.00 |
|
|
|
|
|
| Subtotal |
|
| £260.00 |
| Discount |
|
| -£8.00 |
| VAT (20%) |
|
| £50.40 |
| Total |
|
| £302.40 |
5% Cans discount: (£40 + £60 + (£25 + £35)) * 0.05 = £8.00
In the example above, I add 12x 440ml Cans of Double IPA. This fills the remaining half of my third case of can; making my order eligible again for the 5% volume discount applicable to cans.
Concurrent calculations
When there are multiple, container-specific volume discounts of different container types available to a given customer, they apply concurrently when the customer qualifies for both. The supplier now offers volume discount on their keg products.
Volume discount: Buy 3 cases of cans, get 5% off
Volume discount: Buy 4 kegs, get 7.5% off
Case size rule: 1 case of cans = 24x 440ml cans
Qty | Product | Container |
| Price |
1x | Pale Ale | 24x 440ml Cans |
| £40.00 |
1x | IPA | 24x 440ml Cans |
| £60.00 |
1x | Stout | 24x 440ml Cans |
| £50.00 |
4x | Lager | 30L E-Keg |
| £100.00 |
|
|
|
|
|
| Subtotal |
|
| £550.00 |
| Discount |
|
| -£37.50 |
| VAT (20%) |
|
| £102.50 |
| Total |
|
| £615.00 |
5% Cans discount: (£40 + £60 + £50) * 0.05 = £7.50
7.5% Kegs discount: (4 x 100) * 0.075 = £30
Total discount: £7.50 + £30 = £37.50
In the example above, the customer has qualified for both volume discounts on the same order. Both discounts are calculated behind the scenes and then applied as a total discount line item after the order subtotal.
Qualifying for the biggest container-specific discount
When there are more than one container-specific discounts of the same container, only one of those will apply to the customer’s order. Essentially, the biggest discount they have qualified for. The supplier adds a second volume discount on kegs.
Volume discount: Buy 3 cases of cans, get 5% off
Volume discount: Buy 4 kegs, get 7.5% off
Volume discount: Buy 8 kegs, get 10% off
Case size rule: 1 case of cans = 24x 440ml cans
Qty | Product | Container |
| Price |
1x | Pale Ale | 24x 440ml Cans |
| £40.00 |
1x | IPA | 24x 440ml Cans |
| £60.00 |
1x | Stout | 24x 440ml Cans |
| £50.00 |
8x | Lager | 30L E-Keg |
| £100.00 |
|
|
|
|
|
| Subtotal |
|
| £950.00 |
| Discount |
|
| -£87.50 |
| VAT (20%) |
|
| £172.50 |
| Total |
|
| £1035.00 |
5% Cans discount: (£40 + £60 + £50) * 0.05 = £7.50
10% Kegs discount: (8 x 100) * 0.1 = £80
Total discount: £80 + £7.50 = £87.50
In the example above, the customer has now qualified for the 10% kegs discount. This supersedes the previous kegs volume discount of 7.5%.
When discounts combine (specific circumstance)
As we’ve seen with container-specific volume discounts, they are calculated in isolation from other containers on the same order before being totalled up and applied as a total discount after the subtotal. This is a clean way to manage discounts across all your product formats and make it easy for the customer to understand the deal you’re offering when they buy in bulk.
When using the ‘any’ item volume discount on Sellar, there specific behaviour to be aware of. The worked example below will demonstrate how an ‘any’ item volume discount works in combination with container-specific volume discounts.
Despite allowing this combination, we strongly recommend you avoid mixing these two types of discounts. Instead, choose one or the other. Either set container-specific volume discounts for a given customer, or set ‘any’ item volume discounts for a given customer instead.
However, let’s take a look at an example when they are used together.
Volume discount: Spend £1000 on any items, get 10% off
Volume discount: Buy 4 kegs, get 7.5% off
Volume discount: Buy 8 kegs, get 10% off
Qty | Product | Container |
| Price |
1x | Pale Ale | 24x 440ml Cans |
| £40.00 |
1x | IPA | 24x 440ml Cans |
| £60.00 |
3x | Stout | 24x 440ml Cans |
| £50.00 |
8x | Lager | 30L E-Keg |
| £100.00 |
|
|
|
|
|
| Subtotal |
|
| £1050.00 |
| Discount |
|
| -£185.00 |
| VAT (20%) |
|
| £173.00 |
| Total |
|
| £1038.00 |
10% Kegs discount: (8 x £100) * 0.1 = £80
10% 'Any' item discount: £1050 x 0.1 = £105
Total discount: £80 + £105 = £185.00
In the example above, the customer has added a few more cases of Stout to their order. They have now qualified for both the 10% kegs discount and the 10% ‘any’ item discount. Because the ‘any’ item discount applies to all eligible items in the basket, it effectively has to stack with the other container-specific discounts the customer has qualified for. In this instance, 10% off kegs.