Stock quantity changing incorrectly

(@regalguy)

Thanks for your reply Amanda.

I’ll run that test later. I am still a little confused why enabling back orders would cause that to happen? My understanding is that it will allow customers to purchase something that is not yet in stock (which is something i rely on heavily)

Please see System Status below


### WordPress Environment ###

WordPress address (URL): http://www.regaldog.co.uk
Site address (URL): http://www.regaldog.co.uk
WC Version: 3.8.0
REST API Version: ✔ 1.0.2
Log Directory Writable: ✔
WP Version: 5.3
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: –
Language: en_GB
External object cache: ✔

### Server Environment ###

Server Info: Apache/2.4.29 (Unix) mod_hive/6.27 OpenSSL/1.0.1e-fips mod_fastcgi/2.4.6
PHP Version: 7.3.11
PHP Post Max Size: 128 MB
PHP Time Limit: 120
PHP Max Input Vars: 5000
cURL Version: 7.59.0
OpenSSL/1.0.2r

SUHOSIN Installed: –
MySQL Version: 5.6.36-82.1-log
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.8.0
WC Database Prefix: 475_
MaxMind GeoIP Database: ✔
Total Database Size: 45.81MB
Database Data Size: 30.51MB
Database Index Size: 15.30MB
475_woocommerce_sessions: Data: 0.19MB + Index: 0.01MB + Engine MyISAM
475_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
475_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_woocommerce_order_items: Data: 0.06MB + Index: 0.03MB + Engine MyISAM
475_woocommerce_order_itemmeta: Data: 0.91MB + Index: 0.28MB + Engine MyISAM
475_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_atum_export_templates: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
475_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_atum_product_data: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
475_bwg_album: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_bwg_image: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_bwg_image_tag: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_bwg_shortcode: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_bwg_theme: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
475_commentmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
475_comments: Data: 1.26MB + Index: 0.73MB + Engine MyISAM
475_cp_calculated_fields_form_discount_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_cp_calculated_fields_form_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_cp_calculated_fields_form_revision: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
475_cp_calculated_fields_form_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_grp_google_place: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_grp_google_review: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_mailchimp_carts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
475_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_mystyle_designs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_mystyle_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_nm_personalized: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_options: Data: 1.99MB + Index: 0.12MB + Engine MyISAM
475_postmeta: Data: 19.85MB + Index: 11.61MB + Engine MyISAM
475_posts: Data: 1.39MB + Index: 0.47MB + Engine MyISAM
475_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_responsive_menu: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
475_responsive_menu_pro: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
475_sbi_instagram_feeds_posts: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
475_sbi_instagram_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
475_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_stock_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_ta_link_clicks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_ta_link_clicks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
475_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
475_term_relationships: Data: 0.06MB + Index: 0.12MB + Engine MyISAM
475_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
475_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_usermeta: Data: 0.33MB + Index: 0.18MB + Engine MyISAM
475_users: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
475_wcfm_enquiries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wcfm_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wcfm_support: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wcu_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wcu_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wcu_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
475_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
475_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wc_product_meta_lookup: Data: 0.09MB + Index: 0.13MB + Engine InnoDB
475_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
475_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
475_wfconfig: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
475_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
475_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
475_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
475_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
475_wpam_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpam_affiliates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpam_affiliates_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpam_creatives: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpam_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpam_impressions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpam_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpam_paypal_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpam_tracking_tokens: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
475_wpam_tracking_tokens_purchase_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpam_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpforms_entries: Data: 0.14MB + Index: 0.02MB + Engine InnoDB
475_wpforms_entry_fields: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
475_wpforms_entry_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_wplc_chat_msgs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wplc_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_wpmailsmtp_emails_log: Data: 0.27MB + Index: 0.12MB + Engine MyISAM
475_wsal_metadata: Data: 0.09MB + Index: 0.14MB + Engine InnoDB
475_wsal_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
475_yoast_seo_links: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
475_yoast_seo_meta: Data: 0.20MB + Index: 0.21MB + Engine MyISAM
475_zi2_conf: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
475_zi2_shipments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Security ###

Secure connection (HTTPS): ❌
					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ✔

### Active Plugins (29) ###

