If you purchased our Fraud Score service prior to November 2017, you're likely using an outdated, legacy version of the feature. We've made a ton of great improvements, so be sure to upgrade to the new Fraud Insights tool as soon as possible. 

What's Different?

The new version, called Fraud Insights, uses a scale of 1 to 99, representing the probability of risk (as a percentage). The higher the score, the higher the risk.

For more details about the new features, as well as a quick video tutorial, see our main article titled Fraud Insights 101.

How to Preserve Legacy Fraud Score Data

Because we've switched to a new service, Fraud Score will be no longer be available for any orders that were placed through your store prior to the upgrade. 

If you need to preserve any of the Fraud Scores on older orders, please be sure to do so prior to upgrading to Fraud Insights. 

Follow the instructions below to create a saved custom query and then export legacy Fraud Score data:

  1. Go to Inventory > Import/Export in your Admin Area.
  2. Click Saved Exports.
  3. To the right of the Saved Queries drop-down list, click Add New Query.
  4. Complete the required fields on this page as follows:
    QB Customer ID: 0
    QB Table: DB_Export
    QB Title: Fraud Score Old
    QB Query Type: SELECT
    QB Query:
    SELECT
    o.orderid,
    o.orderstatus,
    o.orderdate,
    (f.score * 3) AS 'FraudScore'
    FROM orders AS o
    JOIN fraud AS f ON f.orderid = o.orderid
    WHERE o.orderstatus <> 'Cancelled'
    QB Export File Type: CSV
  5. Click Save.
  6. Return to Inventory > Import / Export > Saved Exports.
  7. From the Saved Queries drop-down list, choose "Fraud Score Old".
  8. Click Export.

Legacy Fraud Score values for each applicable order will appear in the "Score" column of the resulting .CSV file.

All Ready to Upgrade?

Fill out the Fraud Insights Upgrade form to let us know!

Did this answer your question?