WordPress.org

Ready to get started?Download WordPress

Forums

WooCommerce - excelling eCommerce
[resolved] Change comma for dot in the DB (2 posts)

  1. Joan Boluda
    Member
    Posted 11 months ago #

    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/

  2. Joan Boluda
    Member
    Posted 11 months ago #

    Never mind, found it:

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

    Easy as pie.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.