Admin Menu Editor: by Janis Elsts – 1.9.2
Affiliates Manager WooCommerce Coupons Integration: by wp.insider
affmngr – 1.0.2 – Not tested with the active version of WooCommerce

Affiliates Manager Google reCAPTCHA Integration: by wp.insider
affmngr – 1.0.6

WP Affiliate Manager: by wp.insider
wpaffiliatemgr – 2.6.9

Classic Editor: by WordPress Contributors – 1.5
Flexible Shipping: by WP Desk – 3.9.3
Google Analytics Dashboard for WP (GADWP): by ExactMetrics – 5.3.9
Instagram Feed Pro Business: by Smash Balloon – 5.0
Kadence WooCommerce Email Designer: by Kadence WP – 1.3.5
LoginPress - Customizing the WordPress Login: by WPBrigade – 1.3.2
Mailchimp for WooCommerce: by Mailchimp – 2.3 – Not tested with the active version of WooCommerce
SG Optimiser: by SiteGround – 5.3.7
Tawk.to Live Chat: by Tawkto – 0.4.1
WC Fields Factory: by Saravana Kumar K – 3.0.3 – Not tested with the active version of WooCommerce
Estimated Delivery Plugin: by PluginHive – 1.7.8 – Not tested with the active version of WooCommerce
Google Reviews Widget: by RichPlugins  – 1.8
WooCommerce Currency Switcher by WooBeWoo: by woobewoo – 1.2.3
WooCommerce Extended Coupon Features FREE: by Soft79 – 3.1.2 – Not tested with the active version of WooCommerce
WooCommerce Stripe Gateway: by WooCommerce – 4.3.1
WooCommerce Product SKU Generator: by SkyVerge – 2.4.1
WooCommerce - ShipStation Integration: by WooCommerce – 4.1.30
WooCommerce: by Automattic – 3.8.0
Woocurrency by Woobewoo PRO: by woobewoo.com – 1.2.0 – Not tested with the active version of WooCommerce
Yoast SEO: by Team Yoast – 12.5
WP Mail SMTP Pro: by WPForms – 1.7.1
WP Rocket | No LazyLoad for Custom Image Sources: by WP Rocket Support Team –
WP Rocket: by WP Media – 3.4.1.2
WPForms: by WPForms – 1.5.6.2
YITH WooCommerce Name Your Price: by YITH – 1.1.9

### Inactive Plugins (8) ###

Advanced Database Cleaner PRO: by Younes JFR. – 3.0.0
ATUM Inventory Management for WooCommerce: by Stock Management Labs™ – 1.6.3.1
Calculated Fields Form: by CodePeople – 1.0.341
Conditional Payments for WooCommerce: by Lauri Karisola / WooElements.com – 2.1.4 – Not tested with the active version of WooCommerce
Product/Review CSV Import Export: by WebToffee – 3.7.8 – Not tested with the active version of WooCommerce
Product Catalog Feed Pro by PixelYourSite: by PixelYourSite – 4.0.6 – Not tested with the active version of WooCommerce
Virtual Reviews for WooCommerce: by VillaTheme – 1.0.2.3 – Not tested with the active version of WooCommerce
Zakeke Interactive Product Designer: by Zakeke – 1.8.1

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
object-cache.php: Memcached

### Must Use Plugins (4) ###

Endurance Browser Cache: by Mike Hansen – 0.4
Endurance Page Cache: by Mike Hansen – 1.5
Endurance PHP Edge: by Mike Hansen – 0.2
SSO: by Garth Mortensen
Mike Hansen – 0.3

### Settings ###

API Enabled: ✔
Force SSL: ✔
Currency: GBP (£)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: bundle (bundle)
external (external)
grouped (grouped)
pw gift card (pw-gift-card)
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)
visible (visible)

Connected to WooCommerce.com: ✔

### WC Pages ###

Shop base: #6 - /shop/
Basket: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #208 - /terms-and-conditions/

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL: 
Child Theme: ✔
Parent Theme Name: Flatsome
Parent Theme Version: 3.10.0
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/terms.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: 2,935
Oldest: 2019-10-15 01:40:18 +0100
Newest: 2019-11-14 13:00:05 +0000

Pending: 4
Oldest: 2019-11-15 12:30:06 +0000
Newest: 2019-11-15 13:00:05 +0000

