Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Customize Order Number Field

  1. #1
    dellend is offline Junior Member
    Join Date
    Dec 2009
    Posts
    5

    Default Customize Order Number Field

    Hi,

    Is there a way in which we can change the Order Number field so that it's not an "int" field, but is instead a "varchar" field. That is, can this be done through the system as it is, or would we need to make massive customizations to the database and code behind? What's happening is that when we integrate with our ERP system, we've had a few instances where the Order Numbers generated by StoreFront had been used by some of our other customers, so we'd like to add some characters to the order number to ensure that they're unique. Has anyone done this before?

    Thanks!

    -Dave-

  2. #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Changing the DataType of the OrderNumber field requires a lot of modifications in the source and in the DB as well. There's nothing built-in that could do this, no.