How to bulk update WooCommerce User Reward Points?

If you want to bulk update WooCommerce Reward points for all users for example, you can do that with a single line query.

UPDATE wp_usermeta SET meta_value = 0 WHERE meta_key = "woocommerce_reward_points";

Make sure wp_usermeta is the correct table. Most WP Instances rename wp prefix with an own one.

Leave a Reply

Your email address will not be published.