Out of box
How to clone
We can use Classic mode to clone price books with related price book entries. I saw few Flow options to do this inlightningg too but need to test that.
How to update?
We can do manual updates from product objects or update price book entries through the Data loader.
Can one Price Book have two entries for the same product, with different currencies?
Yes, we can have two entries for the same product for different currencies
If a product has two price entries, for two different currencies, would an Opportunity or Quote automatically select the right price entry based on the currency of the Opportunity or Quote?
Yes, based on opportunity currency, it will only show selected currency-based product prices.
To improve the user experience.
Customize the Clone button. How many hours?
will check with Umair
What else do we need to do? How many hours?
Need to fix cloning issue on lightening
Should we use one price with duplicate price entries or two price books for different currencies?
Two price books with different currencies will be more feasible and easy to maintain.
Suggested Changes
Add currency on the Price book header
Customize the Clone option on Lightening to allow clone with related records ( Price book entries)
Only allow price book entries for header currency
The currency code should be editable on Price book entries
LWC component for Price book ?