CSV Import & Export

Veridis Fraud Guard Free includes built-in CSV tools under WooCommerce → Fraud Guard → Import/Export to help you migrate existing blocklists, share records across stores, or archive backups.

Blocklist records only

CSV import and export apply exclusively to merchant Blocklist records. Activity logs are historical audit events and are not managed or exported via CSV.

CSV file format specification

CSV files must use standard UTF-8 encoding and comma delimiters. The header row uses the canonical format:

type,value,note
email,[email protected],Repeated non-payment
phone,+15551234567,Refused COD package #1042
ip,198.51.100.42,Bot checkout attempt
domain,example.com,Problem domain

Column specifications:

Column	Required	Accepted Values	Description
type	Yes	email, phone, ip, domain	The identifier type category.
value	Yes	String	The exact identifier value to evaluate.
note	No	String	Optional internal merchant note.

Header and row limits

The CSV file must not contain extra columns beyond type, value, and note. Imports accept up to 1,000 non-blank data rows (10 MB maximum file size) per upload.

Importing a CSV file

To import a blocklist:

1. Navigate to WooCommerce → Fraud Guard → Import/Export.
2. Under the Import Blocklist section, click Choose File and select your UTF-8 CSV file.
3. Click Import Blocklist.
4. Fraud Guard validates the file structure and provides diagnostic feedback:
   • Valid rows are added as active blocklist rules.
   • Normalized duplicate entries are automatically skipped without overwriting existing entries or notes.
   • Any invalid rows (malformed IP address, invalid identifier type, or missing values) are reported with specific row numbers and diagnostic reasons.

Exporting your blocklist

To export your store’s active blocklist:

1. Navigate to WooCommerce → Fraud Guard → Import/Export.
2. Select the Export Blocklist section.
3. Click Export Blocklist.

Fraud Guard streams all active Blocklist entries and merchant notes as a re-importable, UTF-8 CSV file.

Spreadsheet formula protection

To protect store managers opening exported files in spreadsheet software (such as Microsoft Excel, Google Sheets, or LibreOffice Calc), Fraud Guard automatically escapes potential formula triggers (=, +, -, @) upon export. During CSV import, Fraud Guard automatically safely unescapes these values back to their original form.