Applying charges - only for products in a particular category?
I want to apply a 5% surcharge to items from a particular category but the surcharge should only apply to those products, NOT to products in the cart that are not from that category.
I've created a category cart column and have bound that to the category field in my product table when adding to cart. When the product category is "2" I need the surcharge applied.
Can you help me with the calculation because nothing in the list of available options in the calculations section does this. Do I need a custom calculation?
Where it's complicated is, for example, we have the following scenario...
Product Category Quantity Price Total
Whisky Bottle 1 1 1 £45.00 £45.00
Whisky Cask 1 2 1 £900.00 £900.00
Whisky Cask 2 2 1 £1100.00 £1100.00
The 5% surcharge should only be applied to the £2000.00 (£900 + £1100).
I'm sure this is simple but I've been going round and round with it all day and nothing I try does it.