Sequential Order Numbers for WooCommerce still skipping order numbers

Hi Tomas,

Thanks for reaching out.

Could you please share your WooCommerce system status report (WooCommerce>status>system status report) to have a better understanding of your system environment? It will help us assess the issue you are facing.

`
### WordPress Environment ###

WordPress address (URL): https://www.tzw.se/wordpress
Site address (URL): https://www.tzw.se
WC Version: 8.4.0
REST API Version: ? 8.4.0
WC Blocks Version: ? 11.6.2
Action Scheduler Version: ? 3.7.0
Log Directory Writable: ?
WP Version: 6.4.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: sv_SE
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.58 (FreeBSD) mpm-itk/2.4.7-04 PHP/8.1.27
PHP Version: 8.1.27
PHP Post Max Size: 200 MB
PHP Time Limit: 180
PHP Max Input Vars: 5000
cURL Version: 8.5.0
OpenSSL/1.1.1t

SUHOSIN Installed: –
MySQL Version: 10.6.16-MariaDB-log
Max Upload Size: 200 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 8.4.0
WC Database Prefix: wp_
Total databasstorlek: 8.81MB
Datastorlek f?r databas: 6.95MB
Indexstorlek f?r databas: 1.86MB
wp_woocommerce_sessions: Data: 0.08MB + Index: 0.02MB + Motor InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.03MB + Motor InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_actionscheduler_actions: Data: 0.06MB + Index: 0.11MB + Motor InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_actionscheduler_logs: Data: 0.06MB + Index: 0.03MB + Motor InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_comments: Data: 0.05MB + Index: 0.09MB + Motor InnoDB
wp_duplicator_packages: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_options: Data: 4.06MB + Index: 0.08MB + Motor InnoDB
wp_postmeta: Data: 0.14MB + Index: 0.06MB + Motor InnoDB
wp_posts: Data: 1.45MB + Index: 0.06MB + Motor InnoDB
wp_snippets: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_usermeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Motor InnoDB
wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Motor InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Motor InnoDB
wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Motor InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Motor InnoDB

### Post Type Counts ###

attachment: 28
custom_css: 2
nav_menu_item: 8
page: 16
post: 2
product: 11
revision: 149
shop_order_placehold: 13
wp_global_styles: 1
wp_navigation: 1
wp_template: 2

### Security ###

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

### Active Plugins (12) ###

Code Snippets: av Code Snippets Pro – 3.6.2
Contact Coldform: av Jeff Starr – 20231019
Duplicator: av Duplicator – 1.5.8
Gallery Slider for WooCommerce: av WooGallery Slider Team
ShapedPlugin LLC – 2.0.1

Jetpack: av Automattic – 12.9.3
Menyikoner: av ThemeIsle – 0.13.8
Fonts Plugin | Google Fonts Typography: av Typsnittstill?gg – 3.4.9
Payment Plugins for PayPal WooCommerce: av Payment Plugins
[email protected] – 1.0.41

Sold Out Badge for WooCommerce: av Charlie Etienne – 4.4.0
WooCommerce Shipping & Tax: av WooCommerce – 2.4.2
WooCommerce: av Automattic – 8.4.0 (en uppdatering till version 8.5.1 finns tillg?nglig)
Sequential Order Numbers for WooCommerce: av WebToffee – 1.5.8

### Inactive Plugins (1) ###

Minimal Coming Soon & Maintenance Mode: av WebFactory Ltd – 2.37

### Settings ###

API Enabled: –
Force SSL: –
Currency: SEK (kr)
Currency Position: right_space
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 Woo.com: –
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: ?
HPOS feature enabled: ?
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: –

### WC Pages ###

Butikbas: #19 - /
Varukorg: #8 - /varukorg/
Kassan: #9 - /kassan/
Mitt konto: #10 - /mitt-konto/
Villkor: #11 - /aterbetalning_returer/

### Theme ###

Name: Storefront
Version: 4.5.3 (en uppdatering till version 4.5.4 finns tillg?nglig)
Author URL: https://woocommerce.com/
Child Theme: ? – Om du modifierar WooCommerce p? ett modertema som du sj?lv inte byggt
s? rekommenderar vi att du anv?nder ett barntema ist?llet. L?s: Hur du skapar ett barntema

WooCommerce Support: ?

### Templates ###

Overrides: /tzw.se/public_html/wordpress/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/error.php
/tzw.se/public_html/wordpress/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/notice.php
/tzw.se/public_html/wordpress/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/success.php


### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
product-virtual-downloadable
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: customize-store
minified-js
new-product-management-experience
product-external-affiliate
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-01-18 16:07:38 +01:00
Options: ?
Notes: 59
Onboarding: completed

### Action Scheduler ###

F?rdigbehandlad: 51
Oldest: 2023-12-18 22:19:33 +0100
Newest: 2024-01-18 02:09:24 +0100

Misslyckades: 1
Oldest: 2023-11-25 17:38:16 +0100
Newest: 2023-11-25 17:38:16 +0100

V?ntar: 1
Oldest: 2024-01-19 02:09:24 +0100
Newest: 2024-01-19 02:09:24 +0100


### Status report information ###

Generated at: 2024-01-18 12:10:47 +01:00
`

No idea? It’s still skipping numbers (ran all available updates).

Hi Tomas,

Thanks for getting back in touch and sharing the information.

We were unable to replicate the problem when we tested the scenario with the most recent version of our plugin. Can you please confirm that you are experiencing the issue of sequential order numbers being skipped every time an order is placed?

It would be helpful if you could share a screen recording of the order placement process and a screenshot of the WooCommerce order listing page via this link so that we can investigate the issue.

Tomas, are you using Checkout Blocks? Very likely it’s DRAFT Orders which are causing the gaps…

Hm, yes looks like that? It’s a pretty new store/install and I haven’t touched much. On the Checkout page it says that PayPal Gateway By Payment Plugins doesn’t support this block? It works though (but displays in English rather than the site language as set in settings).

Hi Tomas,?

Currently, our plugin does not exclude sequential order numbering for checkout-draft orders that are generated through checkout blocks. This may result in gaps in the sequential order series if draft orders are placed but not confirmed within 24 hours. Could you please confirm if this is the issue you are facing on your site? We have added draft order compatibility to our development backlog and will introduce it in future plugin updates. Thanks for understanding.

It’s using blocks yes, as that is the standard. I don’t know how to confirm there has been draft orders?

Hi?Tomas,?

You can easily identify draft orders by checking the WooCommerce order listing page. Please refer to the attached screenshot for more information

I think you can disable the creation of draft orders by leaving the field to Hold stock blank

I’ve seen a few draft orders, yes (not many orders in this store). Changed the hold stock setting now, thank you.

I tried it and it doesn’t work it seems, Woo blocks create draft orders automatically regardless… It’s a shame, I wished @webtoffeesupport could adjust the plugin so it ignores draft orders…

@webtoffeesupport your are awesome ??

Thank you for adjusting the plugin to ignore draft orders. I just tested it today and it works.

• This reply was modified 8 months ago by barnabas1.