Product Category Display Order

Hi WA,

I've looked at the intermediate.php and I'm not sure what to add or change in order to get the product categories to display by alphabetical order (Categoryname) and not the category ID number. I have about 40 categories now. I could manually change the category ID number in the database in increments of ten for example to allow to slot in other categories later.

What would you advise as the simplest way to display by alphabetical order?

Thanks, Mark.

To do this, go to your menu.php page in the CSSMenuWriter/cssmw_home/ directory within your powerstore and find the MySql query that looks like this:
"SELECT CategoryName, CategoryID FROM productcategories"

Change it to look like this:
"SELECT CategoryName, CategoryID FROM productcategories ORDER BY CategoryName ASC"

Hi Jimmy,

Thanks for that tip. I was able to use it on both the menu.php and intermediatee.php page to organise the categories.

Regards, Mark.

Great, glad it worked out for you.

Hi WA,

My client wants something a little different. She has a catagory "coats" and a catagory "leashes". Both of those catagories have products named "wax cotton". She wants to make sure that "wax cotton" is the first item below both categories respectively. The same would apply for her "rope leashes" and "rope collars". For an example of what exists now, go to:
Products_Results.php?Search=true&CategoryID=1

So, again, the question is, can I control the placement of "wax cotton leashes" "wax cotton collars" and "wax cotton coats" so that they all take 1st place?

Thanks,

Lisa

If there are no products that will be alphabetically after the wax cotton items, then you can go into the CSSMenuWriter folder and find the $query_ProductMenu variable and order that by ProductName and have it be descending. It should end up looking like this:
$query_ProductMenu = sprintf("SELECT * FROM products WHERE ProductLive <> 0 AND COALESCE((SELECT GroupingID FROM productoptions WHERE productoptions.ProductID = products.ProductID LIMIT 1), ProductID) = ProductID AND ProductCategoryID = %s ORDER BY ProductName DESC", GetSQLValueString($catParam_ProductMenu, "int"));