Price Validation Upload Specifications

Usage Description

This document outlines the master price file specifics for use with our FraudTrak’s price validation feature. This feature helps prevent price tampering by ensuring a minimum price is used for products at time of checkout.

Should you enable this validation feature within your FraudTrak administration area & upload a master product price list to our system, we will automatically validate the minimum cost per unit of all products submitted within the customer’s order. Should the cost supplied within a customer’s order be lower then what was specified in your uploaded data, the per unit fee specified within FraudTrak will be what is charged for said product. Should the cost supplied for said product be higher, we will use the higher price provided.

IMPORTANT NOTES:

  • Only 1 master price file is allowed to be uploaded into your account at any given time.

  • All old entries will be removed, upon uploading a new master price file to our system.

  • Ensure your master price file contains all item SKUs of products you are offering & is kept current, to prevent incorrect billing.

  • Item SKUs not contained within the master price file will be exempt from price validation.

  • This feature will use whatever price is highest for the given item SKU; whether it’s provided within the customer’s order or the master price file.

  • This feature should not be used in conjunction with product discounting features (such with Coupon Management & custom product discounting code).

File Format Specifications

When creating the upload file, the file must contain a header line and must be in a tab-delimited format.

The header must be formatted in this fashion:
!BATCH [tab] entry [tab] cost

Please Note:

  • The header line must be the first line in the file.

  • The “!” is required in the header line.

  • All fields are case sensitive in the header line.

All lines there after represent a single product price entry. Repeat for as many product entries as you offer.
Variable Required Max Size Notes
!BATCH Mandatory NA Value needs to be set to ‘fraudtrak_pricemgt’.
entry Mandatory 10 alpha-numeric SKU/model # of item. (see note 1)
cost Mandatory 10 Cost of item. [No ‘$’] [Format: 1234.56] (see note 2)

Notes:

  1. Ensure you enter the exact entry SKU/model# you used within your shopping cart/order form. This would be the same as the ‘itemX’ field you are sending us for EACH item you sell.

  2. Ensure you enter the exact cost per unit of the product being sold & that it matches your shopping cart/order form. This would be the same as the ‘costX’ field you are sending us for EACH item you sell.

Example File: Should be Tab Delimited

!BATCH entry cost
fraudtrak_pricemgt product_sku1 10.99
fraudtrak_pricemgt product_sku2 12.50
fraudtrak_pricemgt product_sku3 168.30
fraudtrak_pricemgt product_sku4 1234.56