Skip to content

Instantly share code, notes, and snippets.

@zarei-dev

zarei-dev/change_woocommerce_price.sql

Created September 24, 2021 20:32
Show Gist options
  • Save zarei-dev/ff3cbbe079d4b5aa57f032b748218346 to your computer and use it in GitHub Desktop.
Save zarei-dev/ff3cbbe079d4b5aa57f032b748218346 to your computer and use it in GitHub Desktop.
Download ZIP
woocommerce change price from rial to tooman
Raw
change_woocommerce_price.sql
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_regular_price' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_sale_price' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_price' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_regular_price_tmp' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_sale_price_tmp' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_price_tmp' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_min_variation_price' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_max_variation_price' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_min_variation_regular_price' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_max_variation_regular_price' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_min_variation_sale_price' AND meta_value != ''
UPDATE wp_postmeta SET meta_value = meta_value*.1 WHERE meta_key = '_max_variation_sale_price' AND meta_value != ''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment