Re: Shopping Cart - Coupon/Discount
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. From my own experience, I would say to go with a different set of tables/settings. One for discounts and one for promotions (free items). You could certainly try to do it in one table, but the information you need for each of these, and the calculations involved are somewhat different. -- Mary Jo Sminkey http://www.cfwebstore.com ~| 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:224981 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Shopping Cart - Coupon/Discount
Thanks mary, I think this is the way I will head - 2 different table setups. mike -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Wednesday, 23 November 2005 5:37 a.m. To: CF-Talk Subject: Re: Shopping Cart - Coupon/Discount 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. From my own experience, I would say to go with a different set of tables/settings. One for discounts and one for promotions (free items). You could certainly try to do it in one table, but the information you need for each of these, and the calculations involved are somewhat different. -- Mary Jo Sminkey http://www.cfwebstore.com ~| 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:224997 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
Shopping Cart - Coupon/Discount
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