Site maintenance: Sun 15 Nov, from 12:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Basic Configuration / Sort Order for Categories

Sort Order for Categories

Locked

Started by retched on 30 Jun 2010, 8:51 PM · Views: 623

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
30 Jun 2010, 8:51 PM
#1
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
949
Plugin Contributions:
3

Sort Order for Categories

This may sound like a simple question but I just wanted to be sure.

Can Sort Orders for either Products or Categories be entered as negatives? And if they are entered as negatives will the category sort from bottom most negative to highest positive?

30 Jun 2010, 11:18 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Sort Order for Categories

It can be done but it is not recommended ...

If you just need more "room" for the Categories Sort Order ...

You could replace the sort_order in the categories table with sort_order * 10 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

1 Jul 2010, 12:02 AM
#3
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
949
Plugin Contributions:
3

Re: Sort Order for Categories

Ajeh:

It can be done but it is not recommended ...

If you just need more "room" for the Categories Sort Order ...

You could replace the sort_order in the categories table with sort_order * 10 ...

Via an SQL code correct?

1 Jul 2010, 6:06 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Sort Order for Categories

That is correct ... it would be best to backup the database then you can run a SQL on the table to replace the field sort_order with sort_order * 10 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!