Mass check a certain box in an option panel for 3000+ WooCommerce products?

If you have database access, and are familiar/comfortable with MySQL, you could write a simple update script on the product table, replacing all ‘review_status’ to be ‘yes’.

I am not familiar with WooCommerce back end, but you will just need to find the proper table, column, and value, and it would be a 5-10 second long ordeal.

UPDATE [wp_woo_products_table] SET [product_status]='[enabled/yes]'

Ignore the square brackers [] in the line above, they simply mean placeholders for the proper values.

Related Posts:

  1. Can I leave off plugin textdomain for terms used in core?
  2. How to tell if a plugin is multisite compatible?
  3. Correct way to serialize the data of options table?
  4. How to force WordPress to temporarily switch locale (using qTranslate)? [closed]
  5. Custom admin column disappearing when using Quick Edit [duplicate]
  6. Create page when plugin is activated
  7. How can I translate the name of my Plugin for other languages?
  8. Article source link for posts
  9. WordPress media upload limit?
  10. How to make a plugin auto-add item to nav menu
  11. Logs to check when the plugin was first installed for the first time
  12. How to get custom field image url of specific size
  13. Getting “Fatal error: Call to undefined function wp_cache_get() in option.php” after updating a cache plugin [closed]
  14. Facebook Like Button On Individual Comments
  15. Keep user’s privileges on accessing contents in JSON response
  16. Displaying admin notice dynamically
  17. Get total number of comment of the posts written by an author
  18. How to Dequeue All WordPress Assets
  19. How to replace or display the special characters from JSON API plugin [closed]
  20. Output HTML only on individual post view
  21. Why plugin ajax response is -1?
  22. printf – problem to understand code
  23. Pass info from functions.php to plugin
  24. add_query_arg not working
  25. Elementor\Scheme_Typography’ not found [closed]
  26. How do I add a custom sub menu menu under Woo-commerce marketing?
  27. Widget for adding HTML markup to a page
  28. WordPress filter that hook after each action/filter hook
  29. When to use action hooks and plugins
  30. Uncode theme content block header ignoring saved changes/not updating?
  31. Unique 4 digit number
  32. One of my plugins broke when I tried to update it, how do I safely uninstall it?
  33. WooCommerce Checkout Error [closed]
  34. User Session and Stored Cookies not get removed
  35. get 404 when accessing wp-admin/plugin-install.php
  36. Pre booking doesn’t work with custom bootstrap modul in woocommerce [closed]
  37. WordPress change Language not working
  38. Bulk updates to post_content
  39. Advanced AJAX Page Loader ignores other JS code
  40. WordPress 3.8.3. custom theme – sliders won’t load js/css files
  41. wp_enqueue_script registers script but does not create html tag
  42. Multiple domains issue
  43. How to add FB like + share AND also other Social Buttons on ALL pages and posts?
  44. file-gallery plugin line 1573 broken in 4.2 upgrade [closed]
  45. How do I use wp_editor() in widget form?
  46. the_tags : can we insert a class
  47. PHP Error When a plugin is active
  48. Errors when trying to use a plugin to write to the database
  49. Moving a plugin js to footer
  50. Is there a plugin for WordPress for creating ‘Accounts’ where all users who belong to that Account can only see Account data? [closed]
  51. wp_redirect doen’t work
  52. How do I add an options page at the bottom of the list?
  53. Hardcoded paths in my plugin
  54. How to save plugin custom settings page fields
  55. wp_insert_term() doesnt insert a term
  56. Dequeue, Unregister, Remove Action – Not Working on Plugin
  57. HTTP requests start hanging after I try activating all plugins, and only stop when I manually disable the plugins via DB
  58. Memory Management when developing plug-ins
  59. How can recognize post’s category?
  60. Developing plugin, where to place action hooks etc?
  61. Widget content turns up before title
  62. Load script only in the admin page
  63. Using AJAX to run SQL statement and populate dropdown
  64. How do I fill the Home Description?
  65. Disable “auto embed” feature when pasting text and links
  66. How to prevent users to view server files using WP File Manager plugin?
  67. Alternative Hook to the_content for Changing Background Color
  68. How to use WordPress header function and footer function and not load word press database
  69. SASS not showing in customized preloader plugin
  70. Lock content in WordPress website
  71. I want to display “how many times this tag used in WordPress?”
  72. After updating theme & plugin I am getting an error message
  73. Get Current Post ID in WP Loop For GiveWP
  74. Suspect incomplete .pot file – what to do?
  75. Password Protect wp-content?
  76. Unable to activate themes on localhost
  77. How to make cover image in post block expand to entire screen?
  78. Can you develop themes and plugins while using the hosting services BlueHost? [closed]
  79. Conditional Fields depending on checkboxes
  80. Identify if the_post hook is being called from the admin post list
  81. Translation plugin with default language?
  82. wordpress ajax pagination object value does not change
  83. Reorganization of namespaces
  84. Google analytic issue in wordpress
  85. Passing a parameter to filter and action functions
  86. image upload error wordpress
  87. Holding 2 wp_user in the same action (to update billing_email when user_email is updated)
  88. Simply Exclude – Category feed exclusion is excluding from category feed instead of just the main feed
  89. OOP Plugin: Where should I place the action hooks in the class?
  90. How to get the real address from a url (permalink)
  91. 404 Page when emptying spam or deleting a plugin
  92. File permissions for wp-minify plugin
  93. How to make temporary expiring link for a downloadable file
  94. Add country flags
  95. How to declare this function correctly?
  96. Content expands beyond its column container [closed]
  97. Make plugin admin page visible to other roles
  98. How Create LastMod and Update Date Only on Taxonomy Category and Tags
  99. How To Convert External Image URLs To Own Website’s Uploaded Images Automatically?
  100. Getting 400 Error in wordpress website