Skip to main content

Merchant Help

 

Affirm Merchant Help

Flat File Charge Management

You can manage your charges (Capture, Void, Refund, and Update) by sending us a batch of flat files. You might do this if your order management system can’t integrate with Affirm because of a technical limitation or if you need to minimize effort when managing charges.

Flat files are .csv files exported by your order management system that you send to an Affirm hosted sFTP folder. To use flat files as a part of your charge management process:

  • Your Order Management System/ERP must be capable of scheduling a .csv export of actions taken on orders
  • You can only deliver flat files via sFTP
  • You must deliver flat files at least once a day
  • Affirm must have an escalation email or alias for reporting processing errors

The filename format is:

YYYY-MM-DD’T’HH:mm:ss’Z’_YYYY-MM-DD’T’HH:mm:ss’Z’_[checksum_value].csv

The first UTC timestamp (HH:mm:ss) is the time of the earliest requested action and the second UTC timestamp is the time of the most recent requested action in the file.

The column header format for each flat file is:

Column Description
charge_id The Affirm Charge ID of the loan. Required
action Capture, void, refund, or update. Required
amount The loan amount, stated in USD cents (e.g., $100 = 10000). Required
data Add additional data to JSON request. Optional

Please reach out to your Client Success Manager to get setup to use flat files for charge management.