Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need SQL for adding additional options to all products


dinki

Recommended Posts

Posted

I run a decal web shop. I've recently purchased some new equipment and now I can cut much bigger decals. Can someone tell me how to form a MySQL query/insert to add the additional sizes to all products?

 

Here's some the information:

 

products_options_id language_id products_options_name

2 1 Size

 

and

 

products_options_values_id language_id products_options_values_name

19 1 12" wide

 

So what I'm trying to do is add the 12" wide option to all products in my catalog without having to manually add it to all 400+ products. I'll want to do this again for 14", 16", 18", 20", and 22" sizes. Is this something that can be written as an easy MySQL query? Where does the additional pricing come in to play?

 

Any help is greatly appreciated....

Archived

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

×
×
  • Create New...