Request for product line items to be auto converted based on your multi-currency price settings.
We want to use USD as standard for product line items, but as a business we are frequently asked to quote in GBP and ERO, so have set our system up to have all 3 currencies.
However, when setting up the product line items it would be helpful to just add in for one currency and the system to calculate the conversion. As a company we have hundreds of line items, now each needing the price to be added in manually three separate times as there is no option to just use the default company currency. The danger of human error with needing the converted line items to be necessary as well as the additional administrative requirement seems odd seeing as the conversion is already entered into the system.
Two solutions are possible to overcome this:
- Automatically populate the additional currencies in the product line items based on the company conversion rates set.
- Offer a conversion / exchange option when building the quote.
Hi Jessica, We are working toward offering such Currency conversions for Products in HubSpot Sales & Line Items.
The start is a new free app called “DoCurrencies” which is now available to install. It simply updates all currency rates in your portal each day.
It does not yet affect any product pricing but this is just our first step, as it uses these yet ‘unreleased’ Currency API.
Would you like to install it? it is free. You can install it here: https://marketplace.hubdo.com/en-US/apps/415197/docurrencies
Then for our user base of DoCurrencies users, we can get feedback and build out the Currency and Product features that everyone needs.
DoCurrencies will be on the HubSpot App Marketplace next week
Looking forward to your feedback!
best
Pete
I’d go a step further to mirror the product catalogue logic with a value for each currency. This will allow you to have a different currency on line items compared to the overarching deal. These would then auto convert to the different currencies so you can aggregate and report in whatever currency you like.
E.g. A deal is being paid in USD, we use an external supplier that shares an invoice in GBP. We should be able to add that line item in GBP to the deal and then it will convert to USD for the overarching value.
@DWhittington1 we’re struggling with the exact same - did you manage to find a solution?
@DWhittington1 and @mariadevicente8, same here.. I wish there was a setting to automatically set the product price in other currencies based on the custom fx rate rather than always manually updating the product price.
Hi @RPepin9 ,
We’ve solved this in several customer portals by adding custom-coded workflow actions to automatically update the product library, setting the product price in other currencies. Do you have Operations Hub to take care of this for you?
best
Pete
@HubDoPete , didn’t even think about this! We do have OpsHub. Are you able to trigger based on updated account settings?
Thanks!
Roxanne
Hi @RPepin9 ,
If you are automatically updating currency rates daily, I recommend scheduling the workflow to run exactly once per day.
Ops Hub does not have Product-Based workflows, so I normally host custom-coded actions like this on a company-based workflow and run it once per day on a single company object representing the portal company. (The enrolled company is not updated. The custom code updates product prices in batches)
Please be aware that each custom-coded action must be completed within 20 seconds. Using batch API calls, you can update multi-currency prices for 3,000 products in around 16 seconds. So if your HubSpot Product library exceeds 3,000 objects, break the task into a series of custom-coded actions, with each handling a subset of products. Happy to help if you need it.
best
Pete
@HubDoPete Of course! Not sure what I was thinking with that question, but that totally makes sense. Will have a think on this! Much appreciate the input!
Same here!
We don’t want to code anything; it is just a new feature that has to be developed by HubSpot! 