Monday, January 23, 2017

Product Automatically Converting To Virtual Product Instead of Simple Product in Magento

If you are experiencing a queer problem where by your products are automatically converting to virtual product instead of the default simple product then one of the reason might be —while creating the product, under the weight field you might be selecting the option - 'This item has no weight.' & when you do this Magento saves the products as virtual product. To save a product as simple product you must select the option as 'This item has weight.'

In case you have lots of product that are virtual and you would like to convert them to simple products, you can run this simple SQL query as below:

 UPDATE catalog_product_entity SET type_id = 'simple' WHERE type_id = 'virtual'  

product-automatically-converting-simple-product-virtual-product

1 comment:

  1. This is great advice, especially if you do not want to heavily burden your servers with databases. I recently collaborated with php developers http://www.nixsolutions.com/departments/php/, they helped me to adjust the work of my old project and solve all the problems with the database, I advise everyone, outsourcing is the key to success in such matters.

    ReplyDelete

Thank you for your Feedback!
www.evagabond.me

Top Magento Hosting:

Top 5 Posts (Weekly)

Lets Connect: