Support » Plugin: WooCommerce » bulk edit price not working

  • Resolved funstix



    I am using the bulk edit feature to change product pricing. After making the change and updating the editor indicates the products have updated but the price itself remains the same and does not change. I tried it for sale items also with the same result.

    I also hanged an item to a single category, it kept the original categories and added the new instead of just picking up the single category I selected.

    I have gone to my staging site and unplugged all other plugins, cleared the browser and server cache and get the same result. Just doesn’t want to update even though it says it has.

    Not sure if this is the right place to be placing this problem but hope someone can shed some light.

    Cheers and thanks in advance

    I have attached the system status report.

    ### WordPress Environment ###
    Home URL:
    Site URL:
    WC Version: 3.2.4
    Log Directory Writable: ✔
    WP Version: 4.9
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_AU
    ### Server Environment ###
    Server Info: Apache
    PHP Version: 7.0.25
    PHP Post Max Size: 128 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    cURL Version: 7.53.0
    SUHOSIN Installed: –
    MySQL Version: 5.6.36
    Max Upload Size: 128 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    ### Database ###
    WC Database Version: 3.2.4
    WC Database Prefix: wp_280rq7wn54_
    MaxMind GeoIP Database: ✔
    Total Database Size: 30.07MB
    Database Data Size: 25.11MB
    Database Index Size: 4.96MB
    wp_280rq7wn54_woocommerce_sessions: Data: 0.04MB + Index: 0.00MB
    wp_280rq7wn54_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB
    wp_280rq7wn54_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_commentmeta: Data: 2.17MB + Index: 0.03MB
    wp_280rq7wn54_comments: Data: 0.03MB + Index: 0.02MB
    wp_280rq7wn54_et_bloom_stats: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_et_social_stats: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_ewwwio_images: Data: 1.11MB + Index: 0.38MB
    wp_280rq7wn54_failed_jobs: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_coupons: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_followup_coupon_logs: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_customers: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_followup_customer_carts: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_followup_customer_notes: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_customer_orders: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_email_coupons: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_email_excludes: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_email_logs: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_followup_email_orders: Data: 0.04MB + Index: 0.01MB
    wp_280rq7wn54_followup_email_order_coupons: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_email_tracking: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_followup_followup_history: Data: 0.11MB + Index: 0.00MB
    wp_280rq7wn54_followup_order_categories: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_order_items: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_subscribers: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_subscribers_to_lists: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_followup_subscriber_lists: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_links: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_mailchimp_carts: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_metaseo_images: Data: 0.02MB + Index: 0.00MB
    wp_280rq7wn54_options: Data: 3.48MB + Index: 0.14MB
    wp_280rq7wn54_postmeta: Data: 5.82MB + Index: 3.53MB
    wp_280rq7wn54_posts: Data: 11.72MB + Index: 0.45MB
    wp_280rq7wn54_queue: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_redirection_404: Data: 0.02MB + Index: 0.02MB
    wp_280rq7wn54_redirection_groups: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_redirection_items: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_redirection_logs: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_sg_fblike_popup: Data: 0.02MB + Index: 0.00MB
    wp_280rq7wn54_sg_html_popup: Data: 0.06MB + Index: 0.00MB
    wp_280rq7wn54_sg_image_popup: Data: 0.02MB + Index: 0.00MB
    wp_280rq7wn54_sg_popup: Data: 0.11MB + Index: 0.00MB
    wp_280rq7wn54_sg_popup_addons: Data: 0.02MB + Index: 0.02MB
    wp_280rq7wn54_sg_popup_addons_connection: Data: 0.02MB + Index: 0.00MB
    wp_280rq7wn54_sg_popup_settings: Data: 0.02MB + Index: 0.00MB
    wp_280rq7wn54_sg_shortCode_popup: Data: 0.02MB + Index: 0.00MB
    wp_280rq7wn54_termmeta: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_terms: Data: 0.03MB + Index: 0.06MB
    wp_280rq7wn54_term_relationships: Data: 0.03MB + Index: 0.05MB
    wp_280rq7wn54_term_taxonomy: Data: 0.03MB + Index: 0.04MB
    wp_280rq7wn54_usermeta: Data: 0.03MB + Index: 0.02MB
    wp_280rq7wn54_users: Data: 0.00MB + Index: 0.01MB
    wp_280rq7wn54_wpex_stats: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_wpex_titles: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_wpms_links: Data: 0.09MB + Index: 0.01MB
    wp_280rq7wn54_wrd_discounts: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_wrd_sent_coupons: Data: 0.00MB + Index: 0.00MB
    wp_280rq7wn54_yoast_seo_links: Data: 0.03MB + Index: 0.01MB
    wp_280rq7wn54_yoast_seo_meta: Data: 0.00MB + Index: 0.01MB
    ### Post Type Counts ###
    attachment: 660
    custom_css: 3
    et_pb_layout: 77
    follow_up_email: 25
    inc_popup: 1
    mts_notification_bar: 4
    nav_menu_item: 29
    page: 26
    post: 2
    postman_sent_mail: 23
    product: 69
    product_variation: 3920
    project: 1
    revision: 902
    scheduled-action: 52
    schema: 2
    shop_coupon: 7
    shop_order: 15
    shop_webhook: 4
    wcps: 2
    woocarousel: 1
    yith_wcps_type: 3
    ### Security ###
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    ### Active Plugins (1) ###
    WooCommerce: by Automattic – 3.2.4
    ### Settings ###
    API Enabled: ✔
    Force SSL: ✔
    Currency: USD (USD $)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    ### WC Pages ###
    Shop base: #31188 - /shop/
    Cart: #29405 - /basket/
    Checkout: #29406 - /checkout/
    My account: #29407 - /my-account/
    Terms and conditions: #29016 - /terms-of-service/
    ### Theme ###
    Name: Child Theme for Divi
    Version: 3.0.41
    Author URL:
    Child Theme: ✔
    Parent Theme Name: Divi
    Parent Theme Version: 3.0.89
    Parent Theme Author URL:
    WooCommerce Support: ✔
    ### Templates ###
    Overrides: –

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support RK


    It might be theme related as well – are you seeing the same thing when switching to the default Twenty Seventeen theme?

    Also, just to make sure, are you using the bulk edit tool found under Products > All Products by selecting all your products and then choosing “Edit”?

    Thanks for the reply, I appreciate it.

    I have just tried that idea of 2017 but no, the same result. Says the products are updated but the price does not change.

    The first screenshot shows 2 products and I’m changing the price to $21 the 2nd shows the products have been updated but you can see the price has not changed. It is the two yellow shirts both reading 25 when should now show 21.

    Unless I’m doing something wrong, any idea of what I could try next?

    Oh, there was a Woocommerce Update that I have just tested on my production site but no change.

    Cheers and Thanks

    Same issue here as well. Using a custom theme. This needs to be fixed fast. were about to push through the Black Friday discounts…

    • This reply was modified 2 years, 1 month ago by compupower.

    Hi, managed to solve the problem. For us, we encountered the problem for the sale price.

    I’ll tell you how we fixed the bug (if I may call it one) for the discount price, surely you’ll find a way to mould it into a suitable fix for the regular price.

    First, I looked into the server error log which gave this error in particular:
    Got error 'PHP message: PHP Warning: A non-numeric value encountered in /home/xx/domains/xx.xx/public_html/wp-content/plugins/woocommerce/includes/admin/class-wc-admin-post-types.php on line 1206

    So I looked up line 1206 in /wp-content/plugins/woocommerce/includes/admin/class-wc-admin-post-types.php.

    The problem is that the variable (in the discount price’s case) wasn’t a number/integer, so what I did was to pre-define the variable first, like so:
    $new_price = 0;

    The altered code looks like this:

    case 3 :
    						if ( strstr( $sale_price, '%' ) ) {
    							$percent = str_replace( '%', '', $sale_price ) / 100;
    							$new_price = 0;
    							$new_price = max( 0, $old_sale_price - ( $old_sale_price * $percent ) );
    						} else {
    							$new_price = max( 0, $old_sale_price - $sale_price );

    Note that by editing the WooCommerce core files you risk breaking other elements of the code when done improperly. Also, the edits you make will be overridden when when updating the plugin.

    Have a nice evening, good luck with BFCM ’17!

    Hey mate thanks for the reply and a possible lead to a solution. I don’t think I’m going to have time now before BFCM to implement it. I have a workaround, lengthy but nonetheless something.

    I will take a closer look at what you’ve done and test it on my staging site. I’m glad someone else at least had a similar experience. I’m just not sure why Woocommerce can’t fix the problem.

    Good luck with your BFCM too.

    I’m leaving this open in the hope someone has further information to offer.


    Plugin Support dougaitken


    Automattic Happiness Engineer

    Hi @funstix

    Were you able to get this sorted?

    If you’re still having trouble with this, can you upload a CSV of a few products I can use to test this with please, then let me know the details you’re wanting to change; detail out the steps you have taken.




    We haven’t heard back from you in a while, so I’m going to mark this as resolved. If you have any further questions, you can start a new thread.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘bulk edit price not working’ is closed to new replies.