Quantity Pricing - Need help! PLEASE

[JustLearnin']

I am creating a store for the sale of software.

 

Prices vary depending on the number of copies that are bought. I need a way to automatically generate the correct price based on the quantity.

 

For profit / loss purposes, I also need to reflect the correct wholesale pricing.

 

See the examples listed below.

 

Note: eg. if customer buys 6 copies, they pay $159 for ALL copies and I pay the supplier $111.30 for ALL copies.

 

Quantity 1 – 4 (minimum purchase is 1)

Wholesale Price $125.30

Retail Price $179

 

Quantity 1 – 9 (minimum purchase is 5)

Wholesale Price $111.30

Retail Price $159

 

Quantity 1 – 24 (minimum purchase is 10)

Wholesale Price $97.30

Retail Price $139

 

I tried doing combinations, but that leaves it up to the customer to decide what price bracket they fall into - it needs to be automatic.

 

If an add on module exists to simplify this - I am happy to go that way.

 

Thanks

 

**** Here is a spreadsheet illustrating the above. I assume I should be able to edit code somewhere to achieve this.

[JustLearnin']

Bump... really need to solve this if anyone can help... my guess is I've missed something very obvious.

[Mallee Boy]

Did you get a solution to this? iwould also like to see wholesale prices included in my stats