I'm configuring and creating some test products for my store. I'm currently using ML 9.0.1.3. My store deals in selling products in bulk (anywhere from 1,000 to 200,000 units) and I'm having a problem when trying to set the pricing. I found the option to restrict the quantity they purchased to certain amounts, but I cannot find a way to set the displayed price for that quantity.
For example: Product A's price is $50 per 1000 units. I can restrict the quantity to multiples of 1000, but if I set the price of the product to be $50, it multiplies the quantity by the price. Is there a way to have the quantity drop-down say "1000 units for $50, 2500 units for $125" etc. and correctly add that amount to their cart with the specified total cost? I realize I can set the default variant's price to be $.05 each and it will calculate the correct total, but I'd like the customer to see the total price of that many units BEFORE adding to the cart.
The one solution I see to this is creating a variant for each quantity. The names of the variants would be the "1000 units for $50" etc. This would allow me to set their prices so that the customer can see the full price in the drop down. However, having to create 5-10 variants or more for each product seems like a large hassle.
Is there an easier way to do this? Thank you!!
Edit: Just to clarify, my ideal situation would be a drop-down menu that says "1000 units - $50", "2000 units - $100", "5000 units - $250" and so forth. The quantity restriction option lets me very quickly create the drop down, but not set the price in 1000 unit intervals. Making 10 variants for each product (I aim to have over 200 products) just to differ the quantity seems like more work than is necessary.