Insert Update Options via MySQL

I had a need to insert easily options into my opencart cart database from Google Sheet so I have created a function and procedure in MySQL todo this.

First the function this will need to be created which looksup the option_id for the name given.

Now the hard part the procedure. This took some time as needed to loop through multiple product_id's.

This need product_id's passed as string i.e. '192,145' or just single id '123' but as string. And also the option_value_id of the option you are trying to add, plus you can set the price also.

This also uses the dependant options mod I created so will also find the related option using the function above.

For some reason could not post the function and procedure if interested please email zastil@gmail.com