Duplicate store_transaction_id in transaction exports

  • 11 April 2022
  • 1 reply

Badge +1


I'm having problem with raw data which I get from Revenucat. If I talk about this problem, the data is coming in dublicated. store_transaction_id that occur in one day are dublicated. Actually, that day is happening and I think store_transaction_id should be singular value for unique users. So what am I missing? If you have any suggestions, please feel free to comment. 

Best Regards

1 reply

Userlevel 5
Badge +9

Hey @adnan!

store_transaction_id should be the unique identifier for a row, the original_store_transaction_id would be duplicated though?

Maybe you have the  “Receive new and updated transactions only” checkbox checked which could be causing duplicates if not handled properly? With this enabled, you’ll receive updated transactions each day as well, and you’d UPSERT to your database against the store_transaction_id. If you INSERT you’ll be adding duplicates.