Home > Developers: Integration Overview > Database Engine Template

eProcessing Network has developed the Database Engine Template for merchants that securely collect and save ALL customer, order and shipping information, but wish to leave the secure collection of credit card information to eProcessing Network.

NoticeNotice

Use of this integration template requires intermediate- to advanced-level programming capability. eProcessing Network offers support for this template via email only at devutils@eprocessingnetwork.com.

This template allows the merchant to control which URL the customer is returned to based on whether the transaction is approved or declined.

It is assumed that the merchant has collected address information for AVS purposes, or the merchant can change the address-related input types in the form below from HIDDEN to TEXT allowing the customer to be prompted for this information directly within the form.

<FORM ACTION="https://www.eProcessingNetwork.com/cgi-bin/dbe/order.pl" METHOD=POST>

<INPUT TYPE="HIDDEN" NAME="ePNAccount" VALUE="Merchants' eProcessingNetworkAccountNumber">
<INPUT TYPE="HIDDEN" NAME="Total" VALUE="OrderTotal">
<INPUT TYPE="HIDDEN" NAME="FirstName" VALUE="TheFirstNameYouCollected">
<INPUT TYPE="HIDDEN" NAME="LastName" VALUE="TheLastNameYouCollected">
<INPUT TYPE="HIDDEN" NAME="Address" VALUE="BillingStreetAddress">
<INPUT TYPE="HIDDEN" NAME="Zip" VALUE="BillingZip">
<INPUT TYPE="HIDDEN" NAME="EMail" VALUE="CustomersEMailAddress">
<INPUT TYPE="HIDDEN" NAME="ID" VALUE=DatabaseEngineGeneratedID>
<INPUT TYPE="HIDDEN" NAME="ReturnApprovedURL" VALUE="http://www.WhereToGoOnApprovedTransaction">
<INPUT TYPE="HIDDEN" NAME="ReturnDeclinedURL" VALUE="http://www.WhereToGoOnDeclinedTransaction">
<INPUT TYPE="HIDDEN" NAME="BackgroundColor" VALUE=BackgroundColorToUse (use 6 digit hex values)>
<INPUT TYPE="HIDDEN" NAME="TextColor" VALUE=TextColorToUse (use 6 digit hex values)>
<INPUT TYPE="HIDDEN" NAME="LogoURL" VALUE="http://www.FullURL.to/Logo.image">
<INPUT TYPE="SUBMIT" VALUE="Submit">

</FORM>

When the customer selects the Submit button from this form, eProcessing Network then securely prompts the customer for credit card information, and processes the transaction on a real-time basis.

After the transaction has been processed, the customer is presented with an HTML page that indicates the status of the transaction, and a button is displayed for the customer with a message asking the customer to select the button to finish processing the transaction. This button directs the customer to the URL specified in either the ReturnApprovedURL or ReturnDeclinedURL field, depending on the status of the transaction, POSTing the passed-in ID to the respective URL.

This template can also be used by merchants already securely collecting the credit card information. In this case, all required information is passed to the eProcessing Network Secure Transaction Processing Server. This can be done with a simple form button as follows:

<FORM ACTION="https://www.eProcessingNetwork.com/cgi-bin/dbe/transact.pl" METHOD=POST>

<INPUT TYPE="HIDDEN" NAME="ePNAccount" VALUE=Merchants' eProcessingNetworkAccountNumber>
<INPUT TYPE="HIDDEN" NAME="FirstName" VALUE="TheFirstNameYouCollected">
<INPUT TYPE="HIDDEN" NAME="LastName" VALUE="TheLastNameYouCollected">
<INPUT TYPE="HIDDEN" NAME="CardNo" VALUE="CustomersCreditCardNumber">
<INPUT TYPE="HIDDEN" NAME="ExpMonth" VALUE="ExpMonth (01 thru 12)">
<INPUT TYPE="HIDDEN" NAME="ExpYear" VALUE="ExpYear (last two digits)>
<INPUT TYPE="HIDDEN" NAME="Total" VALUE=OrderTotal>
<INPUT TYPE="HIDDEN" NAME="Address" VALUE=BillingStreetAddress>
<INPUT TYPE="HIDDEN" NAME="Zip" VALUE=BillingZip>
<INPUT TYPE="HIDDEN" NAME="EMail" VALUE=CustomersEMailAddress>
<INPUT TYPE="HIDDEN" NAME="ID" VALUE=DatabaseEngineGeneratedID>
<INPUT TYPE="HIDDEN" NAME="ReturnApprovedURL" VALUE="http://www.WhereToGoOnApprovedTransaction">
<INPUT TYPE="HIDDEN" NAME="ReturnDeclinedURL" VALUE="http://www.WhereToGoOnDeclinedTransaction">
<INPUT TYPE="HIDDEN" NAME="BackgroundColor" VALUE=BackgroundColorToUse (use 6 digit hex values)>
<INPUT TYPE="HIDDEN" NAME="TextColor" VALUE=TextColorToUse (use 6 digit hex values)>
<INPUT TYPE="SUBMIT" VALUE="Submit">

</FORM>

When the customer selects the Submit button from this order page, eProcessing Network then uses this information to process the transaction on a real-time basis.

After the transaction has been processed, the customer is presented with an HTML page that indicates the status of the transaction. If the transaction was approved, email summarizing the transaction is automatically sent to the merchant, and a button is displayed for the customer, with a message displayed asking the customer to select the button to finish processing the transaction. This button is generated with a form using the following code:

<FORM ACTION="http://www.WhereverTheMerchantWantsTheCustomerToGo.Com" METHOD=POST>

<INPUT TYPE="HIDDEN" NAME="ID" VALUE=DatabaseEngineGeneratedID>
<INPUT TYPE="SUBMIT" VALUE="Finish Processing Order">

</FORM>

This form can be used to notify the merchants database engine of the status of the transaction.

More advanced developers can pass in the additional Redirect parameter (case-sensitive!) set to 1 to bypass the display of the button to the customer, in which case eProcessing Network will transparently redirect the customer back to the appropriate URL.

 

For questions, suggestions or special requests, email us at devutils@eprocessingnetwork.com.

 

Facebook   LinkedIn   YouTube
Copyright 2014 eProcessing Network, LLC. All Rights Reserved.