Salesforce Platform: Pricebook Entry Field Integrity Error via API

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.