Magento – Delete custom options from products in specific store

custom-optionsmagento-1.7MySQL

Within one installation of magento (1.7.0.2) 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!

Best Answer

The custom options are stored in the table catalog_product_option. If you delete all the options for the product_ids that you specify.