More in this section
Forums / Ecommerce / Format of the Ordernumber

Format of the Ordernumber

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
2 posts, 0 answered
  1. Daniel Plomp
    Daniel Plomp avatar
    952 posts
    18 Feb 2004
    02 Sep 2013
    Link to this post
    Hi support,

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

    Kind regards,
  2. Nayden Gochev
    Nayden Gochev avatar
    32 posts
    03 Nov 2014
    05 Sep 2013
    Link to this post
    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
2 posts, 0 answered