VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Customization
 Cross Sell Working but looking at upselling/downse
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

leem
Starting Member

United Kingdom
17 Posts

Posted - February 06 2003 :  06:09:31  Show Profile  Reply with Quote
Last week I was looking for advice for help with cross selling products appearing in my extended description page and being selectable for purchase. I managed to get around this by making some changes to the 'sub procedure crossell' in shopfileio.asp. This acheives the following look:-

|-------------------------------------------------------|
| Product Name| | |
| Extended Desc| | |
| | Picture | |
| | | |
| Item Code| | |
| Price| | |
|-------------------------------------------------------|
|cross sell 1 |cross sell 2 | cross sell 3|cross sell 4 |
| | | | |
| | | | |
|-------------------------------------------------------|
|Order Button |Reset Button |Hyperlinks| |
|-------------------------------------------------------|

From this I can now select multiple items from my extended description and place them back into my main page to the cart.
I did this by using the existing cross sell procedure. What I would like now is to have an upsell/downsell item appearing as shown below.

|-------------------------------------------------------|
| Product Name| |-------------------|
| Extended Desc| |UpSell Item |
| | Picture | |
| | |-------------------|
| Item Code| |DownSell Item |
| Price| | |
|-------------------------------------------------------|
|cross sell 1 |cross sell 2 | cross sell 3|cross sell 4 |
| | | | |
| | | | |
|-------------------------------------------------------|
|Order Button |Reset Button |Hyperlinks| |
|-------------------------------------------------------|

By using a field say pother4 or pother5 I would like to take a value
from this field from the existing recordset displayed and run another
query creating a second recordset much like the crosssell procedure to create upsell and downsell items. All of which can be shown in the form. Can anybody give me a pointer on how to start this as so far I have only acheived the cross sell results by updating existing procedures. My ASP is okay and I have tried creating procedures but I can't seem to tie the recordsets to one another, can anyone help me please????

leem
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000