I am trying to import CSV file with a bunch of contributions that I have downloaded from Stripe, but it is requiring that Transaction ID and Invoice ID be unique across all Contributions.
When creating the CSV file (using a script), I will create a seperate line for each item in an individual Stripe transaction.
So if a single transaction on Stripe for $100 shows Building Fund $75 and General Fund $25, then in my CSV file that is generated, I create two seperate lines with basically all identical information except the Amount and the Financial Type. Since both these items come from the same Stripe transaction, they both have the same Transaction ID (I am using Stripe Charge ID for this).
When I try to import the Contributions I get error log file with this: "Duplicate error - existing contribution record(s) have a matching Transaction ID or Invoice ID. Contribution record ID(s) are: 2"
I am importing as INSERT NEW CONTRIBUTIONS and my mapping is match on EMAIL only (I have made sure there are not duplicate emails in my contacts).
Has anybody else come across this issue?