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


Membership discounts on selected products

Thread began 9/30/2009 7:11 am by john275907 | Last modified 9/30/2009 7:18 pm by john275907 | 1055 views | 4 replies |


Membership discounts on selected products

I have a situation where members may purchase products and receive a discount. Each product may have its own discount rate for members and the rate is stored in the product table. So, to get the discount, the member must login and I need to show the discount when a product is added to the cart and also display it in the cart and checkout pages.
I cant seem to figure out how to use the Discount feature of the eCart Object wizard to provide this capability. Is this achievable using the wizard or must I use custom coding ?

Sign in to reply to this post


You might consider adding some custom code to the actual product list or detail pages that does something like:
If (some session variable you get / create when the customer logs in exists) Then

price = regular price * rate


price = regular price
If you do this, you can show the discount with the product information, and, you can also store the price (regular or discount) when the customer adds the item to their cart.

Doing this shows the discount in the individual item price in the cart display as opposed to as a discount below the subtotal.

This approach might be easier than trying to create discount rules in the cart behavior.

Sign in to reply to this post

Eric Mittman

Another variation on that suggestion would be to have an extra price column in the cart for the discounted members. You can then just bind this value to the other column and use the calculations to use one price over the other. This way would also show on a per item basis rather than all at the bottom but the benefit would be that the user can login after adding items to the cart to still get the discount rather than adjusting the price that is added to the cart if a member is logged in.

Sign in to reply to this post


I believe I had the same issue John. The way i solved it (and this solution is posted somewhere here on these forums, but you'll have to dig):

In the triggers section add the following 2 triggers:
1. "Based on session variable value"--
If the value of the session variable VisitorIsMember is = a value of 1. (where VisitorIsMember is the name of my variable that determines valid membership upon login)
2. "Number of items with a specific column value"--
If the total number of items where CatID has a value of 12 is > a value of 0. (where CatID=12, in my case, is all products that fall in the Training Manuals category)

Then in the calculations section use "based on items with a specific value":
total of Totalprice Where CatID has a value of 12 [times] 0.10
(depending on your discount, the '0.10' value will vary. In my case it's actually 0.1739, because members get $20 off the full price $115)

Hope this helps.

Sign in to reply to this post


Many thanks to all who offered suggestions. It has certainly helped a lot. Will report back when I have a working solution.

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





Ease of use


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