/
/
Find BigCommerce products missing or mispriced in Rillet
For operations teams who want the store catalogue checked against the Rillet product list by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
The store catalog and the ledger catalog drift apart
Products are set up in BigCommerce and again in Rillet, and the two catalogs drift. Invoices then carry the wrong product or price, and finding the gaps means lining up two lists by name.
Without PopdockAI
- Export BigCommerce products and the Rillet product list
- Line them up by name in a spreadsheet
- Compare prices row by row
- Miss products where the SKU only appears in a description
With PopdockAI
- Visible best sellers are read from BigCommerce with the Rillet list
- Matching is by exact name, then by SKU in the Rillet name or description
- Each product is marked Matched, Price differs or Missing
- Name-only matches are labelled as suggestions, and nothing is created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List the best-selling BigCommerce products (at least `{min-sold}` units sold, default 10) and show which have no matching product in Rillet.
**Step 1: Store products (bigcommerce server)**
Call `bigcommerce-get-product` with `total-sold.min` = `{min-sold}`, `visible` true and `max-records` 100. Keep `id`, `sku`, `name`, `price`, `total-sold`.
**Step 2: Ledger products (rillet server)**
Call `rillet-get-products` and keep `product-id`, `name`, `price`, `currency`, `status`, `account-code`.
**Step 3: Match**
Match each store product to a Rillet product by exact `name` (case-insensitive), then by `sku` appearing in the Rillet `name` or `description`. Mark Matched, Price differs (show both) or Missing, and note a Rillet product with `status` inactive.
**Step 4: Report**
A table of Missing and Price-differs products ordered by `total-sold`, then counts.
**Rules & Guidelines:**
* `bigcommerce-*` tools are on the bigcommerce server; `rillet-*` tools are on the rillet server. Both servers must be connected.
* This prompt is read-only. Never call any bigcommerce `-add`, `-update` or `-delete` tool or any rillet `-add`, `-update`, `-apply`, `-unapply`, `-record`, `-set` or `-setup` tool.
* Quote ids and amounts exactly as returned. Do not guess a match.
**Validation:**
* If either side returns nothing, say so and stop.
* A name-only match is a suggestion; label it as such.Who it's for
One answer, three teams that use it
Accountants
Keep invoice products in line with the store
Products missing from Rillet are listed by units sold, so you add the ones that matter first.
Which BigCommerce products with 50 or more units sold are missing from Rillet?
Catalog managers
Find price differences between systems
Price differs rows show where the store and the ledger disagree on price.
List BigCommerce products whose price differs from the Rillet product price.
Finance operations
Check catalog setup before month end
Counts of matched, missing and mispriced products give a quick health check before close.
How many BigCommerce best sellers are matched, missing or priced differently in Rillet?
How it works
What PopdockAI does when you ask
You set a minimum units sold and your AI assistant checks those BigCommerce products against Rillet. It only reports and never creates a product.
01
Ask
You give a minimum units sold, or accept 10.
02
Read
It reads the visible BigCommerce products and the Rillet product list.
03
Match
It matches by exact name, then by SKU in the Rillet name or description.
04
Report
It lists Missing and Price differs products by units sold, with 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
rillet-get-products
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
Missing and mispriced ledger products, found by units sold
Related use cases
More ways to put this data to work
Check BigCommerce refunds against Rillet credit memos
Ask your AI to match refunded BigCommerce orders to Rillet credit memos and report which refunds have none, with ambiguous matches flagged and nothing created.
Learn More
Compare BigCommerce sales with Rillet invoiced revenue
Ask your AI to total BigCommerce orders and refunds against Rillet invoices and credit memos for a period and get the gap per currency, with partial sums flagged.
Learn More
Find BigCommerce customers missing from Rillet
Ask your AI which recent BigCommerce customers are not customers in Rillet and it matches on email then name, never guesses and changes nothing.
Learn More
Reconcile a BigCommerce order with a Rillet invoice
Ask your AI to find the Rillet invoice for a BigCommerce order and it compares total, currency and date, labelling inferred matches and refusing to pick between ties.
Learn More
Review BigCommerce gift certificate liability in Rillet
Ask your AI to compare active BigCommerce gift certificate balances with the Rillet balance sheet and it shows the difference, never assuming zero when no line is found.
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.