Duplicate Numbers
-
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)
-
### 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: https://xtemos.com Child Theme: ? Parent Theme Name: Woodmart Parent Theme Version: 4.6.0 Parent Theme Author URL: https://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 +0000Some 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).
Viewing 5 replies - 1 through 5 (of 5 total)
- The topic ‘Duplicate Numbers’ is closed to new replies.
