problem searching products in Admin

I am having the same problem, it seem to be everyone that has EP installed, The products that i uploaded with EP doesn't show up when i use the search in admin. I tried what AJ suguested and the search brings back products not related to the word i use. for example i use the word "smart" and the resulst where: RCA DRC8295 DVD Recorder/VCR Combo and Samsung SPP2040 Photo Color Printer

Those where the only two items that came up. Anyone have a fix yet?

I have another problem not sure if it is related or not when i did the upgrade from 1.3.5 to 1.3.6 per the Doc instructions i still get the message that there is a updated version 1.3.6 download here. when i first login to admin. That is fine i have it set to tell me that so i know when there are bug fixes and update. But at the footer in admin just below the zencart logo i have this message :"E-Commerce Engine Copyright © 2003 Zen Cart™ Zen Cart v1.3.5/v1.3.6"

I am nto sure why i followed the instructions correctly. Any ideas?

If you are able, check and see that all of your products have a products_id in the products_description and products_to_categories tables ...

Then see that the categories_id that they are matched to are in the categories and categories_description table ...

You can check this in phpMyAdmin ...

Ajeh:

If you are able, check and see that all of your products have a products_id in the products_description and products_to_categories tables ...

Then see that the categories_id that they are matched to are in the categories and categories_description table ...

You can check this in phpMyAdmin ...

Every thing checks out ok, in those table you said to look in

In the Admin on the Categories/Products this is the main criteria for the search on Products:

                                and (
                                pd.products_name like '%" . zen_db_input($_GET['search']) . "%'
                                or pd.products_description like '%" . zen_db_input($_GET['search']) . "%'
                                or p.products_model like '%" . zen_db_input($_GET['search']) . "%')" .
                                $order_by);

If you were to go into phpMyAdmin and search the products_name and products_description using the Like%...% you should pull up the same products (excluding the products_model located in the products table) ...

Try a search on something in your Zen Cart Admin that is a products_name ... now do the same in phpMyAdmin ... how many records come up in each?

Thorght I'd jump in on this one, as I'm having the same problem too! :(

The strange thing is, I think this all occured after the 1.3.7 upgrade. I started out on 1.3.0.2 then upgraded the 1.3.6 and then 1.3.7.

All products were added to my database using Easy Populate (when I was running 1.3.0.2. Everything (the search from admin and so on) was working fine until the 1.3.7 upgrade.

Like other users, I can search for products manually created, but not those imported using EP. However, the problem did not exist in 1.3.0.2 or 1.3.6.

Has anyone found a solution for this yet?

You are missing the field:
master_categories_id

in the products table ...

Ajeh,

I've just gone to Admin | Store Manager and run Reset ALL Products Master Categories ID.

It appears to have sorted the problem. Maybe it added the missing field?

Is this a 'safe' fix? Just want to be sure before running on my live store.

The master_categories_id is maintained throught the admin regardless of adding, editing, moving, copying products etc. by the Zen Cart Admin ...

Unfortunately, many import programs do not address this field nor the products_price_sorter ... so they are not current and up to date ...

If you do not use Linked Products, you can just run the Update in the Tools ... Store Manager for:

1 Master Categories ID

2 Products Price Sorter

in that order ...

If you do have Linked Products ... be aware that what this does is select the first categories_id in the products_to_categories table and assign it as the master_categories_id ...

Usually this is correct ... but should be checked ...

NOTE: Always backup your database before running these types of changes as well as on a regular basis ...

Excellent... thanks for the help! :)

Also worked for me, much thanks!

Hi I just want to say excellent!! This worked for me too. I upgraded an OSCommerce site to latest Zencart. I wrote some SQL scripts to copy the products info and many other tables over. Then the Search didn't work.

So this was the reason and now it is working.

Thanks

Alex and Ajeh,

thanks - i ran into this same issue. this fix, well, fixed it!

Thanks for the update that the missing master_categories_id was the problem ... :smile:

Gotta watch those import programs and make sure that all of your data gets added/edited correctly ... :cool: