Magento Batch Update Product Type in MySQL

I just want to share a simple MySQL snippet to batch update product type in Magento. This is a pretty basic SQL query, and I’ll just save it here in my blog so that I can remember what I did to update product types by batch.

I just went to my SQL database via phpmyadmin, click the SQL tab, and run this command:
UPDATE prefix_catalog_product_entity
SET type_id = REPLACE(type_id, 'simple', 'virtual')

If you’re using a custom table prefix, replace prefix with your prefix. Otherwise, just use catalog_product_entity.

This is what I did to change all my product types from simple to virtual. It’s quick and easy and I was able to change it all in 1 second.