Hey there,
I'm trying to build an order management system and I'm a little new at this. Here's what I'm trying to figure out:
- Each item we can order comes in multiple sizes
- Each size for a given item has its own pricing
- Pricing is based on the quantity in an order, with different combinations of item + size having different quantity breaks
As an example, say we could order Flour in a 20lb bag or a 50lb bag. The 20lb bags are $10 each if you order 1, $9 each if you order 3, $8 each if you order 5. The 50lb bags are $20 each if you order 1, $15 each if you order 10.
We ultimately need to be able to track our items regardless of the size in which it's ordered, so I need to associate a variety of sizes with a given item, and then for each combination of those be able to set up price breaks that can be looked up when added to an order.
Creating a one-to-many relationship between item and size was easy enough, but I tried to create a new form for pricing and lookup the combination of item and size to no avail.
Any ideas?
Thanks!