Support » Plugin: WooCommerce » Backorders issue

  • Resolved essmeier

    (@essmeier)


    I have a store where I sell one of a kind items. My inventory is binary; it’s either in stock or sold out. AFAIK, I have nothing checked anywhere to enable backorders.

    When creating individual product pages, I enable stock management, set quantity to 1 and set backorders to “do not allow.’

    Problem: When I sell an item, it still shows an available quantity of 1 to site visitors, giving the impression that it’s available for purchase.

    If I go to Woocommerce -> Products, that product is shown as “on backorder,” rather than “out of stock,” with an inventory count of 0. The system is correctly decrementing inventory when a sale is made, but incorrectly marking sold items as “on backorder.”

    If I edit the product page, it correctly shows an in-stock quantity of 0. If I click “update” without changing anything, the published page then shows as “out of stock” to site visitors and it updates on the Woocommerce -> Products page from “on backorder” to “out of stock.”

    Any idea what’s happening here?

    
    ### WordPress Environment ###
    
    Home URL: https://www.rarerecords.net
    Site URL: https://www.rarerecords.net
    WC Version: 3.5.4
    Log Directory Writable: ✔
    WP Version: 5.0.3
    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.2.15
    PHP Post Max Size: 8 MB
    PHP Time Limit: 0
    PHP Max Input Vars: 1000
    cURL Version: 7.64.0
    OpenSSL/1.0.2q
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.41
    Max Upload Size: 2 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: 3.5.4
    WC Database Prefix: wp_
    MaxMind GeoIP Database: ✔
    Total Database Size: 65.62MB
    Database Data Size: 58.91MB
    Database Index Size: 6.71MB
    wp_woocommerce_sessions: Data: 33.71MB + Index: 1.71MB
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_order_items: Data: 0.04MB + Index: 0.02MB
    wp_woocommerce_order_itemmeta: Data: 0.19MB + Index: 0.15MB
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wp_blc_filters: Data: 0.00MB + Index: 0.00MB
    wp_blc_instances: Data: 0.13MB + Index: 0.03MB
    wp_blc_links: Data: 1.11MB + Index: 0.13MB
    wp_blc_synch: Data: 0.00MB + Index: 0.00MB
    wp_commentmeta: Data: 0.01MB + Index: 0.02MB
    wp_comments: Data: 0.05MB + Index: 0.03MB
    wp_gdpr_request_records: Data: 0.02MB + Index: 0.00MB
    wp_itsec_distributed_storage: Data: 0.00MB + Index: 0.00MB
    wp_itsec_fingerprints: Data: 0.00MB + Index: 0.00MB
    wp_itsec_geolocation_cache: Data: 0.00MB + Index: 0.00MB
    wp_itsec_lockouts: Data: 0.00MB + Index: 0.00MB
    wp_itsec_logs: Data: 0.00MB + Index: 0.01MB
    wp_itsec_temp: Data: 0.00MB + Index: 0.00MB
    wp_links: Data: 0.00MB + Index: 0.00MB
    wp_options: Data: 2.38MB + Index: 0.23MB
    wp_pmxe_exports: Data: 0.00MB + Index: 0.00MB
    wp_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB
    wp_pmxe_posts: Data: 0.00MB + Index: 0.00MB
    wp_pmxe_templates: Data: 0.00MB + Index: 0.00MB
    wp_pmxi_files: Data: 0.00MB + Index: 0.00MB
    wp_pmxi_history: Data: 0.00MB + Index: 0.00MB
    wp_pmxi_images: Data: 0.01MB + Index: 0.00MB
    wp_pmxi_imports: Data: 0.07MB + Index: 0.00MB
    wp_pmxi_posts: Data: 0.00MB + Index: 0.00MB
    wp_pmxi_templates: Data: 0.00MB + Index: 0.00MB
    wp_popularpostsdata: Data: 0.05MB + Index: 0.00MB
    wp_popularpostssummary: Data: 0.39MB + Index: 0.50MB
    wp_postmeta: Data: 9.39MB + Index: 2.19MB
    wp_posts: Data: 8.35MB + Index: 0.46MB
    wp_redirection_404: Data: 0.14MB + Index: 0.10MB
    wp_redirection_groups: Data: 0.00MB + Index: 0.00MB
    wp_redirection_items: Data: 0.01MB + Index: 0.01MB
    wp_redirection_logs: Data: 2.26MB + Index: 0.60MB
    wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB
    wp_termmeta: Data: 0.03MB + Index: 0.02MB
    wp_terms: Data: 0.02MB + Index: 0.05MB
    wp_term_relationships: Data: 0.15MB + Index: 0.32MB
    wp_term_taxonomy: Data: 0.03MB + Index: 0.03MB
    wp_usermeta: Data: 0.01MB + Index: 0.01MB
    wp_users: Data: 0.00MB + Index: 0.01MB
    wp_vtprd_purchase_log: Data: 0.00MB + Index: 0.00MB
    wp_vtprd_purchase_log_product: Data: 0.00MB + Index: 0.00MB
    wp_vtprd_purchase_log_product_rule: Data: 0.00MB + Index: 0.00MB
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    wp_wdp_orders: Data: 0.00MB + Index: 0.00MB
    wp_wdp_order_items: Data: 0.00MB + Index: 0.01MB
    wp_wdp_rules: Data: 0.02MB + Index: 0.00MB
    wp_woocommerce_exported_csv_items: Data: 0.08MB + Index: 0.01MB
    
    ### Post Type Counts ###
    
    attachment: 2772
    customize_changeset: 68
    custom_css: 1
    jetpack_migration: 2
    jp_img_sitemap: 4
    jp_img_sitemap_index: 2
    jp_pay_order: 1
    jp_sitemap: 2
    jp_sitemap_master: 2
    nav_menu_item: 13
    page: 37
    post: 65
    product: 679
    revision: 214
    shop_coupon: 30
    shop_order: 322
    shop_order_refund: 2
    tablepress_table: 1
    testimonial: 24
    turbo-sidebar-cpt: 13
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (41) ###
    
    Advanced Dynamic Pricing for WooCommerce: by AlgolPlus – 1.5.2
    Anti-spam: by webvitaly – 5.3
    Better Search Replace: by Delicious Brains – 1.3.2
    iThemes Security: by iThemes – 7.3.0
    Broken Link Checker: by Janis Elsts
    Vladimir Prelovac – 1.11.5
    
    Classic Editor: by WordPress Contributors – 1.4
    Cloudflare: by John Wineman
    Furkan Yilmaz
    Junade Ali (Cloudflare Team) – 3.3.2
    
    Contact Form 7 Honeypot: by Nocean – 1.14
    Contact Form 7: by Takayuki Miyoshi – 5.1.1
    Easy Testimonials: by Gold Plugins – 3.3.1
    Google XML Sitemaps: by Arne Brachhold – 4.1.0
    HTML Widget Text: by <a href="https://jaimyn.com.au">Jaimyn Mayer</a> – 1.1
    Jetpack by WordPress.com: by Automattic – 7.0.1
    PHP Compatibility Checker: by WP Engine – 1.4.7
    Platinum SEO Pack: by Rajesh - Techblissonline Dot Com – 1.3.8
    Really Simple SSL pro: by Rogier Lankhorst – 2.0.23
    Really Simple SSL: by Rogier Lankhorst
    Mark Wolters – 3.1.3
    
    Redirection: by John Godley – 3.7.3
    Simple Custom CSS: by John Regan
    Danny Van Kooten – 4.0.1
    
    Social Media Feather: by socialmediafeather – 1.8.4
    WP woocommerce featured product by category: by WP OnlineSupport – 1.1
    Spider Blocker: by Easy Blog Networks – 1.0.19
    Storefront Powerpack: by WooCommerce – 1.4.13 – 1.4.14 is available
    TablePress: by Tobias Bäthge – 1.9.1
    TinyMCE Advanced: by Andrew Ozz – 5.0.1
    WooCommerce Customer/Order CSV Export: by SkyVerge – 4.6.2
    WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.9
    WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.6.2
    WooCommerce Sequential Order Numbers Pro: by SkyVerge – 1.12.2
    WooCommerce Services: by Automattic – 1.18.0
    WooCommerce USPS Shipping: by WooCommerce – 4.4.20
    WooCommerce Shortcodes: by WooThemes
    Claudio Sanches – 1.0.0 – Not tested with the active version of WooCommerce
    
    WooCommerce: by Automattic – 3.5.4
    WordPress Popular Posts: by Hector Cabrera – 4.2.2
    WP All Export Pro: by Soflyy – 1.5.4
    WP All Import Pro: by Soflyy – 4.5.5
    Smush: by WPMU DEV – 3.1.1
    WP All Import - WooCommerce Add-On Pro: by Soflyy – 3.0.6
    WP GDPR Fix Pro: by TEKNIKFORCE – 1.7
    WPS Hide Login: by WPServeur
    NicolasKulka
    tabrisrp – 1.5.2.1
    
    Google XML Sitemap for Videos: by Amit Agarwal – 2.6.1
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    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)
    
    ### WC Pages ###
    
    Shop base: #4 - /store/
    Cart: #5 - /cart/
    Checkout: #6 - /checkout/
    My account: #7 - /my-account/
    Terms and conditions: #68 - /terms/
    
    ### Theme ###
    
    Name: Storefront Child
    Version: 1.0
    Author URL: http://woocommerce.com
    Child Theme: ✔
    Parent Theme Name: Storefront
    Parent Theme Version: 2.4.3
    Parent Theme Author URL: https://woocommerce.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    
    ### Customer/Order CSV Export ###
    
    Order Export Format: default
    Customer Export Format: default
    Automatically Export Orders: disabled
    Automatically Export Customers: disabled
    
    • This topic was modified 11 months ago by James Huff.
    • This topic was modified 11 months ago by essmeier. Reason: deleted extraneous content

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • essmeier

    (@essmeier)

    Made a sale this morning; sold three items.
    Each item was unique; I had a stock of 1 on each item.

    After the sale, the following conditions exist:

    1. All three items are showing as still available for purchase if you view them on the Website as a site visitor.
    2. All three items show “On Backorder” on the Woocommerce -> Products page.
    3. If I go to edit each of these three items, all three show stock quantity of 0 and Allow Backorders is set to “Do Not Allow.”

    As I had each item open for editing, I clicked the “Update” button without editing anything.

    After the refresh, all three items are now showing as “Out of Stock” on the Woocommerce -> Products page.

    Plugin Support grigaswp

    (@grigaswp)

    Hi there,

    Thank you for reaching out!

    I understand that despite backorders being disabled in the settings of your products – out of stock products are on backorder instead.

    Are those variable products by any chance?

    If it’s a variable product:

      1. Edit the product.
      2. Go to the Variations tab.
      3. Edit the variation.
      4. Ensure that Manage Stock is enabled, and Allow Backorders is set to Do not allow.

    A quick fix would be to go to WooCommerce > Settings > Inventory and tick the box next to Hide out of stock items from the catalog, but I have a feeling that this could be caused by a plugin/theme conflict and the best way to determine whether that’s the case is to do a full plugin/theme conflict test.

    From your System Status Report I do see that you have quite a few premium WooCommerce.com extensions so you should be eligible for premium support via chats and tickets on WooCommerce.com.

    If a plugin/theme conflict test doesn’t show the reason behind this behaviour – please head to Create a Ticket section on WooCommerce.com and submit a new support request with a link to this support thread. My colleagues will be happy to dig deeper into this for you.

    I hope this helps!

    essmeier

    (@essmeier)

    Not variable products.

    I think the problem may relate to products that I migrated from another shopping cart system.

    I just built my Woocommerce site in the past two weeks and migrated 95% of my products from a Shopp system using the paid Cart2Cart service. I’ve since added products to the store directly.

    Recently added “test” products decrement properly and show out of stock but the sales causing the problem were sales of products that had been migrated from the old cart.

    Perhaps there’s some issue with the migrated products so that they weren’t properly flagged as “do not allow backorders” in the database.

    Yesterday, I installed the Woocmmerce Bulk Stock Management plugin. I edited all of my products in bulk to reinforce the “Do not allow backorders” setting.

    I also upgraded Woocommerce to the new 3.5.5 version.

    I’m hoping that one of those two things will fix the problem, though I’ll need a “real” sale to verify that.

    I just added a test product and used my wife’s PayPal account to make a purchase and everything worked correctly, with inventory showing “out of stock” on both the product page and the Woocommerce -> Products page.

    I’ll have a “real” sale soon enough and that should tell me if the problem is fixed. I’ll update here with the results of that.

    Plugin Support grigaswp

    (@grigaswp)

    Hi there,

    Thank you for the additional details and your attempted solutions!

    Indeed, an import could definitely be the root cause here. If the solutions you’ve tried so far will not help – you could try exporting all products, making sure this particular set of data is included in the .csv file and re-importing the products.

    Please let us know if Bulk Stock Manager or export/re-import won’t solve this, otherwise we’ll mark this thread as resolved next week.

    I just made a sale of one of the products in my store that had been migrated to Woocommerce from the old Shopp cart.

    As a result of the sale:

    1. Inventory decremented from 1 item to 0.
    2. Item correctly shows “Out of Stock” on the product page.
    3. Item correctly shows “Out of Stock” on the Woocommerce -> Products page.

    Don’t know if it was the bulk edit or the upgrade to Woocommerce 3.5.5 that fixed it, but it seems to be working now.

    If I had to wager, I’d guess that it was the bulk edit that solved the problem.

    All good now. Thanks for the help.

    • This reply was modified 10 months, 4 weeks ago by essmeier.
    Plugin Support grigaswp

    (@grigaswp)

    Hi there,

    I’m glad to hear that product stock level statuses are correct now! You’re right, re-saving the products probably did the trick.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Backorders issue’ is closed to new replies.