I am re writing as I have not explained myself to get a reply! The shop will offer special discount ot customers across a range of products subject to the total volume purchased and the variety of colours selected. The business reuqirement is to try to keep stocks of clours balanced and promoting certain colours by offering volume discounts. My analysic mind thinks this is a good solution. Level 1 - Colour Level 2 - Product A, Product B, Product C Level 3 - A Colour Range, B Colour Range, C Colour Range. Overall there are 60+ different colours. Will the above product structure work? to achieve a volume / qty discount at the basket …? Thanks Lee