Automating Price Book Entry updates

By | August 10, 2018

We run an Appexchange app that updates the currencies in our multi-currency org. The problem for us is that we’re based in a country with a volatile currency, and a huge list of products that are bought in various currencies.

I would like to be able to do the following:

  1. Run the exchange rate update app
  2. Automatically send the updated exchange rates into a product cost calculation object
  3. After the cost calculation has updated, send an update to our selling price book, so that our pricelist is quickly and easily updated.

I have attempted to use a flow, but i found myself going circles.

As an addition, i would also like to share the price book as a simple table in a partner community.

Can anyone give me a pointer as to where to start with this?