Forums / Upgrading from 1.3.x to 1.3.9 / 1.3.9e product search in Admin not working for me

1.3.9e product search in Admin not working for me

Locked

Started by bromleysid on 29 Jul 2010, 2:40 PM · Views: 1,495

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
29 Jul 2010, 2:40 PM
#1
bromleysid avatar

bromleysid

New Zenner

Join Date:
Aug 2009
Posts:
45
Plugin Contributions:
0

1.3.9e product search in Admin not working for me

Hi All,

Got a problem with the search in the products section on the admin side.

Say for example i searched for bed it wont find it although there may be about a hundred there.

Can someone please help if possible.

Thanks in Advance

29 Jul 2010, 4:37 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: 1.3.9e product search in Admin not working for me

Search seems to work fine for me.

What's the character-set and collation in your database for the name and description fields in your products_description table? (Use phpMyAdmin to find that)

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

29 Jul 2010, 7:27 PM
#3
buckrgs avatar

buckrgs

New Zenner

Join Date:
Oct 2006
Posts:
1
Plugin Contributions:
0

Re: 1.3.9e product search in Admin not working for me

I had the same problem up until a couple hours ago. What I found was that if I entered my products manually the admin-catalog search was fine. But once I used Easy Populate to load the products to the catalog, the search didn't work.

The solution that worked for me was to go to Tools->Store Manager and run "Reset ALL Products Master Categories ID".

This fixed my problem. Hope it helps with yours.

Buck

30 Jul 2010, 1:02 AM
#4
ajeh avatar

ajeh

Oba-san

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

Re: 1.3.9e product search in Admin not working for me

Thanks for the update on what worked for you ...

Often on imports the master_categories_id and the products_price_sorter fields are not setup properly ...

On the Tools ... Store Manager you will see two settings to fix this ...

NOTE: if you used Linked Products using the Reset on the Master Categories ID may or may not work for you as it will pull the first categories_id it finds in numeric order from the database table ...

Always run the Update Products Price Sorter, after the Rest of the Master Categories ID ...

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!