• Resolved antoinetech

    (@antoinetech)


    We have an issue when changing orders status in batches from “Processing” to “Completed”. Currently, invoice numbing is triggered on “Completed” status changes, however when switching multiple orders at the same time form the Orders List Page we have duplicate invoice numbers for two orders. This issue happens in pairs, so if we batch change 10 orders we end up with about 5 duplicate invoice numbers.

    Any suggestions to correct this issue would be greatly appreciated. Perhaps a slight pause between invoice creations?

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author webtoffee

    (@webtoffee)

    Hi @antoinetech,

    We have tested the scenario but couldn’t replicate the duplicate number issues. The invoice number generation works perfectly well in the testing site.

    Please share your woocommerce system report. Go to WooCommerce > Status > Select Get System Report and copy/paste it here.

    Thread Starter antoinetech

    (@antoinetech)

    
    ### WordPress Environment ###
    
    WC Version: 4.4.0
    REST API Version: ✔ 1.0.15
    WC Blocks Version: ✔ 3.1.0
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 1.4.0
    Log Directory Writable: ✔
    WP Version: ❌ 5.4.4 - There is a newer version of WordPress available (5.6)
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_GB
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.25 (Debian)
    PHP Version: 7.4.13
    PHP Post Max Size: 20 MB
    PHP Time Limit: 600
    PHP Max Input Vars: 3500
    cURL Version: 7.52.1
    OpenSSL/1.0.2u
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.27-MariaDB-1:10.3.27+maria~stretch-log
    Max Upload Size: 20 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 4.4.0
    WC Database Prefix: wp_
    Total Database Size: 207.03MB
    Database Data Size: 166.02MB
    Database Index Size: 41.01MB
    wp_woocommerce_sessions: Data: 8.02MB + Index: 1.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.22MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 7.52MB + Index: 8.95MB + 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: 9.19MB + 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: 6.03MB + Engine InnoDB
    wp_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_bv_ip_store: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 3.52MB + Index: 0.83MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailjet_wc_abandoned_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailjet_wc_abandoned_cart_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailjet_wc_guests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 4.33MB + Index: 0.23MB + Engine InnoDB
    wp_osapi_last_modified: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_postmeta: Data: 121.52MB + Index: 6.88MB + Engine InnoDB
    wp_posts: Data: 5.50MB + Index: 0.39MB + Engine InnoDB
    wp_prflxtrflds_fields_id: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_prflxtrflds_fields_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_prflxtrflds_field_values: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_prflxtrflds_roles_and_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_prflxtrflds_roles_id: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_prflxtrflds_user_field_data: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_prflxtrflds_user_roles: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 3.52MB + Index: 5.03MB + Engine InnoDB
    wp_users: Data: 0.17MB + Index: 0.17MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 1.47MB + Index: 0.86MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.11MB + Index: 0.08MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.08MB + Index: 0.09MB + 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_wfpklist_template_data: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woodmart_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woodmart_wishlist_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpml_mails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yoast_indexable: Data: 0.08MB + Index: 0.08MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    afreg_fields: 1
    attachment: 279
    cms_block: 10
    csp_rules: 2
    fl-builder-template: 7
    nav_menu_item: 16
    page: 21
    post: 5
    postman_sent_mail: 89
    product: 64
    product_variation: 266
    revision: 421
    shop_coupon: 20
    shop_order: 677
    shop_order_refund: 18
    woodmart_slide: 6
    wpforms: 1
    ywdpd_discount: 5
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (33) ###
    
    B2B for WooCommerce: by Addify – 1.2.5
    Beaver Builder Plugin (Standard Version): by The Beaver Builder Team – 2.4.0.2
    Ultimate Addons for Beaver Builder: by Brainstorm Force – 1.28.4
    Custom Order Numbers for WooCommerce: by Tyche Softwares – 1.2.10 – Installed version not tested with active version of WooCommerce 4.4.0
    Disable PW Notification EMails: by  –
    Duplicate Page and Post: by Arjun Thakur – 2.6.3
    ELEX WooCommerce Role-based Pricing Plugin & WooCommerce Catalog Mode: by ELEXtensions – 2.6.0 – Installed version not tested with active version of WooCommerce 4.4.0
    MonsterInsights - eCommerce Addon: by MonsterInsights Team – 7.3.7
    MonsterInsights Pro: by MonsterInsights – 7.12.2
    Head, Footer and Post Injections: by Stefano Lissa – 3.2.1
    Import and export users and customers: by codection – 1.15.7
    James and James Fulfilment Stock Feed: by KiBoDo – 18.4.0 – Installed version not tested with active version of WooCommerce 4.4.0
    Mailjet for WordPress: by Mailjet SAS – 5.2.1
    MalCare Security - Free Malware Scanner, Protection & Security for WordPress: by MalCare Security – 4.4
    Members: by MemberPress – 3.0.10
    Profile Extra Fields by BestWebSoft: by BestWebSoft – 1.1.9
    Safe SVG: by Daryll Doyle – 1.9.9
    SendCloud | Smart Shipping Service: by SendCloud B.V. – 1.1.2
    WooCommerce Split Orders: by Vibe Agency – 1.1.0
    Theme My Login: by Theme My Login – 7.1.1
    Aelia Foundation Classes for WooCommerce: by Aelia – 2.0.21.200629 – Installed version not tested with active version of WooCommerce 4.4.0
    Shipping Method Display Style for WooCommerce: by theDotstore – 3.6 – Installed version not tested with active version of WooCommerce 4.4.0
    Aelia Currency Switcher for WooCommerce: by Aelia – 4.6.7.181124 – Installed version not tested with active version of WooCommerce 4.4.0
    WooCommerce EU VAT Number: by WooCommerce – 2.3.20 – Installed version not tested with active version of WooCommerce 4.4.0
    WooCommerce Product Table: by Barn2 Plugins – 2.6.4
    WooCommerce Xero Integration: by WooCommerce – 1.7.33 – Installed version not tested with active version of WooCommerce 4.4.0
    WooCommerce: by Automattic – 4.4.0 (update to version 4.8.0 is available)
    Woodmart Core: by  – 1.0.22
    WordPress Importer: by wordpressdotorg – 0.7
    Yoast SEO: by Team Yoast – 14.9
    WPForms Lite: by WPForms – 1.6.2.2
    WooCommerce PDF Invoices, Packing Slips, Delivery Notes & Shipping Labels: by WebToffee – 4.0.8 – Installed version not tested with active version of WooCommerce 4.4.0
    YITH WooCommerce Dynamic Pricing and Discounts Premium: by YITHEMES – 1.4.5 – Installed version not tested with active version of WooCommerce 4.4.0
    
    ### Inactive Plugins (7) ###
    
    Bulk Delete: by Sudar – 6.0.2
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.11.0
    Manage Notification E-mails: by Virgial Berveling – 1.5.1
    Privy Website Widget: by Privy Inc. – 2.0.11
    WooCommerce Show Attributes: by Isabel Castillo – 1.6.4 – Installed version not tested with active version of WooCommerce 4.4.0
    WPBakery Page Builder: by Michael M - WPBakery.com – 6.2.0
    WP Server Stats: by Saumya Majumder
    Acnam Infotech – 1.6.9
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: EUR (€)
    Currency Position: left
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    woosb (woosb)
    
    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: #84 - /shop
    Basket: #85 - /cart
    Checkout: #86 - /checkout
    My account: #87 - /my-account
    Terms and conditions: #1004 - /terms-and-conditions
    
    ### Theme ###
    
    Name: Woodmart Child
    Version: 1.0.0
    Author URL: http://xtemos.com
    Child Theme: ✔
    Parent Theme Name: Woodmart
    Parent Theme Version: 4.6.0
    Parent Theme Author URL: http://themeforest.net/user/xtemos
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: woodmart/woocommerce/archive-product.php
    woodmart/woocommerce/cart/cart-item-data.php
    woodmart/woocommerce/cart/cart.php version 3.8.0 is out of date. The core version is 4.4.0
    woodmart/woocommerce/cart/cross-sells.php version 3.0.0 is out of date. The core version is 4.4.0
    woodmart/woocommerce/cart/mini-cart.php
    woodmart/woocommerce/checkout/form-checkout.php
    woodmart/woocommerce/checkout/thankyou.php
    woodmart/woocommerce/content-product.php
    woodmart/woocommerce/content-product_cat.php
    woodmart/woocommerce/content-single-product.php
    woodmart/woocommerce/content-widget-product.php
    woodmart/woocommerce/global/breadcrumb.php
    woodmart/woocommerce/global/form-login.php
    woodmart/woocommerce/global/quantity-input.php
    woodmart/woocommerce/loop/add-to-cart.php
    woodmart/woocommerce/loop/loop-end.php
    woodmart/woocommerce/loop/loop-start.php
    woodmart/woocommerce/loop/no-products-found.php
    woodmart/woocommerce/loop/orderby.php
    woodmart/woocommerce/loop/pagination.php
    woodmart/woocommerce/loop/sale-flash.php
    woodmart/woocommerce/myaccount/form-login.php version 3.6.0 is out of date. The core version is 4.1.0
    woodmart/woocommerce/product-searchform.php
    woodmart/woocommerce/single-product/add-to-cart/grouped.php
    woodmart/woocommerce/single-product/add-to-cart/variable.php
    woodmart/woocommerce/single-product/meta.php
    woodmart/woocommerce/single-product/product-image.php
    woodmart/woocommerce/single-product/product-thumbnails.php
    woodmart/woocommerce/single-product/rating.php
    woodmart/woocommerce/single-product/related.php
    woodmart/woocommerce/single-product/sale-flash.php
    woodmart/woocommerce/single-product/tabs/tabs.php
    woodmart/woocommerce/single-product/title.php version 1.6.4 is out of date. The core version is 4.4.0
    woodmart/woocommerce/single-product/up-sells.php
    woodmart/woocommerce/single-product.php
    
    Outdated Templates: ❌
    					
    					
    						Learn how to update
    
    ### Action Scheduler ###
    
    Complete: 9,833
    Oldest: 2020-11-27 08:53:31 +0000
    Newest: 2020-12-28 02:49:30 +0000
    
    Failed: 4
    Oldest: 2020-07-22 09:21:09 +0000
    Newest: 2020-09-04 07:25:12 +0000
    
    Pending: 2
    Oldest: 2020-12-28 17:27:31 +0000
    Newest: 2020-12-29 02:49:30 +0000
    
    
    • This reply was modified 3 months, 3 weeks ago by antoinetech.
    Thread Starter antoinetech

    (@antoinetech)

    Some IMPORTANT additional information I found out from client:

    The bulk order status change is NOT coming from Woo’s order list page. It is being initiated from a third party plugin (James and James) through API. I believe J&J sends multiple status change requests at the same time for separate orders.

    When viewing the order notes with duplicate invoice numbers the time the orders are changed from “Processing to Completed” are identical (i.e. “Order status changed from Processing to Completed. – 23/12/2020 at 18:20”).

    This would explain how its bypassing the order of operation for creating sequential numbers (line 231-235 sequential-number.php).

    • This reply was modified 3 months, 3 weeks ago by antoinetech.
    Plugin Author webtoffee

    (@webtoffee)

    Hi @antoinetech,

    In that case, we have certain limitations in assisting you. Can you share that plugin link?

    Plugin Author webtoffee

    (@webtoffee)

    Hi @antoinetech,

    This thread has been inactive for a bit, so I’m going to mark it as resolved now. Please feel free to open a new thread if you have any further questions or still need help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.