50k Jump in Order ID Numbers

Hi @joelp24,

I did make some edits to pages yesterday but did not touch the WooCommerce settings or update any plugins.

To see if there’s a connection, could you kindly share more info about these changes? Perhaps, did the changes touch on post IDs?

Just to add, some plugins that offer the functionality of ordering posts/orders sequentially can cause such modifications in the numbers. To get a better view of your setup, is it possible to share with us your System Status from WooCommerce → Status?

Thanks.

Thank You!

### WordPress Environment ###

WordPress address (URL): [removed for privacy]
Site address (URL): [removed for privacy]
WC Version: 5.3.1
REST API Version: ? 5.3.1
WC Blocks Version: ? 4.9.1
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.2.6
Log Directory Writable: ?
WP Version: ? 5.7.2 - There is a newer version of WordPress available (5.8.1)
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.22
PHP Post Max Size: 32 MB
PHP Time Limit: 60
PHP Max Input Vars: 1000
cURL Version: 7.61.1
OpenSSL/1.1.1g

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.21-MariaDB
Max Upload Size: 32 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: 5.3.1
WC Database Prefix: wp_
Total Database Size: 69.58MB
Database Data Size: 47.09MB
Database Index Size: 22.49MB
wp_woocommerce_sessions: Data: 1.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: 0.34MB + Index: 0.14MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 3.52MB + Index: 5.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.05MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.44MB + Index: 0.48MB + 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: 0.36MB + Index: 0.27MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 2.52MB + Index: 1.58MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 8.48MB + Index: 0.16MB + Engine InnoDB
wp_postmeta: Data: 20.52MB + Index: 10.03MB + Engine InnoDB
wp_posts: Data: 6.52MB + Index: 0.56MB + Engine InnoDB
wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_sbi_instagram_posts: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 1.52MB + Index: 2.03MB + Engine InnoDB
wp_users: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + 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.14MB + Index: 0.13MB + 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: 0.42MB + Index: 0.48MB + Engine InnoDB
wp_wc_order_stats: Data: 0.17MB + Index: 0.22MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.11MB + Index: 0.19MB + 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

### Post Type Counts ###

attachment: 128
custom_css: 1
elementor_library: 8
nav_menu_item: 20
page: 16
post: 4
postman_sent_mail: 250
product: 8
product_variation: 711
revision: 218
shop_coupon: 7
shop_order: 1407
shop_order_refund: 76
wc_order_status: 8
wpsl_stores: 20

### Security ###

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

### Active Plugins (15) ###

Application Passwords: by George Stephanis – 0.1.3
Elementor Pro: by Elementor.com – 3.2.2
Elementor: by Elementor.com – 3.2.4
Smash Balloon Instagram Feed: by Smash Balloon – 2.9.1
Multiple Roles: by Florian TIAR – 1.3.1
Post SMTP: by Yehuda Hassine – 2.0.23
Variation Swatches for WooCommerce - Pro: by Emran Ahmed – 1.1.17
Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.17
WooCommerce Stripe Gateway: by WooCommerce – 5.2.0
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.1
WooCommerce Order Status Manager: by SkyVerge – 1.12.2
WooCommerce Shipment Tracking: by WooCommerce – 1.6.26
WooCommerce: by Automattic – 5.3.1 (update to version 5.7.1 is available)
WP Store Locator - CSV Manager: by Tijmen Smit – 1.2.0
WP Store Locator: by Tijmen Smit – 2.2.234

### Inactive Plugins (5) ###

Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.2.6
Additional Variation Images Gallery for WooCommerce - Pro: by Emran Ahmed – 1.1.27
Akismet Anti-Spam: by Automattic – 4.1.9
Astra Pro: by Brainstorm Force – 2.6.3
Jetpack: by Automattic – 9.8

### 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)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #8 - /shop/
Cart: #9 - /cart/
Checkout: #10 - /checkout/
My account: #11 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Astra
Version: 2.5.3 (update to version 3.7.3 is available)
Author URL: https://wpastra.com/about/
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 1,541
Oldest: 2021-09-06 17:34:11 +0000
Newest: 2021-10-07 15:54:03 +0000

### Status report information ###

Generated at: 2021-10-07 16:09:41 +00:00

• This reply was modified 3 years, 1 month ago by Joel P.

Update – This issue seems to be related to our web hosts staging environment. I created a new staging instance and then checked the WP tables and the wp_posts ID had jumped another 500,000.

Our newest order is #1008157. Two days ago we were on #8088.

I explained the issue with the hosting support rep and they insist that this is a plugin issue. I don’t understand how that can be the problem. Is that possible?

Hi @joelp24 ??

This issue seems to be related to our web hosts staging environment. I created a new staging instance and then checked the WP tables and the wp_posts ID had jumped another 500,000.

Thank you very much for the update!

I explained the issue with the hosting support rep and they insist that this is a plugin issue. I don’t understand how that can be the problem. Is that possible?

It’s very unlikely being caused by WooCommerce, but my guess is that there is some connection between the database used on your sites which is causing the order numbers to jump.

I tested this out on my end by creating a new staging site and then making an order on my main site but was unable to replicate the behaviour – the order numbers are unaffected. My recommendation would be that you try a plugin like WP Staging to create a Staging Site to see if it does the same or not.

Thanks!

Resolved: After more testing and chatting with hosting support (WPX.net), they finally confirmed the issue was with their staging site creation process.

“From here on we will try to fix the whole ID change or at least put a big warning message.”

Great! Thanks for letting us know @joelp24 ??

If anything else comes up, please feel free to create a new thread ??