Import Price Books from Salesforce Sales Cloud to Pricefx

This template fetches Price Book entries from Salesforce via REST API and imports them to Pricefx as Product Extension, using a customer defined mapper.

ImportPriceBooks01.png

When configuring the template, the customer must define if the Salesforce instance is configured as multi-currency. If it is not, the customer must define the default currency.

Connection between PlatformManager and Salesforce

For details on creating the connection see Salesforce Configurations.

Installation

Go to PlatformManager > Marketplace, find Import Price Books from Salesforce to Pricefx, select Deploy and then select a target integration instance and template version.

Configuration Steps

  1. Choose Salesforce REST connection to be used.

  2. Configure Integration Template parameters:

    • Cron expression for triggering synchronization – Defines when this Integration Template should run. Example value: "0+0+*+*+*+?+*".

    • Salesforce API version – Version of the target Salesforce API. You should enter only the number, skip the usual "v" in the path. Example value: "48.0".

    • Flag defining if Salesforce is configured as multi-currency (true/false).

    • Default currency if Salesforce multi-currency flag is set to false.

  3. Define a mapper to map Salesforce Price Book entries to Pricefx Product Extensions. Available Salesforce fields are:

    • Pricebook2Id

    • ProductCode

    • IsActive

    • UnitPrice

    • CurrencyIsoCode

    • SFDC_PriceBook – Name of PX Extension table in Pricefx (needs to be created upfront).