Stock Error (Product Showing ‘Out of Stock’ in the cart)
-
I have the same problem as described in this thread https://www.ads-software.com/support/topic/stock-error-product-showing-out-of-stock-in-the-cart/
But only one product seems to be affected.I cleared clients carts but the issue is still there.
What is your advice?
-
Hello,
only one product seems to be affected.
Can you please share the product page URL as well as 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.
Product url https://namaste24.pl/produkt/roller-do-akupresury-mapa-masazu-yogattractive/
### WordPress Environment ### WordPress address (URL): https://namaste24.pl Site address (URL): https://namaste24.pl WC Version: 5.1.0 REST API Version: ? 5.1.0 WC Blocks Version: ? 4.4.3 Action Scheduler Version: ? 3.1.6 WC Admin Version: ? 2.0.2 Log Directory Writable: ? WP Version: 5.7 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ? Language: pl_PL External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.0 PHP Post Max Size: 256 MB PHP Time Limit: 30 PHP Max Input Vars: 10000 cURL Version: 7.66.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.6.25 Max Upload Size: 256 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 5.1.0 WC Database Prefix: wp_ Ca?kowity rozmiar bazy danych: 126.77MB Rozmiar bazy danych: 92.03MB Rozmiar indeksu bazy danych: 34.74MB wp_woocommerce_sessions: Dane: 1.52MB + Indeks: 0.02MB + Silnik InnoDB wp_woocommerce_api_keys: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_woocommerce_attribute_taxonomies: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_woocommerce_downloadable_product_permissions: Dane: 0.02MB + Indeks: 0.06MB + Silnik InnoDB wp_woocommerce_order_items: Dane: 0.42MB + Indeks: 0.16MB + Silnik InnoDB wp_woocommerce_order_itemmeta: Dane: 4.52MB + Indeks: 5.03MB + Silnik InnoDB wp_woocommerce_tax_rates: Dane: 0.02MB + Indeks: 0.06MB + Silnik InnoDB wp_woocommerce_tax_rate_locations: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_woocommerce_shipping_zones: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_woocommerce_shipping_zone_locations: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_woocommerce_shipping_zone_methods: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_woocommerce_payment_tokens: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_woocommerce_payment_tokenmeta: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_woocommerce_log: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_actionscheduler_actions: Dane: 7.02MB + Indeks: 2.00MB + Silnik InnoDB wp_actionscheduler_claims: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_actionscheduler_groups: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_actionscheduler_logs: Dane: 3.02MB + Indeks: 1.52MB + Silnik InnoDB wp_commentmeta: Dane: 0.06MB + Indeks: 0.06MB + Silnik InnoDB wp_comments: Dane: 2.52MB + Indeks: 1.20MB + Silnik InnoDB wp_fp_log: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_links: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_mailchimp_carts: Dane: 0.09MB + Indeks: 0.00MB + Silnik InnoDB wp_mailchimp_jobs: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_options: Dane: 10.36MB + Indeks: 0.48MB + Silnik InnoDB wp_pmxi_files: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_pmxi_history: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_pmxi_images: Dane: 0.30MB + Indeks: 0.00MB + Silnik InnoDB wp_pmxi_imports: Dane: 0.05MB + Indeks: 0.00MB + Silnik InnoDB wp_pmxi_posts: Dane: 0.08MB + Indeks: 0.00MB + Silnik InnoDB wp_pmxi_templates: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_postmeta: Dane: 25.56MB + Indeks: 14.98MB + Silnik InnoDB wp_posts: Dane: 17.44MB + Indeks: 1.27MB + Silnik InnoDB wp_quform_entries: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_quform_entry_data: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_quform_entry_entry_labels: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_quform_entry_labels: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_quform_forms: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_quform_sessions: Dane: 0.05MB + Indeks: 0.00MB + Silnik InnoDB wp_redirection_404: Dane: 1.02MB + Indeks: 2.08MB + Silnik InnoDB wp_redirection_groups: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_redirection_items: Dane: 0.16MB + Indeks: 0.19MB + Silnik InnoDB wp_redirection_logs: Dane: 0.17MB + Indeks: 0.05MB + Silnik InnoDB wp_revslider_css: Dane: 0.13MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_css_bkp: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_layer_animations: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_layer_animations_bkp: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_navigations: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_navigations_bkp: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_sliders: Dane: 0.03MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_sliders_bkp: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_slides: Dane: 0.30MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_slides_bkp: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_static_slides: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_revslider_static_slides_bkp: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_social_users: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_subscriptio_scheduled_events: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_termmeta: Dane: 0.06MB + Indeks: 0.03MB + Silnik InnoDB wp_terms: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_term_relationships: Dane: 0.22MB + Indeks: 0.16MB + Silnik InnoDB wp_term_taxonomy: Dane: 0.08MB + Indeks: 0.03MB + Silnik InnoDB wp_usermeta: Dane: 1.52MB + Indeks: 0.78MB + Silnik InnoDB wp_users: Dane: 0.06MB + Indeks: 0.05MB + Silnik InnoDB wp_wcpdf_invoice_number: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wc_admin_notes: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wc_admin_note_actions: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_wc_category_lookup: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wc_customer_lookup: Dane: 0.16MB + Indeks: 0.13MB + Silnik InnoDB wp_wc_download_log: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_wc_order_coupon_lookup: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_wc_order_product_lookup: Dane: 0.27MB + Indeks: 0.31MB + Silnik InnoDB wp_wc_order_stats: Dane: 0.17MB + Indeks: 0.20MB + Silnik InnoDB wp_wc_order_tax_lookup: Dane: 0.14MB + Indeks: 0.17MB + Silnik InnoDB wp_wc_product_meta_lookup: Dane: 0.14MB + Indeks: 0.22MB + Silnik InnoDB wp_wc_reserved_stock: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wc_tax_rate_classes: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_wc_webhooks: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_wfblockediplog: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wfblocks7: Dane: 0.02MB + Indeks: 0.05MB + Silnik InnoDB wp_wfconfig: Dane: 0.45MB + Indeks: 0.00MB + Silnik InnoDB wp_wfcrawlers: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wffilechanges: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wffilemods: Dane: 4.52MB + Indeks: 0.00MB + Silnik InnoDB wp_wfhits: Dane: 0.02MB + Indeks: 0.05MB + Silnik InnoDB wp_wfhoover: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_wfissues: Dane: 0.02MB + Indeks: 0.06MB + Silnik InnoDB wp_wfknownfilelist: Dane: 2.52MB + Indeks: 0.00MB + Silnik InnoDB wp_wflivetraffichuman: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_wflocs: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wflogins: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_wfls_2fa_secrets: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_wfls_settings: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wfnotifications: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wfpendingissues: Dane: 0.02MB + Indeks: 0.06MB + Silnik InnoDB wp_wfpklist_template_data: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wfreversecache: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wfsnipcache: Dane: 0.02MB + Indeks: 0.05MB + Silnik InnoDB wp_wfstatus: Dane: 0.13MB + Indeks: 0.09MB + Silnik InnoDB wp_wftrafficrates: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_woocommerce_p24_data: Dane: 0.00MB + Indeks: 0.00MB + Silnik MyISAM wp_wpfm_backup: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_wpmailsmtp_tasks_meta: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB wp_yith_wcwl: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_yith_wcwl_lists: Dane: 0.02MB + Indeks: 0.03MB + Silnik InnoDB wp_yoast_indexable: Dane: 4.52MB + Indeks: 1.61MB + Silnik InnoDB wp_yoast_indexable_hierarchy: Dane: 0.17MB + Indeks: 0.23MB + Silnik InnoDB wp_yoast_migrations: Dane: 0.02MB + Indeks: 0.02MB + Silnik InnoDB wp_yoast_primary_term: Dane: 0.09MB + Indeks: 0.11MB + Silnik InnoDB wp_yoast_prominent_words: Dane: 0.30MB + Indeks: 0.34MB + Silnik InnoDB wp_yoast_seo_links: Dane: 0.16MB + Indeks: 0.13MB + Silnik InnoDB wp_yoast_seo_meta: Dane: 0.13MB + Indeks: 0.00MB + Silnik InnoDB wp_zp_locations: Dane: 0.02MB + Indeks: 0.00MB + Silnik InnoDB ### Post Type Counts ### attachment: 3249 br_product_tab: 1 custom_css: 1 customize_changeset: 40 etheme_portfolio: 12 googlefeed: 8 jp_pay_order: 388 mc4wp-form: 1 nav_menu_item: 27 oembed_cache: 2 page: 24 pi_shipping_method: 1 post: 14 product: 804 product_variation: 135 revision: 796 shipment: 459 shipping_manifest: 3 shop_coupon: 8 shop_order: 1523 shop_order_refund: 22 shopmagic_automation: 1 staticblocks: 39 testimonials: 3 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (34) ### WooCommerce Przelewy24 Payment Gateway: przez DialCom24 Sp. z o.o. – 1.0.0 Cookie Notice & Compliance dla RODO / CCPA: przez Hu-manity.co – 2.0.3 Custom Order Numbers for WooCommerce: przez Tyche Softwares – 1.2.12 XStore Core: przez 8theme – 3.2.6 Facebook for WooCommerce: przez Facebook – 2.3.3 Flexible Checkout Fields PRO: przez WP Desk – 3.0.3 Flexible Checkout Fields: przez WP Desk – 3.0.7 Flexible Printing: przez WP Desk – 1.2.0 Flexible Shipping Import/Export WooCommerce: przez WP Desk – 1.0.1 Flexible Shipping PRO: przez WP Desk – 2.2.0 Flexible Shipping: przez WP Desk – 4.1.2 Furgonetka.pl: przez Furgonetka.pl – 1.0.7 Heartbeat Control by WP Rocket: przez WP Rocket – 2.0 Jetpack by WordPress.com: przez Automattic – 9.5 WPBakery Page Builder: przez Michael M - WPBakery.com – 6.6.0 Loco Translate: przez Tim Whitlock – 2.5.2 MC4WP: Mailchimp for WordPress: przez ibericode – 4.8.3 Redirection: przez John Godley – 5.0.1 Slider Revolution: przez ThemePunch – 6.4.2 Under Construction: przez WebFactory Ltd – 3.88 W3 Total Cache: przez BoldGrid – 2.1.1 Woo Image SEO: przez Danail Emandiev – 1.2.1 P?ac? z PayU: przez PayU SA – 1.3.1 WooCommerce Aktywne P?atno?ci: przez WP Desk – 3.6.6 Print Invoice & Delivery Notes for WooCommerce: przez Tyche Softwares – 4.6.2 WooCommerce DPD: przez WP Desk – 2.6.3 WooCommerce Google Analytics Integration: przez WooCommerce – 1.5.1 WooCommerce InPost: przez WP Desk – 3.15.8 WooCommerce Shipping & Tax: przez Automattic – 1.25.9 (dost?pna aktualizacja do wersji 1.25.10) WooCommerce: przez Automattic – 5.1.0 WooCommerce iFirma: przez WP Desk – 3.4.3 Yoast SEO Premium: przez Zespó? Yoast – 16.0.3 Yoast SEO: przez Zespó? Yoast – 16.0.2 WooCommerce Google Merchant XML: przez WP Desk – 1.7.9 ### Inactive Plugins (6) ### Apaczka.pl Mapa Punktów: przez Inspire Labs – 1.1.3 Apaczka.pl WooCommerce: przez Inspire Labs – 1.3.11 Mailchimp for WooCommerce: przez Mailchimp – 2.5.1 Massive Addons for WPBakery Page Builder: przez MassivePixelCreation – 2.4.8 Query Monitor: przez John Blackbourn – 3.6.7 WooCommerce Fakturownia: przez WP Desk – 1.4.7 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: – Force SSL: – Currency: PLN (z?) Currency Position: right_space 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 ### Strona sklepu: #6102 - /sklep/ Koszyk: #22 - /koszyk/ Zamówienie: #23 - /checkout/ Moje konto: #24 - /my-account/ Regulamin: #8764 - /regulamin-zakupow/ ### Theme ### Name: XStore Child Version: 1.0 Author URL: https://8theme.com Child Theme: ? Parent Theme Name: XStore Parent Theme Version: 7.2.6 Parent Theme Author URL: https://www.8theme.com WooCommerce Support: ? ### Templates ### Overrides: xstore/woocommerce/archive-product.php xstore/woocommerce/cart/cart-empty.php xstore/woocommerce/cart/cart-item-data.php xstore/woocommerce/cart/cart-shipping.php xstore/woocommerce/cart/cart.php xstore/woocommerce/cart/cross-sells.php xstore/woocommerce/cart/mini-cart.php xstore/woocommerce/checkout/form-billing.php xstore/woocommerce/checkout/form-checkout.php xstore/woocommerce/checkout/form-shipping.php xstore/woocommerce/checkout/thankyou.php xstore/woocommerce/content-product-cat.php xstore/woocommerce/content-product.php xstore/woocommerce/content-single-product.php xstore/woocommerce/content-widget-product.php xstore/woocommerce/content-widget-reviews.php xstore-child/woocommerce/emails/admin-new-order.php xstore-child/woocommerce/emails/customer-note.php xstore-child/woocommerce/emails/customer-on-hold-order.php xstore/woocommerce/global/breadcrumb.php xstore/woocommerce/global/form-login.php xstore/woocommerce/global/wrapper-end.php xstore/woocommerce/global/wrapper-start.php xstore/woocommerce/loop/loop-end.php xstore/woocommerce/loop/loop-start.php xstore/woocommerce/loop/no-products-found.php xstore/woocommerce/loop/result-count.php xstore/woocommerce/myaccount/dashboard.php xstore/woocommerce/myaccount/form-login.php xstore/woocommerce/myaccount/navigation.php xstore/woocommerce/single-product/add-to-cart/simple.php xstore/woocommerce/single-product/meta.php xstore/woocommerce/single-product/product-image.php xstore/woocommerce/single-product/related.php xstore/woocommerce/single-product/tabs/tabs.php xstore/woocommerce/single-product/title.php xstore/woocommerce/single-product/up-sells.php xstore/woocommerce/single-product.php ### Action Scheduler ### Zrealizowane: 8 811 Oldest: 2021-02-23 14:21:27 +0100 Newest: 2021-03-26 14:17:18 +0100 Nieudana: 8 Oldest: – Newest: – Oczekuj?ca: 3 Oldest: 2021-03-26 14:22:20 +0100 Newest: 2021-03-26 14:32:18 +0100 ### Status report information ### Generated at: 2021-03-26 14:19:54 +01:00
Hello,
Let me also make sure if you have tried the following:
- Set the out of stock threshold to 0
- Clear transients and cache under WooCommerce > Status > Tools
I did i now. still no effect. Right now product is sold out ( I was able to sell it over a phone). I am worried that this glitch can affect other products as well.
I cleared the above mentioned caches, cdn, browser, w3 total caches.
This product is our bestseller, we sold it out many times. No problems before.
Hello,
Ok, let’s rule out any conflicts. Please temporarily switch your theme to Storefront and disable all plugins except for WooCommerce. If that resolves the issue, then re-enable features one-by-one until you find the one that’s causing the conflict. If you don’t want to test on your live site, you can create a staging site using a plugin called?WP Staging: https://www.ads-software.com/plugins/wp-staging/
Hi @namaste24
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.
Just FYI – no it was not resolved and turning off live store is a terrible solution for it. Really tired with Woocommerce right now.
Quick update. I have found the workaround but still think that it is a flaw/glitch in woocomerce. Posting anyway for people who can experience similar issue.
I had this product purchased by a customer who didn’t complete the payment. In the order details I saw that the stock was reduced.
In the product inventory after reduction I still had 1 available (which reflected how many actual products we had in warehouse)
When soemone wanted to buy it system was kind of “claiming the product” one more time not allowing to complete the order.So really my question for Woocommerce is – when is the stock reduction happening?
I know that it is messy but maybe will help anyone experiencing similar issue.
Issue resolved for now.Hello,
I had this product purchased by a customer who didn’t complete the payment. In the order details I saw that the stock was reduced.
What was the order status then? If it was on hold, stock gets reduced even though payment hasn’t been received yet. You can read more about order statuses here: https://docs.woocommerce.com/document/managing-orders/#order-statuses
Hi @namaste24
We’ve not heard back from you in a while, so I’m marking this thread as resolved. If you have further questions, please feel free to open a new topic.
- The topic ‘Stock Error (Product Showing ‘Out of Stock’ in the cart)’ is closed to new replies.