close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Discount on specific item category

Thread began 9/18/2009 4:08 pm by mywebassist220499 | Last modified 9/21/2009 1:33 pm by Jason Byrnes | 950 views | 3 replies |

mywebassist220499

Discount on specific item category

I'm not getting this and feeling like a real idiot. Related posts have left me feeling even more confused than when I began.

In my database of products, each product is assigned a category type: 1, 2, 3 or 4.

I have added an "itemType" column in eCart and capture that data when an item is added to the cart.

I want to be able to offer a discount only on items of type 2 or type 3 and have the discount automagically expire on a future date.

I get the future date in the Discount section but I don't get how to just discount type 2 or type 3 items only.

Sign in to reply to this post

Jason ByrnesWebAssist

In the triggers section add the trigger "Number of items with a specific column value":
If the number of items where [itemType] has a value of [1] is [>] a value of [0]


and in the calculations section use "based on items with a specific value":
total of [Totalprice] Where [itemType] has a value of [1]] [times] [0.10]


for a 10% discount on all items with an item type of 1.

Sign in to reply to this post

mywebassist220499

Jason,

It works!!
That was a great example!
Thank you so much!!

Is there any way to specify a range of numeric itemType category like > 2 or similar so as not to have to specify one for each itemType?

Thanks,
David

Sign in to reply to this post

Jason ByrnesWebAssist

No, you will need to create a separate rule for each category.

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