FraudLabs Credit Card Fraud Prevention: Installation Guide

FraudLabs Pro™ Credit Card Fraud Prevention v1.3.5

Overview

FraudLabs Pro™ Credit Card Fraud Prevention v1.3.5 screens credit card transactions for online frauds. It increases e-commerce merchant profits by reduces chargeback, improves operation efficiency and provides business intelligence. Merchants can investigate all complex, high-risk orders in a simple way by using merchant administrative interface.

You can sign up a free account at https://www.fraudlabspro.com/sign-up to start using this awesome feature.

Installation

There are 3 files to be added.
catalog/admin/includes/modules/fraudlabs_pro/summary.php
catalog/admin/includes/modules/fraudlabs_pro/feedback.php
catalog/includes/modules/fraudlabs_pro/process_order.php

There are 2 files to be modified.
catalog/checkout_process.php
catalog/admin/orders.php

Please take note that the "server" in this tutorial means the location where you install the osCommerce.
This solution has been successfully tested on osCommerce 2.3.3
IMPORTANT: Please BACKUP the osCommerce source files in your server before proceed with the below upgrade!

First of all, you need a FraudLabs Pro license key. You can register a free license key at https://www.fraudlabspro.com/sign-up if you do not have one.

Unzip the package.

Upload catalog/includeds/modules/fraudlabs_pro/process_order.php into server

Upload catalog/admin/includeds/modules/fraudlabs_pro/summary.php into server

Upload catalog/admin/includes/modules/fraudlabs_pro/feedback.php into server

Open catalog/includeds/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 license key.

$flpData['key'] = 'YOUR_LICENSE_KEY_HERE';



	Please take note that we suppose the osCommerce folder shall have the same structure as our package files. However, if the server folder doesn't start with catalog parent folder, please omit the catalog parent and upload the files accordingly.

Step 3: Edit checkout_process.php (server)

	Open catalog/checkout_process.php with a text editor.
	
		Search for:

		  $insert_id = tep_db_insert_id();
	
	Replace with:

		  $insert_id = tep_db_insert_id();

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


	

Step 4: Edit orders.php (server)

	Open catalog/admin/orders.php with a text editor.
	
		Search for:

		  $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');
	
	
		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']);
	
	
		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>
	
	
		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>


	

Step 5: Create FraudLabs Pro table in osCommerce database

	
		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(39) 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;


	

Step 6: Done

	You have successfully completed the installation process.
	What's next!? You can start customizing your fraud checking rules at https://www.fraudlabspro.com and start protecting your business from unwanted fraud attempts.

Copyright© 2017 FraudLabs Pro. All Rights Reserved.