Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Delete one color for all products


morganbvn

Recommended Posts

I have over 100 products that share the same color choices and want to delete one color from all. Problem is I can't delete because all products are linked to that color. Is there a quick and dirty way to delete a color w/o having to go into every product and removing it? This will take hours!!!!

Link to comment
Share on other sites

1. Back up your database.

 

2. Go to the Attributes page an note the Options ID (e.g. color) and the options value ID (e.g. red). Those are the numbers on the left side of the particular tables.

 

3. Open your phpMyAdmin and choose the table products_attributes.

 

4. Click the SQL tab.

 

5. Enter the following statement to the text area:

Delete from products_attributes where options_id=<here comes the options ID> and options_values_id=<here the options values ID>

 

6. Click OK and you should be good to go.

Link to comment
Share on other sites

Thanks! I'll give this a try!

 

 

 

 

 

1. Back up your database.

 

2. Go to the Attributes page an note the Options ID (e.g. color) and the options value ID (e.g. red). Those are the numbers on the left side of the particular tables.

 

3. Open your phpMyAdmin and choose the table products_attributes.

 

4. Click the SQL tab.

 

5. Enter the following statement to the text area:

Delete from products_attributes where options_id=<here comes the options ID> and options_values_id=<here the options values ID>

 

6. Click OK and you should be good to go.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...