How to Change Product Type in magento?

Change Product Type In Magento:-

If you are looking to change the product type in Magento then there are no options from Magento admin, for which you have to make the adjustments in the database accordingly. Only by running a query you can change the product type in Magento on following the steps given below.

We can add specific product type accordingly when adding new products in Magento

  • 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.

You may also like...

Leave a Reply

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