We are trying to import Product2 and PriceBookEntry data from a single table in SQL server. It will be a weekly scheduled job.
The insert operation works fine. But How do we upsert the modified records next week.
Say, we imported 100 records in first week.
next we may have 20 new and 10 modified records. How do we import them without duplicating the modified records.