Loading

Salesforce Platform: Pricebook Entry Field Integrity Error via API

Publiceringsdatum: Mar 31, 2026
Beskrivning

  1. API (Application Programming Interface):

    • Provides programmatic access to Salesforce.
    • Enables integration with external systems and automation of processes within Salesforce.

  2. Pricebook Entry:

    • Represents the association between a product and a pricebook, defining product pricing in a specific pricebook.
    • Each Pricebook Entry links a product (Product2) to a pricebook (Pricebook2) and specifies pricing details like unit price and currency.

When you attempt to mass update the Pricebook Entry object with Data Loader or other API tools, the error "field integrity exception" is received.

This is because the checkbox 'Use Standard Price' is checked on the Pricebook Entry record. This means that the field becomes unavailable via the API with exception of the ability to update the 'Use Standard Price' field itself.  

To resolve this issue, update your PricebookEntry records and set the "Use Standard Price" field to false before you attempt to update product's unit price.
 

Lösning

To set the "Use Standard Price" field to false 


1. Add a column to your CSV file with the header: "UseStandardPrice" and set the value to FALSE for all rows.
2. Perform an update to the PricebookEntry object with Data loader and map only the Id and UseStandardPrice fields. For more details, please review Insert, Update, or Delete Data Using Data Loader.
 

Once this update is complete, you will be able to perform your original update as intended.


Notes:

  • If you want to associate a different Price for a product in a custom pricebook, you will need to map the PricebookEntry ID and the Unit Price fields on update.
  • You'll need to set "Use Standard Price" to false and then perform a separate secondary update to set your desired "Unit Price" on your PricebookEntry records.


 

Knowledge-artikelnummer

000386253

 
Laddar
Salesforce Help | Article