- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2019
02:56 AM
09-20-2019
02:56 AM
Can I change virtual products to simple products?
I already added products on Magento and they are showing as virtual products. How can I change all virtual products without writing code?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2019
03:17 AM
09-20-2019
03:17 AM
Re: Can I change virtual products to simple products?
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2019
06:32 AM
09-20-2019
06:32 AM
Re: Can I change virtual products to simple products?
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 !
if issue solved,Click Kudos & Accept as Solution