close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Invoice number

Thread began 5/15/2014 10:53 am by ed331947 | Last modified 10/07/2014 4:00 pm by Jason Byrnes | 580 views | 7 replies |

ed331947

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!

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

ed331947

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Daniel

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Daniel

Gotcha... Thank You

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...