search if any product has a option value

**dedj** · 22 Jun 2007, 01:35 PM

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

**dedj** · 24 Jun 2007, 11:33 PM

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

thanks

**dedj** · 28 Jun 2007, 04:45 PM

..anyone?

Need info about this soon, please help

**Ajeh** · 28 Jun 2007, 08:03 PM

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 ...

**dedj** · 29 Jun 2007, 10:58 AM

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

**Ajeh** · 1 Jul 2007, 12:03 AM

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 ...