problem searching products in Admin

Hi, I am having trouble searching through my products in the admin part of my page. I search for a product's model number that I can see is clearly in the category and the search comes up with nothing (again this is seaching within the admin part of the site). Any ideas?

I cannot reproduce this problem regardless of depth of the product within the categories ...

What version of Zen Cart are you running?

Clean install or an upgrade? If an upgrade, what version were you and how did you do it?

Have you an add-ons in the Admin?

I'm running ZC v1.3.6.

Upgraded from a v1.3.5 clean install. I upgraded from v1.3.5 exactly as laid out in the readme doc for upgrading.

I am operating with the following add ons:

1. User tracking
2. Easy Populate
3. About Us Page
4. Viewable Pricelist
5. MAP Pricing
6. Email confirmation

Any advice would be greatly appreciated. I have about 8,000 products I need to add descriptions for, but I want to add the most in-demand ones first so the search function is really essential.

Thanks!

i'm having the same problem I can search by product model fine in the front end but when i search admin for a product model i get nothing and i can see the product when i view the category so i know it's there.

I've got a fresh install of 1.3.6 only addon is easy populate v1.2.5.4

of note might be the fact the EP file i imported into the database is probably from a 1.3.5 version of zen cart not sure if there were database changes in 1.3.6 or if that even makes any difference but i figured it was worth mentioning. I've just started setting up my store and so far this is the only problem i've encountered.

Thanks for any help!

Just to rule out issues ... based on the number of Add-ons etc.

Have you tried a clean install of Zen Cart v1.3.6 into a clean directory such as /new_shop using a clean database, username and password?

ok this is interesting. Out of curiosity i created a test product and put it in a category and tried to search by product model and it worked perfectly. so the problem seems to be the EP file i imported into the database, as far as searching in admin, otherwise the EP file i imported seems to be fine. i can search for the test product i created but if i search for something inserted with the EP file i get nothing.

That is interesting. I never had this problem with EP when I was using ZC v1.3.5. I checked out my database and it appears that the same thing happens. Items I created just using the 'create product' button the the categories/products section of admin show up on the search fine. However, when I search for any products added through a bulk EP upload, they don't show up even though I can see that the product is clearly there. I'm not sure whether this is an EP problem or a ZC problem or both?

Using phpMyAdmin ... browse the products table to your database ...

If you Edit a Product that you cannot search for, do you find spaces before or after the products_model or any other strange characters such as tabs?

ok, editing a product in ZC doesn't show any spaces before or after or any other characters i checked several different products.

phpmyadmin in the products table doesn't show any spaces or other characters either it all looks good. this has me puzzled :(

I'm gonna mess around with the ep file perhaps import it again and see what happens.

Any luck yet?

Update:

I deleted a bunch of products (8000+) from my database and now only have 250. My search function in admin seems to be working, at least for the moment. Does anyone have an idea what this means? Is there some problem that prevents me from searching when I have too many products? I'd like to fix it so I can add products once again.

Another Update:

Altough the admin search function seems to be working for the most part, there is still at least 1 product in my db that doesn't come up when seached for altough it is definately there...:blink:

I have sites with 700,000 products and can search ...

There is something with that Product that it is not working ...

I'm experiencing the same problem searching the admin. I use EP too.

Anyone have a fix?

I'm having the same issue. My store has about 1500+ products, and I believe this cropped up when I updated to 1.3.6. Has anyone had any luck resolving this?

There has to be something related to Easy Populate and the problems that you are having ...

I cannot reproduce this error ...

What happens if you manually add a Product with something unique for the products_name and something unique for the products_description ...

Are you able to do a search and find this product?

Well, I do have Easy Populate installed...though I've never used it and am also pretty certain that it no longer works. Most of my products were added through phpmyadmin using hand-crafted mysql statements. This was because I actually converted from a Cubecart installation way back when.

If I just manually add a product it IS searchable through the admin area. The weird thing being that before the recent 1.3.6 update (or possibly 1.3.5) this was not a problem.

Thanks for the assistance... :-]

Makes me think you have bad records or bad data somewhere ...

Do you use Linked Products? Or do all Products belong to only 1 Category?

What version did you upgrade from?

Sorry for the delay...I do have a few linked products, only a handful though. It doesn't seem to be specific to one category.

The oldest version that I had was 1.3.0.2...from that I upgraded to 1.3.5, and finally to 1.3.6 (when I think the problem cropped up).

Products added via the normal method in the Admin do not reproduce the vanishing products on the search ...

As you can search for manually added products but not for products imported with Easy Populate ... I am suspecting something to do with Easy Populate ...

Let's try an experiment ...

The idea is to do a search for something that does not include the first or last word in a products_name ... as in if the products_name have 3 words in it, you would search for the second word ...

If you do a search for the 2nd word in a products_name that was added with Easy Populate can you find it?

Another test would be, if the products_name was: Hewlett

Search for: ewlet

If you do a search for a part of the products_name that was added with Easy Populate can you find it?