quantity discount

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   We are using SalesCart Pro with the Product Management Plugin.  We have multiple products that receive discounts at varying quantity levels.  For example, item 1234 receives qty discounts of 5% with qtys of 5-9, 10% with qtys of 10-14, and 15% with qtys of 15 or more.  Item 5678 receives 5% with qtys of 8-12, 10% with qtys of 13-17, and 15% with qtys of 18 or more.  Even though our products receive the same quantity discount (5%, 10% or 15%), they receive them at different quantity levels.  How can I set this up to function properly?  Or maybe a better question is, can this be accomplished using the dynamic database?  If so, how?  

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ohio Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: September/06/06 Status: Offline Points: 3	Post Options Post Reply Quote ohio Report Post Thanks(0) Quote Reply Topic: quantity discount Posted: September/08/06 at 2:51pm
	We are using SalesCart Pro with the Product Management Plugin. We have multiple products that receive discounts at varying quantity levels. For example, item 1234 receives qty discounts of 5% with qtys of 5-9, 10% with qtys of 10-14, and 15% with qtys of 15 or more. Item 5678 receives 5% with qtys of 8-12, 10% with qtys of 13-17, and 15% with qtys of 18 or more. Even though our products receive the same quantity discount (5%, 10% or 15%), they receive them at different quantity levels. How can I set this up to function properly? Or maybe a better question is, can this be accomplished using the dynamic database? If so, how?

ohio Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: September/06/06 Status: Offline Points: 3	Post Options Post Reply Quote ohio Report Post Thanks(0) Quote Reply Posted: September/08/06 at 3:37pm
	I believe I found a solution: I created six fields in the products db named level1, level2, level3, discount1, discount2, and discount3. I set discount1, discount2, and discount3 field types to Number/Percent. In the Discount tab of the SalesCart component on the more.asp page, I selected "Use % Discount". Under Volume Discount, I inserted the following in the level 1 field: <%=FP_FieldVal(fp_rs,"Level1")%> and <%=FP_FieldVal(fp_rs,"Discount1")%> in the % or Abs Amt field. I did the same for each of the subsequent fields, i.e. level 2, level 3, etc.

mikeb Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: March/17/04 Location: United States Status: Offline Points: 194	Post Options Post Reply Quote mikeb Report Post Thanks(0) Quote Reply Posted: September/29/06 at 2:49pm
	Yes that will work.