Overselling out of Stock items

  • Resolved dermreagle

    (@dermreagle)


    3 years, 12 months ago

    Hi – have tried finding this on the forum – and surprised nobody has had same error.

    I have set my out of stock limit to 2 items – these are items we manage for guarantee items, which only the store admin can book out.

    However when a client logs in they see all items in stock and can purchase all remaining items – including the numbers in the out of Stock threshold.

    Say I have 5 items left in stock – I expect with an out of stock limit of 2 – only 3 items to be available in the store – however 5 can be purchased by anybody.

    Once the out of stock threshold has been reached – and not oversold – the item is as expected not for sale anymore.
    This issue only occurred when there are still items available for sale.

    Hope somebody has a workaround/solution/plug-in suggestion to help with this.

Viewing 11 replies - 1 through 11 (of 11 total)

  • Hello,

    I have set my out of stock limit to 2 items

    Just to clarify, are you referring to the “Out Of Stock Threshold” under Settings > Products > Inventory? If so, this setting changes the stock status when the stock count reaches the number entered – https://docs.woocommerce.com/document/configuring-woocommerce-settings/#products-inventory-options

    If you’d like to limit the allowed number of backorders, you’d need to use a plugin like https://www.ads-software.com/plugins/woo-backorder-manager/

    Thread Starter dermreagle

    (@dermreagle)

    Good day,

    Thanks for the reply.

    Yes I am referring to the out of stock threshold.
    If I set the threshold to 2. with 5 products in stock – I expect only 3 items to be left for sale. However a customer can still add 5 pieces to their cart and submit the order.
    This is not ideal.
    We do not work with Backorders – as our products are all once off productions.

    Hello,

    Thank you for clarifying. Could you also make sure backorders are not allowed in your product settings?

    If I set the threshold to 2. with 5 products in stock – I expect only 3 items to be left for sale.

    If backorders are not allowed, then only 3 items should be purchasable in this case. If your customers can still purchase more than 3, then I’d suspect the issue is caused by a conflict with a plugin or theme – in which case, I recommend running a conflict test explained here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/

    Thread Starter dermreagle

    (@dermreagle)

    Hi,

    I can confirm all backorders are not allowed.
    Have removed any plugins that have anything to do with stock/inventory. I had ATUM installed.

    And still I can purchase all remaining stock – if levels are above 2.

    Theme i am using is the default storefront by Woocommerce.

    Scratching my head trying to understand this.

    Hi @dermreagle

    I can confirm all backorders are not allowed.

    Thank you for the confirmation. Ok, then it’s likely a conflict issue with your plugin – it could be one that’s not related to inventory. To determine this, please disable all plugins except for WooCommerce.

    If the problem is solved after that, then the issue is with the plugins 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.

    Thread Starter dermreagle

    (@dermreagle)

    Good day,

    Thanks for the recommendation.

    Just disabled all Plugins – and it still allowed me to purchase all 5 items – with the stock set to be out of stock at 2 items.

    I also checked – items currently with only 2 in stock are marked out of stock as it should be.

    Hi again,

    Could you share your store 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.

    Thread Starter dermreagle

    (@dermreagle)

    https://neovisiongroup.co.za/store

    Note this is a b2b store and hidden from Public – can grant access to the store only via AnyDesk.

    
### WordPress Environment ###

