Setting up syncing between ProductEngine and your Salesforce instance requires the following:
- An active sandbox or live Salesforce (SFDC) instance. We recommend using your sandbox or developer instance first.
- SFDC credentials that grant you:
- Read permission for objects: Product2, Pricebook2, PricebookEntry
- Read/Edit access to import/mapped fields: Product2, PricebookEntry
- Read/Edit access to any other custom mapped fields
- A ProductEngine plan or a valid trial that gives you access to Salesforce Publish Advanced.
Salesforce Publish Advanced features and considerations
- One product in ProductEngine can publish to 1 or more records in Salesforce.
- You can use Salesforce Publish Advanced to publish to standard and custom objects in Salesforce.
- You can use field data matching to determine whether to update a field or create a new record.
- For example, you may chose to update a Salesforce field (like quantity) by matching the Product Code in ProductEngine with Supplier ID in Salesforce. You can instruct ProductEngine to skip creating a new record using
- You can deploy to multiple instances without having to worry about different record Ids in Salesforce between instances
Salesforce Publish Advanced Lookup Configuration Reference
Before mapping data to a field, you have to setup parameters for a lookup. There are two ways to lookup data in Salesforce, they are:
- Lookup by query
- Lookup by data in either a CSV format or JSON format.
Both of these are discussed in the following sections.
Lookup by query
This is an example of a lookup by query:
{
"name": "Pricebook2",
"type": "query",
"query": "SELECT Id, Name, IsActive, IsStandard FROM Pricebook2 WHERE IsStandard = true OR (IsStandard = false AND IsActive = true)"
}
This is what this query looks like in ProductEngine:

You can also use the JSON editor to type the query.

Note: This is designed as a lookup tool and not a data mapping tool, we highly recommend selecting only the required fields, using WHERE conditions to reduce the size of the dataset and keeping to less than 2000 rows.