topic Calculated field in Product properties in Tips, Tricks & Best Practices

Calculated field in Product properties

mattjohnson068 — Thu, 16 May 2024 12:38:04 GMT

Hi there!

I've been looking around but cannot seem to find an exact answer. I am building products in HubSpot for rolls of material. The roles have a lenght and width and I want to auto calculate the m2 based on these two feilds i.e

Feild 1 - Width: 0.7m

Feild 2 - Length: 8.0m

Feild 3 - Square Meterage: [width] x [length]

Calculated properties seem greyed out when I go to select them, so I wondered if there was a solution or work around for this?

I have Marketing hub starter and Sales hub professional only.

Re: Calculated field in Product properties

Lucila-Andimol — Thu, 16 May 2024 12:51:15 GMT

Hey @mattjohnson068

calculated properties are available for PRO versions

as you mentioned you have Sales Pro, you should be able to create this properties in Deals.

Have you tried changing the object?

Ohh I see you are trying to create it in Products> this is not possible.

you can try to do this with Zapier maybe.

Re: Calculated field in Product properties

LouiseHare — Thu, 16 May 2024 12:49:23 GMT

Hi @mattjohnson068 ,

Calculated properties aren't possible on the Product object, unfortunately.

My only suggestion would be that you create a different product for each possible size for every individual roll of material - I appreciate that this could end up with a lot of products!

You can submit your feedback on the inability to create calculation properties on the Product object to the Ideas forum. This is where the HubSpot product team go to get product/feature update ideas so something may come of it.

Sorry I can't be of more help,

Louise Hare she/her

Freelance HubSpot Expert

If my reply helped to answer your question please mark it as a solution to make it

easier for others to find!

Re: Calculated field in Product properties

mattjohnson068 — Thu, 16 May 2024 12:52:45 GMT

Thanks very much for clarifying @LouiseHare !

Re: Calculated field in Product properties

mattjohnson068 — Thu, 16 May 2024 12:53:14 GMT

This is specifically for products unfortunately!

Re: Calculated field in Product properties

MarketingMagpie — Wed, 18 Sep 2024 07:57:13 GMT

This is really is needed @hubspot we have the same problem and sell exhibition space. So stand has a length and depth and need to work out total SQM. Our old platform did this and it's really not ideal we can't replicate it. I am sure there are others that would benefit from this.

We can do this in deals but on a deal we may have 2 or more stands if booking for multiple years or 2 x regional events so it wouldn't really work.

We would also ideally want to know yield. So in publishing the amount paid / page size = yield and with exhibitions the amount paid / total sqm = yield.

Are there any plans to get this in future or even better is there something in beta? It really would be immensely useful!

Re: Calculated field in Product properties

PollyPieCharts — Thu, 03 Oct 2024 15:21:53 GMT

Hi, I have the sam problem. Calculated properties on the Product are EXTREMELY NECESSARY!

HubSpot please 🙏

Re: Calculated field in Product properties

hapilyJonathan — Fri, 31 Jan 2025 18:40:41 GMT

Hey @mattjohnson068

I’m with hapily, a HubSpot App Partner, and we offer a HubSpot app called quote•hapily that supports calculated pricing for line items. The quote•hapily calculated pricing allows you to create several different types of formulas and apply them to line items.

Once you have configured your calcualtions you will be able to enter in the values while editing the quote when adding line items and configuring your quote through the quote•hapily quote builder. This calculation will then apply to the line item's unit price.

Hope this helps!

Best,

-Jonathan