Within one installation of magento (188.8.131.52) I have 1 website with 2 stores. In store #1 there are 1000 simple products with custom options. In store #2, using Magento Store Manager, I created copies of each 1000 products and was able to changed them to configurable items.
However, now I need to delete the custom options for the items in store #2 since they no longer need custom options as I'll be making associated simple items (to replace the function of custom options). While the store manager makes some tasks very easy to do via the GUI, it doesn't appear to have a simple way of deleting custom options from a group of products.
So, I'm looking for a way to do it via mySQL (phpmyadmin) and any help would be greatful. I searched all over google but all I've found are programmatic ways of adding, which isn't what I need. Thanks in advance!