RE: Shopping Cart - Coupon/Discount

2005-11-22 Thread Mike | NZSolutions Ltd
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


Re: Shopping Cart - Coupon/Discount

2005-11-22 Thread Mary Jo Sminkey
>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