Shipments at Cloud Kicks (CK) are created and updated by the warehouse staff in a shipping application. The Information needs to be pushed into…

The core requirement is to perform an "upsert" operation: insert new records and update existing ones based on a key from an external system. The standard Salesforce mechanism for this is to use a field with the "External ID" attribute. This attribute designates a field as a unique record identifier from a system outside of Salesforce.

Data Loader is the appropriate tool for regular data integration tasks, as it is specifically designed to use an External ID field to match records and perform upsert operations efficiently. This combination directly prevents duplicate record creation while ensuring existing records are correctly updated.

A. Use the Import Wizard and match on the tracking number.

The Import Wizard is less suitable for regular, automated data pushes from an application compared to Data Loader. While it can match on an External ID, Data Loader is the more robust tool for this integration scenario.

C. Use the Import Wizard and match on the Salesforce ID.

The external shipping application would not have the Salesforce Record ID for new records, making it impossible to use this ID as the matching key for an upsert operation that includes creating new records.

D. Create a duplicate match rule and use Dataloader.

A duplicate rule is designed to block or report the creation of duplicate records. It does not facilitate the "update" part of the requirement; it would simply cause the data load to fail for existing records, not update them.

1. Salesforce Help & Training - Upsert Records: "Upsert combines insert and update into a single call. Upsert uses a record's ID or an external ID field to determine whether to create a new record or update an existing one." This document explicitly links the upsert operation with an External ID.

Source: Salesforce Developer Documentation, Bulk API Developer Guide, "Upsert Records".

2. Salesforce Help & Training - Data Loader Guide: "Use the upsert operation to both insert and update records at the same time. To use this operation, you need to specify an external ID field or the ID field to be used for matching."

Source: Salesforce Help, Data Loader Guide, "Insert, Update, or Delete Data Using Data Loader".

3. Salesforce Help & Training - Prepare Your Data for Import: "External ID: This is a custom field that has the External ID attribute, meaning that it contains unique record identifiers from a system outside of Salesforce."

Source: Salesforce Help, Salesforce Help, "Prepare Your Data for Import".