Forums / Basic Configuration / How to find products without manufacturer?

How to find products without manufacturer?

Views: 1,102

Results 1 to 2 of 2
29 Jan 2014, 11:35 PM
#1
matteoraggi avatar

matteoraggi

New Zenner

Join Date:
Mar 2007
Location:
italy
Posts:
92
Plugin Contributions:
0

How to find products without manufacturer?

In the past I was deleting a manufacturer, leaving the products on the cart, but now I would like to add back these products to them manufacturer, but I can't find them easily between many others.
These products are different from others, because without manufacturer. Is there a tip or module to find them quickly?

30 Jan 2014, 11:25 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: How to find products without manufacturer?

For products without a manufacturer set you could go to phpMyAdmin and run the SQL statement for:

SELECT * FROM products WHERE manufacturers_id = 0;

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!