close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Quantity discounts based on same item

Thread begun 6/24/2013 2:03 am by markdoyle87077 | Last modified 6/25/2013 11:47 pm by markdoyle87077 | 1738 views | 6 replies |

markdoyle87077

Quantity discounts based on same item

I am trying to implement quantity discounts based on the number of the same item ordered. I can see that I can apply a discount based on the quantity of a specific item in the cart but as I understand it I would have to provide the specific item number. I want this to work across the whole site (roughly 4000 products) so the customers can get a discount for buying 5 and 10 of the same product. To do this using the quantity of a specific item in the cart trigger would require 4000 rules. Could you kindly point me in the right direction? This is a customer request for an ASP site.

Many thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

you would need to have a Cart column for the category and store the category in that column using the add to cart buttons.

instead of using a calculation for this, you would use a discount rule on the discounts tab.

Set the trigger to:
"Number Of Items with A Specific Column value"

if the number of items where "category" has a value of "category name" is ">=" a value of "3"


and in the calculations section, use:
"Based on items with a specific value"
Total of "Total Price" where "category" has a value of "category name" "times" "0.10"

Sign in to reply to this post

markdoyle87077

Discounts

Originally Said By: Jason Byrnes
  you would need to have a Cart column for the category and store the category in that column using the add to cart buttons.

instead of using a calculation for this, you would use a discount rule on the discounts tab.

Set the trigger to:
"Number Of Items with A Specific Column value"

if the number of items where "category" has a value of "category name" is ">=" a value of "3"


and in the calculations section, use:
"Based on items with a specific value"
Total of "Total Price" where "category" has a value of "category name" "times" "0.10"  




Hi Jason,

I have set that up but it does not work how I want it to. I have set the rule to look at the VolumeDiscount column in eCart and then give 10% discount if there are 3 of more of the VolumeDiscount category in the cart. See attachment: rule.

This works fine, see attachment: invoice. Both items have the same VolumeDiscount and they total up to 3 and the discount is applied.

What I want to happen is that the discount is only applied if a single or multiple rows meets the rule so in the attachment: invoice if 43956 was set to quantity 3 and 79700 was set to 1 I would like the rule to work for row 43956 and apply 10%. Equally if both 43956 and 79700 where set to quantity 3 then the rule would apply discounts for both rows.

Maybe the rule has to calculate based in a unique ID and VolumeDiscount, only guessing here..

Hope you follow.

Many thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

So the discount should only apply to an item in the category if the quantity is 3 or more.

OK, so that has to go back to the calculation method.


[Price] - ((Abs([Quantity]>=3 && [VolumeDiscount] == 7)*[Price]*0.1)

Sign in to reply to this post

markdoyle87077

Discounts

Hi Jason,

I have set the following that you supplied to TruePrice, ss that correct

[Price] - ((Abs([Quantity]>=3 && [VolumeDiscount] == 7)*[Price]*0.1)

and then I changed TotalPrice to:

([Price] - ((Abs([Quantity]>=3 && [VolumeDiscount] == 7)*[Price]*0.1)) * [Quantity]

As a result I now get this:


Microsoft VBScript compilation error '800a03ea'

Syntax error

/dmbc/WA_eCart/dmbp_VB.asp, line 320
itmObj.TotalPrice = (itmObj.Price - ((Abs(itmObj.Quantity>=3 && itmObj.VolumeDiscount == 7)*itmObj.Price*0.1)) * itmObj.Quantity'c
--------------------------------------------------------------^

My end goal here is to have 3 different order quantities that will result in the following discounts for VolumeDiscount = 7, is it possible to evaluate 2 or more VolumeDiscounts in this calculation or not

3 +- 10%
10+ - 15%
20+ - 20%

Sign in to reply to this post

Jason ByrnesWebAssist

Sorry, you did not specify this was ASP, I thought it was PHP

in ASP
&& [VolumeDiscount] == 7

should be:
AND [VolumeDiscount] = 7

to have multiple break points, you need multiple conditions:
((Abs([Quantity]>=3 AND [Quantity]<=9 [VolumeDiscount] = 7)*[Price]*0.1) + ((Abs([Quantity]>=10 AND [Quantity]<=19 [VolumeDiscount] = 7)*[Price]*0.15) + ((Abs([Quantity]>=20 AND [VolumeDiscount] = 7)*[Price]*0.2)

Sign in to reply to this post

markdoyle87077

Discount based on Quantity

Hi Jason,

I will have a play around now I know how the format works. I will come back to you if I hit any problems but I am fairly confident that I can proceed.

Yet again, superb support, totally unrivalled.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...