{"id":12579,"date":"2022-08-10T20:42:07","date_gmt":"2022-08-10T18:42:07","guid":{"rendered":"https:\/\/www.welaunch.io\/en\/?post_type=faq&#038;p=12579"},"modified":"2022-08-10T20:42:07","modified_gmt":"2022-08-10T18:42:07","slug":"how-to-bulk-update-woocommerce-user-reward-points","status":"publish","type":"faq","link":"https:\/\/www.welaunch.io\/en\/knowledge-base\/faq\/how-to-bulk-update-woocommerce-user-reward-points\/","title":{"rendered":"How to bulk update WooCommerce User Reward Points?"},"content":{"rendered":"<p>If you want to bulk update WooCommerce Reward points for all users for example, you can do that with a single line query.<\/p>\n<pre>\r\nUPDATE wp_usermeta SET meta_value = 0 WHERE meta_key = \"woocommerce_reward_points\";\r\n<\/pre>\n<p>Make sure wp_usermeta is the correct table. Most WP Instances rename wp prefix with an own one.<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","product_cat":[],"class_list":["post-12579","faq","type-faq","status-publish","hentry","faq_topics-reward-points"],"_links":{"self":[{"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/faq\/12579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/types\/faq"}],"author":[{"embeddable":true,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/comments?post=12579"}],"version-history":[{"count":1,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/faq\/12579\/revisions"}],"predecessor-version":[{"id":12580,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/faq\/12579\/revisions\/12580"}],"wp:attachment":[{"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/media?parent=12579"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/product_cat?post=12579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}