{"id":1007,"date":"2020-10-20T17:10:15","date_gmt":"2020-10-20T21:10:15","guid":{"rendered":"https:\/\/websitepsychiatrist.com\/?p=1007"},"modified":"2025-03-20T09:37:19","modified_gmt":"2025-03-20T13:37:19","slug":"delete-sale-prices-in-woocommerce","status":"publish","type":"post","link":"https:\/\/websitepsychiatrist.com\/delete-sale-prices-in-woocommerce\/","title":{"rendered":"Delete Sale Prices in WooCommerce"},"content":{"rendered":"\n<p>Need to clean out a product file? Old crusty sale prices sitting around from 6 years ago? Run these mysql commands to make the nothing but a faint memory:<\/p>\n\n\n\n<p><code>DELETE FROM wp_postmeta WHERE meta_key = '_sale_price';<br>DELETE FROM wp_postmeta WHERE meta_key = '_sale_price_dates_to';<br>DELETE FROM wp_postmeta WHERE meta_key = '_sale_price_dates_from';<\/code><\/p>\n\n\n\n<p>As with all database manipulation. Make sure you back it up before you potentially break it. You&#8217;ll thank me later.<\/p>\n\n\n\n<p>Source for this handy information: <a href=\"https:\/\/www.webdesign101.net\/remove-woocommerce-sale-prices\/\" class=\"rank-math-link\" target=\"_blank\" rel=\"noopener\">https:\/\/www.webdesign101.net\/remove-woocommerce-sale-prices\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Need to clean out a product file? Old crusty sale prices sitting around from 6 years ago? Run these mysql commands to make the nothing but a faint memory: DELETE FROM wp_postmeta WHERE meta_key = &#8216;_sale_price&#8217;;DELETE FROM wp_postmeta WHERE meta_key = &#8216;_sale_price_dates_to&#8217;;DELETE FROM wp_postmeta WHERE meta_key = &#8216;_sale_price_dates_from&#8217;; As with all database manipulation. Make sure &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Delete Sale Prices in WooCommerce\" class=\"read-more button\" href=\"https:\/\/websitepsychiatrist.com\/delete-sale-prices-in-woocommerce\/#more-1007\" aria-label=\"Read more about Delete Sale Prices in WooCommerce\">Read more<\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[161,160],"class_list":["post-1007","post","type-post","status-publish","format-standard","hentry","category-articles","tag-on-sale","tag-woocommerce","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50"],"_links":{"self":[{"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/posts\/1007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/comments?post=1007"}],"version-history":[{"count":1,"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/posts\/1007\/revisions"}],"predecessor-version":[{"id":1008,"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/posts\/1007\/revisions\/1008"}],"wp:attachment":[{"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/media?parent=1007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/categories?post=1007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/websitepsychiatrist.com\/api\/wp\/v2\/tags?post=1007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}