We installed the CSV import blocks inside our Airtable because we have a CSV file that we have to update daily to make sure the data is up-to-date. We use a column to merge with that always has a unique value (product_id). Like this we want to keep the data up to date for example when a price changes or when a new product is added.
The strange thing is that we import a CSV and we receive a lot of duplicates which are not in the CSV file itself. Even stranger is when we right after import the same CSV file again it will continue to import duplicate rows inside our Airtable. Since we just updated it, in my opinion there shouldn’t be any rows to update the second time we import the CSV.
Is there anyone that has experienced these kind of issues and does anyone know a solution how to solve this? It would help us out very much.
Thank you in advance!