osCommerce

plus-sign-simple

Integrate osCommerce and Sagepay

Trexle connects osCommerce to Sagepay and 100+ other payment gateways using a single plugin for one time annual fee

Sagepay and osCommerce Integration Guide

Getting your SagePay API credentials

You will need to retrieve your Integration Key (username) and Integration Password. You can do this by following the steps below:

Step 1: Log in to MySagePay

Go to MySagePay in either the TEST or LIVE environment and log in using the Administration log in details that were provided to you during the setup of the account.

Once you are logged in as the Administrator, in the Password details section of the Administrator tab you will see an option to ‘Create API credentials’.

Step 2: Create API credentials

To create your credentials you just have to select the tick-box labelled “I understand that this will create new credentials and may break any existing Sage Pay API implementations.” and click on the ‘Create API credentials’ button.

When you choose to create new credentials, any previously generated credentials are immediately rendered invalid. Therefore, if you have already integrated with our REST API, you will not be able to authenticate your calls until you replace your expired credentials with the ones you just generated.

Once you have opted to create your new credentials we will present you with the following information:

►  Environment: This specifies the environment for which the credentials apply (test or live)

►  Vendor Name: The vendorname for the account

►  Integration Key: The value for the Integration key (username)

►  Integration Password: The value for the Integration password

 

Step 3: Save credentials

It is important that you store these credentials safely and securely. If you lose them, you will need to generate a new set of credentials using the same process. Please note that these credentials are only valid for PI and not for any legacy Sage Pay integration methods

Take the credentials you just obtained from Sagepay and navigate to Trexle dashboard, click Payments Gateways and select Sagepay from the drop down menu as shown below.

Fill into your Sagepay credential and click Add Gateway. Click the Activate button next to Sagepay, and it will give you a success message and the button will turn into green. You should see something like below.

To integrate Sagepay and osCommerce you need Trexle API keys

How to install Trexle extension to osCommerce

 

  1. Log in to your osCommerce admin panel

  1. On the left menu in the Admin panel, click on the ‘Modules’ tab

  1. Under the ‘Modules’ tab, click on the link ‘Payment’ and then on the button ‘Install Module’

  1. Find the ‘Trexle’ extension after clicking on the ‘Install Module’

  1. Click on ‘Trexle’ and then on the ‘Install Module’ button

  1. Trexle plugin should now be successfully installed

To ensure the integration works seamlessly, create a test product, logout from your admin session and perform a checkout as a regular customer.

Here is a video tutorial on both installation and order testing.

Each card number will provide you with a different result when processing a transaction to ensure your website can handle all possible responses from our system.

Along with the different 3D Secure results each card type will return you are also able to test cards issued from multiple countries.

Card

Card Number

CardType Response from Sage Pay

3D Secure Response from Sage Pay

CV2 Value

VISA

4929 0000 0000 6

VISA

Y

123

VISA

4929 0000 0555 9

VISA

N

123

VISA

4929 0000 0001 4

VISA

U

123

VISA

4929 0000 0002 2

VISA

E

123

VISA Corporate

4484 0000 0000 2

VISA

N

123

VISA Debit

4462 0000 0000 0003

DELTA

Y

123

VISA Electron

4917 3000 0000 0008

UKE

Y

123

MasterCard

5404 0000 0000 0001

MC

Y

123

MasterCard

5404 0000 0000 0043

MC

N

123

MasterCard

5404 0000 0000 0084

MC

U

123

MasterCard

5404 0000 0000 0068

MC

E

123

Debit MasterCard

5573 4700 0000 0001

MCDEBIT

Y

123

Maestro (UK Issued)

6759 0000 0000 5

MAESTRO

Y

123

Maestro (German Issued)

6705 0000 0000 8

MAESTRO

Y

123

Maestro (Irish Issued)

6777 0000 0000 7

MAESTRO

Y

123

Maestro (Spanish Issued)

6766 0000 0000 0

MAESTRO

Y

123

American Express

3742 0000 0000 004

AMEX

N/A

1234

Diners Club/Discover

3600 0000 0000 08

DC

N/A

123

JCB

3569 9900 0000 0009

JCB

N/A

123

PayPal

Use your own PayPal Sandbox details

PAYPAL

N/A

N/A

 

The 3D Secure responses are –

  • Y – Enrolled, and will progress to the password page to complete verification.
  • N – NOT Enrolled and will return a 3DSecureStatus=NOTAVAILABLE back to your system.
  • U – Unable to verify enrollment and will return a 3DSecureStatus=NOTAVAILABLE back to your system.
  • E – Error occurred during the 3D Secure verification.  This will return a 3DSecureStatus=ERROR back to your system.

Each response is to ensure your website can handle the multiple responses that are sent from Sage Pay back to your site.

When using any of the cards above for testing you will also need to enter an expiry date.  Any expiry date can be accepted as long as it is in the future from the date you are processing the test transaction.

Address Details

When using the test card details and processing a transaction you will be required to enter an address for the shopper.

We have assigned address details to each of the above cards that will be accepted on our test system.

When using the address details with the card details above the transactions will be able to processed successfully, along with passing both the simulated address and postcode fraud prevention checks.

Address                 : 88

Postcode               : 412

3D Secure

If you have 3D Secure active on your account you will also be required to enter a password to complete the process.

We have a range of passwords that can be used to test the different responses that will be sent back by 3D Secure upon completion of the verification (PaRes).

To successfully complete 3D Secure you will need to enter – password (case sensitive) on the 3D Secure page.

If you would like to test the other 3D Secure responses that can be sent you will simply need to enter :

  • A:D:06 – The Cardholder is not enrolled in the 3D Secure scheme and will return the 3DSecureStatus=ATTEMPTONLY
  • U:N:06 – The 3D Secure authentication is not available and will return the 3DSecureStatus=INCOMPLETE
  • E:N:06 – An error occurred during the 3D Secure authentication and will return the 3DSecureStatus=ERROR

By using these passwords you will be able to complete and test all other responses 3D Secure can return to you.

Sagepay Supported Countries

Sagepay Supported Payment Processing Actions

✔ Purchase
✔ Authorize
✔ Capture
✔ Void
✔ Credit
✖ Recurring
✔ Card Store

Key Features

Credit Card Vault: securely store your customers sensitive credit card data using tokens.
Instant PCI-DSS Compliance: your customers credit card data never touches your site or server.
Multiple Gateway Support: Connect your osCommerce site to 100+ payment gateway

About Trexle

Trexle is a powerful online recurring subscription billing platform that integrate Sagepay and other +100 payment gateways with osCommerce and other dozen of e-commerce platforms.

About Sagepay

SagePay is a British multinational enterprise software company headquartered in Newcastle upon Tyne, United Kingdom. It is the world's third-largest supplier of enterprise resource planning software (behind Oracle and SAP), the largest supplier to small businesses, and has 6.1 million customers worldwide. It has offices in 24 countries. The company is the patron of The Sage Gateshead music venue in Gateshead.

About osCommerce

Being in the fintech business for 18 years, osCommerce platform enables merchants to create their very own online store and start selling products and services to customers worldwide. The tools they offer to merchant owners are free, available under Open Source license. osCommerce also has a large community of store owners, developers, and service providers who help each other during the many stages of maintaining an online business.

Cart