Order numbers duplicating, resetting, prefix duplicating

  • Resolved bwragg

    (@bwragg)


    3 years, 1 month ago

    Hi,

    We launched a new site on Woocart. Site ran well for a day, took around 30 orders then suddenly we started getting failing payments via paypal. We checked the logs and discovered it was due to duplicate order numbers. We checked the orders and ran a test order and we found that for some reason the order numbers were not advancing. So when you created an order the order number Sequential Order Number would create was the same as the last order. We tested with our credit card gateway and it did the same thing, started creating orders with the same number.

    We rebooted the PHP/Nginx servers and the problem seemed to go away. 30 minutes later it started again.

    While trying to debug the plugin and work with Woocart on the issue another issue presented itself. Our order number are formatted prefix=2, length=10, start number set e.g 20000032569. Suddenly the orders started showing up with duplicated prefixes. e.g 22221000032573 . Notice the prefix is appended 4 times instead of 1 and a number 1 has been added!

    Also at one point the starting number seemed to reset to 1…we had it set to 32000ish as we had orders from an old system imported. This obviously caused more issues as 20000000001 already existed in the system.

    What is strange is when i go into the setting tab everything looks correct. e.g right now the settings tab shows a Prefix of 2, length of 10 and start number as 32553. Preview shows 20000032554. yet the last order is 22221000032575. If i checkout the wt_last_order_number field in the options table it is 22221000032575.

    So from all this we, and Woocart, felt it was some sort of cache which is screwing up the plugin. We thought maybe this plugin doesn’t work well with Redis. So we disabled Redis. This seemed to be a temp fix and for a few days it ran ok. But just now it has started happening again and Redis is disabled.

    Any ideas?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter bwragg

    (@bwragg)

    forgot to add running version 1.4.2 and WP 5.8.3

    Plugin Author WebToffee

    (@webtoffee)

    Hi @bwragg,

    Thanks for reaching out.

    We are sorry for the inconvenience caused. We were not able to replicate the issue when we tested the same scenario (with the same prefix, order number length, start number) on our end. It seems more site-specific, might be a conflict with some plugins that you are using. Could you please share the WooCommerce system status report (WooCommerce>status>system status report) for a better understanding? If you have any privacy concerns, you can share the details via this link.

    Thread Starter bwragg

    (@bwragg)

    Thanks. I just sent the system status report to that link.

    I had a better look at the issue this morning and discovered what I said originally isn’t quite right. To get it clear I will explain from the top. I will use what has recently happened rather than what happened a few weeks back.

    We have set in the settings Prefix of 2, length of 10 and start number as 32553

    Order 20000032766 came into the system ok at 11:23am
    Next order at 12:11pm goes crazy. Order id shows as 22221000032554

    So it has done 2 things wrong.
    1) Prefix is still there but its added 2221 to the start of the number.
    2) it resets the starting order number back to the original start number I set weeks ago.

    When I look in the wt_last_order_number setting in wp_options the number is now set to (few days one) 2221000032575.

    I’m setting up a staging environment and will try and replicate the trigger.

    Plugin Author WebToffee

    (@webtoffee)

    Hi @bwragg,

    Thanks for sharing the information. As we are communicating the issue in the Support Desk, more communication related to this will be shared there. Thanks for understanding.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Order numbers duplicating, resetting, prefix duplicating’ is closed to new replies.

Tags