Format of the Ordernumber - Ecommerce - Ecommerce - Progress Community

Format of the Ordernumber

  • Format of the Ordernumber
  • Hi support,

    Is it possible to change the format of the Ordernumber, so that it can be part of a certain sequence?

    Kind regards,
  • Hi Daniel,

    Currently the order number is always an Integer number.
    You can specify where the order number can start from (for example if you are moving old site to sitefinity ecommerce you can specify that your orders will start from 1000 instead of 0. But that's all you can do.

    Also keep in mind the maximum for OrderNumbers is 2,147,483,647 currently.

    In order to specify where the next order number should start from you need to update your SQL database there is a table sf_ec_next_order_number which is used like a SEQUENCE to return the next order number. So you have to execute an SQL query like :

    UPDATE sf_ec_next_order_number SET next=1000;

    It is not possible to use a custom pattern for order numbers.

    If you need future assistance let me know. 

    Nayden Gochev
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items