How to Change Product Type in Magento 2?

In this tutorial, you will go through how to change the product type in Magento 2.

There are no options from Magento 2 admin, for which you have to make some changes in the database.

Simply, You can change the product type in Magento on following the steps given below.

Change Product Type in Magento 2

To change the product type in Magento 2, follow these steps:

Step 1: First of all Login to your database using the PhpMyAdmin with right credentials

Step 2: Now search for catalog_product_entity tables

Step 3: Now click on “SQL” tab respectively run the below query with it:

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

This query will change all the Simple products type into the Downloadable products. In above table, product type is showing only simple product type but when you will run this sql query it will change into downloadable type accordingly.

Step 4: Now Login to your admin panel and see the changes into the products type. You can do this similar for configurable and bundle products types as well.

That’s it !!


I hope you like this post, Please feel free to comment below, suggestion and problems!

(Visited 9 times, 1 visits today)
Chandra Kumar

Hello World, I am Chandra Kumar from New Delhi, India. I am professionally developer, programmer and blogger. I am the founder of WebShouters.com.

0 Comment

Leave a Comment

Your email address will not be published. Required fields are marked *