Support » Plugin: WooCommerce » Problem with Stock Status

  • Resolved wnstr

    (@wnstr)


    Hello,

    i have a problem with the stock status of my products. If i update the Stock of a normal or variable Product to any number , for example 10 and then a costumer place an order with this Product, the Stock Amount is reduced to 1 not to 9.

    The problem came without installing a plugin or something. It appears about 4 days ago.

    Can anyone help?

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Zach W

    (@dynamiczach)

    Automattic Happiness Engineer

    Howdy!

    The first two things you’ll want to look for is available updates to WooCommerce (which should be at version 3.6.4), the WooCommerce Database (which should match version 3.6.4), and WordPress (version 5.2.1).

    If those are all updated, I would also recommend checking for caching issues. If you have a caching plugin or have server-side caching setup, try disabling that, then testing the inventory again.

    We’ve also seen similar issues like this when there is a POS/Inventory sync option being used.

    If updating and checking caching doesn’t help, and you don’t have any inventory syncing going on in your store, could you 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!

    Hello Zach,

    thank you for your quick reply!

    The System Versions are all correct and up to date.
    I use the WP Rocket caching plugin and deactivate it now. I test the inventory with a few orders and it works fine.

    But i did the same test yesterday with the Plugin and it doesn’t work. Don’t know what the difference is now.

    Here is my Systemreport, maybe you find anything:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.wnstr.de
    Site address (URL): https://www.wnstr.de
    WC Version: 3.6.4
    Log Directory Writable: ✔
    WP Version: 5.2.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: de_DE
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.3.2
    PHP Post Max Size: 129 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.29.0
    NSS/3.36
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.60-MariaDB
    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.6.4
    WC Database Prefix: wp_
    MaxMind GeoIP Database: ✔
    Datenbank-Gesamtgröße: 256.48MB
    Datenbank-Datengröße: 140.68MB
    Datenbank-Indexgröße: 115.80MB
    wp_woocommerce_sessions: Daten: 5.02MB + Index: 0.11MB
    wp_woocommerce_api_keys: Daten: 0.02MB + Index: 0.03MB
    wp_woocommerce_attribute_taxonomies: Daten: 0.02MB + Index: 0.02MB
    wp_woocommerce_downloadable_product_permissions: Daten: 0.02MB + Index: 0.06MB
    wp_woocommerce_order_items: Daten: 2.52MB + Index: 1.44MB
    wp_woocommerce_order_itemmeta: Daten: 20.55MB + Index: 24.06MB
    wp_woocommerce_tax_rates: Daten: 0.02MB + Index: 0.06MB
    wp_woocommerce_tax_rate_locations: Daten: 0.02MB + Index: 0.03MB
    wp_woocommerce_shipping_zones: Daten: 0.02MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations: Daten: 0.02MB + Index: 0.03MB
    wp_woocommerce_shipping_zone_methods: Daten: 0.02MB + Index: 0.00MB
    wp_woocommerce_payment_tokens: Daten: 0.02MB + Index: 0.02MB
    wp_woocommerce_payment_tokenmeta: Daten: 0.02MB + Index: 0.03MB
    wp_woocommerce_log: Daten: 0.02MB + Index: 0.02MB
    wp_aiowps_events: Daten: 0.02MB + Index: 0.00MB
    wp_aiowps_failed_logins: Daten: 0.02MB + Index: 0.00MB
    wp_aiowps_global_meta: Daten: 0.02MB + Index: 0.00MB
    wp_aiowps_login_activity: Daten: 0.02MB + Index: 0.00MB
    wp_aiowps_login_lockdown: Daten: 0.02MB + Index: 0.00MB
    wp_aiowps_permanent_block: Daten: 0.02MB + Index: 0.00MB
    wp_atum_order_itemmeta: Daten: 0.02MB + Index: 0.03MB
    wp_atum_order_items: Daten: 0.02MB + Index: 0.02MB
    wp_atum_product_data: Daten: 0.06MB + Index: 0.05MB
    wp_borlabs_cookie_blocked_content_types: Daten: 0.02MB + Index: 0.02MB
    wp_borlabs_cookie_log: Daten: 6.52MB + Index: 14.09MB
    wp_commentmeta: Daten: 0.22MB + Index: 0.23MB
    wp_comments: Daten: 20.55MB + Index: 20.06MB
    wp_failed_jobs: Daten: 0.02MB + Index: 0.00MB
    wp_links: Daten: 0.02MB + Index: 0.02MB
    wp_mailchimp_carts: Daten: 1.02MB + Index: 0.00MB
    wp_options: Daten: 5.02MB + Index: 0.31MB
    wp_postmeta: Daten: 49.41MB + Index: 41.61MB
    wp_posts: Daten: 18.20MB + Index: 7.67MB
    wp_queue: Daten: 0.02MB + Index: 0.00MB
    wp_revslider_css: Daten: 0.13MB + Index: 0.00MB
    wp_revslider_layer_animations: Daten: 0.02MB + Index: 0.00MB
    wp_revslider_navigations: Daten: 0.02MB + Index: 0.00MB
    wp_revslider_sliders: Daten: 0.08MB + Index: 0.00MB
    wp_revslider_slides: Daten: 1.33MB + Index: 0.00MB
    wp_revslider_static_slides: Daten: 0.02MB + Index: 0.00MB
    wp_termmeta: Daten: 0.02MB + Index: 0.03MB
    wp_terms: Daten: 0.02MB + Index: 0.03MB
    wp_term_relationships: Daten: 1.50MB + Index: 0.42MB
    wp_term_taxonomy: Daten: 0.05MB + Index: 0.03MB
    wp_usermeta: Daten: 2.47MB + Index: 2.84MB
    wp_users: Daten: 0.11MB + Index: 0.08MB
    wp_wc_admin_notes: Daten: 0.02MB + Index: 0.00MB
    wp_wc_admin_note_actions: Daten: 0.02MB + Index: 0.02MB
    wp_wc_customer_lookup: Daten: 0.30MB + Index: 0.23MB
    wp_wc_download_log: Daten: 0.02MB + Index: 0.03MB
    wp_wc_order_coupon_lookup: Daten: 0.02MB + Index: 0.03MB
    wp_wc_order_product_lookup: Daten: 2.52MB + Index: 1.16MB
    wp_wc_order_stats: Daten: 1.52MB + Index: 0.39MB
    wp_wc_order_tax_lookup: Daten: 0.31MB + Index: 0.23MB
    wp_wc_product_meta_lookup: Daten: 0.09MB + Index: 0.13MB
    wp_wc_webhooks: Daten: 0.02MB + Index: 0.02MB
    wp_wpgmza: Daten: 0.02MB + Index: 0.00MB
    wp_wpgmza_categories: Daten: 0.02MB + Index: 0.00MB
    wp_wpgmza_category_maps: Daten: 0.02MB + Index: 0.00MB
    wp_wpgmza_circles: Daten: 0.02MB + Index: 0.00MB
    wp_wpgmza_maps: Daten: 0.02MB + Index: 0.00MB
    wp_wpgmza_polygon: Daten: 0.02MB + Index: 0.00MB
    wp_wpgmza_polylines: Daten: 0.02MB + Index: 0.00MB
    wp_wpgmza_rectangles: Daten: 0.02MB + Index: 0.00MB
    wp_wpmelon_advbedit_temp: Daten: 0.02MB + Index: 0.00MB
    wp_yith_wcwl: Daten: 0.02MB + Index: 0.02MB
    wp_yith_wcwl_lists: Daten: 0.02MB + Index: 0.03MB
    wp_yoast_seo_links: Daten: 0.17MB + Index: 0.06MB
    wp_yoast_seo_meta: Daten: 0.13MB + Index: 0.00MB
    
    ### Post Type Counts ###
    
    _op_register: 1
    _op_warehouse: 4
    ahashop_mega_menu: 1
    attachment: 537
    blocks: 8
    chart: 9
    custom_css: 5
    customer_groups: 2
    cwginstocknotifier: 296
    etheme_portfolio: 6
    featured_item: 8
    im_voucher: 67
    im_voucher_template: 1
    mc4wp-form: 3
    nav_menu_item: 55
    page: 23
    post: 9
    product: 175
    product_variation: 464
    revision: 1
    scheduled-action: 16093
    shop_coupon: 55
    shop_order: 6558
    shop_order_refund: 364
    staticblocks: 3
    stores: 1
    testimonials: 3
    whatsapp-accounts: 1
    wpcf7_contact_form: 8
    wpmm_theme: 3
    yith-wcbm-badge: 4
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (38) ###
    
    PW Advanced Woo Reporting: von Proword – 4.8 – Nicht getestest mit der aktiven WooCommerce-Version
    Advanced Database Cleaner: von Younes JFR. – 2.0.0
    B2B Market: von MarketPress – 1.0.3 – Nicht getestest mit der aktiven WooCommerce-Version
    Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: von codewoogeek – 1.7.5
    Borlabs Cookie - Cookie Opt-in: von Benjamin A. Bornschein
    Borlabs – 1.9.9
    
    Coming Soon Page & Maintenance Mode by SeedProd: von SeedProd – 5.0.25
    Contact Form 7: von Takayuki Miyoshi – 5.1.3
    WooCommerce Coupon Generator: von Jeroen Sormani – 1.0.1 – Nicht getestest mit der aktiven WooCommerce-Version
    Add-on: Custom CSS - Back In Stock Notifier for WooCommerce: von codewoogeek – 1.1 – Nicht getestest mit der aktiven WooCommerce-Version
    Add-on: Unsubscribe - Back In Stock Notifier for WooCommerce: von codewoogeek – 1.0 – Nicht getestest mit der aktiven WooCommerce-Version
    DHL for WooCommerce: von DHL – 1.3.19 – Nicht getestest mit der aktiven WooCommerce-Version
    Disable Cart Fragments: von LittleBizzy – 1.3.0 – Nicht getestest mit der aktiven WooCommerce-Version
    Dupliziere Seite: von mndpsingh287 – 3.5
    Favicon by RealFaviconGenerator: von Philippe Bernard – 1.3.15
    WooCommerce Gutscheinsystem: von IZE Media – 1.1.0 – Nicht getestest mit der aktiven WooCommerce-Version
    Loco Translate: von Tim Whitlock – 2.3.0
    Mailchimp for WooCommerce: von Mailchimp – 2.1.16 – Nicht getestest mit der aktiven WooCommerce-Version
    Mailchimp for WordPress: von ibericode – 4.5.2
    No CAPTCHA reCAPTCHA for WooCommerce: von MailOptin Team – 1.2.6 – Nicht getestest mit der aktiven WooCommerce-Version
    NC Size Chart for Woocommerce: von Nabaraj Chapagain – 1.0.6 – Nicht getestest mit der aktiven WooCommerce-Version
    ShortPixel Image Optimizer: von ShortPixel – 4.13.1
    Vendidero Helper: von Vendidero – 1.2.1
    WhatsApp Chat by NinjaTeam: von NinjaTeam – 2.1.1
    PayPal PLUS für WooCommerce: von Inpsyde GmbH – 2.0.4
    WooCommerce Variation Swatches: von Emran Ahmed – 1.0.57
    Germanized für WooCommerce Pro: von Vendidero – 1.10.0
    Germanized für WooCommerce: von Vendidero – 2.3.0
    WooCommerce Multiple Free Gift PRO: von Ankit Pokhrel – 1.3.0 – Nicht getestest mit der aktiven WooCommerce-Version
    WooCommerce POS Pro: von kilbot – 0.4.19 – Nicht getestest mit der aktiven WooCommerce-Version
    WooCommerce POS: von kilbot – 0.4.23
    WooCommerce Stock Manager: von Vladislav Musílek – 1.2.8 – Nicht getestest mit der aktiven WooCommerce-Version
    Woocommerce upcoming Products: von Sk Shaikat – 1.5.8.8 – Nicht getestest mit der aktiven WooCommerce-Version
    WooCommerce: von Automattic – 3.6.4
    WooRechnung: von Zweischneider GmbH & Co. KG – 2.0.13 – Nicht getestest mit der aktiven WooCommerce-Version
    WooSidebars: von WooCommerce – 1.4.5
    Yoast SEO: von Team Yoast – 11.3 – Nicht getestest mit der aktiven WooCommerce-Version
    WP Rollback: von Impress.org – 1.6
    YITH WooCommerce Badge Management Premium: von YITH – 1.3.21
    
    ### Inactive Plugins (4) ###
    
    Facebook for WooCommerce: von Facebook – 1.9.10 – Nicht getestest mit der aktiven WooCommerce-Version
    WooCommerce Advanced Bulk Edit: von George Iron – 4.4.2 – Nicht getestest mit der aktiven WooCommerce-Version
    WooCommerce Amazon Pay Gateway: von WooCommerce – 1.10.0
    WP Rocket: von WP Media – 3.3.5
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right_space
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    voucher (voucher)
    
    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-Basis: #9621 - /shop/
    Warenkorb: #16933 - /warenkorb/
    Kasse: #16932 - /kasse/
    Mein Konto: #16931 - /konto/
    Allgemeine Geschäftsbedingungen: #9611 - /allgemeine-geschaeftsbedingungen/
    
    ### Theme ###
    
    Name: Flatsome Child
    Version: 3.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.8.3
    Parent Theme Author URL: http://www.uxthemes.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart-shipping.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-product_cat.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/content-widget-product.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    
    ### Action Scheduler ###
    
    Complete: 16.089
    Oldest: 2019-05-16 08:32:49 +0200
    Newest: 2019-06-11 09:29:30 +0200
    
    Pending: 3
    Oldest: 2019-06-12 02:12:05 +0200
    Newest: 2019-06-13 08:33:32 +0200
    
    Canceled: 0
    Oldest: –
    Newest: –
    
    In-progress: 0
    Oldest: –
    Newest: –
    
    Failed: 1
    Oldest: 2019-05-29 07:47:41 +0200
    Newest: 2019-05-29 07:47:41 +0200
    
    

    Hello Zach,
    me again.

    After a while the Stock is reduced to 1. The deactivate of the Cache Plugin is not the solution.

    Hello Zach, me again a third time.

    I deactivate all Plugins (instead of Woocommerce), and use the standard theme.
    My products has an Stock of 95 pcs.

    I place an order and the stock is reduced to 94. then i place another order and the stock is reduced to 93. then i cancel the first order and the stock is increase to 94. i cancel the second order and the stock is increase from 1 to 2.

    I think i have a big Problem with Woocommerce. Not with my other Plugins. And i don’t know why.

    Plugin Support Amanda

    (@amandasjackson)

    Hi there,

    We’ve seen similar behavior on a few sites, when the update scripts for WooCommerce 3.6. didn’t set up all the required database tables. There’s a fix included for this problem in WooCommerce version 3.6.3 and newer.

    Once you update to version 3.6.3 or newer, we’ll need to fix the database rows that were affected by this bug. To do this, you can go to WooCommerce > Status > Tools and regenerate product lookup tables on that page:


    Link to image: https://cld.wthms.co/09WNUg

    It may take up to 10-15 minutes to complete, depending how many products there are in your store. Once it’s over, saving the product again will set the correct stock status.

    Plugin Support Kenin

    (@kbassart)

    Automattic Happiness Engineer

    Hi there,

    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 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.