MYSQL Help - Publish Woocommerce products using phpmyadmin

  • You MUST read the Babiato Rules before making your first post otherwise you may get permanent warning points or a permanent Ban.

  • You MUST read the Babiato Rules before making your first post otherwise you may get permanent warning points or a permanent Ban.

    Our resources on Babiato Forum are CLEAN and SAFE. So you can use them for development and testing purposes. If your are on Windows and have an antivirus that alerts you about a possible infection: Know it's a false positive because all scripts are double checked by our experts. We advise you to add Babiato to trusted sites/sources or disable your antivirus momentarily while downloading a resource. "Enjoy your presence on Babiato"

SpiderWeb

Active member
Trusted Uploader
Sep 23, 2020
177
165
43
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.
 

playerone

Active member
May 13, 2020
26
108
33
For the permalinks ... did you check in "Setting--> Pemalinks" to make sure it's enabled ?
 

Forum statistics

Threads
54,950
Messages
711,582
Members
148,921
Latest member
ronsnyndersyn
AdBlock Detected

Hi bro. Can you please help us?

I know the ads sometimes are too annoying and you want to use Adblock. But I think you can support us by adding Babiato to the whitelist. It will help us and our community.

Thanks for your help!

I've Disabled AdBlock