We’re experiencing an issue where the line items on one of our deals (178 line items) appear to be displayed in a random order. We can’t pinpoint when or why this happened.
After some investigation via the HubSpot API (using an MCP connection with Claude), I extracted all line item IDs together with their hs_position_on_quote values. The hs_position_on_quote field should determine the display order of line items on the quote, but the values are not aligned with the chronological order in which the line items were created.
I’ve shared the extracted data in this Google Sheet for reference:
https://docs.google.com/spreadsheets/d/1G5HDkKAbwWpwVcYkqBBw3N0EDIpTz8XF3FNLSC6qy1Y/edit?gid=0#gid=0
My questions:
1. Has anyone experienced line items being reordered unexpectedly on a deal with a large number of line items?
2. Is there a known issue with hs_position_on_quote when line items are added to a deal in multiple sessions or via an integration?
3. Has anyone successfully bulk-updated hs_position_on_quote via the API to restore the correct order? Any pitfalls to watch out for?
Any help or pointers would be greatly appreciated!
Thanks