SubscriptionFlow allows you to import historical transactions for your records. This guide walks you through the process of importing transactions. Note that customers these transactions are tied to must already exist in the system.
Sample File:
Step 1: Prepare your file
Prepare your data. Make sure to include the following mandatory fields:
Mandatory Fields
| Name | Description | Example |
| Name | An identifier label | TR_001 |
| Amount | The quantity transacted. | 120 |
| Customer ID | A 25 character string that identifies a customer within the system. | 2bfd07aa-e055-467a-8381-edf7d7960f9e |
| Transaction Category | The category of transaction which may be Payment, Payout, Write-Off or Credit-Note. | Payment |
| Transaction Type | This is the type of transaction which may be payment or refund - the two transaction types. | Refund |
| Status | The status may be Paid, Pending, Declined, Failed. | Paid |
| Currency | The currency of the transaction | USD |
| Payment Source | A text descriptor of the payment mode. | Cash |
| Unapplied Amount | If not linked to an invoice this transaction can correspond to an unapplied amount that can be applied to future invoices | 50 |
| Invoice ID | A 36 character string that identifies an invoice in the system. | 66728254-50a3-4209-8dff-b7d2f7e3bd02 |
| Payment Method ID | To identify a specific payment method in the system against other payment methods. | ccof:CA4SEDfxxqF8zeYK5HwfJJMbRCQoAg |
| Transaction ID | A unique 35 character string to map relevant transactions in the system. | 65e55004-2630-42af-bd66-32caf772d69b |
**Note:**To import a refund the Category is set to Payment and the Type is set to Refund. To import a credit note set to Payment and the Credit-Note is set to Transaction.
You may also add optional fields such as miscellaneous charges, , reference, payment method ID and transaction ID.
Export your data to CSV; only CSV files are supported.
Step 2: Upload the file
- Open Transactions (if you don't see it, click Customize Navigation at the bottom of the left menu and move it to the visible modules). Click More, then Import. Import Data opens.
- Under Manual Import, click the CSV / XLS card. Click Browse Files, upload your file and click Next.
- Click Skip & Map Manually (or Analyze with AI to let AI clean the file and suggest mappings), then Next.
Step 3: Map the file
- Transactions isn't shown on File(s) Mapping by default. Click Configure.
- In Customize Import Modules, select Transactions under Hidden Modules, click the right arrow to move it to Visible Modules, and click Save Changes. You only need to do this once.
- Transactions now appears as a module. Drag your file from Unmapped Files onto Transactions, then click Next.
- On Field Mapping, check that each column is mapped to the right SubscriptionFlow Property, for example Customer ID to Customer and Transaction Type to Type. Click Next.
- Review Mapping shows the mapped fields. Click Next to start the import.
Comments
0 comments
Please sign in to leave a comment.