I need to collate sales from the itch "purchases" CSV to those from Stripe and Paypal.
For a given sale in the itch "purchases" data, there is no unique ID that appears in either the Stripe "charges" data nor the paypal sales data. Right now, I'm trying to use the customer "full_name" column to make a match, but that is unreliable since names are not unique and, more seriously, the names for the SAME transaction do not always match (due to international characters being used). I have also tried to the use time, but this varies quite a bit and sometimes another customer's time is actually a closer match (due to overlapping transactions).
the customer email address is absent in the Stripe data, so i cannot use that.
Surely, everyone else must be having this same problem since otherwise they cannot properly make their business accounts.
Any ideas for a solution? thanks.