function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Upserting data into PriceBookEntry table

We need to do a daily upsert of Pricing data from our quoting tool into the PriceBookEntry table in SFDC. Problem is that we cannot create a custom field in PriceBookEntry in SFDC, that can store the unique Pricing ID from the quoting tool, which can be used for the daily upsert process using Cast Iron. Also, we cannot get the PriceBookEntry IDs to be stored in a custom object, as you cannot write triggers on PriceBookEntry!

Has anyone encountered a similar scenario wherein there is a requirement for synchronizing the PriceBookEntry table between an external system and SFDC??


Hi there,


yes indeed we're doing that with Cast Iron. We added our unique external key field on Product2. So we upsert on Product2 then just upsert on PriceBookEntry with an entry for each currency, for each product.







I am also facing a problem while upserting in pricebookentry through cast iron.I have successfully upserted in product2 i got product2id and i have currencyisocode , to upsert in pricebookentry if i dont have pricebookentryId.kindly tell me the step how u have implemented in castiron. 


I have this problem too, actually not Cast Iron have this problem, all the solutions work with upsrt price book entry would occurr this.