WordPress address (URL): https://neovisiongroup.co.za/store
Site address (URL): https://neovisiongroup.co.za/store
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: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.15
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 10.3.27-MariaDB-cll-lve
Max Upload Size: 2 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: wp4e_
Total Database Size: 21.44MB
Database Data Size: 18.98MB
Database Index Size: 2.46MB
wp4e_woocommerce_sessions: Data: 0.13MB + Index: 0.01MB + Engine MyISAM
wp4e_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_woocommerce_order_items: Data: 0.14MB + Index: 0.08MB + Engine MyISAM
wp4e_woocommerce_order_itemmeta: Data: 1.34MB + Index: 0.93MB + Engine MyISAM
wp4e_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_actionscheduler_actions: Data: 0.09MB + Index: 0.05MB + Engine MyISAM
wp4e_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_actionscheduler_logs: Data: 0.06MB + Index: 0.05MB + Engine MyISAM
wp4e_atum_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_atum_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_atum_product_data: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp4e_berocket_termmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_braapf_product_stock_status_parent: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_braapf_product_variation_attributes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_braapf_term_taxonomy_hierarchical: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_braapf_variation_attributes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_comments: Data: 0.20MB + Index: 0.05MB + Engine MyISAM
wp4e_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_ocwma_billingadress: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp4e_options: Data: 2.69MB + Index: 0.08MB + Engine MyISAM
wp4e_postmeta: Data: 8.59MB + Index: 0.53MB + Engine MyISAM
wp4e_posts: Data: 5.18MB + Index: 0.12MB + Engine MyISAM
wp4e_stock_log: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp4e_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp4e_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_term_relationships: Data: 0.05MB + Index: 0.11MB + Engine MyISAM
wp4e_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_usermeta: Data: 0.16MB + Index: 0.06MB + Engine MyISAM
wp4e_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp4e_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_wc_order_product_lookup: Data: 0.25MB + Index: 0.20MB + Engine MyISAM
wp4e_wc_order_stats: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp4e_wc_order_tax_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_wc_product_meta_lookup: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
wp4e_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp4e_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp4e_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp4e_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

attachment: 546
br_product_filter: 1
customize_changeset: 10
page: 7
post: 4
postman_sent_mail: 250
product: 183
product_variation: 11
revision: 14
shop_order: 102
shop_order_refund: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (11) ###

Multiple Shipping Address Woocommerce: by Ocean Infotech – 1.0
Product Code for WooCommerce: by Artios Media – 1.2.4
WC Duplicate Order: by Jamie Gill – 1.7
Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.8
Show Single Variations Shop & Category for WooCommerce: by Gravity Master – 2.0
Advanced AJAX Product Filters for WooCommerce: by BeRocket – 1.5.2.10
WooCommerce PDF Invoices: by Bas Elbers – 3.1.4
WooCommerce Private Store: by Barn2 Plugins – 1.6.3
WooCommerce: by Automattic – 5.1.0
WP Mail SMTP: by WPForms – 2.6.0
WPO365 | LOGIN: by [email protected] – 12.10

### Inactive Plugins (0) ###

### Dropin Plugins (1) ###

maintenance.php: maintenance.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: ZAR (R)
Currency Position: left
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 ###

Shop base: #9 - /
Cart: #10 - /cart/
Checkout: #11 - /checkout/
My account: #12 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Storefront
Version: 3.5.0
Author URL: https://woocommerce.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 ###

Canceled: 1
Oldest: 2021-03-07 09:26:27 +0000
Newest: 2021-03-07 09:26:27 +0000

Complete: 348
Oldest: 2021-02-14 10:13:52 +0000
Newest: 2021-03-10 15:52:48 +0000

Pending: 2
Oldest: 2021-03-11 00:00:00 +0000
Newest: 2021-03-11 00:00:39 +0000

### Status report information ###

Generated at: 2021-03-10 17:59:56 +02:00

    Hello,

    it still allowed me to purchase all 5 items – with the stock set to be out of stock at 2 items.

    Sorry for the late reply. I did further testing and research on this, and I can confirm the same results – with your settings, customer still can purchase the remaining stock quantity (5) even though out of stock threshold is set to 2.
    I believe this is something that should be improved. So I’ve submitted a report on GitHub. You can follow the post here: https://github.com/woocommerce/woocommerce/issues/29411

    Thread Starter dermreagle

    (@dermreagle)

    Thank you very much.

    Hi @dermreagle

    I’m closing this thread as I can see you had followed the GitHub thread. Although it won’t be fixed since intended, I can suggest adding a improvement request to our Ideas Board. There’s no guarantee on when/if this will be improved, but it may be worth a try ??

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Overselling out of Stock items’ is closed to new replies.