Changing Woocommerce order numbers

Hi – I have an interesting problem and am reaching out to see if anyone has a solution.

Today my customer discovered that woocommerce stopped recording his shop orders from July 3rd. By great good fortune he uses a shpping plugin / service called shipstation and by further good fortune the orders were reaching shipstation and they were being accurately recorded and despatched. We are also satisfied that the orders were being paid for via his payment gateways.

I started an investigation and one of the first rules of diagnostics is to ask what changed on the material date. As it happened, on July 3rd I added a shipping zone for Woocommerce using the flexible shipping plugin. It was a bit of struggle setting this up and needed the developers help to do so. In the end we were happy it was working on staging so we pushed it live. I’m pretty satisfied that this is where the problem lies.

The orders appearing again in woocommerce from 11th August and today the client noticed them and discovered that they were not being pushed through to shipstation. Again, what changed on the material date? The WP update from 5.42 to 5.5. This update which has actually caused a bunch of problems has actually solved this problem – well kind of. It has at least started to record the orders again, However … and here’s the problem … woocommerce has woken up and started to allocate what it believes is the next available order no (post ID). Unfortuantely it hasn’t noticed that 64 orders have been placed whilst it was asleep and so is 64 order numbers behind. Shipstation is now refusing to play ball as woocommerce is sending it orders that it believes it’s already received!

Here’s the question – is it possible to restart the woocomm orders at last order +64 so that shipstation starts reciving unique order numbers and starts fulfilling them again? Or, more broadly, does anyone have a solution?

Thanks

Martin

• This topic was modified 4 years, 3 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic