Best Practice For Uploading CSV Files

[Duck Duck]

We have a customer control panel where customers can upload their products into our online shop. For each product, we also need to call a third party API. But what's the best practice for allowing users to upload their own CSV files?


1. Bulk upload the CSV file directly into the destination products table, then call the API, then update the data as needed.

2. Bulk upload the CSV file into a staging table, then call the API, then insert the row into the destination products table.