Canceled: 2
Oldest: 2019-11-14 07:09:28 +0000
Newest: 2019-11-14 07:12:55 +0000

In-progress: 0
Oldest: –
Newest: –

Failed: 25
Oldest: 2019-08-09 08:32:26 +0100
Newest: 2019-10-21 10:36:00 +0100

Thread Starter

(@regalguy)

DUPLICATE POST

This reply was modified 6 years, 5 months ago by regalguy.

Thread Starter

(@regalguy)

DUPLICATE POST

This reply was modified 6 years, 5 months ago by regalguy.

(@amandasjackson)

Hi @regalguy

The setting used on the product here :

![Screenshot](https://cld.wthms.co/1i1KBQ+)
Screenshot direct link: https://cld.wthms.co/1i1KBQ

Is explained further in this post

Setting the backorders option to “Allow, but notify customer” changes the scenario. Now the following is true:

Changing the stock value in the backend now does not set the stock status. Because WooCommerce is now prepared to keep selling regardless of the inventory count, both values are not linked any longer.
The product can be purchased from the front end. There is a notice above the add to cart button that signals that this is a backorder

If it helps, You can view all backordered items by using this plugin: https://wordpress.org/plugins/woocommerce-backorders-report/ – it adds a simple overview located at WooCommerce -> Reports -> Stock -> On Backorder

Thread Starter

(@regalguy)

Just to clarify, i understand what backorders are and how they work. It’s an integral part of my business as i don’t always stock every item.

I would completely expect stock level to adjust into the negatives as explained in that article. As mentioned previously, the issue i’m facing is the stock quantity adjustment is not reflecting correctly.

If backorders are not to be used as it doesn’t count stock correctly then why is the feature available? The article implys that it should work as i am expecting. Unless there is something third party that doesn’t like below zero stock levels when a product is still in stock. That in itself has some logic, but i’m seeing issues long before the stock level gets to zero.

For example:
Stock level: 10
Order for 2
New Stock level: -6
Expected New stock level: 8

Thanks
Adam

This reply was modified 6 years, 5 months ago by regalguy.

(@amandasjackson)

Hi @regalguy

Unless there is something third party that doesn’t like below zero stock levels when a product is still in stock.

This could certainly caused by either a conflict with your theme or with another plugin.

The best way to determine this is to:

Temporarily switch your theme to Storefront
Disable all plugins except for WooCommerce
Then create a new product with the same backstock settings and with stock and test a few purchases to see if the stock reduces correctly. I tested this on my site and stock was reduced correctly each time an order was placed.

If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

Thread Starter

(@regalguy)

The problem i have is it’s very intermittent. So disabling all plugins and setting the theme to default isn’t a viable option for a live business (i’m sure everyone here has heard that one before).

I cannot replicate the issue in any staging copy i have made so it’s very difficult.

The only plugins i have remaining that have not been disabled to test are:
Flexible Shipping
Kadence WooCommerce Email Designer
WP Mail SMTP Pro
WPForms

All have been disabled and not fixed issued:
Admin Menu
ATUM
Classic Editor
calculated fields
Conditional Payments
Estimated Delivery
Loginpress
Google review widget
Product catalog feed
SG Optimizer
WP-Rocket
Tawk.to
WC Fields Factory
WooCommerce – ShipStation
Woo – currency switcher
Woo – SKU generator
Woo Extended coupon
wp affiliate manager
YITH name your price
virtual reviews
Zakeke Designer
mailchimp
CSV import/export
loginpress
Instagram feed pro business
Yoast
Stripe Gateway

(@amandasjackson)

https://github.com/woocommerce/woocommerce/issues/new/choose

@regalguy

I cannot replicate the issue in any staging copy i have made so it’s very difficult.

If the issue is not able to be replicated on a staging site, then that would suggest that the issue is indeed not a problem with any functionality of the WooCommerce core plugin.

Until you are able to replicate the issue and find the route cause (most likely at this point it is a theme or other plugin), there isn’t anything we can do to help further as this forum is specific to the WooCommerce core plugin.

If the behaviour can be replicated with only WooCommerce core and a default theme, then a bug can be submitted to the core GitHub repo for our developers to take a look at here: