Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Finding all products that have been assigned an attribute.

Finding all products that have been assigned an attribute.

Views: 530

Results 1 to 2 of 2
28 Aug 2012, 1:42 AM
#1
bi11i avatar

bi11i

Zen Follower

Join Date:
Jun 2005
Location:
Portland, OR
Posts:
157
Plugin Contributions:
0

Finding all products that have been assigned an attribute.

I'm sure there's an easy way to do this. Help?

28 Aug 2012, 1:20 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Finding all products that have been assigned an attribute.

A Product with attributes would have a record in the table:
products_attributes

in phpMyAdmin, you can get the products_id in that table and match them to the products_id in the table:
products

or in the table:
products_description