Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 Customization
 Categories in VPASP 6		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Alan F
VP-CART New User

102 Posts
Posted - January 03 2006 :  05:31:44  Show Profile  Visit Alan F's Homepage  Reply with Quote
Is it possible to change the default ort for the auto category display in VPASP 6

At present it is sorted alphabetically, but the client wants them by order of importance

Thanks

Alan

support
Administrator

4679 Posts
Posted - January 03 2006 :  05:48:29  Show Profile  Visit support's Homepage  Reply with Quote
Please go into the set up in the admin and locate xsortcategory.

You can insert the field anem you wish to have the categories sorted on.

Thank you
VPASP Support
Go to Top of Page

tiju
Starting Member

11 Posts
Posted - March 01 2006 :  17:16:04  Show Profile  Reply with Quote
I got a problem with that. I used the field catextra to do that and put 10,20,30,40 etc in it.

But nothing append on my site it still in alpha order

tks
Go to Top of Page

devshb
Senior Member

United Kingdom
1904 Posts
Posted - March 02 2006 :  09:00:27  Show Profile  Visit devshb's Homepage  Reply with Quote
don't forget that catextra is a text field, so you'd need to use a format like:
001-001

rather than
10
20
100
etc

because otherwise "100" will come before "20" as it'll be ordering it as a character field and not a number


Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page

tiju
Starting Member

11 Posts
Posted - March 02 2006 :  13:18:29  Show Profile  Reply with Quote
ok but I Understand.

I actually just got 4 categories and give them

001-001
002-001
003-001
004-001

So I expected the 001-001 to become first but nothing append it stay at the end because of the alpha order on the name.

tks
Go to Top of Page

frisbee365
Starting Member

13 Posts
Posted - March 07 2006 :  06:39:09  Show Profile  Reply with Quote
I have followed the previous instructions, using catextra for sorting the order.

The new ordering is working fine on the sort order on the page:
shopdisplaycategories.asp

Unfortunately, the vertical table of categories on the left hand side remains ordered alphabetically.

Any solutions?
Go to Top of Page

support
Administrator

4679 Posts
Posted - March 07 2006 :  06:48:29  Show Profile  Visit support's Homepage  Reply with Quote
Open shopprpductssubs.asp and locate the NavigateShowCategoriesStyled sub routine.

In here you will find the following line:

catSQL=catsql & " order by catdescription"

Change to:

catSQL=catsql & " order by " & getconfig("xsortcategories")
' catSQL=catsql & " order by catdescription"

Thank you
Cam

VP-ASP Support
Go to Top of Page

frisbee365
Starting Member

13 Posts
Posted - March 07 2006 :  07:28:31  Show Profile  Reply with Quote
beautiful.

Thank you.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty