Paying a fortune to HS to get:
HS doesnt have Total Cost in Line table (not total price). So Ive created a Calculated Property:
Total Cost = Unit Cost x Quantity
I cannot see this calculated property when Im trying to add in the Quote template line table.
HS answer: BUY Commerce Hub Pro+!!!
All of that to simply make a TOTAL …
Im open to any suggestion, workaround.
Hi @chrisvuillaume and thanks for sharing the details of your setup and what you’re trying to achieve with the HubSpot Community!
Here are some resources that you might want to take a look at:
- Legacy quote template variables
- Legacy quote templates
Now, let’s consult our Top Experts: Hi @evaldas, @HubDoPete and @TomM2 can you think of a workaround to help @chrisvuillaume, please?
Thanks so much and have a lovely day!
Bérangère
Bonjour/Good morning Berangere,
Ive checked both links.. none of them are explaining how I can inject in the Line item table included in a quote template, how to construct the TOTAL COST (again not the total price). TOTAL COST = Unit COST x Quantity. I ve already created a Calculated property (as recommended by HS support).. but impossible to present this Calculated property in Quote template
Bonjour @chrisvuillaume 
and thanks for getting back to us!
Here’s a handy workaround for legacy quote templates in Sales Hub:
With custom-coded templates using HubL, you can access line item data directly and calculate your Total Cost (Unit Cost × Quantity) within the template.
You can also use the crm_product_property parameter in the line items module to add custom product properties as columns, just note, calculated properties made in HubSpot settings won’t appear automatically.
If you’re using CPQ quotes in Commerce Hub, template customization isn’t an option.
If this feature would help your workflow, I recommend sharing your feedback through the Developer Feedback form, your input can make a difference!
Thanks and have a wonderful weekend!
Bérangère
- Si vous le souhaitez @chrisvuillaume, vous pouvez accéder à la Communauté francophone en changeant la langue dans les paramètres de votre profil -
This post was created with the assistance of AI tools
Hello HubSpot Support,
I am following up on your previous suggestion regarding using HubL and the
crm_product_property parameter to calculate “Total Cost” (Unit Cost ×
Quantity) on our quote templates.
I understand the logic, but I am not a developer and I cannot find where to
implement these changes within the standard HubSpot interface. I am
currently using the Drag-and-Drop Quote Editor, but I do not see the
“Design Manager” or a place to add HubL code.
Can you please assist with the following?
Locate/Enable Design Manager: I need to know where to go to create a
“Custom-Coded” template.
Implementation of HubL: We need a specific column in our Line Items table
that calculates: [Unit Cost] * [Quantity] = [Total Cost].
Our internal cost property is named: [Insert exact name of your cost
property here, e.g., “unit_cost”].
Clone for Internal Use: Our goal is to have an “Internal Quote” template
that Dave and Sara can apply to a cloned quote so Lisa (Accounting) has the
total PO amounts for our 3rd-party vendors.
Could you provide the specific code snippet for this calculation and
instructions on how to apply it to a new template?
Hey @chrisvuillaume, thank you for your message!
Great question, thanks for asking!
I’d love to put you in touch with our Top Experts: Hi @Anton, @zach_threadint and @SteveHTM do you have suggestions to help @chrisvuillaume, please?
Have a wonderful day and thanks so much!
Bérangère
Hi @chrisvuillaume, getting back to you on this!
Custom-coded quote templates are currently available only for legacy quotes in Sales Hub, not for CPQ quotes in Commerce Hub.
If you’re using the Drag-and-Drop Quote Editor, you’re likely on CPQ quotes, which don’t support code customization.
If you have a legacy quotes access: There isn’t a “Design Manager” button for editing these templates. Instead, you’ll use the HubSpot CLI (command-line tool): you download the boilerplate theme, make edits to the HTML/HubL files in your favorite code editor, and then upload your changes. This is typically handled by developers.
To calculate Total Cost for line items in your template, you can loop through LINE_ITEMS like this: {% for item in LINE_ITEMS %} {{ item.unit_cost|float * item.quantity|float }} {% endfor %} (Just update “unit_cost” to match your actual property name.)
To clone a template, simply duplicate and rename the file (e.g., “Internal Quote”), update its label, and upload it. Sales reps will then be able to select it when creating quotes.
If coding isn’t your thing, no worries at all! I recommend reaching out to a HubSpot Solutions Partner or a developer who can support you.
The process involves some command-line work, HTML, and HubL, and isn’t available through the regular UI, but help is definitely out there.
I hope this helps!
Bérangère
This post was created with the assistance of AI tools
Hi @chrisvuillaume, our app DocuGen can put your Total Cost calculated property right into the line item table of an internal quote, with no HubL or command line involved. @Berangere is right that the native CPQ templates won’t show it. DocuGen fills an Internal Quote template (built once) with the deal’s line items, including that Total Cost column, and saves the PDF to the deal. Dave and Sara generate it from the deal in one click, and Lisa gets the vendor PO totals without anyone leaving HubSpot.
You’ll find us on the HubSpot marketplace.
P.S. The free plan covers 400 documents a month with no watermark, and users are unlimited, so Dave, Sara and Lisa all get on at no cost.