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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Sessions and recordset

Thread began 8/01/2010 3:29 am by victor405909 | Last modified 8/26/2010 10:22 pm by victor405909 | 3173 views | 15 replies

CraigRBeta Tester

Ok, here are some ideas
Upselling - Suggesting a better or higher value alternative
Simple
Add a field to your product table of the same data type as your product id
Use this field for other product id’s which you ‘recommend’, or are of higher value/margin
Advanced
Create a new table for recommended products.
Need a minimum of 2 fields (if using a compound key) or 3 fields if using DataAssist.
DataAssist table example structure, ID (PK), MainProductID, RecommendedProductID.
Link this table to your products table in your select query.
Good place to use this is on product detail pages, (where you are already retrieving productid as a URL parameter), so you can filter the recordsets above.
Cross Selling – Suggesting additional or related products to increase customer spend per transaction
Both methods above still apply for cross selling, depending on the recommended products added.
Additional ways
Items recently viewed, (covered in this thread)
Reminds a customer what they were considering in this session.
Sometimes referred to as ‘Customers who bought x also bought y’
Analyse the order details table, to see what items were ordered at the same time as the currently selected product. Collate this data into descending order of quantity purchased, perhaps limiting to a few rows, and display on the product detail and/or cart pages. (This is only applicable when you have some order history.)
The benefit of this approach is that the data is always based on your order history, so will update itself.

That should get you started

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