We run a WooCommerce web site and final week observed that our order numbers elevated dramatically by 500,000 (ex. 8088 to 508098). This was alarming to our achievement group.
I perceive that WooCommerce order numbers are created from the wp_posts ID. It is completely regular for us to see small skips (5-20) within the order numbers as a result of the desk contains different publish sorts and there are often different data being created between store orders.
I checked the wp_posts desk and certain sufficient, there’s a large leap within the ID discipline.
I additionally observed that the ID in wp_users jumped by 1000 (ex. 446 to 1447).
I retraced my steps to try to word any latest adjustments I had made previous to noticing the problem:
- Some small edits on a couple of pages
- Modified web page standing from revealed to draft on a number of pages
- Setup some 301 Redirects
- Created a brand new staging occasion on our webhost
My suspicion is that a part of the method our host makes use of when making a staging occasion is to "provision" ID numbers in order that later if the staging web site is merged with the dwell web site, there should not duplicate ID numbers.
To check my idea, I created a 2nd staging occasion and certain sufficient, the ID’s on the dwell web site jumped up one other 500,000.
I chatted at size with internet hosting assist and so they insist the staging websites should not the trigger. They declare that the problem is being attributable to a plugin, though they can not inform me which plugin or how/why.
Has anybody else skilled large jumps so as/ID numbers earlier than? Is it doable it is a plugin problem? How can I affirm the trigger?
Thanks!