Admin Search Differs From Product Search

[Ajeh]

Check in phpMyAdmin and look at your products table ... do you have master_categories_id values? These should match your Categories ...

If not, are you importing products?

Do you use Linked Products?

[DiZZ]

Hi Guys,

Thanks for getting back to me on this. To answer your questions:

1. I am running version 1.36 of ZC (I know there is a newer version!!)

2. There are no master_categories_id set. The values for all 291 products are 0. Should I update the table to match this column to the products_id column? What is the difference between the two ids?

3. The entire product listing was imported - only about 5% of the products were entered using the admin area.

4. I am not sure what you mean by linked products or how I would check to find out...

[Ajeh]

A Linked Product is a Product in 2 or more Categories ...

If you are not using Linked Products the quick fix is to:

1 Backup your database

2 Make sure you backed up your database

3 Go to Tools ... Store Manager ...

Run the:

Reset ALL Products Master Categories ID
to be used for Linked Products and Pricing:

4 In Tools ... Store Manager ...

Next run the:

Update ALL Products Price Sorter
to be able to sort by displayed prices: Update

This will fix both the missing master_categories_id by assigning the first match in the products_to_categories table and then fix the products_price_sorter for sorting on the Catalog by price ...

[DiZZ]

OK sounds good - I will try this and get back to you with the results!

[DiZZ]

Perfect solution - this corrected the issue. Not sure if its's worthy of a sticky, but definitely a good bit!