WordPress.org

Support

Support » Plugins and Hacks » WooCommerce » [Resolved] Change comma for dot in the DB

[Resolved] Change comma for dot in the DB

  • Hi! I need some help, please!

    I have all my prices with commas for decimals in my database (the “_regular_price” meta key value). It causes some problems in WooCommerce, since they should be dots.
    How Can I update all the commas using MySQL? Is there any MySQL UPDATE instruction I can use?

    Thanks so much!

    http://wordpress.org/plugins/woocommerce/

Viewing 1 replies (of 1 total)
  • Never mind, found it:

    UPDATEwp_postmeta`
    SET meta_value= replace(meta_value, ‘,’, ‘.’)
    WHERE meta_key= ‘_regular_price’
    `

    Easy as pie.

Viewing 1 replies (of 1 total)
  • The topic ‘[Resolved] Change comma for dot in the DB’ is closed to new replies.
Skip to toolbar