/
/
Clean up your HubSpot product library before reps quote
For operations teams who want missing SKUs, bad margins and price drift found in the catalog, by asking their AI assistant.
On this page
Connector
Connect HubSpot, pick your AI tool and paste the prompt.
The problem
Reps quote from a product library full of gaps
Product libraries collect missing SKUs, blank prices, negative margins and products nobody sells. Reps then quote from bad data, and finding the problems means comparing the catalog with what actually sold on deals.
Without PopdockAI
- Export the product library
- Scan for missing SKUs, prices and descriptions
- Compare cost and price product by product
- Match deal lines back to products by hand
With PopdockAI
- Every product is checked for missing fields and duplicate SKUs
- Cost at or above price and recurring items with no term are flagged
- Deal line items are matched back to show what sold
- Lines sold over 20 percent off list are flagged, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Audit the HubSpot product library (type `{product-type}`, default all) and find products that are incomplete, unprofitable or unused since `{sold-since}` (default 365 days ago).
**Step 1: Products**
Call `hubspot-get-products`, with `product-type` when given.
**Step 2: Completeness and margin**
* Missing SKU, missing unit price, missing description.
* Unit cost greater than or equal to unit price (zero or negative margin).
* Recurring products (a `billing-frequency` is set) with no `term`.
* Duplicate SKUs.
**Step 3: Usage**
Call `hubspot-get-deal-line-items` with `create-date.from` = the start date. Match line items to products by `sku` (fall back to exact `name`). Count line items, quantity and net revenue per product. Also flag line items whose `unit-price` differs from the library price by more than 20 percent.
**Step 4: Report**
* Product table: name, SKU, type, unit price, unit cost, margin percent, line items, net revenue.
* Issue lists: missing data, negative margin, duplicate SKU, never sold in the window.
* Price drift: deal, product, list price, sold price.
**Rules & Guidelines:**
* This prompt is read-only. Do NOT call any write tool: `hubspot-add-contact`, `hubspot-add-company`, `hubspot-add-deal`, `hubspot-add-ticket`, `hubspot-update-contact`, `hubspot-update-company`, `hubspot-update-deal`, `hubspot-update-ticket`, `hubspot-add-contact-note`, `hubspot-add-company-note`, `hubspot-add-deal-note`, `hubspot-add-ticket-note`.
**Validation:**
* If there are no products, say so and stop.
* If line items hit `max-records`, say usage may be undercounted.Who it's for
One answer, three teams that use it
Sales operations
Clean the library before reps quote
Find products with missing SKUs, prices or descriptions and duplicate SKUs in one pass.
Audit our HubSpot product library for missing SKUs, prices and duplicates.
Product managers
See which products actually sell
See how often each product sold since a date and for how much, to retire the ones nobody buys.
Which HubSpot service products have not sold on any deal since last January?
Pricing analysts
Catch discounting and negative margins
Lines sold far from list price and products costing more than they sell for are flagged.
Which HubSpot products were sold more than 20 percent below list price this year, and which have negative margins?
How it works
What PopdockAI does when you ask
You pick a product type and a sold since date, and your AI assistant audits the HubSpot product library against real deals. It only reads.
01
Ask
You pick a product type and a sold-since date.
02
Check
It checks each product for missing fields, cost matching or over price and duplicate SKUs.
03
Match
It matches deal line items to products to see what sold and for how much.
04
Report
You get the gaps and lines sold over 20 percent off list, changing nothing.
What PopdockAI provides
The tools behind the answer
Ready made tools for HubSpot and one secure connection to your AI tool. No code, no exports.
hubspot-get-products
hubspot-get-deal-line-items
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
A clean catalog and visible price drift
Related use cases
More ways to put this data to work
Add a new HubSpot contact
Ask your AI to add a contact to HubSpot and it checks the email for duplicates, matches the company by name and domain, and saves only after you confirm.
Learn More
Add HubSpot list members to a Constant Contact list
Ask your AI to add HubSpot list members to a Constant Contact list and it finds who is missing, excludes anyone opted out, and adds people only after you confirm.
Learn More
Add HubSpot list members to a Mailchimp audience
Ask your AI to add HubSpot list members to a Mailchimp audience and it skips opt-outs and existing members, then adds the rest as pending after you confirm.
Learn More
Check a HubSpot contact's email consent
Ask your AI whether a HubSpot contact can receive marketing email and it checks subscriptions, lists and delivery history for a verdict with dated evidence.
Learn More
Check a HubSpot list's coverage in Drip
Ask your AI to check a HubSpot list against Drip and it groups members as active, unsubscribed, not in Drip or no email, with counts for each.
Learn More
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.