Product list view sorting problems, none working

[ebaobao]

Hi,

Under product list view, none of the sorts work..clicking on the price title or the description title doesn't sort accordingly for that column.

I remember modifying the default_filter.php so that the product list view will list out the newly added item first. I don't know if this would a cause the problem of sorting.

Here is what I changed, around line 220 on default_filter.php

.....$sort_col = substr($_GET['sort'], 0 , 1);
$sort_order = substr($_GET['sort'], 1);

// WEBMASTER EDIT SORT THE PRODUCT ADDED BY DATE
// $listing_sql .= ' order by ';

$listing_sql .= ' order by p.products_date_added DESC,';

      switch ($column_list[$sort_col-1]) {......

Any ideas?

[ebaobao]

I just did a test by removing my change and putting back the original code, the sorting by price and description still doesn't work.

[ebaobao]

Anyone have any ideas that can help? I was just checking the All Products page and selecting the drop down list box sort by price and it doesn't work either. I haven't touched any of this code either, is there something I didn't configure right in Admin?

[yellow1912]

If I remember correctly you have to set the default sort order somewhere in the config, and I dont remember where it is :|

[Ajeh]

In phpMyAdmin, check to see that all of your Products have in the in the products table both a:
master_categories_id
products_price_sorter

Do you import your Products?

Do you use Linked Products?

[ebaobao]

Hi Linda,
Please see my replies below.

In phpMyAdmin, check to see that all of your Products have in the in the products table both a:
master_categories_id
products_price_sorter


Do you import your Products?

Do you use Linked Products?

The master_categories_id has a entry for all the products.
The products_price_sorter has a entry for all the products, but quite a bit of products has 0.0000 in that field.

Yes, I do import the products via Easy Populate.
Yes, I do link my products to multiple categories, but I link via from the Admin side. The only initial linking I do is from Easy populate when I import. I assign the product to a master category id=715, and then I also do 1 link to another category all at the same time during import. Then I link the product to multiple categories via the Admin side.

I'm not sure if this will help, but I do have that master category id disabled because I don't want that category to show up on my left sidebox.

Thanks for your help.

[Ajeh]

All Products need a master_categories_id to calculate the prices ...

The sorting on the Product Listing for the Product Price is done based on the products_price_sorter ...

This is calculated using the master_categories_id ...

If you import products, you are most likely missing one or both of these fields ...

If you backup your database, and use the Tools ... Store Manager ... there is a feature to update the master_categories_id but this will use the first categories_id found in the products_to_categories table ...

Then, running the Update Products Price Sorter with fix the products_price_sorter field ...

If running the Update Master Categories ID is going to incorrectly set the master_categories_id, you can also set the master_categories_id based on a specific Category using the Multiple Categories Link Manager which you can reach from the Copy on any Product ...

There is an option at the bottom of the screen to manage this ...

Once the master_categories_id are all correct, you can run the Update Products Price Sorter ...

[ebaobao]

Hi Linda,

Thank You for your reply.

"Once the master_categories_id are all correct, you can run the.."
Sorry for my ignorance, but what do you mean by correct?

All the products currently do have a master_categories_id. Some products have different master ids, but all of them do have an master id. Will it matter that the product's master category is disabled but the product itself is enabled? Because thats what I have for a lot of my products.

So I guess all I need to do is do the price updater and it should work?

Thanks.

[Ajeh]

That should work, in theory ... I cannot recall any affect of disabling a Category and updating the products_price_sorter ...

Be sure to backup your database before run it ...

[ebaobao]

Thanks Linda!

Will do later tonight and let you know the results. Wish me luck!