Support » Plugin: WooCommerce » Products with Variation shows out of stock

  • Resolved crgrayaz

    (@cgraydbay)


    [ WooCommerce v 3.7.0, Product Add-ons v 2.8.1 ]

    2 of my 47 Products (all with Variations) show out of stock and shouldn’t.
    *****
    Update – I NOW see that all of my (variable) products have been affected. When I simply ‘Edit Product’, any product, I now get the new ‘out of stock’ indication. (I was editing products to improve SEO (based on Yoast SEO Premium’s indicators), to go from orange to green, using focus keyphrase more frequently within my product verbiage.)
    *********
    Background:
    Shows red type ‘Out of stock’; this not on my site but on the WordPress dashboard’s “ALL PRODUCTS” page where they are all listed (name, SKU, stock, price, etc.). Each of my 47 products has 372 variations! (“Package” ie -std size or not, “Shipping” ie -digital file ie no cost, or not; and “Quantity” many options ie for discount pricing)

    I have read several threads, closed now, evidently, and based on those suggestions/comments:

    -I do NOT have ‘Manage stock’ checked under the main variable product or its children, all of the variations. Rather – I have checked “Sold individually, “Enable this to only allow one of this item to be bought in a single order” but all my products are checked in this manner.
    -All of my products have pictures associated with them.
    -The ‘stock status’ within all the children/variations (of the one product (of 2) in question)) reads ‘in stock’ (I didn’t sample all 372 but did a random sampling of maybe 20)
    And additionally, variations have prices associated with them.

    (ALSO – I created a test order with one of these products and it went through to completion?) What else might I try?
    Thank in advance.

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

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

    (@m155y5)

    Automattic Happiness Engineer

    Hi @cgraydbay

    There are a number of things that could have gone haywire here. There’s a pretty lengthy github issue on this subject. I believe the suggestions toward the bottom of the discussion might be the most useful for you.

    Additionally, if you can please share your System Status Report, that will help us further troubleshoot. You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, you can paste it into your reply here.

    crgrayaz

    (@cgraydbay)

    Thank you, I was on vacation, now ready to get back to this. While I go to that link you provided, here is that Status report:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://lifeinspires.com
    Site address (URL): https://lifeinspires.com
    WC Version: 3.7.0
    REST API Version: ✔ 1.0.2
    Log Directory Writable: ✔
    WP Version: 5.2.2
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.3.8
    PHP Post Max Size: 260 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.65.3
    OpenSSL/1.0.2s
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.23-23
    Max Upload Size: 256 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.5.7
    WC Database Prefix: wp_
    MaxMind GeoIP Database: ✔
    Total Database Size: 59.92MB
    Database Data Size: 37.94MB
    Database Index Size: 21.98MB
    wp_woocommerce_sessions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 0.10MB + Index: 0.04MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_cntctfrm_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_comments: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
    wp_layerslider: Data: 0.07MB + Index: 0.00MB + Engine MyISAM
    wp_layerslider_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_options: Data: 1.92MB + Index: 0.09MB + Engine MyISAM
    wp_postmeta: Data: 22.88MB + Index: 17.61MB + Engine MyISAM
    wp_posts: Data: 6.97MB + Index: 3.00MB + Engine MyISAM
    wp_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_terms: Data: 0.03MB + Index: 0.07MB + Engine MyISAM
    wp_term_relationships: Data: 0.07MB + Index: 0.15MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
    wp_usermeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
    wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfBlockedIPLog: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfConfig: Data: 1.47MB + Index: 0.01MB + Engine MyISAM
    wp_wfCrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfFileMods: Data: 2.19MB + Index: 0.46MB + Engine MyISAM
    wp_wfHits: Data: 0.61MB + Index: 0.04MB + Engine MyISAM
    wp_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfIssues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wfKnownFileList: Data: 1.13MB + Index: 0.14MB + Engine MyISAM
    wp_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfLocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfLogins: Data: 0.05MB + Index: 0.02MB + Engine MyISAM
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfNotifications: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
    wp_wfPendingIssues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wfReverseCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfStatus: Data: 0.14MB + Index: 0.06MB + Engine MyISAM
    wp_wfTrafficRates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_yoast_seo_links: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
    wp_yoast_seo_meta: Data: 0.06MB + Index: 0.06MB + Engine MyISAM
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (13) ###
    
    Share Buttons by AddThis: by The AddThis Team – 6.2.6
    BackWPup: by Inpsyde GmbH – 3.6.10
    Classic Editor: by WordPress Contributors – 1.5
    Contact Form by BestWebSoft: by BestWebSoft – 4.1.5
    Easy HTTPS (SSL) Redirection: by Tips and Tricks HQ – 1.9
    PayPal Sandbox IPN Tester: by WooThemes – 1.0.0
    PW WooCommerce Bulk Edit Pro: by Pimwick
    LLC – 2.201
    
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.1
    Typekit Fonts for WordPress: by OM4 – 1.9.0
    WooCommerce Product Add-ons: by WooCommerce – 3.0.14
    WooCommerce: by Automattic – 3.7.0
    Wordfence Security: by Wordfence – 7.3.6
    Yoast SEO Premium: by Team Yoast – 11.9
    
    ### Inactive Plugins (1) ###
    
    WooCommerce Helper: by WooCommerce – 1.7.2 – Not tested with the active version of WooCommerce – Network enabled
    
    ### Must Use Plugins (2) ###
    
    Endurance Browser Cache: by Mike Hansen – 0.4
    Endurance Page Cache: by Mike Hansen – 1.5
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: 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)
    
    Connected to WooCommerce.com: ✔
    
    ### WC Pages ###
    
    Shop base: #10 - /shop/
    Cart: #11 - /cart/
    Checkout: #12 - /checkout/
    My account: #13 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Enfold
    Version: 4.4
    Author URL: https://kriesi.at
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 4
    Oldest: 2019-08-03 02:06:21 +0000
    Newest: 2019-08-24 02:55:06 +0000
    
    Pending: 1
    Oldest: 2019-08-31 02:55:06 +0000
    Newest: 2019-08-31 02:55:06 +0000
    
    Canceled: 0
    Oldest: –
    Newest: –
    
    In-progress: 0
    Oldest: –
    Newest: –
    
    Failed: 0
    Oldest: –
    Newest: –
    
    
    crgrayaz

    (@cgraydbay)

    I have found something that works for me, after reading though (“lengthy github issue on this subject”: https://github.com/woocommerce/woocommerce/issues/16620

    FIX – 2 steps:
    1.
    Edit the product
    Go to one of the variations (the first one should do) << That’s what I did, as I have 372 variations for each of my variable products!!)
    Check the “Manage Stock?” option
    Save changes on the variations button
    Update the product on the main button, to the right (just in case some variables or scripts aren’t loading correctly)
    Go to the same variation you edited on step 2
    Uncheck the “Manage Stock?” option
    Save changes on the variations button

    THEN:
    2.
    Change ‘Stock Status’ to ‘in stock’ manually for that same variation for this product. (and only that one variation – thankfully was enough)

    The product now has changed from ‘out of stock’ to ‘in stock’. Like someone else said…Let’s hope it stays this way.

    Plugin Support m155y5

    (@m155y5)

    Automattic Happiness Engineer

    @cgraydbay – Wow! That’s fantastic that fix worked for you (for now)! Please keep us posted on whether it stays that way!

    • This reply was modified 6 months ago by m155y5.
    crgrayaz

    (@cgraydbay)

    I’m curious…it seems that status report I sent gives my general environment info, plugins, etc. Do you know if that will still be helpful, utilized for troubleshooting/debugging, and then used in conjunction with similar info provided by other users, hopefully lead to a new updated version that would cover this issue, yes? I’d hope to anticipate that. Until then I will definitely be keeping an eye out.

    Plugin Support Jesse Pearson

    (@jessepearson)

    Automattic Happiness Engineer

    @cgraydbay What I notice in your System Status Report is that your WC version is 3.7.0 and your WC database version is 3.5.7, which is most likely the culprit here. If you have not yet updated your database, there is a tool under WooCommerce > Status > Tools to update the database. Once that’s done, there’s one to regenerate the product lookup tables, we suggest doing that next.

    crgrayaz

    (@cgraydbay)

    Thank you. But in the time since, after I fixed the issues as I described above, my site was hacked. My tech guys had to restore & their work included reconciling the versions to 3.7.0 (as you suggest). Then I had to re-do those fixes. All is fine still/again (all is ‘In stock’) since then, so I hesitate to do anything else at this point. Still, I will make a note of your suggestion, to attempt if/when needed down the road. Thank you.

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.