close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

eCart Discount

Thread begun 11/21/2013 1:22 pm by johna1964 | Last modified 11/22/2013 11:56 am by Jason Byrnes | 3485 views | 9 replies |

johna1964

eCart Discount

Is there a way to apply a discount automatically based on the number of an individual's total number of orders? For example on any orders above the 5th order, the customer would see an automatic overall discount. So it would be an incentive to return to shop again. Thank you.

Sign in to reply to this post

Jason ByrnesWebAssist

you would need to forced the users to login.

and when placing and order store the users ID in the orders table.

See the Tutorials for adding user registration to the checkout process and for creating an order history for details.

after the user is logged in, create a record to look up the number of orders placed, much like the order history recordset. you can use that recordset to trigger the discount if it returns more than 5 rows.

Sign in to reply to this post

johna1964

Thank you Jason,

I have had the forced log in and customer order history and customer order details finished for quite some time. My questions should been how do I create a record to look up the number of orders placed, and what triggers do I use to create the discount for returning more than 5 rows - do I somehow use the totalRows_WADAorders? I realize I should understand how to do this, but I am not able to understand the step by step of it. Thank you much for your help.

Sign in to reply to this post

Jason ByrnesWebAssist

the recordset should lookup the orders table, and filter the orderUserID usingthe session variable of the logged in user.

the recordset will have a variable named $totalRows_<recordsetName> where <recordsetName> is the name of the recordset.

use the set session value behavior to store the $totalRows_<recordsetName> variable.

in the discount, use the Based on session variable value trigger to trigger the discount if the session is greater than 5.

Sign in to reply to this post

johna1964

Thank you.

Sign in to reply to this post

Jason ByrnesWebAssist

wel the customer would need to visit the order history page to trigger setting the session, then, yes, the discount could be created as detailed previously.

Sign in to reply to this post

johna1964

Please see private. :-)

Sign in to reply to this post

Jason ByrnesWebAssist

you could add the recordset and the Set Session Value behavior to the cart page, if you need help setting this up, we could help through a premiere support appointment:
http://www.webassist.com/premier_request.php

Sign in to reply to this post

johna1964

Thank you again!

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

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