Forums / Setting Up Categories, Products, Attributes / search if any product has a option value

search if any product has a option value

Locked

Started by dedj on 22 Jun 2007, 12:35 PM · Views: 1,653

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
22 Jun 2007, 12:35 PM
#1
dedj avatar

dedj

Zen Follower

Join Date:
Jan 2007
Posts:
129
Plugin Contributions:
0

search if any product has a option value

Hi, a quick question.
if i wan't to clean up some option names and option values.

I think lots of people have played a little with the shop in the beginning to learn the features of it.

I know have a option name called "material" and option values "fiberglass" and "carbonfiber". When I was playing with the webshop i added the attributes to all kinds of different products on my shop. Problem is that I don't know if I have missed to remove theese option values of a product that shouldn't have this.

Is there any way to search and see what products have a certain option name or certain option values as attribute?

thanks

24 Jun 2007, 10:33 PM
#2
dedj avatar

dedj

Zen Follower

Join Date:
Jan 2007
Posts:
129
Plugin Contributions:
0

Re: search if any product has a option value

So, is there a way to search your webshop if you want to see what products have a certain attribute?

thanks

28 Jun 2007, 3:45 PM
#3
dedj avatar

dedj

Zen Follower

Join Date:
Jan 2007
Posts:
129
Plugin Contributions:
0

Re: search if any product has a option value

..anyone?

Need info about this soon, please help :cool:

28 Jun 2007, 7:03 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: search if any product has a option value

If you hit delete in either the Option Name Manager or Option Value Manager it tells you what products are using them ...

You can also look at the products_attributes table in phpMyAdmin to see what the options_id and/or options_values_id are for each products_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!

29 Jun 2007, 9:58 AM
#5
dedj avatar

dedj

Zen Follower

Join Date:
Jan 2007
Posts:
129
Plugin Contributions:
0

Re: search if any product has a option value

nice thanks for answer.
you can probably see more info in phpmyadmin, but what I needed at the moment worked just fine with hitting the delete button and looking.

thanks

30 Jun 2007, 11:03 PM
#6
ajeh avatar

ajeh

Oba-san

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

Re: search if any product has a option value

This is why that safety is there ... keeps you from wiping out things in addition to being a quick check for is an Option Name or Option Value in use ...

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!