Support » Plugin: WooCommerce Sequential Order Numbers » PRO not working as intended

  • skallerup

    (@skallerup)


    We had an incident where we had to do a backup that then created issues with our order id’s. Therefore I changed the orderID’s to a very high number. Sadly this number suddenly got added to the order number.
    Before the incident we had the lastest number: BAN8100DK. Now we got BAN100000964DK. We can’t go back now since this is the message we get:
    “There is an existing order (BAN100000964DK) with a number greater than or equal to 10000. To set a new order number start please choose a higher number or permanently delete the relevant order(s).”

    We have PRO version but for some reason can’t submit the ticket on woocommerce.com

    Can you help us on how we through the database can run a SQL or something else in order to get back to more userfriendly order number?
    -Thanks.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author SkyVerge

    (@skyverge)

    Hey @skallerup!

    Thanks for reaching out. I’m not sure why it wouldn’t let you submit a support request through your WooCommerce account, though I’m still happy to help!

    When an order is processed in your store with Sequential Order Numbers Pro active, it will set a new piece of metadata, ‘_order_number‘ with the new value. When trying to set a new start number in the plugin settings, it first checks what the maximum value of this metadata is, before checking that your new value is less than this to remain consistent and sequential.

    Therefore, if you wanted to go backward, you would need to edit the existing orders with the current high order numbers and make sure they were set lower. This would then allow you to choose a new lower start number in the settings!

    One additional note is that there is also a ‘_order_number_formatted‘ metakey that will contain the other information such as prefixes if in use. If you are using these, then you may want to consider updating these metavalues as well, so that they are consistent across both order number, and formatted order number values.

    I’m afraid this goes a bit beyond the support we can provide under our support policy, as you would be needing to adjust the data in the database directly. Though I hope this information is useful for you to bring those order numbers back in line! 🙂

    Is there anything else I can help out with today?

    Cheers!

    Simon.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.