I need to move the my product options to the product info column on every product in my Magento store. To do this manually I navigate to manage products, pick a product > design > "Display Product Options in". The problem is that I have thousands of products.
I have been searching through databases in Cpanel trying to find where this option exists so that I can write a query to change it for my entire store. Can anyone point me in the right direction so I can change this option for every product at once?
Thank you I really appreciate any help!
I think the import functional will suit your needs best. Create a CSV file with sku and options_container columns and insert into the latter column value container1. Use Import All Products DataFlow profile. Should do the trick for you.
You can change it from Admin panel.Go to
Catalog->Manage Products
Select the list of the products.click Update Attributes from Action Menu
Change the value for "Display Product Options In" and save