Connectors

/

BigCommerce

/

Copy BigCommerce products into the HubSpot product library
Write
Cross-Connector

Keep the HubSpot product library in step with BigCommerce

For ecommerce and revenue teams who sell on BigCommerce and quote from HubSpot, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Copy BigCommerce products into the HubSpot product library
Bring the HubSpot product library up to date with our BigCommerce products whose names contain Trail.
I compared 12 BigCommerce products with the HubSpot product library. - To create: 3, including Trail Mug, SKU TM-12, price 18.00, cost 6.50 - To update: 2, including SKU TB-01, price 79.00 to 85.00 - Skipped: 1 product with no SKU - In sync: 6 Shall I make these 5 changes?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-product
hubspot-get-products
hubspot-add-product
hubspot-update-product

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

BigCommerce
Run it on your own BigCommerce data.

Connect BigCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

The HubSpot product library falls behind the store

When your catalog lives in BigCommerce, the HubSpot product library falls behind: new products are missing and prices and costs go stale. Fixing it means matching SKUs one by one, and a sale price copied by mistake ends up on every quote.

Without PopdockAI

  • Export products from BigCommerce
  • Search HubSpot for each SKU
  • Edit names, prices and costs by hand
  • Copy a sale price onto every quote by mistake

With PopdockAI

  • Products are matched to HubSpot by SKU, and those with no SKU are set aside
  • You see create, update and skip lists with before and after values
  • The regular price is copied, never the sale price
  • Nothing is written until you confirm, and each product is read back

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Make the HubSpot product library match up to `{max-records}` BigCommerce products (default 25, optionally only names containing `{product-name}`), matched by SKU. Nothing is written until the user confirms.

**Step 1: Read products from BigCommerce**

Call `bigcommerce-get-product` with `name.contains` set to `{product-name}` if given and `max-records` set to `{max-records}` (25 if empty). Keep `id`, `sku`, `name`, `price`, `cost-price`, `type` and `visible`. Products with an empty `sku` cannot be matched: list them and leave them out. Variant SKUs are not synced.

**Step 2: Compare with the HubSpot product library**

The join is the BigCommerce `sku` against the HubSpot `sku`, compared exactly after trimming. For each product, call `hubspot-get-products` with `sku` set to it.

* No match: call `hubspot-get-products` with `name` set to the BigCommerce `name`. If that finds a product, list it as a possible match with a different SKU and leave it alone. Otherwise the product goes on the create list.
* One match: compare `name`, `unit-price` and `unit-cost`. Any difference puts the product on the update list with the before and after values.
* More than one match: list the duplicates and leave them alone.

**Step 3: Confirm**

Show products to create (name, SKU, price, cost, type), products to update (record-id, field, current value, new value) and products skipped with the reason. Ask for an explicit yes and offer to exclude rows. Do not continue without a yes.

**Step 4: Write and verify**

For each confirmed new product, call `hubspot-add-product` once with `name`, `sku`, `price` from the BigCommerce `price`, `cost` from `cost-price` when it is above zero, and `product-type` set to inventory for a physical product or non_inventory for a digital one. For each confirmed change, call `hubspot-update-product` once with `id` set to the HubSpot `record-id` and only the fields that differ. Then call `hubspot-get-products` with `sku` set to each SKU and confirm the values. Report created, updated, failed and skipped rows.

**Rules & Guidelines:**

* `bigcommerce-get-product` is on the bigcommerce server; `hubspot-get-products`, `hubspot-add-product` and `hubspot-update-product` are on the hubspot server.
* The only write tools allowed are `hubspot-add-product`, once per confirmed new product, and `hubspot-update-product`, once per confirmed change, both only after the confirmation in Step 3. Call no other hubspot-add, hubspot-update, hubspot-rename, hubspot-remove, hubspot-subscribe, hubspot-unsubscribe or hubspot-import tool.
* Never call `bigcommerce-product-add`, `bigcommerce-product-update`, `bigcommerce-product-delete`, `bigcommerce-product-metafield-add` or any other bigcommerce add, update or delete tool. BigCommerce is only read here.
* Copy the regular `price`, not `sale-price`; a sale is temporary. Do not set `billing-frequency` or `owner-id`.

**Validation:**

* If `bigcommerce-get-product` returns nothing, say so and stop.
* If the user declines or does not answer, stop with nothing written.
* If a product does not show the new values on re-read, say so and do not retry blindly.

Who it's for

One answer, three teams that use it

Sales operations

Keep quote products current

New products and price changes reach HubSpot in one reviewed pass, so quotes use the right prices.

Update the HubSpot product library from BigCommerce and show me what will change first.

HubSpot administrators

Avoid duplicate products

Name matches under a different SKU and duplicate SKUs are listed rather than touched.

Sync BigCommerce products with Contoso in the name into HubSpot, but do not touch any duplicates.

Ecommerce managers

Push new launches to the sales team

New store products appear in HubSpot with name, price and cost, ready for reps to quote.

Add any BigCommerce products missing from HubSpot, using the regular price and cost.

How it works

What PopdockAI does when you ask

You ask in plain words and your AI assistant compares BigCommerce products with the HubSpot product library. Nothing is written until you have reviewed the changes and said yes.

01

Read

It reads BigCommerce products, setting aside any without a SKU.

Your AI tool

02

Compare

It matches each product to HubSpot by SKU and compares name, price and cost.

hubspot-get-products

03

Confirm

You review products to create, update and skip, and say yes.

No items found.

04

Write

It creates and updates the confirmed products and reads each one back.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.

get-data

bigcommerce-get-product

Returns products from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

hubspot-get-products

Returns products in the HubSpot product library, with SKU, price, cost, type, status and billing terms from the HubSpot connector. Filter by folder, status, unit price, sku, product type, name.
run-action

hubspot-add-product

Creates a product in the HubSpot product library and returns the new product's ID. Required: Name. Optional: SKU, Price, Description, Product type, Billing frequency, Unit cost, Owner ID. Writes to HubSpot.
run-action

hubspot-update-product

Updates a product in HubSpot. Only the fields you pass are changed. Required: Product ID. Optional: Name, SKU, Price, Description, Product type, Billing frequency, Unit cost, Owner ID. Writes to HubSpot.
Read only.Nothing in BigCommerce Changes

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.

How Popdock AI secures your data

The outcome

A HubSpot product library that matches the store

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation