Can I change virtual products to simple products?

[ify_nwabuokei]

I already added products on Magento and they are showing as virtual products. How can I change all virtual products without writing code?

[Sarvagya Pandey]

Hello @ify_nwabuokei ,

You can do this by Database. Use the below query : 

update catalog_product_entity set type_id = 'simple' where type_id = 'virtual';

Note: This query converts all virtual products to simple. (better to create db backup before start) If this helps you please accept as solution and give kudos.

Regards

[Manthan Dave]

Hi @ify_nwabuokei 

You can try to update the same using CSV import - in that mentioned product_type = simple and also pass the product SKU with the same.

You can also try the approach which @Sarvagya Pandey  has suggested that will also works.

Hope it helps !