Connectors

/

BigCommerce

/

Reconcile BigCommerce products with Nutshell products
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile BigCommerce products with Nutshell products
Compare our BigCommerce products with Nutshell by SKU for anything with tea in the name.
Compared 18 BigCommerce products with 15 in Nutshell: 12 matched, 2 priced differently. - In BigCommerce only: NW-TEA-500, NW-TEA-GIFT, NW-TEA-SAMPLE - In Nutshell only: NW-OLD-TEA - Price mismatch: NW-TEA-250, BigCommerce 18.50, Nutshell 17.00, difference 1.50 - Skipped: 1 Nutshell product with an empty SKU Want the second price mismatch spelled out?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-product
nutshell-get-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

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.

Prompt
**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.

Your AI tool

02

Read

It reads the visible BigCommerce products and the Nutshell products.

bigcommerce-get-product
nutshell-get-product

03

Match

It matches on SKU and compares prices, listing empty SKUs separately.

No items found.

04

Report

You get three lists and counts.

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

nutshell-get-product

Returns the products in the Nutshell product catalogue with their prices.
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

Product and price drift found before the next quote

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