Setting up syncing between ProductEngine and your Salesforce instance requires the following:

  1. An active sandbox or live Salesforce (SFDC) instance. We recommend using your sandbox or developer instance first.
  2. SFDC credentials that grant you:
    1. Read permission for objects: Product2, Pricebook2, PricebookEntry
    2. Read/Edit access to import/mapped fields: Product2, PricebookEntry
    3. Read/Edit access to any other custom mapped fields
    4. A ProductEngine plan or a valid trial that gives you access to Salesforce Publish Advanced.

Salesforce Publish Advanced features and considerations

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:

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.