osCommerce Fraud Prevention Module

Overview

This fraud prevention module will screen every order transacted on osCommerce e-commerce platform in real-time for payment fraud. Its sophisticated validation algorithm will accurately detect the fraud patterns to help you to minimize the chargeback and fraud losses.

Visit the FraudLabs Pro Features page to learn more about the type of fraud validation performed and how it could help you to prevent fraudulent online transactions and reduce manual reviews.

Download Fraud Prevention Module

Before downloading the module, please sign up for a free API license key, which is required during the module installation.

For osCommerce version 2.3.x or later

DOWNLOAD

Install Fraud Prevention Module

Download the package.
Unzip the package.
Upload catalog/includes/modules/fraudlabs_pro/process_order.php into server.
Upload catalog/admin/includes/modules/fraudlabs_pro/summary.php into server.
Upload catalog/admin/includes/modules/fraudlabs_pro/feedback.php into server.
Open catalog/includes/modules/fraudlabs_pro/process_order.php (the server copy) with text editor, search for the below code and replace YOUR_LICENSE_KEY_HERE with your API license key.
```
$flpData['key'] = 'YOUR_LICENSE_KEY_HERE';
```
We assume the default osCommerce is used during the installation. Shall the custom path being used, please upload the files to the correct folders.
Open catalog/checkout_process.php with a text editor.

Search for:

$insert_id = tep_db_insert_id();

And replace with:

$insert_id = tep_db_insert_id();

include(DIR_WS_MODULES . '/fraudlabs_pro/process_order.php');

Open catalog/admin/orders.php with a text editor.

Search for:

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

And replace with:

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

include(DIR_WS_MODULES . 'fraudlabs_pro/feedback.php');

Search for:

tep_remove_order($oID, $HTTP_POST_VARS['restock']);

And replace with:

tep_remove_order($oID, $HTTP_POST_VARS['restock']);
tep_db_query("delete from fraudlabs_pro where order_id='". $oID ."'");

Search for:

<tr>
	<td class="main"><br /><strong><?php echo TABLE_HEADING_COMMENTS; ?></strong></td>
</tr>

And replace with:

<tr>
	<td><?php include(DIR_WS_MODULES . 'fraudlabs_pro/summary.php'); ?><td>
</tr>
<tr>
	<td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>
</tr>

Create a fraudlabs table in osCommerce database using the below SQL query.

CREATE TABLE `fraudlabs_pro` (
	`flp_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`api_key` CHAR(32) NULL DEFAULT NULL,
	`is_country_match` CHAR(2) NULL DEFAULT NULL,
	`is_high_risk_country` CHAR(2) NULL DEFAULT NULL,
	`distance_in_km` INT(10) NULL DEFAULT NULL,
	`distance_in_mile` INT(10) NULL DEFAULT NULL,
	`ip_address` VARCHAR(15) NULL DEFAULT NULL,
	`ip_country` CHAR(2) NULL DEFAULT NULL,
	`ip_continent` VARCHAR(10) NULL DEFAULT NULL,
	`ip_region` VARCHAR(50) NULL DEFAULT NULL,
	`ip_city` VARCHAR(50) NULL DEFAULT NULL,
	`ip_latitude` DECIMAL(14,6) NULL DEFAULT '0.000000',
	`ip_longitude` DECIMAL(14,6) NULL DEFAULT '0.000000',
	`ip_timezone` VARCHAR(6) NULL DEFAULT NULL,
	`ip_elevation` INT(10) NULL DEFAULT NULL,
	`ip_domain` VARCHAR(100) NULL DEFAULT NULL,
	`ip_mobile_mnc` VARCHAR(50) NULL DEFAULT NULL,
	`ip_mobile_mcc` CHAR(2) NULL DEFAULT NULL,
	`ip_mobile_brand` VARCHAR(50) NULL DEFAULT NULL,
	`ip_netspeed` VARCHAR(10) NULL DEFAULT NULL,
	`ip_isp_name` VARCHAR(50) NULL DEFAULT NULL,
	`ip_usage_type` VARCHAR(50) NULL DEFAULT NULL,
	`is_free_email` VARCHAR(2) NULL DEFAULT NULL,
	`is_new_domain_name` VARCHAR(2) NULL DEFAULT NULL,
	`is_proxy_ip_address` VARCHAR(2) NULL DEFAULT NULL,
	`is_bin_found` VARCHAR(2) NULL DEFAULT NULL,
	`is_bin_country_match` VARCHAR(2) NULL DEFAULT NULL,
	`is_bin_name_match` VARCHAR(2) NULL DEFAULT NULL,
	`is_bin_phone_match` VARCHAR(2) NULL DEFAULT NULL,
	`is_bin_prepaid` VARCHAR(2) NULL DEFAULT NULL,
	`is_address_ship_forward` VARCHAR(2) NULL DEFAULT NULL,
	`is_bill_ship_city_match` VARCHAR(2) NULL DEFAULT NULL,
	`is_bill_ship_state_match` VARCHAR(2) NULL DEFAULT NULL,
	`is_bill_ship_country_match` VARCHAR(2) NULL DEFAULT NULL,
	`is_bill_ship_postal_match` VARCHAR(2) NULL DEFAULT NULL,
	`is_ip_blacklist` VARCHAR(2) NULL DEFAULT NULL,
	`is_email_blacklist` VARCHAR(2) NULL DEFAULT NULL,
	`is_credit_card_blacklist` VARCHAR(2) NULL DEFAULT NULL,
	`is_device_blacklist` VARCHAR(2) NULL DEFAULT NULL,
	`is_user_blacklist` VARCHAR(2) NULL DEFAULT NULL,
	`user_order_id` INT(10) NULL DEFAULT NULL,
	`user_order_memo` VARCHAR(100) NULL DEFAULT NULL,
	`fraudlabspro_score` INT(10) NULL DEFAULT '0',
	`fraudlabspro_distribution` INT(10) NULL DEFAULT '0',
	`fraudlabspro_status` VARCHAR(10) NULL DEFAULT NULL,
	`fraudlabspro_id` VARCHAR(15) NULL DEFAULT NULL,
	`fraudlabspro_version` VARCHAR(5) NULL DEFAULT NULL,
	`fraudlabspro_error_code` VARCHAR(3) NULL DEFAULT NULL,
	`fraudlabspro_message` VARCHAR(50) NULL DEFAULT NULL,
	`fraudlabspro_credits` VARCHAR(10) NULL DEFAULT NULL,
	`order_id` INT(11) NOT NULL,
	PRIMARY KEY (`flp_id`),
	INDEX `idx_order_id` (`order_id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;

Done.

Articles & Tutorials

How to add FraudLabs Pro secured seal on osCommerce platform

Explore More On osCommerce Videos

Watch valuable tips on fraud detection and prevention for osCommerce Fraud Prevention Module at our YouTube playlist.