---
schema_version: "1"
id: 8ba53d99e0a6c9a9dbd003f7e73c629e6b03ebd642d621e190224b53ef856aea
title: Load Pricing Data from a Backend ERP System
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/ppp_scenario_load_erp_data.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.ppp_scenario_load_erp_data.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e25d86f2bbb32387b1d7a04cb766ae8c99bbfa899c221639d1d77bb0978dac74
description: Export pricing condition data from an ERP system and consolidate it for runtime pricing lookups — the load-and-consolidate procedure shared by the pricing scenarios in this section.
products:
  - Manufacturing
  - Automotive
  - Consumer Goods
release: "264"
---
# Load Pricing Data from a Backend ERP System

Export pricing condition data from an ERP system and consolidate it for runtime pricing lookups — the load-and-consolidate procedure shared by the pricing scenarios in this section.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong> and <strong>Unlimited</strong> Editions in Manufacturing Cloud, Automotive Cloud, and Consumer Goods Cloud, with <a href="https://help.salesforce.com/s/articleView?id=xcloud.ppp_editions_permissions.htm&amp;release=264.0.0&amp;type=5" title="Confirm the editions, add-on licenses, and organization-level permissions required before you configure or use Penny Perfect Pricing.">required add-ons</a>.</td></tr></tbody></table>

Each pricing scenario in this section uses this same load-and-consolidate procedure. In production, you typically export this data from a backend ERP system (for example, SAP) as CSV rather than entering it by hand.

1. Export pricing condition data from your ERP system as CSV, mapping the required fields: Merged Key Value (or individual key values), Pricing Value, Currency, Valid From, Valid To — plus Tier Threshold Value for scale/tier records.
2. From **Setup**, in **Quick Find**, enter Data Loader, and select **Data Loader**. Click **Insert**, and select **External Pricing Key Value** (standard conditions) or **External Pricing Key Value Tier** (scale/tiered conditions). Select your CSV, map the fields, and complete the import.
3. From **Setup**, in **Quick Find**, enter Data Processing Engine, and select **Data Processing Engine**.
4. Locate the **External Pricing Key Value Consolidation** job definition. This job ships as a packaged definition and can't be edited or deactivated directly. Select **Save As** to create an editable copy, and configure its execution parameters: for the first run (full sync), set **Last Sync Date** to 1970-01-01T00:00:00Z; for subsequent runs (incremental sync), use the timestamp of the last successful run. Unless you need this run to pick up records updated since then, use a timestamp earlier than those records' last-modified date instead.
5. Click **Save**, then select **Run Now**.
6. (Optional) To run this job automatically on a recurring basis, use **Salesforce Flow** to schedule it — running during off-peak hours is recommended. The Data Processing Engine builder doesn't include a native scheduling option for this job.

![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-penny_perfect_pricing-264-0-0-production-enus/8ac1130d-00eb-4b6b-ba82-4b09e6f166a0/images/icon_important.png)

Important The External Pricing Key Value Consolidation job must complete successfully before the system can retrieve newly loaded pricing data for order calculations.