Invoice number

I want to build a tracking page where someone can input their Invoice number and zip code and have the actual order show up. In order to do that, I need to save the Invoice number in the database. How is it generated and where should I input it?

Thanks a bunch!

eCart does not generate an invoice number, but it does generate an order number which is the ID for the record created in the orders table.

When you run the checkout wizard, make sure to select the option to save the order info to the database.

When the info is saved, a new record is stored in the order table, and the Order ID is set to use the ID value for the primary key column in the orders table.

If you use a local checkout method like paypal pro, eCart can also send am email receipt that will contain the order ID value.


you can create a recordset lookup to search for the order IDF and the Zip code.

I did know about the order id in the database. However, the invoice number I am referring to is what is actually on the customer's receipt. Where does that come from?

I'm assuming you mean the receipt generated by the gateway. That is generated by the gateway and in some cases is not a value that is available at the time the order is being stored to the database.

It is better to use a remote checkout system, and set up eCart to send a custom receipt, that receipt will contain the orderID, use the order ID instead of the invoice number generated by the gateway.

Jason,

We were wondering the same thing about the invoice number that Authorize.net is showing on the receipt. Looking on Authorize.net we are getting the impression that the invoice number is coming from the site. I know you said that it is better to use a custom receipt, which we will start to use, but for the purpose of matching the information in the database to authorize.net in QuickBooks, is there a way we can save that authorize.net invoice number in the database along with the other information?

Thank You

This is only possible using the AIM method, in the AIM Method the transaction ID is set to the sessionID, you could store the session ID in the database.

With the SIM, the transaction ID is set by the authorize.net server and is not passed back to the site.

Gotcha... Thank You

you're welcome.