Routy

Upload Report

Manually upload commission or performance data for this account.

When to Upload

Use this feature when:

  • The affiliate network doesn't support API integration
  • You need to import historical data
  • You have custom reports from the merchant

Supported Formats

Format Extension Notes
CSV .csv Comma-separated, UTF-8 encoding
Excel .xlsx First sheet is used
TSV .tsv Tab-separated values

Column Mapping

After uploading, you'll need to map columns from your file to Routy's fields:

  • Date — Transaction date (required)
  • Amount — Commission amount (required)
  • Currency — Currency code (defaults to account currency)
  • Order ID — Unique transaction identifier
  • Status — Approved, Pending, or Rejected
  • Sub ID — Your tracking sub-parameter

Tips

Duplicate detection: Routy checks Order ID to prevent duplicate imports. Make sure your file includes unique order identifiers.

  • Remove header rows that aren't column names
  • Ensure dates are in a consistent format (YYYY-MM-DD recommended)
  • Amounts should use period (.) as decimal separator