Update trashed variations to publish - replace wp_posts with the correct prefix!

gistfile1.txt

UPDATE wp_posts SET post_status = 'publish' WHERE post_type = 'product_variation' AND post_status = 'trash';

hello Mike,
I don't know what to do with this txt, could you tell me the steps to follow please? :)

thank you

margzmi
go to phpmyadmin and then go to wordpress database then go to SQL paste this code
UPDATE wp_posts SET post_status = 'publish' WHERE post_type = 'product_variation' AND post_status = 'trash';
and click GO

thank youuuu mrqaidi, I tried it but nothing changed :(
In fact, all variations disappeared after woocommerce pudate... After that I updated all the variations of my products but the parent's quantities don't work (it always shows no stock for all variations even if the parent stock is for example 22). And when I pick one variation, the related image doesn't appear in front as it was before :( This didn't change even using this code ... Any idea please?

Tras la actualización de un Woocommerce 2.8 a la versión 3.0.1 y luego de actualizar la plantilla (asegurando su compatibilidad), me di cuenta que las variaciones no estaban en la administración y no funcionaban en el front. Ejecuté en el PhpMyAdmin la consulta SQL que dejaste:

UPDATE wp_posts SET post_status = 'publish' WHERE post_type = 'product_variation' AND post_status = 'trash';

Luego, limpié el caché de mi navegador... y ya pude ver las variaciones en el backend como en el front. MIL GRACIAS.

I am at WC 3.0.6 and just ran SQL string. It seems to have affected 16 records, it seems to have done the trick for some products. Not all I am afraid :(

I'm having issues as well. Haas this been resolved?