SQL to clear all product EAN numbers

[steve_c]

Hi there

 

My shop no longer functions properly due to a developer adding EAN to all products.

 

I get blank orders (especially when someone orders products with a combination).  I am not sure what he has done wrong.

Is there any way to clear all EAN for products via PHP MySQL?

 

Thanks in advance, everyone!

[bellini13]

I believe this should do it

UPDATE `ps_product` SET `ean13` = '';
UPDATE `ps_product_attribute` SET `ean13` = '';