Now that we can create custom properties for Products, can we enable calculated properties for Products? Without this basic feature, our products have quantitative properties that we have to manually calculate before adding to HubSpot. This creates room for error.
Been using HubSpot since 2017. We only offer 10-12 courses but every year we have to update thousands of Product Prices because we cannot add one field to our Quotes -> Weeks.
We just want to muliply our Product ["Course"] Price by
- number of students AND
- number of weeks
Waiting best part of a decade & its not like HubSpot is cheap software...
Hi everyone! My name is Hallie, and I'm an Associate Program Manager on our CXM team here at HubSpot. I've been in communication with our product team regarding this product, and they confirmed that while this is something on their radar, it's not on the roadmap over the next few quarters, so it's being marked as 'not currently planned' at this time.
With that said, the team would still find more use cases around this helpful to understand the value this feature could add in more depth. Please continue to leave any example use cases here in comments, and I'll share any updates here in the future around this if they arise. 😊
@hhiggins This feature really is a basic requirement for any business wanting to report accurately at product line level. Other restrictions in line item functionality make it even more critical such as lack of workflows based on Product Lines that could be used to calculate line item properties.
Some of the use cases our business requires this for are:
- Managing cost credits from suppliers given that it is not possible to enter a negative cost against a product. We have had to create a custom property for cost credits but can't then calculate the true margin value of the line item. (Weirdly, negative costs can be added during an import but expecting salespeople to run an import for a single line item just because of this anomoly is overkill).
- Our business is measured on the "net new" value of sales so if we are renewing a line item with some uplift, we add a negative value to reflect the existing line item value. We then can't calculate the net new amount at product line level.
- Calculating sales commission at product line level. This currently has to be extracted to a spreadsheet.
I really hope this development can be moved along more quickly. Having moved over from Salesforce last year, these limitations in HubSpot would defintely discourage me from recommending anyone to move if their business includes any product complexity.
@egp19 This is unfortunate to hear as for our use case we need to have 2 types of fee that contribute to a line item total. We will therefore have to use PandaDoc, which means we will miss out on using quoting, payments and invoices via HubSpot
Need this. We are a SAAS company and use a 12-month term to calculate TCV. However, the discount term is often less, something like 6 months. Calculated properties would allow us to roll up the actual TCV after the partial-term discount, and update the deal amount correctly. For now we have to use a workaround of adding the same product twice, once with the discount and once without.
We recognise revenue differently in our Finance team vs. Sales team (to allow reps to be paid commission in a timely fashion). We want to create a calculated Date field for Finance and a calculated Date field for Sales on the Line Item level which will allow us to report & forecast accurately.
Right now, my team has about 30 different yes/no properties for whether a product falls under a specific category, as multi-checkbox is not usable as a rollup calculation property on the Deal level; this means that creating a new product requires a significant number of questions to be answered with accuracy when most of these details are easily extracted from other properties. Calculated fields would take a significant configuration burden off of the Product library and save us a lot of time long-term -- for the setup of our current library, it took an obscenely long time and a lot of trial and error to figure out how to get it setup the way we needed it to leverage Deal reporting. If I had known this many workarounds were necessary, I may not have considered moving my sales team to HubSpot and instead just continued to operate out of our old system.
We're also looking foward to use calculated properties for products. We need this, cause we use different prices depending on the size of the customers. For offering we have to count the prices depending on factor. If we could use calculated properties it would be much easier to handle.
In nearly every object we can use workflows or calculated fields to attapt we values in HubSpot. But for products and LineItems there is nothing. It' s sad.
See https://app-eu1.hubspot.com/support-inbox/[HubID]/tickets/[ID]
My team is looking to have a calcuation for each Deal of how much revenue to anticipate by EOY for the Deal, and because each product Line Item can have a different Billing Start Date, the most accurate way to get the total we want would be to calculate the anticipated revenue by EOY on each Line Item and then sum them for the Deal. I'm no confident the functions available in calcuations would allow me to do this anyway, but there's no way to even try without the calculation functionality.
Hi from the Commerce team! We are actively working on enabling custom properties directly on Line Items, which would support calculated properties as well other property types as well (rollups, sync properties, etc). We are working toward opening up a private beta shortly. We don't immediately have plans to support calculated properties on Products but open to learning more there and exploring that option. Thanks!
Hello from HubSpot! As of today we've enabled Line Item custom properties for all portals, including calculated property support for those tiers that include them. This allows better modeling of Line Item-only properties (such as around discounting), defining calculated properties to minimize manual work or conditional properties to collect required information. To get started, go to Settings > Data Management > Properties and Select Line Item properties from the dropdown. Read more here: https://app.hubspot.com/l/product-updates/?rollout=269893
This better unifies Line Items with other CRM object capabilities. There are related asks on supporting field-level permissions that is being planned, and the supporting a custom formula to set the unit price/discount/amount that is being explored.
