need some help with a database syntax to clear a column

  • Resolved atechstl

    (@atechstl)


    7 years, 10 months ago

    Essentially I paid hundreds of dollars for a cart to cart migration to migrate cubecart to WooCommerce. I did a full migration with migration insurance. All looked good but I cleared the data and migrated just the customers and orders then went live. I thought all was good however it wasn’t. Customer nicknames, billing and shipping addresses are all pointing to different customers. Several new orders have been taken by new and existing customers. The best thing to do is to clear the database entries and let the customers fill them back in. The cart2cart migration team wanted to clear the data and perform a new migration which can’t happen. Those guys only answer one time in 24 hours and by them asking a simple question you are put off for 24 hours. At least all the products are moved over.

    In the table usermeta there are the below entries for meta_key. For each of the below entries in the meta_key column I need to clear the value of item in the meta_value column. Example In table usermeta in column where meta_key = nickname, clear meta_value data. I just don’t know how to write the Syntax. Any help?

    nickname
    billing_first_name
    billing_last_name
    billing_company
    billing_address_1
    billing_address_2
    billing_city
    billing_postcode
    billing_state
    billing_country
    billing_phone
    billing_email
    shipping_first_name
    shipping_last_name
    shipping_company
    shipping_address_1
    shipping_address_2
    shipping_city
    shipping_postcode
    shipping_state
    shipping_country

    https://wordpress.org/plugins/woocommerce/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Claudio Sanches

    (@claudiosanches)

    7 years, 10 months ago

    Help you broke your database? For sure I can help 😛
    Just kidding, but please backup it before xD

    It’s easy to do this, simply run the following query (and make sure about the usermeta table name is wp_usermeta or if need to change):

    UPDATE wp_usermeta SET meta_value='' WHERE meta_key IN ('nickname', 'billing_first_name', 'billing_last_name', 'billing_company', 'billing_address_1', 'billing_address_2', 'billing_city', 'billing_postcode', 'billing_state', 'billing_country', 'billing_phone', 'billing_email', 'shipping_first_name', 'shipping_last_name', 'shipping_company', 'shipping_address_1', 'shipping_address_2', 'shipping_city', 'shipping_postcode', 'shipping_state', 'shipping_country')
    Thread Starter atechstl

    (@atechstl)

    7 years, 10 months ago

    HA! Thank you that was exactly the command I needed. It worked as expected.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘need some help with a database syntax to clear a column’ is closed to new replies.

Tags