• Resolved shivapentacove

    (@shivapentacove)


    Hi Team,

    I have disabled backorders at both product level and variation level and enabled stock management, and im still getting backorders.

    I noticed this happens mainly during a launch, when the last product is added to cart by two different people at the same time. So the cart allows the product to be added, and I don’t see a validation prior to checkout to see if the availability is present.

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

Viewing 10 replies - 1 through 10 (of 10 total)
  • Pranav R.

    (@pranavrana89)

    Hello @shivapentacove!

    Kindly note that variation level stock settings override main stock settings. Still, I tried a similar scenario; I disabled backorders at the product level as well as the level of the variations.

    Then, I opened two separate browser windows (Chrome and Chrome Incognito); simultaneously added the same item into the cart that has a stock of 1. The system let me add the items to the cart; but, at the payment/checkout level, I was only able to make the payment for one order. One of the checkout attempts failed.

    So, at the checkout level, the available stock is also checked. Following is the screenshot of the error I received:

    Are you able to replicate the issue on your end?

    If yes, this might be happening because of a plugin conflict or custom modifications. Please share your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

    Also, please check your error logs from the “WooCommerce > Status > Logs” section (you can filter the latest error logs from the top right corner of the screen). If you find any errors related to this problem, please take a screenshot of your full browser page, upload it on snipboard and paste the generated URL here.

    Best!

    Thread Starter shivapentacove

    (@shivapentacove)

    Hi Pranav,

    I think scenario pops up when the checkout is also clicked at the same time.

    Please find below the system status below,

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://foaclothing.com
    Site address (URL): https://foaclothing.com
    WC Version: 6.9.4
    REST API Version: ? 6.9.4
    WC Blocks Version: ? 8.6.0
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.1
    WP Multisite: –
    WP Memory Limit: 2 GB
    WP Debug Mode: ?
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: nginx/1.18.0
    PHP Version: 7.4.3
    PHP Post Max Size: 8 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.68.0
    OpenSSL/1.1.1f
    
    SUHOSIN Installed: –
    MySQL Version: 8.0.23
    Max Upload Size: 8 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.9.4
    WC Database Prefix: wp_
    Total Database Size: 567.02MB
    Database Data Size: 310.80MB
    Database Index Size: 256.22MB
    wp_woocommerce_sessions: Data: 17.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 1.52MB + Index: 0.38MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 15.55MB + Index: 9.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 2.02MB + Index: 1.83MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 2.02MB + Index: 1.73MB + Engine InnoDB
    wp_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 4.52MB + Index: 2.09MB + Engine InnoDB
    wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
    wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_e_submissions: Data: 3.52MB + Index: 5.89MB + Engine InnoDB
    wp_e_submissions_actions_log: Data: 0.08MB + Index: 0.17MB + Engine InnoDB
    wp_e_submissions_values: Data: 0.52MB + Index: 0.36MB + Engine InnoDB
    wp_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 8.48MB + Index: 0.33MB + Engine InnoDB
    wp_oses_attachments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_oses_clicks: Data: 1.52MB + Index: 0.19MB + Engine InnoDB
    wp_oses_email_attachments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_oses_emails: Data: 35.52MB + Index: 0.27MB + Engine InnoDB
    wp_oses_failures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_oses_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_postmeta: Data: 32.55MB + Index: 22.00MB + Engine InnoDB
    wp_posts: Data: 4.50MB + Index: 3.56MB + Engine InnoDB
    wp_term_relationships: Data: 0.19MB + Index: 0.16MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tinvwl_analytics: Data: 0.34MB + Index: 0.13MB + Engine InnoDB
    wp_tinvwl_items: Data: 0.27MB + Index: 0.00MB + Engine InnoDB
    wp_tinvwl_lists: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
    wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_usermeta: Data: 6.52MB + Index: 5.03MB + Engine InnoDB
    wp_users: Data: 0.42MB + Index: 0.30MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.47MB + Index: 0.42MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 1.52MB + Index: 1.13MB + Engine InnoDB
    wp_wc_order_stats: Data: 1.52MB + Index: 0.59MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.22MB + Index: 0.22MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.42MB + Index: 0.67MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wdr_order_discounts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wsal_metadata: Data: 103.64MB + Index: 178.58MB + Engine InnoDB
    wp_wsal_occurrences: Data: 64.59MB + Index: 20.06MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 2601
    cookielawinfo: 6
    custom_css: 1
    elementor_library: 31
    elementor_snippet: 4
    elementskit_content: 6
    envato_tk_import: 1
    giftcard: 8
    nav_menu_item: 41
    oembed_cache: 1
    page: 20
    post: 4
    product: 131
    product_variation: 1592
    pscw-size-chart: 84
    revision: 116
    shop_coupon: 33
    shop_order: 6171
    wcp_ruleset: 1
    wp_global_styles: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (34) ###
    
    Mintpay Price Breakdown: by Algoredge (PVT) LTD – 1.0
    Cities Shipping Zones for WooCommerce: by Condless – 1.1.9
    Cloudflare: by Cloudflare
    Inc. – 4.11.0
    
    Conditional Payments for WooCommerce: by Lauri Karisola / WP Trio – 2.3.1
    CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.3
    Disable Comments: by WPDeveloper – 2.4.2
    Elementor Pro: by Elementor.com – 3.7.3
    Elementor: by Elementor.com – 3.6.8
    ElementsKit Lite: by Wpmet – 2.7.2
    Essential Addons for Elementor: by WPDeveloper – 5.3.2
    Facebook for WooCommerce: by Facebook – 2.6.27
    Site Kit by Google: by Google – 1.84.0
    Koko WooCommerce Plugin: by dInnovation (Pvt) Ltd – 1.0.4
    Login No Captcha reCAPTCHA (Google): by Robert Peake and Contributors – 1.7
    Mintpay: by Mintpay (Private) Limited – 1.0.4
    WooCommerce - PayHere Payment Gateway: by PayHere (Private) Limited – 2.0.5
    Product Size Chart for WooCommerce: by VillaTheme – 1.1.1
    TI WooCommerce Wishlist: by TemplateInvaders – 2.0.6
    Visibility Logic for Elementor: by StaxWP – 2.3.2
    WooCommerce Weight Based Shipping: by weightbasedshipping.com – 5.3.24
    Ultimate Gift Cards For WooCommerce: by WP Swings – 2.4.5
    WooCommerce Blocks: by Automattic – 8.6.0
    Woo Payment Discounts: by WPCodelibrary – 1.3.0
    Product Feed PRO for WooCommerce: by AdTribes.io – 11.9.5
    WooCommerce Additional Variation Images: by WooCommerce – 1.9.0
    WooCommerce Buy One Get One Free: by Oscar Gare – 2.2.3
    Checkout Fields Manager for WooCommerce: by QuadLayers – 6.3.1
    WooSwatches - Woocommerce Color or Image Variation Swatches: by WooMatrix – 3.3.11
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.8
    WooCommerce: by Automattic – 6.9.4 (update to version 7.0.1 is available)
    WP Activity Log: by WP White Security – 4.4.2.1
    WP Offload SES Lite: by Delicious Brains – 1.4.6
    WPForms Lite: by WPForms – 1.7.7.1
    Smart Coupons For WooCommerce Coupons: by WebToffee – 1.4.2
    
    ### Inactive Plugins (2) ###
    
    WP-Optimize - Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.2.9
    
    WP Mail SMTP: by WPForms – 3.6.1
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (1) ###
    
    Elementor Safe Mode: by Elementor.com – 1.0.0
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: LKR (??)
    Currency Position: left
    Thousand Separator: 
    Decimal Separator: .
    Number of Decimals: 0
    Taxonomies: Product Types: external (external)
    gift-card (gift-card)
    grouped (grouped)
    simple (simple)
    variable (variable)
    wgm_gift_card (wgm_gift_card)
    
    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: –
    Enforce Approved Product Download Directories: –
    
    ### WC Pages ###
    
    Shop base: #2243 - /shop/
    Cart: #2449 - /cart/
    Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
    My account: #11 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Blank Canvas
    Version: 1.2.9
    Author URL: https://automattic.com/
    Child Theme: ?
    Parent Theme Name: Seedlet
    Parent Theme Version: 1.1.13
    Parent Theme Author URL: https://automattic.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: blank-canvas/woocommerce/emails/customer-processing-order.php
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    wc-pay-promotion
    wc-pay-welcome-page
    
    Disabled Features: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ? Next scheduled: 2022-11-03 03:56:54 +05:30
    Options: ?
    Notes: 107
    Onboarding: completed
    
    ### TI WooCommerce Wishlist Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Canceled: 1
    Oldest: 2022-10-29 12:09:39 +0000
    Newest: 2022-10-29 12:09:39 +0000
    
    Complete: 5,893
    Oldest: 2022-10-02 06:47:20 +0000
    Newest: 2022-11-02 06:27:16 +0000
    
    Pending: 6
    Oldest: 2022-11-02 08:47:40 +0000
    Newest: 2022-11-08 09:22:59 +0000
    
    ### Status report information ###
    
    Generated at: 2022-11-02 12:02:40 +05:30
    

    Nothing on the logs though.

    Hope you can help me out!

    Thank you.

    Pranav R.

    (@pranavrana89)

    Hello @shivapentacove!

    I see the following error in your SSR report:

    Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.

    This error means that your main checkout page doesn’t have the expected checkout shortcode. The checkout page in general has only the shortcode (as follows).

    Have you made any modifications to the checkout page/functionality of your site?
    If yes, the developer who originally coded this should be able to help you out.

    Otherwise, you can switch back to the default behavior to see if the problem persists. But, make sure to take a backup of your site before proceeding.

    Best!

    Thread Starter shivapentacove

    (@shivapentacove)

    Hey Pranav,

    I have built the checkout page using woocommerce pages element. Could this be the issue?

    Thank you.

    Pranav R.

    (@pranavrana89)

    Hi @shivapentacove!

    I believe you are referring to Elementor Pro’s feature of updating WooCommerce pages. If that is the case, I suggest you get in touch with their support.

    We can best assist with the default WooCommerce setup. You can switch back to the default checkout system for now; clear all caches, and if the problem persists after that, let us know.

    Best!

    Thread Starter shivapentacove

    (@shivapentacove)

    Hi Pranav,

    I’ve been running a couple of test and still unsuccessful on this, just wanted to check with you when you mentioned “at the payment/checkout level, I was only able to make the payment for one order. One of the checkout attempts failed.”, did you click the checkout at the same time?

    I tried with the basic Woocommerce checkout and it had the same issue.

    Thread Starter shivapentacove

    (@shivapentacove)

    Hey Pranav,

    here is the new system report post fixing the checkout shortcode

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://foaclothing.com
    Site address (URL): https://foaclothing.com
    WC Version: 7.1.0
    REST API Version: ? 7.1.0
    WC Blocks Version: ? 9.0.0
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.1.1
    WP Multisite: –
    WP Memory Limit: 2 GB
    WP Debug Mode: ?
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: nginx/1.18.0
    PHP Version: 7.4.3
    PHP Post Max Size: 8 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.68.0
    OpenSSL/1.1.1f
    
    SUHOSIN Installed: –
    MySQL Version: 8.0.23
    Max Upload Size: 8 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.9.4
    WC Database Prefix: wp_
    Total Database Size: 929.85MB
    Database Data Size: 507.13MB
    Database Index Size: 422.72MB
    wp_woocommerce_sessions: Data: 4.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 1.52MB + Index: 1.50MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 25.56MB + Index: 13.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 4.02MB + Index: 5.70MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 3.02MB + Index: 3.38MB + Engine InnoDB
    wp_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 5.52MB + Index: 4.77MB + Engine InnoDB
    wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
    wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_e_submissions: Data: 5.52MB + Index: 9.05MB + Engine InnoDB
    wp_e_submissions_actions_log: Data: 0.08MB + Index: 0.17MB + Engine InnoDB
    wp_e_submissions_values: Data: 1.52MB + Index: 0.56MB + Engine InnoDB
    wp_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 16.08MB + Index: 1.22MB + Engine InnoDB
    wp_oses_attachments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_oses_clicks: Data: 2.52MB + Index: 0.44MB + Engine InnoDB
    wp_oses_email_attachments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_oses_emails: Data: 84.52MB + Index: 1.52MB + Engine InnoDB
    wp_oses_failures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_oses_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_postmeta: Data: 38.56MB + Index: 27.00MB + Engine InnoDB
    wp_posts: Data: 6.48MB + Index: 3.66MB + Engine InnoDB
    wp_term_relationships: Data: 0.19MB + Index: 0.16MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tinvwl_analytics: Data: 0.39MB + Index: 0.23MB + Engine InnoDB
    wp_tinvwl_items: Data: 0.34MB + Index: 0.00MB + Engine InnoDB
    wp_tinvwl_lists: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
    wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_usermeta: Data: 8.52MB + Index: 7.98MB + Engine InnoDB
    wp_users: Data: 1.52MB + Index: 0.50MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 1.52MB + Index: 0.50MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 2.52MB + Index: 1.45MB + Engine InnoDB
    wp_wc_order_stats: Data: 1.52MB + Index: 0.77MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.22MB + Index: 0.20MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.42MB + Index: 0.67MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wdr_order_discounts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wdr_order_item_discounts: Data: 0.28MB + Index: 0.22MB + Engine InnoDB
    wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wsal_metadata: Data: 176.72MB + Index: 304.83MB + Engine InnoDB
    wp_wsal_occurrences: Data: 112.64MB + Index: 32.11MB + Engine InnoDB
    wp_wt_sc_coupon_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 2607
    cookielawinfo: 6
    custom_css: 1
    elementor_library: 33
    elementor_snippet: 4
    elementskit_content: 6
    envato_tk_import: 1
    giftcard: 8
    nav_menu_item: 39
    oembed_cache: 1
    page: 21
    post: 6
    product: 128
    product_variation: 1591
    pscw-size-chart: 84
    revision: 193
    shop_coupon: 39
    shop_order: 7973
    wcp_ruleset: 1
    wp_global_styles: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (34) ###
    
    WP Activity Log (Premium): by WP White Security – 4.4.2.2
    Mintpay Price Breakdown: by Algoredge (PVT) LTD – 1.0
    Cities Shipping Zones for WooCommerce: by Condless – 1.2
    Cloudflare: by Cloudflare
    Inc. – 4.11.0
    
    Conditional Payments for WooCommerce: by Lauri Karisola / WP Trio – 2.3.1
    CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.5
    Disable Comments: by WPDeveloper – 2.4.2
    Elementor Pro: by Elementor.com – 3.7.3
    Elementor: by Elementor.com – 3.6.8
    ElementsKit Lite: by Wpmet – 2.7.5
    Essential Addons for Elementor: by WPDeveloper – 5.4.4
    Facebook for WooCommerce: by Facebook – 3.0.4
    Site Kit by Google: by Google – 1.88.0
    Koko WooCommerce Plugin: by dInnovation (Pvt) Ltd – 1.0.4
    Login No Captcha reCAPTCHA (Google): by Robert Peake and Contributors – 1.7
    Mintpay: by Mintpay (Private) Limited – 1.0.4
    WooCommerce - PayHere Payment Gateway: by PayHere (Private) Limited – 2.0.5
    Product Size Chart for WooCommerce: by VillaTheme – 1.1.1
    TI WooCommerce Wishlist: by TemplateInvaders – 2.0.15
    Visibility Logic for Elementor: by StaxWP – 2.3.2
    WooCommerce Weight Based Shipping: by weightbasedshipping.com – 5.3.26
    Ultimate Gift Cards For WooCommerce: by WP Swings – 2.4.7
    WooCommerce Blocks: by Automattic – 9.0.0
    Woo Payment Discounts: by WPCodelibrary – 1.3.0
    Product Feed PRO for WooCommerce: by AdTribes.io – 12.0.3
    WooCommerce Additional Variation Images: by WooCommerce – 1.9.0
    WooCommerce Buy One Get One Free: by Oscar Gare – 2.2.3
    Checkout Fields Manager for WooCommerce: by QuadLayers – 6.3.5
    WooSwatches - Woocommerce Color or Image Variation Swatches: by WooMatrix – 3.3.11
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.17
    WooCommerce: by Automattic – 7.1.0
    WP Offload SES Lite: by Delicious Brains – 1.4.6
    WPForms Lite: by WPForms – 1.7.8
    Smart Coupons For WooCommerce Coupons: by WebToffee – 1.4.3
    
    ### Inactive Plugins (4) ###
    
    Woo Discount Rules: by Flycart – 2.5.2
    WP-Optimize - Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.2.9
    
    WP Activity Log: by WP White Security – 4.4.2.1
    WP Mail SMTP: by WPForms – 3.6.1
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: LKR (??)
    Currency Position: left
    Thousand Separator: 
    Decimal Separator: .
    Number of Decimals: 0
    Taxonomies: Product Types: external (external)
    gift-card (gift-card)
    grouped (grouped)
    simple (simple)
    variable (variable)
    wgm_gift_card (wgm_gift_card)
    
    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: –
    Enforce Approved Product Download Directories: –
    
    ### WC Pages ###
    
    Shop base: #2243 - /shop/
    Cart: #2449 - /cart/
    Checkout: #4251 - /checkout/
    My account: #11 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Blank Canvas
    Version: 1.2.9
    Author URL: https://automattic.com/
    Child Theme: ?
    Parent Theme Name: Seedlet
    Parent Theme Version: 1.1.13
    Parent Theme Author URL: https://automattic.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: blank-canvas/woocommerce/emails/customer-processing-order.php
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    
    Disabled Features: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ? Next scheduled: 2022-12-01 03:56:54 +05:30
    Options: ?
    Notes: 109
    Onboarding: completed
    
    ### TI WooCommerce Wishlist Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 10,619
    Oldest: 2022-10-30 10:59:36 +0000
    Newest: 2022-11-30 10:13:23 +0000
    
    Pending: 7
    Oldest: -0001-11-30 00:00:00 +0000
    Newest: 2022-12-06 09:23:35 +0000
    
    ### Status report information ###
    
    Generated at: 2022-11-30 15:44:44 +05:30
    

    Hello,

    You can perform a conflict test to check if there is a theme or plugin affecting the normal behavior.

    If you would not like to touch the live site during the test, we recommend WP Staging for quickly spinning up a new test site. Once it is created, you can disable all plugins except WooCommerce, and make a test order, try to order the same product on two browsers, check if the back-order occurs again or not, more info is below:

    https://docs.woocommerce.com/document/how-to-test-for-conflicts/

    Let us know how this goes for you.

    Thread Starter shivapentacove

    (@shivapentacove)

    Hey Igor,

    We tried the conflict test and the issue can be recreated, can you follow the below steps, please understand this issue occurs when you use a payment gateway outside of the site, such a paypal gateway.

    `I have a product that has 1 item in stock. I proceed to buy it and decide to pay via PayPal. I am redirected to Paypal while the order get placed but leaving the order as Pending Payment and stock isn’t reduced.

    In the meantime, another customer is able to purchase the item through another immediate payment method. The stock is now 0.

    When my payment on payment is also completed and redirected back to the main site. The order is successfully processed and the stock of the item is reduced to -1.

    I have disabled all backorders.

    This issue comes into play when you have an IPG outside the site, such as paypal. where the site needs to send a request and wait for a response, in the meantime another customer is able to purchase that item.

    Can you help on how we can fix this. I’m thinking of reducing the stock as soon as a order is placed, even in pending payment state, so the hold time will release the stock if a payment is not recieved in the give period, can you help me with hooks to achieve this?

    Thread Starter shivapentacove

    (@shivapentacove)

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Backorders are being placed even after disabling backorder at product level’ is closed to new replies.