/
/
Spot product and price drift between BigCommerce and Nutshell
For operations teams who want store products matched to the Nutshell product list by SKU, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Quotes go out at old prices from a stale CRM list
Sales quotes from the Nutshell product list while BigCommerce changes prices and SKUs. Nobody compares the two, so quotes go out at an old price or for a product that is no longer sold.
Without PopdockAI
- Export products from BigCommerce
- Export products from Nutshell
- Match SKUs and compare prices by hand
- Quote a product you no longer sell
With PopdockAI
- Visible store products and Nutshell products are read
- They are matched on SKU, ignoring case and spaces
- Missing products on each side and price mismatches are listed
- Empty SKUs and other currencies are set apart, 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:** Compare BigCommerce products with Nutshell products by SKU, for products matching `{name-contains}` (default all, at most 50), and report what is missing or priced differently.
**Step 1: Read the store products**
Call `bigcommerce-get-product` with `name.contains` set to `{name-contains}` (omit it if empty), `visible` set to true and `max-records` 50. Keep `id`, `sku`, `name`, `price` and `availability`.
**Step 2: Read the CRM products**
Call `nutshell-get-product` with `max-records` 200, and with `name.contains` set to `{name-contains}` when given. Keep `sku`, `name`, `price`, `currency`.
**Step 3: Match on SKU**
Match on `sku`, ignoring case and surrounding spaces. Products with an empty `sku` cannot be matched; list them separately. For each match, compare `price`; for products on one side only, say which side.
**Step 4: Report**
Report three lists: in BigCommerce but not Nutshell, in Nutshell but not BigCommerce, and price mismatches (SKU, name, BigCommerce price, Nutshell price, difference). End with the counts.
**Rules & Guidelines:**
* `bigcommerce-*` tools are on the bigcommerce server and `nutshell-*` tools are on the nutshell server. Both servers must be connected.
* This is read-only. Never call any add, update or delete tool on either server (for example `bigcommerce-customer-update`, `nutshell-add-person`, `nutshell-update-lead`, `nutshell-delete-company`).
**Validation:**
* If either side returns nothing, say so and report the other side as unmatched.
* Do not compare prices when the Nutshell `currency` is not the store currency; note it instead.Who it's for
One answer, three teams that use it
Sales operations
Keep the CRM product list current
Store products missing from Nutshell are listed, so reps can quote them.
Which visible BigCommerce products are missing from Nutshell?
Sales reps
Quote the right price
Price mismatches with the difference show where your CRM prices are out of date.
Compare BigCommerce and Nutshell prices for products with chair in the name.
Catalog managers
Retire products no longer sold
Nutshell products not in the store point to items that should be retired from quoting.
Which Nutshell products are no longer in our BigCommerce store?
How it works
What PopdockAI does when you ask
You optionally give a name fragment and your AI assistant compares BigCommerce and Nutshell products by SKU. It only reads.
01
Ask
You optionally give a name fragment to narrow the products.
02
Read
It reads the visible BigCommerce products and the Nutshell products.
03
Match
It matches on SKU and compares prices, listing empty SKUs separately.
04
Report
You get three lists and counts.
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.
bigcommerce-get-product
nutshell-get-product
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
Product and price drift found before the next quote
Related use cases
More ways to put this data to work
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.

.webp)
