Products with Variation shows out of stock

  • Resolved Cathy

    (@cgraydbay)


    5 years, 6 months ago

    [ 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 Missy a11n

    (@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.

    Thread Starter Cathy

    (@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: –
    Thread Starter Cathy

    (@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 Missy a11n

    (@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 5 years, 6 months ago by Missy a11n.
    Thread Starter Cathy

    (@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.

    jessepearson

    (@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.

    Thread Starter Cathy

    (@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)
  • The topic ‘Products with Variation shows out of stock’ is closed to new replies.