Support » Plugin: WooCommerce » WooCommerce Status in Admin Dashboard ‘Out of Stock’ Number is Wrong

  • Resolved joyryde

    (@joyryde)


    On our WordPress dashboard, the number of Out of Stock products is always wrong. No matter how many products we change to Out of Stock, the dash always shows 3 items.

    There are no issues in our WooCommerce status report except the PHP version, our host doesn’t offer PHP 7.2 so we are on 7.1.

    When we go to PRODUCTS > ALL PRODUCTS > FILTER BY STOCK STATUS we see 35 products that are out of stock.

    When we go to our dashboard and look at the WooCommerce Status panel, we see 3.

Viewing 15 replies - 1 through 15 (of 17 total)
  • Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there!

    That’s definitely odd.

    Can you please share screenshots of the two screens you mentioned, as well as one of the product’s Inventory tab?

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status.
    Select “Get system report” and then “Copy for support”.  Once you’ve done that, paste it here in your response.

    Thanks!

    _____________________

    
    ### WordPress Environment ###
    
    Home URL: https://djdeals.com
    Site URL: https://djdeals.com
    WC Version: 3.5.1
    Log Directory Writable: ✔
    WP Version: 4.9.8
    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.1.14 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP Post Max Size: 64 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.19.7
    NSS/3.27.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.41-84.1
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.5.1
    WC Database Prefix: wp_
    MaxMind GeoIP Database: ✔
    Total Database Size: 60.16MB
    Database Data Size: 48.74MB
    Database Index Size: 11.42MB
    wp_woocommerce_sessions: Data: 1.65MB + Index: 0.06MB
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_order_items: Data: 0.07MB + Index: 0.03MB
    wp_woocommerce_order_itemmeta: Data: 0.43MB + Index: 0.31MB
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
    wp_woocommerce_tax_rate_locations: Data: 0.30MB + Index: 0.31MB
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wp_ac_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB
    wp_ac_email_templates_lite: Data: 0.01MB + Index: 0.00MB
    wp_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.01MB
    wp_ac_sent_history_lite: Data: 0.01MB + Index: 0.01MB
    wp_adtribes_my_conversions: Data: 0.00MB + Index: 0.00MB
    wp_ahm_emails: Data: 0.00MB + Index: 0.00MB
    wp_commentmeta: Data: 0.00MB + Index: 0.01MB
    wp_comments: Data: 0.28MB + Index: 0.13MB
    wp_failed_jobs: Data: 0.00MB + Index: 0.00MB
    wp_image_compression_details: Data: 0.00MB + Index: 0.00MB
    wp_image_compression_settings: Data: 0.00MB + Index: 0.00MB
    wp_links: Data: 0.00MB + Index: 0.00MB
    wp_mailchimp_carts: Data: 0.00MB + Index: 0.00MB
    wp_mclean_refs: Data: 0.24MB + Index: 0.10MB
    wp_mclean_scan: Data: 0.01MB + Index: 0.00MB
    wp_nm_personalized: Data: 0.00MB + Index: 0.00MB
    wp_options: Data: 6.02MB + Index: 0.70MB
    wp_postmeta: Data: 23.43MB + Index: 6.85MB
    wp_posts: Data: 8.41MB + Index: 0.72MB
    wp_queue: Data: 0.00MB + Index: 0.00MB
    wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB
    wp_termmeta: Data: 0.05MB + Index: 0.04MB
    wp_terms: Data: 0.03MB + Index: 0.06MB
    wp_term_relationships: Data: 0.24MB + Index: 0.49MB
    wp_term_taxonomy: Data: 0.06MB + Index: 0.04MB
    wp_usermeta: Data: 1.61MB + Index: 0.59MB
    wp_users: Data: 0.04MB + Index: 0.04MB
    wp_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    wp_wdp_orders: Data: 0.00MB + Index: 0.00MB
    wp_wdp_order_items: Data: 0.00MB + Index: 0.00MB
    wp_wdp_rules: Data: 0.00MB + Index: 0.00MB
    wp_wfBadLeechers: Data: 0.00MB + Index: 0.00MB
    wp_wfBlockedCommentLog: Data: 0.00MB + Index: 0.00MB
    wp_wfBlockedIPLog: Data: 0.00MB + Index: 0.00MB
    wp_wfBlocks: Data: 0.00MB + Index: 0.00MB
    wp_wfBlocks7: Data: 0.00MB + Index: 0.00MB
    wp_wfBlocksAdv: Data: 0.00MB + Index: 0.00MB
    wp_wfConfig: Data: 1.79MB + Index: 0.01MB
    wp_wfCrawlers: Data: 0.00MB + Index: 0.00MB
    wp_wfFileChanges: Data: 0.00MB + Index: 0.00MB
    wp_wfFileMods: Data: 0.00MB + Index: 0.00MB
    wp_wfHits: Data: 1.66MB + Index: 0.41MB
    wp_wfHoover: Data: 0.00MB + Index: 0.00MB
    wp_wfIssues: Data: 0.00MB + Index: 0.01MB
    wp_wfKnownFileList: Data: 1.94MB + Index: 0.21MB
    wp_wfLeechers: Data: 0.00MB + Index: 0.00MB
    wp_wfLiveTrafficHuman: Data: 0.01MB + Index: 0.02MB
    wp_wfLockedOut: Data: 0.00MB + Index: 0.00MB
    wp_wfLocs: Data: 0.00MB + Index: 0.00MB
    wp_wfLogins: Data: 0.12MB + Index: 0.03MB
    wp_wfNet404s: Data: 0.00MB + Index: 0.00MB
    wp_wfNotifications: Data: 0.01MB + Index: 0.00MB
    wp_wfPendingIssues: Data: 0.00MB + Index: 0.00MB
    wp_wfReverseCache: Data: 0.00MB + Index: 0.00MB
    wp_wfScanners: Data: 0.00MB + Index: 0.00MB
    wp_wfSNIPCache: Data: 0.00MB + Index: 0.00MB
    wp_wfStatus: Data: 0.06MB + Index: 0.04MB
    wp_wfThrottleLog: Data: 0.00MB + Index: 0.00MB
    wp_wfTrafficRates: Data: 0.10MB + Index: 0.08MB
    wp_wfVulnScanners: Data: 0.00MB + Index: 0.00MB
    wp_yoast_seo_links: Data: 0.03MB + Index: 0.01MB
    wp_yoast_seo_meta: Data: 0.09MB + Index: 0.09MB
    
    ### Post Type Counts ###
    
    attachment: 3482
    custom_css: 3
    customize_changeset: 64
    feedback: 3
    mc4wp-form: 1
    nav_menu_item: 16
    oembed_cache: 7
    page: 19
    post: 3
    product: 2890
    product_variation: 154
    revision: 64
    shop_coupon: 5
    shop_order: 408
    shop_order_refund: 119
    turbo-sidebar-cpt: 1
    yith_best_price: 6
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (49) ###
    
    CloudFlare Flexible SSL: by iControlWP – 1.2.2
    404page - your smart custom 404 error page: by Peter Raschendorfer – 7
    Advanced Database Cleaner: by Younes JFR. – 2.0.0
    Advanced Dynamic Pricing for WooCommerce: by AlgolPlus – 1.5.0 – Not tested with the active version of WooCommerce
    Attachment Pages Redirect: by Samuel Aguilera – 1.1
    Better Search Replace: by Delicious Brains – 1.3.2
    CloudFlare: by LittleBizzy – 1.4.0
    CMB2: by CMB2 team – 2.4.2
    Custom Related Products for WooCommerce: by Scott Nelle – 1.3 – Not tested with the active version of WooCommerce
    Customer Reviews for WooCommerce: by ivole – 3.47 – Not tested with the active version of WooCommerce
    Disable Cart Fragments: by LittleBizzy – 1.3.0 – Not tested with the active version of WooCommerce
    Disable XML-RPC Pingback: by Samuel Aguilera – 1.1
    WooCommerce Discontinued Products: by Leon @ 211J – 1.1.3 – Not tested with the active version of WooCommerce
    Easy Theme and Plugin Upgrades: by Chris Jean – 2.0.1
    Google Customer Reviews for WooCommerce: by eCreations – 2.6.8 – Not tested with the active version of WooCommerce
    Enhanced E-commerce for Woocommerce store: by Tatvic – 2.1.4 – Not tested with the active version of WooCommerce
    Force HTTPS: by LittleBizzy – 1.2.0
    Jetpack by WordPress.com: by Automattic – 6.7
    Kirki Toolkit: by Aristeides Stathopoulos – 3.0.34.1
    Loco Translate: by Tim Whitlock – 2.2.0
    MailChimp for WordPress: by ibericode – 4.2.5
    Paste as Plain Text: by Till Krüss – 1.0.1
    PayPal for WooCommerce: by Angell EYE – 1.5.3 – Not tested with the active version of WooCommerce
    Perfect WooCommerce Brands: by Alberto de Vera Sevilla – 1.6.5 – Not tested with the active version of WooCommerce
    PW WooCommerce Bulk Edit: by Pimwick
    LLC – 2.53 – Not tested with the active version of WooCommerce
    
    PW WooCommerce Exclude Free Shipping: by Pimwick
    LLC – 1.8 – Not tested with the active version of WooCommerce
    
    Seo 301 Meta: by Mian Shahzeb – 1.6
    Term Management Tools: by scribu – 1.1.4
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.15.3
    
    UPS (BASIC) WooCommerce Shipping: by PluginHive – 1.2.14 – Not tested with the active version of WooCommerce
    WooCommerce Waitlist: by XootiX – 1.4 – Not tested with the active version of WooCommerce
    Premmerce WooCommerce Customers Manager: by premmerce – 1.1.8 – Not tested with the active version of WooCommerce
    WooCommerce Product Feed PRO: by AdTribes.io – 3.8.6 – Not tested with the active version of WooCommerce
    Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 5.1.1 – Not tested with the active version of WooCommerce
    WooCommerce Checkout Add-Ons: by SkyVerge – 1.12.5 – 1.12.6 is available – Not tested with the active version of WooCommerce
    WooCommerce Stripe Gateway: by WooCommerce – 4.1.13 – Not tested with the active version of WooCommerce
    WooCommerce AdWords Conversion Tracking: by Wolf+Bär Agency – 1.4.12 – Not tested with the active version of WooCommerce
    Booster for WooCommerce: by Algoritmika Ltd – 4.0.1 – Not tested with the active version of WooCommerce
    WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.2.4 – Not tested with the active version of WooCommerce
    WooCommerce Shipping Tracking: by Lagudi Domenico – 15.2 – Not tested with the active version of WooCommerce
    WooCommerce: by Automattic – 3.5.1
    Wordfence Security: by Wordfence – 7.1.17
    Yoast SEO: by Team Yoast – 9.2.1
    Smush: by WPMU DEV – 2.9.1
    WPO Tweaks: by Fernando Tellado – 0.9.14
    
    ### 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)
    
    ### WC Pages ###
    
    Shop base: #8409 - /product-categories/
    Cart: #6 - /cart/
    Checkout: #7 - /checkout/
    My account: #8 - /my-account/
    Terms and conditions: #8792 - /djdeals-com-terms-conditions/
    
    ### Theme ###
    
    Name: Universal Store
    Version: 1.0.4
    Author URL: https://themes4wp.com/
    Child Theme: ✔
    Parent Theme Name: MaxStore
    Parent Theme Version: 1.5.0
    Parent Theme Author URL: https://themes4wp.com
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Archive Template: Your theme has a woocommerce.php file
    you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.
    
    Overrides: –
    

    Disabled Woocommerce and all other plugins, re-enabled, still wrong.

    Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there,

    Can you please also share screenshots of the two screens?

    I recommend https://snag.gy for easily sharing screenshots – please follow the instructions on the page, then paste the URL in your response. It works with Chrome, Firefox and IE.

    Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    Okay, so the problem is that the total number of products shown in WP-Admin > Products doesn’t match the widget that you’re seeing on the dashboard. Is that correct?

    If so, that’s because the widget isn’t showing the total number of products, just the number of products that are low in stock.

    Hi, please refer to the original post. Out of stock items on dashboard report and inside WooCommerce reports, is always wrong. 40 products are out of stock, both WooCommerce reports state 3.

    Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    Thanks for the correction!

    The only thing that I can think of that could be causing this is caching. However, I’m not seeing any caching plugins on your site. Your next step is to reach out to your host and ask that they (temporarily) disable caching on your site.

    If that doesn’t solve it, the next step would be to log into your site to see what’s going on – that’s out of the scope of support for the forums. If you need more help with this, I highly recommend contacting one of the services on our customizations page: https://woocommerce.com/customizations/

    Hi,

    We only use Cloudflare for caching and the cache is cleared daily because we work 10-12 hours per day on the site and have to clear it after working on it. There is no caching at the host level.

    Hi there

    I have the same exact problem. Out of nowhere the dash widget says there are 50+ items out of stock, yet I never had stock management and still none of the products or variants have stock management turned on. None of the products have ever had a stock number added.

    Cheers
    Chris

    Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    @ckhatton This actually sounds like quite a different problem:

    Out of nowhere the dash widget says there are 50+ items out of stock, yet I never had stock management and still none of the products or variants have stock management turned on. None of the products have ever had a stock number added.

    Could you please create your own thread, so we can troubleshoot this separately? Thanks!

    Hi, how was this resolved? I’m having the same issue.

    @joset173 It was never solved in the end. It also seem to be a common bug. It seems the products become marked as “out of stock” for no reason.

    @fernashes I have now created a new ticket… https://wordpress.org/support/topic/woocommerce-status-in-admin-dashboard-out-of-stock-number-is-wrong-2/

    Thank you
    Chris

    Hi there

    I have the same exact problem. Out of nowhere the dash widget says there are 63 items out of stock, yet I never had stock management and still, none of the products or variants have stock management turned on. None of the products have ever had a stock number added.

    Dev1

    Is there any movement on this?? This definitely isn’t solved!

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘WooCommerce Status in Admin Dashboard ‘Out of Stock’ Number is Wrong’ is closed to new replies.