Stardard place for payment references ?

[nathanblogs]

Hi,

I did a quick search of the forums and couldn't find an answer to my question.

Is there a standard place that payment references are stored in the database ( I have no addons, out of the box zen cart install ), for example looking at the orders table in the database there is a payment_method and payment_module_code, but there doesn't seem to be a reference anywhere?

thanks for any help.

[gjh42]

What do you mean by "payment references"?

[nathanblogs]

What do you mean by "payment references"?

The unique code that can be used to track down the payment in your payment system.

[DrByte]

Each order is assigned an order number. That's a good starting point.
Anything else largely depends on what payment system is used for each payment. So ... what payment module(s) are you using to collect payments in your store?

[nathanblogs]

Each order is assigned an order number. That's a good starting point.
Anything else largely depends on what payment system is used for each payment. So ... what payment module(s) are you using to collect payments in your store?

I was thinking there might be a central place that stores something like

orderid - the id
paymenttype - paypal, eway, etc
paymentreference - the unquie payment id
paymentsuccess - success

[DrByte]

Yes, that information is stored with all the order data.

What exactly are you wishing to do with it? Surely there's a business reason behind why you're asking the question.

[nathanblogs]

Yes, that information is stored with all the order data.

What exactly are you wishing to do with it? Surely there's a business reason behind why you're asking the question.

Basically we have some code in zen-cart which pushes orders into an inventory system.

I would like to be able to get the payment information and push that data to the inventory system.

I don't see anything in the orders table that looks like a payment reference, all I can see is payment_method and payment_module_code there is order_id but that is of no help to me.

[DrByte]

If the payment module received and stored any transaction number data, it likely stored it in the orders_status_history records for that order as part of free-form comment text.