multiple price columns
I'm building a cart for our company to sell water filters, plumbing fittings, etc. I need to have multiple price columns based on quantity. I've seen other posts that use fixed formulas to adjust price based on quantity, but that won't work for us. It's not a fixed formula since the volume discount varies by manufacturer.
Is there a way to add multiple price columns? ie: list price, 10-49 units, 50-99 units, 100-499 units, etc
Thanks so much!