function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
TS21TS21 

Duplicate records are created during upsert in Apex batch job.

I need to extract records from an external application database table and Create a new table (custom object named CustomObj) in Salesforce to receive the data upload (upsert this based on the id using Data Loader).

I need to create an Apex Batch job so that it can be scheduled and from the uploaded data, need to create SOQL statement to fetch some fields from CustomObj and Upsert those fields to Product2 object in Salesforce.

My issue is when I run the Apex Batch job second time it inserts the same set of records again in Product2 object when it should have done the update operation. It causes duplicate records in Product2 object. Below is my code to have a look. Please help me.

global class ProductUpsertBatch implements Database.Batchable<sobject> {
   // Start Method
   global Database.QueryLocator start(Database.BatchableContext bc) {
            return Database.getQueryLocator('Select id, ExternalAppUniqueId__c, Name, Description__c, Category__c, uom__c, Cost_Price__c From CustomObj__c');
       }
       //execute method
       global void execute(Database.BatchableContext bc, List<sObject> scope) {

           list<Product2> newObjects = new list<Product2>();

           for(Sobject s : scope){
               CustomObj__c obj = (CustomObj__c) s;
               newObjects.add(new Product2(
                   ExternalId = obj.id,
                   ProductCode = obj.Name,
                   Name = obj.Formula_Description__c,
                   QuantityUnitOfMeasure = obj.uom__c,
                   Description = obj.Category__c,
                   Cost_Price__c = obj.cost_price__c
               ));
           }
           upsert newObjects;
               }
       //finish method
       global void finish(Database.BatchableContext bc) {
          system.debug('ProductUpsertBatch is finished processing');
       }
}
Best Answer chosen by TS21
Waqar Hussain SFWaqar Hussain SF
Hi Tanu,

There is no standard field with name ExternalId on Product2 standard object. If you are using custom field, you will have to append __c such as ExternalId__c and make sure that you have checked External Id checkbox in the custom field defination. 

All Answers

Waqar Hussain SFWaqar Hussain SF
Hi Tanu,

There is no standard field with name ExternalId on Product2 standard object. If you are using custom field, you will have to append __c such as ExternalId__c and make sure that you have checked External Id checkbox in the custom field defination. 
This was selected as the best answer
TS21TS21
Hi Waqar,

Thanks for the reply, I do have ExternalId standard field on Product2(Snapshot below)​

ExternalId Field on Product2

Thanks!
TS21TS21
Hi Waqar,

Thanks for your earlier reply, I have figured out the problem and created ExternalId custom field as suggested by you which worked.

Thanks!
Waqar Hussain SFWaqar Hussain SF
Great