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
 General help me questions
 Change sequience of Display
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jmccann
VP-ASP New User

United Kingdom
131 Posts

Posted - July 05 2004 :  03:48:45  Show Profile  Visit jmccann's Homepage  Reply with Quote
Is there a way to control the display sequence of products within shopdisplayproducts.asp. The default sequence is alpahabetical. I don't want products displayed this way.

I have a number of product sub categories and wish to control the sequencee in which the sub categories get displayed. I dont want subcategories displayed alphabetically either. I want them to appear in a predefined sequence. eg Most popular subcategories first.

eg If I have Sub categories A,B,C,D,E,F,G,H
But I want products to be displayed as: F, G, A, H, C, D, B, E


Is this possible?

stamen
Starting Member

United Kingdom
3 Posts

Posted - July 05 2004 :  04:31:39  Show Profile  Reply with Quote
Hi,

I can't understand exactly what type of criteria you need.
I guess I'm trying to do something similar.
I need to display the most visited cats, subcats and products.
So I'm making a counter for each one.
Also sql statements have to be changed.
No result by now but I keep my fingers crossed.

Regards

Go to Top of Page

stamen
Starting Member

United Kingdom
3 Posts

Posted - July 05 2004 :  04:31:46  Show Profile  Reply with Quote
Hi,

I can't understand exactly what type of criteria you need.
I guess I'm trying to do something similar.
I need to display the most visited cats, subcats and products.
So I'm making a counter for each one.
Also sql statements have to be changed.
No result by now but I keep my fingers crossed.

Regards

Go to Top of Page

greatphoto
VP-ASP Super User

USA
304 Posts

Posted - July 05 2004 :  16:12:09  Show Profile  Reply with Quote
Hi jmccann!

Yes, its possible...and actually pretty easy. Under the cart administration configuration, set xsortproducts to the name of a product field you would like to use to control the order. I wanted ultimate control over the ordering independent of any other value already in the product record, so I selected an otherwise unused field and placed my own 2 digit numbers in the field to force it to give exactly the ordering I wanted. I used the pother1 field (set xsortproducts="pother1"), but you can use whatever you like.

I used 2 digit numbering to give me plenty of room for future expansion. The sort is character by character by default (non-numeric) so 2 actually comes after 10. However, 02 comes before 10. (You could use letters to make this clearer). I spaced out my numbering to allow for future products to be interspersed in between. For the product I want first, I put "10" in the pother1 field. For the product I want second, I put "20" in the pother2 field...and so on. Later if I decide to add another product that needs to go betwee the first and second, I can number it "15"

Hope this helps...

Nathan

Go to Top of Page

jmccann
VP-ASP New User

United Kingdom
131 Posts

Posted - July 06 2004 :  08:28:09  Show Profile  Visit jmccann's Homepage  Reply with Quote
Nathan,

This works a treat. Exactly what I wanted.

Thanks for your suggestion.

regards,

jim mccann

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000