Magento 2 Converts Simple Product To Virtual Product

Step-1: By Using Magento 2 Admin

• Go To Magento 2 Admin
• Catalog–Products: select Simple Products, which you want to converts into Virtual products.

• Click on Edit

• Go To Weight: “The item has weight” for Simple Product already mentioned.
• To Converts into Virtual Product, “select Item has no weight”

• Step-2: By Using Database SQL Query

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

Note: Be careful, this query will be converted all Simple Products To Virtual Products

Note: If user wants to convert specific Simple Products To Virtual Products, below query need to run

update catalog_product_entity 
set type_id = 'virtual' 
where type_id = 'simple' and sku in ('BSX55MOLCG','BSX55MOLCLW','BSX55MOLCMW','BSX55MOLWWH')