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
 Announcements
 Sorting Sub Products in V7
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Data0999
Starting Member

USA
42 Posts

Posted - November 02 2011 :  01:06:20  Show Profile  Visit Data0999's Homepage  Reply with Quote
Does anybody know how the sorting is done on sub products in Version 7 ? It doesn't seem to follow the sort method as do products under the categories. It seems to only sort by how they are added.

Been a mystery. Just checking.

Thanks,
Dave Layton

zachary
Starting Member

29 Posts

Posted - November 02 2011 :  03:33:00  Show Profile  Reply with Quote
Hi Dave,

You are able to define the "sorting field" at config : xsortproducts
for example, i change it to "level5" (without quotes),
then i just need to define the sequence at the Product Setup > Spare Fields > Other Fields 5

due to "level5" is a text fields, hence you need to define the sequence as:
01
02
.
.
.
10
11
.
99

if you have product more than 100, then you need to use
001
002
.
.
.
010
011
.
099

because system will sort by 0 first then only 1.

If you want order by descending, just enter "level5 desc" in the xsortproducts
for ascending just enter "level5 asc"

pls note that this setting is apply the ALL products but for sub product only.

hope it helps.

Thanks
zach
Go to Top of Page

zachary
Starting Member

29 Posts

Posted - November 02 2011 :  05:22:59  Show Profile  Reply with Quote
Dear Dave,

My post above is confusing.

let my explain gain clearly.

i know there is vpasp config called Xsortproducts which you can use for this purpose.

by default, the value usually cname, which means to sort by product name.
you can change it to use any other field, for example set to : level5.
then so that each of your product can be ordered by the value of level5 field, due to "level5" is a text fields,
you need to define the sequence as 001,002,003,...010,011,999(because system will sort by 0 first then only 1 in'text' format) value into each of products for the level5 field.

In edit product page, the 'level5' field is labelled as "Other Fields 5".
So go to edit each of your product and enter value in "Other Fields 5" field eg. 001 (if you want this product to be displayed first).

Then go edit the other product and enter value in "Other Fields 5" eg. 002.
and so on for the next products with labelling. 003, 004, 005, 006, 007 etc.....

eventually the above trick can be applied for all products, not only sub products.

that is all, the text from my revision.


Thanks
zach
Go to Top of Page

Data0999
Starting Member

USA
42 Posts

Posted - November 10 2011 :  22:18:36  Show Profile  Visit Data0999's Homepage  Reply with Quote
Okay, we're experimenting with that information. I thought responses were emailed. So far it seems to be working out. thanks a bunch,

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