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
 Display Products in certain order
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jack
Starting Member

USA
6 Posts

Posted - January 13 2003 :  19:39:05  Show Profile  Visit jack's Homepage  Reply with Quote
The merchant wants his products displayed in a certain order within a category. I tried using ascending numeric values in Other1 and added

' Added this line to force products to show in merchant's preferred
' sequence field pother1 stores sequence number
SQL = SQL + ",pother1" '''' modified this line

around line 100 in file shopdisplayproducts.asp, subroutine DisplayProducts, immediately prior to the line that calls subroutine ShopOpenRecordSet

The wierd thing is that it seems to work for some, but not all, categories. Anyone got a better, simplier, and/or supported way to
force products to be displayed in an arbitrary order? Thanks! Jack

support
Administrator

4266 Posts

Posted - January 13 2003 :  19:46:45  Show Profile  Visit support's Homepage  Reply with Quote
You almost never have to alter our code to do basic things like this
In shop Configuration set

xsortproducts=pother1

that is it

Howard Kadetz
VP-ASP

Go to Top of Page

jack
Starting Member

USA
6 Posts

Posted - January 13 2003 :  19:57:32  Show Profile  Visit jack's Homepage  Reply with Quote
You are so right - within 10 minutes of posting I found the answer myself.

Thank you!



Edited by - jack on January 13 2003 19:58:18
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000