Print this page

"field integrity exception" error when updating Pricebook Entry object via the API

Knowledge Article Number 000193277
Description When attempting to mass update the Pricebook Entry object via the API the error "field integrity exception" is received because the checkbox "Use Standard Price" is checked on the Pricebook Entry record.  

In other words, once the Pricebook Entry has the "Use Standard Price" checkbox checked that record becomes unavailable via the API with exception of the "Use Standard Price" field itself. 
Resolution To fix this issue, you have to update your csv file so it cancels the setting "Use Standard Price" for the Pricebook entries you are updating.

1) Add a column to your csv file with the header: "Use Standard Price" and set the value to FALSE for all rows

2) Use the updated file to perform the mass-updates

promote demote