Causing Order Numbers to Jump

  • Resolved keeneyemedia

    (@keeneyemedia)


    5 years, 4 months ago

    Hello, we’re seeing that the scheduled actions this plugin creates are causing our order numbers to jump drastically. This only started within the last few months (I’m not sure which version number changed).

    For example, we’ll have an order, then there are ~10 post IDs of “scheduled-action” post type before the next order (with titles like “MailChimp_WooCommerce_Single_Order” and “MailChimp_WooCommerce_Cart_Update”). So our Woocommerce order numbers jump drastically.

    Is this intentional?

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author ryanhungate

    (@ryanhungate)

    @keeneyemedia hi, thanks for writing in about this topic. Yes, you are correct, where the Action Scheduler is currently using the posts table ( as a lot of other plugins do as well ) where the native order ids would be impacted. This is also the same for any custom post type, where if you were to have created a new page, or even a new product etc, the ID’s are going to depend on this table, and would increment as you’ve seen.

    Here are a few things to note.

    1. If you’re requiring sequential order numbers, there is a native plugin for that which you can get off of the Woocommerce website directly. Here is an example query – you may of course do whatever you would like to accomplish this. https://woocommerce.com/search/?q=sequential%20orders

    2. Action Scheduler version 3 will be out at some point in the future which is going to be making use of a custom table for performance reasons, and that will also solve the incrementing ID problem. From what we’ve heard, there are some plugins that help this already – but we’ve elected to wait until the core has been updated because we’re in favor of long term support.

    So to sum it all up, we understand how this may be a little bothersome if you’re counting on the sequential order numbers in your current store setup, but again if that’s a high priority, you have options with the Woocommerce company to accomplish that.

    Thread Starter keeneyemedia

    (@keeneyemedia)

    Thanks for the feedback on this.

    Good to know theres eventually an update coming down the line. We’ll see if we want to add the Sequential Order Numbers plugin in the meantime.

    Thanks

    Plugin Author ryanhungate

    (@ryanhungate)

    @keeneyemedia sounds good. Please do let us know if you have any other questions – be glad to help.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Causing Order Numbers to Jump’ is closed to new replies.