close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

discount coupons apply to certain items

Thread began 3/25/2010 7:42 pm by sandyrumsey378810 | Last modified 3/15/2011 1:00 pm by Jason Byrnes | 1980 views | 15 replies |

sandyrumsey378810

discount coupons apply to certain items

When people enter the discount code on the website , they will receive 20% off of the titles that are in the attached ad. So, I want the custom trigger to compare the item Number of each item with the list of items in the ad. What is the correct syntax for that?

Sign in to reply to this post

Ray BorduinWebAssist

In powerstore you can browse and pick items for coupons to apply to.

If you are doing this manually in eCart and don't have a database driven coupon system like what powerstore uses, then you would probably have to do it manually.

You could add a column to your shopping cart for "coupon_applicable" and set it to "1" for items that are included in the coupon and "0" for items that aren't. Then you can create a calculation for:

discountedTotal = [Quantity] * [Total] * [coupon_applicable]

Then base your coupon on 0.2 times the total of that calculated discountedTotal column.

There are really a million ways you could do it depending on the complexity of what you are doing. Do you have multiple coupons like this each that apply to different groups of items? How often do the coupons change? At some point couponing can be very complex, but it all depends on the specific details of what you need.

Sign in to reply to this post

SaladoGuyBeta Tester

I want to do something similar to this...

I've got 6 extra columns in my shopping cart for 3 groups of optional accessories.
So there are two columns for each accessory group, one for the accID and one for accPriceIncrement.
The discount that I want to apply is 50% off of any accessory (accPriceIncrement) that is in the cart, if someone enters a specific coupon code.

I have all of the code working for the coupon input, (I have several simple coupons setup that are working great).

I just don't understand how to make a discount that will take (50% off of accPriceIncrement) if (accPriceIncrement is not = NULL) and a coupon code is entered.

If this isn't clear, please let me know.

Thanks in advance!

Sign in to reply to this post

Ray BorduinWebAssist

You would store the coupon code as a session variable so that you could refer to it in a calculation or discount rule based on the value of the accPriceIncrement column.

Sign in to reply to this post

SaladoGuyBeta Tester

I know that, I have the code stored stored as a session variable, I just don't know how to do the calculation...

Attached is what I've tried so far, but it doesn't really make too much sense to me.

Sign in to reply to this post

Jason ByrnesWebAssist

in the calcualtion, you are using the Based on items column value, this takes an Item ID as the first argument, it is intended for only one item in the cart,

you should be using the Based on items with a specific column value:
Total of 'Total price' where 'accTipPriceInc' has a value of '1' 'times' '0.5'

Sign in to reply to this post

SaladoGuyBeta Tester

Ok, I think I'm getting closer....
Attached is a screenshot of what I've done.
The thing that doesn't make sense to me is where it says: if the total number of items where 'MyColumn' has a value of 'MyValue' is '>=' to a value of '0'. What I need is simply: if the total number of items where 'MyColumn' has a value that is '>=' to a value of '0'.

Sign in to reply to this post

Jason ByrnesWebAssist

you have the trigger set correctly now, but not the calculation.

for the calculation, use Based on items with a specific value:

Total of 'TotalPrice' where 'MyColumn' has a value of '1' 'times' '0.5'

Sign in to reply to this post

SaladoGuyBeta Tester

I think this is what you're asking me to do... (see attached)
It still doesn't calculate any discount. :-(

Please forgive me if I'm being thick headed, but I just want to make sure that you know "MyColumn" doesn't always have the same value. And I want the coupon to take 50% off of "MyColumn" if "MyColumn" doesn't equal "0".

Sign in to reply to this post

Jason ByrnesWebAssist

OK, I had misunderstood then


the calculation should be:
Based on multiple of column subtotal

subtotal of column 'MyColumn' times '0.5' 'plus' '0'


if you are still having a problem with this, create a new php page, and add a new cart display manager to it.

on the second page of the display manager wizard, set it to display all columns.

send me a link to this page and an item i can use to test.

Sign in to reply to this post
loading

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