custom-order-numbers

WooCommerce Custom Order Numbers

WooCommerce sequential order numbering, custom order number prefix, suffix and number width

Description

Now order numbers are sequential and customizable. Have you experienced or are you experiencing random order numbers being generated when customers purchase from your WooCommerce store? WooCommerce Custom Order Numbers module will help you set things straight! Enable this module to organize your future orders so each one is sequential. With this module you can:

  • Set the next (i.e. first) order number to get things back in line (and, if you wish, renumerate all existing WooCommerce orders).
  • Add a custom order number prefix, date prefix and/or suffix of your choosing.
  • Define the custom order number width.
  • Enable WooCommerce order tracking by custom number.

Order Numbers Module Options

WooCommerce Custom Order Numbers - Admin Settings

Order Numbers

This section lets you enable sequential order numbering, set custom number prefix, suffix and width.

Number Generation
Possible values are: sequential; order ID; random.

Default: Sequential
Next Order Number
This will be ignored if sequential order numbering is disabled. Next new order will be given this number. Use Renumerate Orders tool for existing orders.

Default:
Order Number Custom Prefix
Prefix before order number (optional). This will change the prefixes for all existing orders.

Default: None
Order Number Date Prefix
Date prefix before order number (optional). This will change the prefixes for all existing orders. Value is passed directly to PHP date() function, so most of PHP date formats can be used. The only exception is using symbol in date format, as this symbol will be excluded from date. Try: Y-m-d- or mdy.

Default: None
Order Number Width
Minimum width of number without prefix (zeros will be added to the left side). This will change the minimum width of order number for all existing orders. E.g. set to to have order number displayed as 00001 instead of . Leave zero to disable.

Default:
Order Number Custom Suffix
Suffix after order number (optional). This will change the suffixes for all existing orders.

Default: None
Order Number Date Suffix
Date suffix after order number (optional). This will change the suffixes for all existing orders. Same as with date prefix, value is passed directly to PHP date() function, so most of PHP date formats can be used. The only exception is using symbol in date format, as this symbol will be excluded from date. Try: Y-m-d- or mdy.

Default: None
Use MySQL Transaction
This should be enabled if you have a lot of simultaneous orders in your shop – to prevent duplicate order numbers (sequential).

Default: yes
Enable Order Tracking by Custom Number
Enables/disables order tracking by custom number.

Default: yes
Enable Order Admin Search by Custom Number
Enables/disables order admin search by custom number.

Default: yes

Orders Renumerate Tool Options

This section set options for the order renumerate tool.

WooCommerce Custom Order Numbers - Admin Settings - Orders Renumerate Tool Options

Sort by
Set how you want orders to be sorted when using orders renumerate tool. Possible values: ID; Date; Last modified date; Random.

Default: Date
Sort Ascending or Descending
Possible values: Ascending; Descending.

Default: Ascending

Orders Renumerate Tool

WooCommerce Custom Order Numbers - Orders Renumerate tool

Accessible through:

  • WooCommerce > Settings > Booster > Shipping & Orders > Order Numbers
  • WooCommerce > Booster Tools > Renumerate Orders

Tested on WooCommerce 4.0.0 and WordPress 5.3.2Plugin can be downloaded here. If there are any locked fields in the module, you will need to get Booster Plus to unlock them.

WooCommerce Booster ModulesWooCommerce Custom Order NumbersWooCommerce Orders

#comment>

#comment>

#comment>#comment>#comment>

Leave a Reply Click here to cancel reply.

#comment>

Comments

