Change Product by Type in Magento 2

This can be achieved exclusively through the database, either manually or via an SQL query. To perform a bulk change of product types using SQL in Magento 2, follow these steps:

• Log in to phpMyAdmin.
• Navigate to the SQL tab and enter the following command:

UPDATE catalog_product_entity SET type_id="simple" WHERE type_id = "downloadable";

This command switches all downloadable product types to simple ones. Adjust the query as needed for other substitutions.

• Login to the Admin Panel to verify the results.

Alternatively, you can manually modify the product type in the catalog_product_entity table or refine the query to target specific products.