Quantity Based Pricing

[grimblestyx]

We have been having issues with quantity based pricing, one issue we got around, but the next we're still at loss with.

Our setup is as follows:

We hava a single product in the catalog, pricing set to sum of components. It has a single component, with single drop down. The component has permutations that are linked with the dropdown options. Each permutaion is linked with a hidden product.

This allows us to have a drop-down box to select a type of product, rather than having the normal list of poducts on a page.

We then have prices in the component permutations that set the price for each available option in the drop down box.

What causes the problem is when we have also setup quantity based pricing for each of the permuations.

The setup is as so:-

Product with Option 1
Quantity 1 : £10 each
Quantity 2 : £7 each
Quantity 3 : £5 each

Product with Option 2
Quantity 1 : £12 each
Quantity 2 : £9 each
Quantity 3 : £6 each

etc.

The problem happens in this case:

Customer orders a product with option 1, quantity 2
The price is then £7 each, totaling £14

If they then add another product with option 1, quantity 1
the price becomes £5 each totaling £15, when what we wanted was

Customer orders:
Product Option 1, quantity 2, £14
Product Option 1, quantity 1, £10
Total £24

Rather then the catalog merging the two order lines in to:-
Product Option 1, quantity 3, £15
Total £15

I would have thought there would be an option somewhere to stop the catalog merging seperate order lines, but I can't find one.

Can anyone offer advice on what a fix might be, or a workaround while keeping the drop down structure of the product.

[cdicken]

Hi there

Have you tried using the pricing table within the 'Permutations' tab of the component to set up your quantity-dependent pricing breaks? This should ensure that each permutation works differently with regards to quantity-dependent pricing.

[grimblestyx]

Yes, we've setup the quantity based pricing in the permutations tab. But it leaves us with the same issue, of the quantity from both cart lines being added together which then increases the discount so to speak. So the first cart line "A4 Calendar, quantity 3" and the second cart line is "A4 calendar, quantity 1", the pricing level is then charged for a quantity of 4, rather than calculating the quantity price against each cart line, which would be for a quantity of 3 and then a quantity of 1.

[cdicken]

Sorry Michael - I see what you mean now.

Actinic is working in exactly the way it has been designed to, so I will have to add this to the wish list.

What are you selling by the way? I had a similar issue with ticket request, where people make multiple selections for their first choice of tickets, second choice of tickets etc. I solved this by having multiple components within the product - one called 'First Choice', one called 'Second Choice' and so on. That way, people placed multiple orders for the same product, but the orders effectively stayed separate in the cart.

[grimblestyx]

We do personalised goods. So we'd like to be able to provide lower prices for higher quantities based on the same personalisation. And be able to add the same product to the cart with different personalisation which is not included in the original quantity calculation.

[cdicken]

OK, understood. Quantity dependent pricing is always worked out by product reference - which is why you are having these difficulties. I'm afraid I cannot suggest anything to work around this. I will add this to the wish list for you.