41 Comments

  1. joody January 13, 2020 at 1:18 pm#comment>

    Hi, when i use in the order number
    all orders with FJ as the end, can not generate the right abbr.
    generate fiji.
    I guess the reason comes from changed the hosting and moved database once,
    is there a way to find out the problem from database and fix it, thanks!

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • joody January 13, 2020 at 2:47 pm#comment>

      hi, I just found the admin billing country is fiji, and on frontend, in buyer’s order page, the order number with right suffix, however in backend of admin, all of order number with same suffix “FJ”.

      #comment>#comment>Avatar#comment>

    • #comment>

    • RokasJ January 13, 2020 at 4:15 pm#comment>

      Hi,

      Could you try saving the module options again and then using renumerate tool? If that doesn’t work, please contact us directly at [email protected]

      Best regards,
      Rokas – Support Team

      #comment>#comment>Avatar#comment>

    • #comment>

    • joody January 13, 2020 at 4:22 pm#comment>

      Hey RokasJ
      thanks for your suggestion,
      I’ve tried, failed.
      I guess this call the Already logged admin’s country in backend, but not the order’s,

      #comment>#comment>Avatar#comment>

    • #comment>

    #comment>

  2. #comment>

  3. oosin January 2, 2020 at 4:51 pm#comment>

    Order Number Date Prefix what time it git

    my wordpress is UTC+8 but Order Number always show UTC time

    why?

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

  4. #comment>

  5. Shannon Plaquet June 1, 2019 at 2:24 am#comment>

    i cannot seem to disable the plugin. i feel as though i must be missing something obvious… but i haven’t had this happen on any other extensions that i’ve “reset”.

    – i’ve tried unchecking and saving, with no luck
    – i’ve tried resetting the order numbers module with the red button, but it refreshes the page with the checkbox checked

    any other suggestions on what to try?

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • RokasJ June 1, 2019 at 9:33 am#comment>

      Hi Shannon,

      Could you contact us directly at [email protected]? Thank you.

      Best regards,
      Rokas – Support Team

      #comment>#comment>Avatar#comment>

    • #comment>

    #comment>

  6. #comment>

  7. Suzanne Leusby January 16, 2019 at 3:59 pm#comment>

    Hi, we have been using this for a while and want to change our order numbers to start from a new number that is the same as our new invoicing system. I changed the number in Sequential: Next Order Number and changed the Number Generation from Order ID to Sequential and tried a test order but it’s not starting from the new number I put in. Can you help please?

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • RokasJ January 16, 2019 at 6:14 pm#comment>

      Hi,

      Could you contact us directly at [email protected]? Thank you.

      Best regards,
      Rokas – Support Team

      #comment>#comment>Avatar#comment>

    • #comment>

    #comment>

  8. #comment>

  9. Rick December 12, 2018 at 1:58 pm#comment>

    Is it possible to increment the order number by another random number? Such as 1 through 50?
    Thanks!

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • RokasJ December 15, 2018 at 12:22 pm#comment>

      Hi Rick,

      Unfortunately that is not possible yet but we have added it to our todo list.

      Best regards,
      Rokas – Support Team

      #comment>#comment>Avatar#comment>

    • #comment>

    #comment>

  10. #comment>

  11. chris November 22, 2017 at 3:14 am#comment>

    I am also keen to have each product SKU be part of the order number. I would be happy to use the first product UKU that is in the cart for the order number.

    Can you tell me if this can be done?

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

  12. #comment>

  13. Marc Herman October 20, 2017 at 9:00 am#comment>

    Hi,
    Just discovered this amazing piece of work!
    A quick question.
    So far I have only enabled the Custum Order Numbers. At this moment I am foremost interested in the use of the shortcode that my client wants me to incorporate in a message on the Thank You Checkout page.
    However, the shortcode does not produce any result.
    Am I correct in thinking that I need to enable the PDF Invoice module for that? If so, that ‘s a bit of drawback in my case because I have already implemented that functionality in a different way.

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

  14. #comment>

  15. Martin Blase June 14, 2017 at 10:11 pm#comment>

    Regarding the “Enable Order Admin Search by Custom Number” checkbox: I want to be able to search for both old order numbers AND custom numbers at the same time. If an order uses the new numbers, it should try to match; otherwise, it should try to match the original (WooCommerce) order number.

    It seems the “Enable Order Admin Search by Custom Number” lets me do one or the other, but not both. Is there a fix for this?

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

  16. #comment>

  17. Abi May 8, 2017 at 10:52 am#comment>

    The renumeration tool does not work properly. It renumbers orders in reverse order to all of my order numbers are now incorrect. For order numbers to be sequential an order made yesterday should have number lower than those made today..the reverse is happening.

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • Sebastian October 5, 2017 at 1:27 pm#comment>

      Hello Abi,

      did you find any solution?

      Cheers,
      Sebastian

      #comment>#comment>Avatar#comment>

    • #comment>

    • Booster Support Team October 6, 2017 at 2:31 pm#comment>

      Hi,

      I’ve just rechecked and I’m not sure I can reproduce the issue – like you described, when using renumerate tool, orders from yesterday have lower number than orders made today. In renumerate tool orders are sorted by date of creation starting from the oldest order. Anyway – I’ve made some changes to the plugin and added some options so you could try it and see if issue can be solved. Please download the development version here – https://booster.io/dev/. You will need to uninstall the old plugin version first (don’t worry your saved settings won’t disappear). Now in “WooCommerce > Settings > Booster > Shipping & Orders > Order Numbers” I’ve added “Orders Renumerate Tool Options” section, so you can choose how you want orders to be sorted in renumerate tool. Please check it out and let me know if this solves it.

      Best regards,
      Tom

      #comment>#comment>Booster Support Team#comment>

    • #comment>

    #comment>

  18. #comment>

  19. Donal November 27, 2016 at 11:37 pm#comment>

    Hi Tom,

    Before I purchase/install your plugin can you let me know if it is possible to create an order number custom prefix using a short code?

    I’d like my order numbers to include the product SKU, so I’m thinking it would look like this…

    ####

    Thanks in Advance,
    Donal

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • Booster Support Team November 28, 2016 at 8:12 pm#comment>

      Hi Donal,

      Unfortunately that’s not quite possible at the moment. Order number prefixes and suffixes can contain shortcodes, but that would be mostly order shortcodes (e.g. ). As for products shortcodes, I’m not sure how this should work – what I mean is that order can contain multiple products, so it’s not clear which product SKU do you want to be in order number. Maybe you have an idea how to solve this? I can image only one solution – take order’s first product’s SKU. Would that be ok? If yes, I could implement this in plugin.

      Best regards,
      Tom

      #comment>#comment>Booster Support Team#comment>

    • #comment>

    #comment>

  20. #comment>

  21. Pablo Pacheco Karzin November 17, 2016 at 1:14 am#comment>

    A little plugin i’ve made on WordPress.org to fix this:

    https://wordpress.org/plugins/wc-booster-search-order-by-custom-number-fix/

    It’s the same as the github one but it’s easier to install

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • Booster Support Team December 23, 2016 at 9:32 pm#comment>

      Hi Pablo,

      Sorry for such a delayed reply. Thank you for the code, really appreciate it! I’ve added this (with some minor changes) to our plugin’s development version. If you wish to check it out (or add anything), please visit plugin’s GitHub page – https://github.com/algoritmika/woocommerce-jetpack. Again, thank you.

      Best regards,
      Tom

      #comment>#comment>Booster Support Team#comment>

    • #comment>

    • Pablo Pacheco Karzin December 27, 2016 at 1:42 pm#comment>

      Hello.
      I’m really glad you found my code useful! Thanks for the comments (https://github.com/algoritmika/woocommerce-jetpack/blob/master/includes/class-wcj-order-numbers.php#L56

      Actually I was thinking about a minor change. Instead of validating only the order number as numeric value, we could check exactly what the user wants, including suffixes and prefixes. Do you think it would be cool?

      By the way, I am looking for a job right now. If you are interested, please let me know.
      See you, thanks 🙂

      #comment>#comment>Avatar#comment>

    • #comment>

    #comment>

  22. #comment>

  23. Pablo Pacheco Karzin November 9, 2016 at 7:12 pm#comment>

    Thanks for the feedback @Roland

    I’ve just updated it so now it’s possible to search with leading zeros.
    https://github.com/pablo-pacheco/wc-booster-search-order-by-custom-number-fix

    I appreciate any github stars if you liked it 🙂

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • Roland November 10, 2016 at 7:54 am#comment>

      Thanks for the fast ‘fix’ to the fix haha. I’ve signed up to Github and starred your fix 🙂

      #comment>#comment>Avatar#comment>

    • #comment>

    #comment>

  24. #comment>

  25. Kaspar October 18, 2016 at 3:06 pm#comment>

    Hey there,

    First thanks for your wonderfull plugin! 🙂

    I have the same problem as Jake
    “after modifying how the Order number looks, it is now impossible to track the orders using the modified format, Is this a known issue?”

    I installed the dev Booster. But i’ll keep the problem. Can you help me?

    Thanks in advance!

    Cheers,

    Kaspar

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • Pablo Pacheco Karzin November 9, 2016 at 2:27 pm#comment>

      I’ve just made a plugin to solve this problem. You can try it here.
      https://github.com/pablo-pacheco/wc-booster-search-order-by-custom-number-fix

      You just have to put it on your plugins folder.
      Let me know if it helped you

      #comment>#comment>Avatar#comment>

    • #comment>

    • Roland November 9, 2016 at 2:45 pm#comment>

      You rock! I have the order numbers set to 5 numbers with a leading zero. This zero needs to be removed when searching or it can’t find the order, but other than that, this fix works perfectly!

      #comment>#comment>Avatar#comment>

    • #comment>

    #comment>

  26. #comment>

  27. Javier September 26, 2016 at 4:14 pm#comment>

    The function of custom order numbers is working well, but it’s not possible to search any order with the “new” number. The orders search only accepts the default Woocommerce order number.

    There is any way to make searchable this custom order numbers?

    Thanks in advance.

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

  28. #comment>

  29. Alkis August 26, 2016 at 10:35 am#comment>

    I have the same issue as some of the people below.
    I want booster to be able to send the “custom order number” when it talk to the payment gateway and not the default woocommerce order_id
    For example my issue is that even with BACS payment (bank transfer) the default woocommerce order_id is sent and not the new custom “order number”
    Maybe take a hint from the way paypal integrates the order_id info???

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

  30. #comment>

  31. Jake June 3, 2016 at 10:07 pm#comment>

    Hi, after modifying how the Order number looks, it is now impossible to track the orders using the modified format, Is this a known issue?

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • Booster Support Team June 3, 2016 at 10:26 pm#comment>

      Hi Jake,

      Yes, we’ve recently fixed that. Please download the development version here – http://booster.io/dev/. You will need to uninstall the old version first (don’t worry your saved settings won’t disappear). After that please make sure “Enable Order Tracking by Custom Number” option is enabled in module’s settings (as usual in “WooCommerce > Settings > Booster > Shipping & Orders > Order Numbers”).

      Best regards,
      Tom

      #comment>#comment>Booster Support Team#comment>

    • #comment>

    #comment>

  32. #comment>

  33. Mike Lane May 26, 2016 at 1:59 pm#comment>

    I purchased your Booster product a few days ago looking to alter the order #’s in Woocommerce. I set the order #’s to start at 1000032, which reflects fine in Woocommerce, but the original order # (232) is being sent to my payment gateway. What can I do to have the new Booster provided order # sent to my payment gateway?

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • Booster Support Team May 26, 2016 at 2:01 pm#comment>

      Hi,

      Which payment gateway are you using?

      Best regards,
      Tom

      #comment>#comment>Booster Support Team#comment>

    • #comment>

    • Mike Lane May 26, 2016 at 3:08 pm#comment>

      Thanks for the quick reply Tom. I use WooCommerce Sage Payments USA Gateway, as well as the built in Paypal solution.

      #comment>#comment>Avatar#comment>

    • #comment>

    • Booster Support Team May 26, 2016 at 3:22 pm#comment>

      Didn’t test with Sage Payments yet, however PayPal should be ok. I’ve just retested on our test server and PayPal sandbox, and it seems to be fine – PayPal is displaying Booster’s modified order number and not original order ID. Could you please send me a screenshot from PayPal with wrong order number? My email is [email protected]

      Tom

      #comment>#comment>Booster Support Team#comment>

    • #comment>

    • Stefan Stieranka December 5, 2018 at 9:58 pm#comment>

      Hi,
      I have the same problem – my payment gateway sends the original order number (it is a post ID).
      I was looking for a payment gateway plugin – I found this:

      $order = new WC_Order($order_id);
      $vs = str_pad($order_id, 10, “0”, STR_PAD_LEFT);

      $vs is order number for payment gateway. Function “WC_Order($order_id)” not return the number from booster, bud real order number (post ID – becouse order is post).

      What with that? Any idea?

      Thanks.

      Steve

      #comment>#comment>Avatar#comment>

    • #comment>

    • Stefan Stieranka December 5, 2018 at 11:40 pm#comment>

      Hi,
      I solved the problem:

      Orginal code in payment gateway plugin get Order ID
      $vs = str_pad($order_id, 10, “0”, STR_PAD_LEFT);

      I modified it to get Order Number
      $vs = str_pad($order->get_order_number(), 10, “0”, STR_PAD_LEFT);

      Now it works fine. If someone needed it.. 🙂

      Steve

      #comment>#comment>Avatar#comment>

    • #comment>

    #comment>

  34. #comment>

  35. Roland May 22, 2015 at 10:56 am#comment>

    The custom order numbering works like a charm for the most part, but unfortunately it seems to be impossible to search orders by these ‘new’ numbers while the original WooCommerce order numbers are searchable. It would make life a lot easier if searching by custom order numbers was also possible.

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

  36. #comment>

  37. Greg March 14, 2015 at 1:20 am#comment>

    Hey there!

    First off, thanks for the plugin. The free version is awesome and the paid version is all but a sure thing. I don’t even need anything in the paid version that I can think of (yet…), but at $20, it’s a donation to the future development of this awesome tool. Thanks!

    Just a quick question:

    I’ve used the sequential orders option and started my orders at 1000. I then changed all previous orders to follow this format using the Remunerate Orders tool. However, on completing the Remunerate Orders procedure, my orders have the suffix “##” as opposed to “#”. I don’t suppose you know of a fix for this?

    Cheers!
    Greg

    Reply to thread

    #comment>#comment>#comment>Avatar#comment>

    • WooJetpack Support Team March 17, 2015 at 3:30 pm#comment>

      Hi Greg,

      Thank you so much! And sorry for the delayed reply.
      As mentioned in private email – I’m aware of the problem, will be fixed in next update.

      Best regards,
      Tom

      #comment>#comment>Avatar#comment>

    • #comment>

    • Greg March 17, 2015 at 4:25 pm#comment>

      Thanks Tom,

      Awesome to hear it will be fixed next update.
      Again, sorry for the double contact. I couldn’t find this page again, so worried I hadn’t submitted the comment!

      Cheers!
      Greg

      #comment>#comment>Avatar#comment>

    • #comment>

    #comment>

  38. #comment>

#comment>#comment>#comment>#comment>

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

This site uses Akismet to reduce spam. Learn how your comment data is processed.