Variations get 0 stock
-
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?
-
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.
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
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.
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.
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.
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.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.
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.
- The topic ‘Variations get 0 stock’ is closed to new replies.