Take off virtual items

[clemence_benharbon]

Hello,

I want all the items to be simple items and not virtual.

How can I do that?

thanks

Sharon

[Bhanu Periwal]

Hi @clemence_benharbon 

You can do it only direct in DB. For example with query

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

But beware, this query converts all virtual products to simple. (better to create db backup before start).

It may help you.

Problem Solved? Click on Kudos & Accept as Solution!

[clemence_benharbon]

Hi,

Thanks. Is there a way to do this directly from magento dashboard? As I do not know how to proceed with the query you told me...

best

Sharon