Hello, I have hundreds of products with different prices.
Seemed easy until I tried to normalize
I do have the data in (ugggg) Spreadsheets Like this:
example.zip
Note that this is only for TWO I have hundreds, the first thing is it would be good not to have to retype all that data, the second thing is the only way I can figure right now is to have a separate table for each items pricing structure? That just doesn't make sense....
The pricing structure isn't a formula for quantities, from what I understand each product has different handling needs for the quantity.
My sketches of this db look terrible, any good ideas or I will even take bad ones!