hi there, my client wishes to be able to create coupons/discounts for customers who have purchased from their store.
possible scenarios... 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. any advice on this would really be appreciated. AND this info might be handy for our open source shopping cart!! mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224912 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54