Unable to Search Catalog from Admin Area

Hi,

My database is fairly large, with thousands of products. I'm unable to search my catalog from within the admin area.

For example, if I go to Catalog > Categories/Products and type a SKU in the search box, nothing comes up.

But on the front end, if I type the same SKU in the search box on the homepage, it finds the product almost immediately.

It's very frustrating, because I need to be able to search the backend Catalog via the SKU to make adjustments ... and it won't find it. I'm having to go back to the front end, search for the product, look at the nav links and figure out which category it's in, then dig deep into the catalog structure in the backend and sometimes search through pages of products in a category (or subcategory).

I've used phpMyadmin to repair the mySQL database, and I also ran the "optimize tables" option ... but if it were database issues, the search would be just as bad from the front end, right?

Please help,
Fred

What field in the products_table holds the SKU?

Ajeh:

What field in the products_table holds the SKU?

Hey, it's in:
products_model

Does it break or just not show anything?

I have not been able to repeat the error ...

What version of Zen Cart are you running?

Any Add-ons in the Admin?

Hey,
Zen Cart 1.3.8a
Database Patch Level: 1.3.8

I've got the MagneticOne export tools installed, but I use those on all my other sites and don't have this problem.

For example, at http://www.hppenterprises.com ...
If you put this SKU in the search box, you get an immediate response:
DBNVX-235W

However, in /admin ...
I go to Catalog > Categories/Products, paste DBNVX-235W in the search box, hit enter, and it searches, and the page results are:
Categories / Products - Top
Reset Search:
Search Filter: DBNVX-235W
Status - Disabled
Go To:
ID Categories / Products Model Price/Special/Sale Quantity Status Sort Action
Categories: 0
Products: 0

HOWEVER, if I go to a different store (getskinsnow.com) and do the exact same thing (same contributions, same version of ZenCart), it immediatly finds the item in my catalog in the admin area.

EDIT: the only thing I notice that is different, is that on the site where it WORKS ... even after searching, the SKU is still present in the search text box (and is also listed in the "Search Filter" field ... but on hppenterprises.com, once you hit enter to search, the search box is empty again, but the SKU is listed in the "Search Filter". area.

Beyond Compare from scootersoftware.com is your friend ... :smile:

Take a peek at a clean Admin for Zen Cart v1.3.8 and a copy of your's ...

Somewhere you have changed the search features with a much older method or cut something out ...

Beyond Compare should help you out on this ...

I am having the EXACT same problem. I have one site that works fine, and another that the search comes up empty. I've duplicated everything I can think of from the good one to the one that don't work. Is there anything in Config, or Tools, that will allow this to search correctly?

Are you getting errors or just not getting any results?

Just like FMCKINNON, I'm getting no results

pacdad:

Just like FMCKINNON, I'm getting no results

Peeking at your site it appears that many of /admin files are not current ...

This would lead me to believe that there is an issue on old and new files conflicting and things cannot work correctly ...

How did you do your upgrade to v1.3.8?

Just to jump in. I am also having problems with search in 1.3.8a admin.

Just to isolate the problem, I uploaded a copy of the admin folder from a fresh copy of 1.3.8a, called it 'admin2' and copied 'includes/config.php' into it. The same problem occurs in the new version, so I suspect some modification to the database is to blame.

Any other ideas?

I cannot reproduce this ...

Can you try loading a completely clean Zen Cart v1.3.8 from our download ... into a test directory with a test database and the demo data into it ...

Does it still do this?

I have the previous version of the site (on 1.3.7) still active (but hidden) running on the same server setup (Apache 2, php5, mySQL 5). The admin search facility works fine, same for a new install of 1.3.8a.

I suspect one of the add-ins on the production site is to blame. Can you give me some pointers as to what query is called when admin search is used versus the query when searching from main site as a user. I'll then try to work through and see which table(s)/queries/function calls are changed.

I hava also the same problem, so in admin, after requesting a search, I get the categiory page. I did refresh all files of admin, firstly file by file, and then all directory, it seems that my addons interferre with this search function. I think if I could know which querries are calling in search, may be I can follow to find out which adsdon interferred in this search function . I installed, these addons on zen 1.3.8a:

nemail ddress exporter
2- ad customer from admin
3- zj__zencart_jquery_template_pack_1-0-1
4- master_password db
5- +CSS click-show-hide menu
6- email_archive_manager_1.4
7- BACKUP_MYSQL_ADMIN_PLUGIN-1.3
8- GV_ADMIN_EDIT_1.1
9- improved_attributes_controller_1-1b
10- quick_updates-v2.04
11- reward_point_full_suite_1-13a

12-Simple SEO URL not yet worked
I disabeld by doing this:
http://www.zen-cart.com/forum/showthread.php?t=86353&page=47
To disable ssu, it's a bit troublesome right now at this current version:

13-Debug Error Logging Utility
14- artists side box ok
15- rss feed
zj-silver wide/common/html_header.php
16- super orders

17- edit orders some fioles after super orders also edited and updated

18- search_log_v200

19- Admin Activity Report
20- admin_users__restrict_product_categories_1-0-8 admin pofil
21- orders_Exporter 1.0
22- pdf catalogue maker
23- xinha
24- edit cart doesnot work for music products
25- language_selection__save_to_cookie_1-0-1
26- ZC SID-Redirect
27- book product
28- Omni Slide Menu
29- reference key configuration

I'm another to suffer from the same problem. In my case I have 3 identical stores and 2 out of 3 work. Beyond Compare yields the following:

Binary Comparison of .....\store1> to .....\store2
856 files in 46 folders

840 files match exactly

9 files don't match

admin\images\logo.gif
admin\includes\easypopulate\easypopulate_config.php
admin\includes\languages\english\email_extras.php
admin\includes\languages\english\orders.php
admin\includes\configure.php
admin\includes\menu.css
admin\includes\stylesheet.css
admin.htaccess
admin\error_log

7 folders and files only on right

admin\images\graphs\banner_infobox-10.png
admin\includes\boxes\extra_boxes\view_stuck_paypal_orders_customers_dhtml.php
admin\includes\extra_configures\enable_error_logging.php
admin\includes\extra_configures\pushorder.php
admin\includes\extra_datafiles\view_stuck_paypal_orders.php
admin\includes\languages\english\view_stuck_paypal_orders.php
admin\view_stuck_paypal_orders.php

The store where the Admin Product Search functions correctly is the right-hand store.

In my case when searching I get no errors just no products found. A few search terms do yield results but they are incorrect. For example all my model numbers begin TCS Searching on TCS yields 2 results when it should list 174 products. Searching on the full model number of TCS0095 yields no results.

On the whole though most searches yield no results.

My stores are upgraded from 1.2.7. How? I uploaded a fresh install of 1.3.8a. I then did all my file modifications and template adjustments. Once happy I restored my 1.2.7 database and did a database only upgrade.

Hopefully the answer is out there somewhere.

Brent

For the benefit of anyone else in a similar situation I have found the solution in this thread.:smile:

I reset the Master Categories ID and my admin product search is functioning as normal.

Brent

Brent's link worked for me also. Thanks. :clap: