• Resolved ayakish

    (@ayakish)


    We’re having an issue after a server, core and plugin update where some orders or coming through without the variation data and the customer is being charged the system default price. We suspect front-end caching (we were using a caching service), but this is weeks later and it’s still impacting 1-2% of orders.

    -On wp_posts and wp_postmeta tables everything looks good for both cases. (On this table usually is general info about the order: payment_info,address,name etc)
    -On wp_woocommerce_order_items also everything looks good. (On this table there is a reference of order_id. Also this table contains all the names of products on the order)
    Example : 724573 NAME Purple Nitrile Exam Gloves – Medium, Box of 100 line_item 9296466

    – On table wp_woocommerce_order_itemmeta I do see the problem. In the broken order some of the fields of this table are not set. In this example I do see _variation_id set to 0 also _wc_cog_item_cost is set to 0.
    – In all the cases that the order is broken the _variation_id is set to 0.

    So we do prove it on the db level. I am still working on trying to find out why sometimes this values are not set, but the other values on that specific meta are, for example pa_amount, size-color etc.

    This started after we did the following upgrades :
    The web server we are using is nginx
    Ubuntu 16.04.4 LTS

    This started after :
    Server patching Ubuntu 16.04.4 LTS
    Upgrading from php7.1-fpm to php7.4-fpm
    Full wp and woocommerce (versions) and plugins upgrade.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi @ayakish,

    If you’ll update WooCommerce to the latest version, that should fix this issue for you. There was a recent bug that has been fixed that allowed customers to purchase the parent product in a variable product. It happened most often when a user added the item to the cart before all of the JavaScript loaded or if there was a problem with the JavaScript on the product page.

    The current version of WooCommerce has a fix for this that should prevent it from happening in the future.

    If you still have trouble after updating, please let us know.

    Cheers

    Plugin Support mouli a11n

    (@mouli)

    It’s been a while since we heard from you, so I’m marking this thread resolved. Hopefully, you’ve been able to resolve this, but if you haven’t, please open up a new topic and we’ll be happy to help out.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘_variation_id set to 0’ is closed to new replies.