my client wishes to be able to create coupons/discounts for customers who have purchased from their store.
1. discount off total purchase if over certain amount
2. discount off total purchase (any amount)
2. free product (eg. socks) with purchase (if over certain amount)
3. free product (eg. socks) with purchase (any amount)
the socks or any other items would already be in the main products table.
the customer would receive a unique code via email and enter it at the checkout stage.
i am a bit stumped as to whether i should be looking at one set of tables to handle all the options above, or whether i should create to distinct sets to handle either a discount scenario or a free product scenario.