close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Quantity Discount in eCart 5

Thread began 12/13/2010 11:52 am by marovios@yahoo.com | Last modified 12/29/2010 4:12 pm by marovios@yahoo.com | 1340 views | 8 replies |

marovios@yahoo.com

Quantity Discount in eCart 5

Hello WA support people. I have tried to find an answer in the forum but had no lucky, that's why I'm posting this now.
I only have one product in my store that I need to sell. Key here is the quantity of items the buyer might purchase. So, I need to sell a product for $15, but if they get more than one the price goes down to $10 per product. Now the tricky part is that the first item would still need to be $15 and the rest $10. So, if they purchase 5 items, the final price would be $15 + $10 + $10 + $10 + $10 = $55
Any clue how to create the rule?
Thanks

Sign in to reply to this post

Ray BorduinWebAssist

You could just update the totalprice calculation from:

TotalPrice = [Price] * [Quantity]

to

TotalPrice = ([Price] * [Quantity]) - (5 * ([Quantity]-1))

Sign in to reply to this post

marovios@yahoo.com

Hi Ray, thanks for your response, for some reason I couldn't access webassist forums and that's why I'm answering just now, sorry about that. I will give it a try and let you know. Thanks again.

Sign in to reply to this post

marovios@yahoo.com

Here again Ray, though it sounds that this is the right answer I still cannot get how to implement it. I'm not an expert but I can handle it if you explain me what are the values to select from the trigger and action drop down menus. Also, I noticed you used a fixed number, I know you were just following my example, but what should I use to allow for any quantity? It could be 4 or 13 items. Thanks again.

Sign in to reply to this post

Ray BorduinWebAssist

This formula will work for any number of items.

Just open the eCart object and go to the calculations tab. Then select the TotalPrice calculation and copy and paste this as the value:

([Price] * [Quantity]) - (5 * ([Quantity]-1))

Sign in to reply to this post

marovios@yahoo.com

You are right, I just noticed that and should work perfect!!! I will try it right now, thanks again.

Sign in to reply to this post

marovios@yahoo.com

Hey Ray,
I tried the formula and noticed a few things:
1) the discount is not being displayed as Discounts on the cart created by the display manager. In this case, even though the calculation can be done in the calculation tab, it is important that is shown as discount.
2) I added one more item to the products to sell, I told you first I only had one item, now I have two sorry, and I see that the calculation is messed up, is doing the discount on the first and seconds items at the same time or something weird.

I guess I will need to open a ticket to further look into this. Sorry.

Sign in to reply to this post

Ray BorduinWebAssist

Instead of updating TotalPrice, you can create a new column:

TotalOff = (5 * ([Quantity]-1)

Then you can create a discount rule to discount the total of the TotalOff column. Then it won't be updated in the cart total but will add as a discount below.

How do you want the second item to work? Does it have the same discounts? What if you bought one of each?

Sign in to reply to this post

marovios@yahoo.com

Thanks Ray, I opened up a ticket and it's solved now.

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...