order number prefix

Discussion in 'Technical Support' started by gadgit7, Jul 1, 2009.

Thread Status:
Not open for further replies.

  1. gadgit7 Customer

    Hi,

    I need to put the letters 'sb' in front of the order number so it shows us where the order came from in our accounts system. Any idea how I do this?

    Thanks

    Gary :)

    using 4.1.3
    nustyle3 template
    gadgit7, Jul 1, 2009
    #1

  2. Mike-N-Tosh Owner

    I think you need to provide a little bit more detail to get comprehensive help. Such as how and where are you getting the order number to your accounts system. Does it just need to display with a prefix?
    Mike-N-Tosh, Jul 1, 2009
    #2

  3. gadgit7 Customer

    Hi Mike,

    SRy...OK , we have a gateway to securepay installed. This seurepay account takes orders from multiple sites and each site has its own prefix to the ordr number (ie, rp1234567. This means we can easily see in our MYOB accouning where the order came from. Hope that makes sense.
    What we need is to know where the order number is generated in 68c and then how can we assign a prefix of 'sb' to those order numbers.
    Thanks

    Gary :)
    gadgit7, Jul 1, 2009
    #3

  4. Lhotch curmudgeon

    the order number is not generated by 68C. As orders are added to the database the database server auto increments the ID of the order.
    Lhotch, Jul 1, 2009
    #4

  5. gadgit7 Customer

    OK...what we need to know is how to add a static prefix to the order id string that is sent to securepay. we are not looking to change the orderid in the database.

    Is thatmore clear? hope so

    Gary :)
    gadgit7, Jul 1, 2009
    #5

  6. Mike-N-Tosh Owner

    One issue that I see with that solution is that if you send the orderID altered, then that means it will be returned altered. That means that the order will then never be resolved as paid since the alterd orderID will not match any existing order.

    I guess you could then alter the orderID back on the postback. In any case, both of those functions would be in the sr.php file for your payment gateway.
    Mike-N-Tosh, Jul 1, 2009
    #6

  7. Lhotch curmudgeon

    Why dont you check with your payment provider and see if they have any extra data they accept. Paypal for example accepts various optional parameters that you can send along with a payment. create a static one in the sr.php file for the gateway and be done with it. It seems to me you are trying to make this so much more complicated than it needs to be.
    Lhotch, Jul 1, 2009
    #7

  8. gadgit7 Customer

    I'm afraid it's my lack of knowledge that is making this 'complicated'. I wish I knew how to do this easily ;)

    Thanks for tryng anyway,

    Gary :)
    gadgit7, Jul 1, 2009
    #8
Thread Status:
Not open for further replies.

Share This Page