REMEMBER to backup your database before making any changes!!!<\/p>\n

In order to change the prices for all products in your store, you will need to get into your database (mysql) and run an SQL statement. Here’s an example to change the prices for ALL PRODUCTS to 90% of the original price:<\/p>\n

update wp_postmeta set meta_value = meta_value * 0.9 WHERE meta_key = ‘regular_price’<\/p><\/blockquote>\n

DO YOU LIKE WHAT YOU'VE READ?<\/div>

Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!\r\n\r\n

\n

\n\n

Name<\/label>\n<\/div>\n

Email<\/label>\n<\/div>\n

\n<\/div>\n<\/form>\n<\/div>\n<\/p>\r\n\r\n<\/div><\/div>\n

<\/div>","protected":false},"excerpt":{"rendered":"

REMEMBER to backup your database before making any changes!!! In order to change the prices for all products in your store, you will need to get into your database (mysql) and run an SQL statement. Here’s an example to change the prices for ALL PRODUCTS to 90% of the original price: update wp_postmeta set meta_value […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[618,497,381,403,489,614,615,317,617,619,453,490,488],"class_list":["post-367","post","type-post","status-publish","format-standard","hentry","category-technology","tag-all","tag-database","tag-jigoshop","tag-meta","tag-postmeta","tag-pricings","tag-remember","tag-sql","tag-sql-statement","tag-statement","tag-store","tag-where","tag-wp"],"_links":{"self":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/comments?post=367"}],"version-history":[{"count":3,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/367\/revisions"}],"predecessor-version":[{"id":370,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/367\/revisions\/370"}],"wp:attachment":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media?parent=367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/categories?post=367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/tags?post=367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}