Order Number

[computergenius]

I am creating a Payment Module, but I can't see where the osCommerce Order Number can be found. I can see that it is in the database, orders.orders_id but I would have thought that it would be floating around somewhere...

[michael_s]

It is pulled from the db when needed.

[computergenius]

Well, it's needed now <G>

Let me define what I am looking for - what will become the Invoice number, when we issue the invoice. At this stage, there is product in the cart, and I am going to get the payment. But I need something to track the payment, in case I don't get an immediate reply.

I can't see an order number, I (think that I can) see the cart in the table "sessions", but I can't find a unique number in there. I am using the sessionID in that table, which I don't think is suitable, but is the best that I can do.

[michael_s]

Order numbers are not generated until after processing. It is the way osCommerce is built. So, you cannot get an order number until after the order is completed (it is not assigned until added to the db, which only happens on completion of the transaction).

I think there is a mod that gets around this issue, as I vaguely recall something about this.

You may want to look through the osCommerce mods here:
osCommerce: Contributions