• Resolved riversworldsa

    (@riversworldsa)


    Hi

    I have a strange issue with my woocommerce site.
    Variations quantities stock quantity become 0 and Variable products get out of stock automatically.
    This happens with some products only and I don’t know why.

    I thought there might be something wrong with WP All Import plugins so I disabled them all and the issue still as it is.

    Each time I add stock then wait for several hours to a day then the issue happens. Each time it happens with different products.

    What possible would cause this issue and how to solve it?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support abwaita a11n

    (@abwaita)

    Hi @riversworldsa,
    Just to get a better context, when the issue occurs, does the stock of the affected variable product change to 0 as well or is the “out of stock” text only shown on the front end while you have positive stock for that variation on the admin page?

    Also, could you share with us your a copy of your System Status Report from WooCommerce > Status?

    Thanks.

    Thread Starter riversworldsa

    (@riversworldsa)

    Hello,

    Thanks for your reply ??

    All variations stock become 0 and the products get out of stock.

    Here is a copy of the status report:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://hyakah.com
    Site address (URL): https://hyakah.com
    WC Version: 5.2.2
    REST API Version: ? 5.2.2
    WC Blocks Version: ? 4.7.2
    Action Scheduler Version: ? 3.1.6
    WC Admin Version: ? 2.1.5
    Log Directory Writable: ?
    WP Version: 5.7.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: ar
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.19
    PHP Post Max Size: 8 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 10000
    cURL Version: 7.76.1
    OpenSSL/1.1.1k
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.34
    Max Upload Size: 8 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 5.2.2
    WC Database Prefix: wpyv_
    Total Database Size: 297.92MB
    Database Data Size: 166.29MB
    Database Index Size: 131.63MB
    wpyv_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpyv_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpyv_woocommerce_order_items: Data: 1.52MB + Index: 0.19MB + Engine InnoDB
    wpyv_woocommerce_order_itemmeta: Data: 3.52MB + Index: 4.03MB + Engine InnoDB
    wpyv_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpyv_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpyv_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpyv_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpyv_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_actionscheduler_actions: Data: 7.02MB + Index: 7.61MB + Engine InnoDB
    wpyv_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_actionscheduler_logs: Data: 7.02MB + Index: 5.13MB + Engine InnoDB
    wpyv_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_chaty_contact_form_leads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wpyv_comments: Data: 5.52MB + Index: 6.97MB + Engine InnoDB
    wpyv_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_duplicator_pro_packages: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wpyv_ee_product_sync_call: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_ee_product_sync_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_kbp_countdown_entry: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_kbp_form_entry: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_kbp_form_entrymeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpyv_ksp_layers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_ksp_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_ksp_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_nextend2_section_storage: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    wpyv_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_nextend2_smartslider3_sliders: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpyv_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
    wpyv_options: Data: 6.17MB + Index: 1.34MB + Engine InnoDB
    wpyv_pmxe_exports: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxe_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxe_templates: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxi_hash: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxi_images: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxi_imports: Data: 1.50MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxi_posts: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
    wpyv_pmxi_templates: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
    wpyv_postmeta: Data: 47.58MB + Index: 36.81MB + Engine InnoDB
    wpyv_posts: Data: 12.09MB + Index: 3.50MB + Engine InnoDB
    wpyv_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wpyv_terms: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    wpyv_term_relationships: Data: 0.20MB + Index: 0.14MB + Engine InnoDB
    wpyv_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wpyv_usermeta: Data: 57.59MB + Index: 62.22MB + Engine InnoDB
    wpyv_users: Data: 1.52MB + Index: 0.55MB + Engine InnoDB
    wpyv_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpyv_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_wc_customer_lookup: Data: 0.50MB + Index: 0.45MB + Engine InnoDB
    wpyv_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpyv_wc_order_coupon_lookup: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
    wpyv_wc_order_product_lookup: Data: 1.52MB + Index: 0.59MB + Engine InnoDB
    wpyv_wc_order_stats: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
    wpyv_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpyv_wc_product_meta_lookup: Data: 0.28MB + Index: 0.48MB + Engine InnoDB
    wpyv_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_woocommerce_exported_csv_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpyv_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpyv_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_hyperpay_mada_saving_cards: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_saving_cards: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 1996
    br_labels: 3
    custom_css: 1
    customize_changeset: 7
    kadence_element: 1
    kadslider: 1
    kt_cart_notice: 2
    kt_product_tabs: 1
    kt_reviews: 29
    kt_size_chart: 1
    nav_menu_item: 72
    page: 12
    post: 2
    product: 411
    product_variation: 1782
    revision: 4
    shop_coupon: 44
    shop_order: 4915
    shop_order_refund: 1
    wc_order_status: 8
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (25) ###
    
    Mada for Hyperpay Payment Gateway for WooCommerce: by Hyperpay Team – 1.0
    Hyperpay Payment Gateway plugin for WooCommerce: by Hyperpay Team – 1.0
    WooCommerce Advanced Product Labels: by BeRocket – 1.2.2.1
    Ajax Search Lite: by Ernest Marcinko – 4.9.3
    Duplicator Pro: by Snap Creek – 4.0.3
    Google Tag Manager for WordPress: by Thomas Geiger – 1.12.3
    Enhanced E-commerce for Woocommerce store: by Tatvic – 3.0.5
    Facebook for WooCommerce: by Facebook – 2.4.1
    Kadence Blocks - PRO Extension: by Kadence WP – 1.4.31
    Kadence Blocks – Gutenberg Blocks for Page Builder Features: by Kadence WP – 2.0.3
    Kadence Pro - Premium addon for the Kadence Theme: by Kadence WP – 0.9.13
    Kadence WooCommerce Extras: by Kadence WP – 1.6.22
    Loco Translate: by Tim Whitlock – 2.5.2
    WooCommerce PDF Invoices, Packing Slips, Delivery Notes & Shipping Labels: by WebToffee – 2.7.7
    Smart Slider 3: by Nextend – 3.4.1.17
    Snap Pixel: by Hassan Ali – 1.5.4
    Temporary Login Without Password: by StoreApps – 1.6.11
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.16.56
    
    User Role Editor: by Vladimir Garagulya – 4.59
    WooCommerce Smart COD: by woosmartcod.com – 1.6.1
    Product Feed PRO for WooCommerce: by AdTribes.io – 10.0.9
    WooCommerce Order Status Manager: by SkyVerge – 1.13.0
    WooCommerce: by Automattic – 5.2.2 (update to version 5.3.0 is available)
    WP Mail SMTP: by WPForms – 2.8.0
    WP Rocket: by WP Media – 3.8.7
    
    ### Inactive Plugins (8) ###
    
    ApplePay for Hyperpay Payment Gateway for WooCommerce: by Hyperpay Team – 1.0
    Booster for WooCommerce: by Pluggabl LLC – 5.4.0
    STCPay for Hyperpay Payment Gateway for WooCommerce: by Hyperpay Team – 1.0
    WP All Export - User Export Add-On Pro: by Soflyy – 1.0.4
    WP All Export Pro: by Soflyy – 1.6.4
    WP All Import - User Import Add-On Pro: by Soflyy – 1.1.5
    WP All Import - WooCommerce Add-On Pro: by Soflyy – 3.2.5
    WP All Import Pro: by Soflyy – 4.6.5
    
    ### Dropin Plugins (2) ###
    
    advanced-cache.php: advanced-cache.php
    maintenance.php: maintenance.php
    
    ### Settings ###
    
    API Enabled: ?
    Force SSL: –
    Currency: SAR (?.?)
    Currency Position: left
    Thousand Separator: 
    Decimal Separator: .
    Number of Decimals: 0
    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: #958 - /shop/
    Cart: #959 - /cart/
    Checkout: #960 - /checkout/
    My account: #968 - /my-account/
    Terms and conditions: #1229 - /%d8%a7%d9%84%d8%b4%d8%b1%d9%88%d8%b7-%d9%88%d8%a7%d9%84%d8%a7%d8%ad%d9%83%d8%a7%d9%85/
    
    ### Theme ###
    
    Name: Kadence
    Version: 1.0.20 (update to version 1.0.21 is available)
    Author URL: https://www.kadencewp.com/
    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: 21,910
    Oldest: 2021-04-18 10:59:43 +0300
    Newest: 2021-05-18 09:30:28 +0300
    
    Pending: 2
    Oldest: 2021-05-19 09:30:28 +0300
    Newest: 2021-05-19 09:30:28 +0300
    
    ### Status report information ###
    
    Generated at: 2021-05-18 14:21:11 +03:00
    
    Plugin Support abwaita a11n

    (@abwaita)

    Thanks for your reply @riversworldsa.

    Normally, WooCommerce would reduce stock following order placement. If the order is not paid for, WooCommerce should cancel it and restore the stock according to your Hold Stock timeout at WooCommerce → Setting → Products → Inventory.

    If there are no corresponding orders for the variable products that are going out of stock, it’s possible that some other tool is reducing stock.

    Thus, to rule out some possibilities, could you confirm that there are no corresponding orders (including Pending payment) at WooCommerce → Orders for the affected variations?

    Thanks.

    Thread Starter riversworldsa

    (@riversworldsa)

    No. There are no pending orders that could consume all of these products
    And if there is, it won’t be for all product variations.

    This issue happens with the hold stock option enables or disabled.

    Plugin Support abwaita a11n

    (@abwaita)

    Thanks for your reply.

    As mentioned above, if there are no corresponding orders for the variable products that are going out of stock, it’s possible that some other tool is reducing stock.

    To explore further on the cause of the issue, you will want to do a conflict test as explained here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/

    * Due to the nature of this issue, you may want to do this test on a test/staging site. If you don’t have one already, your hosting company might offer one as part of your package. Alternatively, you can use a free plugin like https://www.ads-software.com/plugins/wp-staging/

    Let us know if the issue persists when you’ve switched to a default WP theme like Twenty Twenty-One with all other plugins deactivated apart from WooCommerce.

    Thanks.

    Thread Starter riversworldsa

    (@riversworldsa)

    Hello,

    Thanks for your reply.
    This kind of test would be useful in a direct issue that happens regularly in some way, like 500 error for example.

    But for the issue I have here, this won’t be a practical approach.
    I will disable all my 30 plugins then wait for 2-5 days to see some items get 0 stock. Then Activate 1 plugin and wait for 2-5 days to see some items get 0 stock.
    Then Activate the second plugin and wait for 2-5 days to see some items get 0 stock.
    This is not a good solution at all.
    It will take from 30 to 150 days to test all plugins.

    Plugin Support abwaita a11n

    (@abwaita)

    Hi @riversworldsa,

    I was under the impression that the issue happens every so often, like after a few hours based on your earlier message:

    “Each time I add stock then wait for several hours to a day then the issue happens.”

    Given that it may happen over a longer duration, could you start with the last part of my previous message: “Let us know if the issue persists when you’ve switched to a default WP theme like Twenty Twenty-One with all other plugins deactivated apart from WooCommerce”?
    This might give some insights, such as whether the manage stock functionality is working correctly.

    *I’d suggest that you purge all cache before deactivating the WP Rocket plugin. Ideally, you will want to do the test on a staging site so as not to affect your customers.

    Let us know how it goes.

    Thanks.

    Hi @riversworldsa

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem! If you have further questions, please feel free to open a new topic.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Variations get 0 stock’ is closed to new replies.