Attributes (S,M,L etc all with prices for the individual attribute) FK product uid
AttributeDiscounts (type (enum Fixed, percentage etc), value int) FK to attribute uid
ProductDiscounts (type (enum Fixed, percentage etc), value int) FK to product uid
Attribute Discounts override Product Discounts.
If you apply this principal to your data, you would need to extend AttributeDiscounts/ProductDiscounts to accept a min & max items for your bulk discounts.
The way my team works is to have separation.
Tables.
Attribute Discounts override Product Discounts.
If you apply this principal to your data, you would need to extend AttributeDiscounts/ProductDiscounts to accept a min & max items for your bulk discounts.
thanks, Ben I will try this
No worries. Any issues, reply here and I can provide some further guidance. I have notifications turned on.