Product2 Lookup
Product2 object in Salesforce represents a service or a physical product.
Required fields:
- ProductCode (required by PowerSync)
- Name (required by Salesforce)
Logic:
Primary goal is to find all Product where "SKU" field matches a ProductCode of a Product2 in Salesforce
Valid matches:
- SKU match
- Magento ID match (SKU could be different) - this matching has highest priority
Duplicate Found
If duplicate Product2 are found in Salesforce, an appropriate error should be shown in Magento to the merchant. Error should read: "Duplicate products in Salesforce found that use the same SKU (mySku123). Please delete all duplicates and re-try synchronization."