I have around 12K products in my woocommerce store. When i use BULK EDIT option in wordpress to PUBLISH my products (20 at time), my shared hosting CPU shoots up to 60-80%.
I want to update all my 12K products from DRAFT to PUBLISH using phpmyadmin (backend using SQL).
I tried below update but it did not generate the URL (permalink) and i got URL of all 12K products as https://example.com/product
update wp_posts set post_status='publish' where post_type='product' and post_status='draft';
Can someone please guide me the correct way to PUBLISH woocommerce products using SQL so all product links, category links, yoast seo inserts will be properly updated.
I want to update all my 12K products from DRAFT to PUBLISH using phpmyadmin (backend using SQL).
I tried below update but it did not generate the URL (permalink) and i got URL of all 12K products as https://example.com/product
update wp_posts set post_status='publish' where post_type='product' and post_status='draft';
Can someone please guide me the correct way to PUBLISH woocommerce products using SQL so all product links, category links, yoast seo inserts will be properly updated.
