Connectors

/

BigCommerce

/

Reconcile a BigCommerce order with a Dynamics 365 Sales order
Report
Cross-Connector

Check a BigCommerce order against its Dynamics 365 Sales order

For finance teams who want a web order matched to the Dynamics 365 Sales order or invoice, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile a BigCommerce order with a Dynamics 365 Sales order
Check whether BigCommerce order 10482 has a matching sales order or invoice in Dynamics 365 and whether the amounts agree.
Amount differs. Order 10482 has a likely match in Dynamics 365 Sales. - BigCommerce total: 1,245.00 USD, 3 lines - Match: invoice INV-1042, status Active - Dynamics 365 total: 1,215.00 USD - Difference: 30.00 Shall I compare the line items against the sales order details?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-order
bigcommerce-get-order-product
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-accounts
microsoft-dynamics-365-sales-get-salesorders
microsoft-dynamics-365-sales-get-invoices
microsoft-dynamics-365-sales-get-salesorderdetails

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

Totals that disagree hide under a parent account

Finance compares a BigCommerce order with the sales order or invoice in Dynamics 365 Sales by switching screens. Totals that disagree are easy to miss, especially when the CRM record sits under a parent account.

Without PopdockAI

  • Open the order and lines in BigCommerce
  • Search Dynamics 365 Sales by customer or account
  • Scan sales orders and invoices for a similar total
  • Force a match that is not really there

With PopdockAI

  • The order and lines are read and the customer found by email or company
  • Sales orders and invoices near the order total are searched
  • Nearest candidates are listed when nothing is in range
  • Currencies are never mixed, 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:** Check whether BigCommerce order `{order-id}` has a matching sales order or invoice in Dynamics 365 and whether the amounts agree.

**Step 1: Read the BigCommerce order**

Call `bigcommerce-get-order` (BigCommerce server) with `id` set to `{order-id}`. Then call `bigcommerce-get-order-product` with `order-id` set to `{order-id}`. Record the billing name, billing email, company, order total including tax and the line items.

**Step 2: Find the customer in Dynamics 365**

Call `dynamics-365-sales-get-contacts` (Dynamics 365 server) with `email` set to the billing email, and use the contact's parent customer name. If none, call `dynamics-365-sales-get-accounts` with `account-name` set to the billing company.

**Step 3: Find the matching documents**

Call `dynamics-365-sales-get-salesorders` and `dynamics-365-sales-get-invoices` with `customer` set to the customer name from Step 2, and `total-amount.min` and `total-amount.max` set to the BigCommerce total plus or minus `{amount-tolerance}` (default 1.00). If nothing matches in range, repeat without the amount filter and list the nearest candidates.

**Step 4: Report**

Show the BigCommerce order total and lines next to the best Dynamics 365 match: amount, status, and difference. Verdict: Matched, Amount differs, or No match. For a match, compare line items using `dynamics-365-sales-get-salesorderdetails` with `order` set to the order name.

**Rules & Guidelines:**

* `bigcommerce-get-order` and `bigcommerce-get-order-product` are on the BigCommerce server; the Dynamics 365 Sales tools (names beginning dynamics-365-sales-) are on the Dynamics 365 Sales server.
* Read only. Never call any add, update, create or delete tool.

**Validation:**

* If the order id is not found in BigCommerce, stop.
* If currencies differ, show both currencies and do not compare the amounts.

Who it's for

One answer, three teams that use it

Accountants

Confirm an order was booked right

Both totals, the difference and a verdict answer the question in one table.

Does BigCommerce order 21734 match a sales order in Dynamics 365 Sales?

Sales operations

Find orders filed under the parent account

The customer is found by billing email or company, so records under a parent account are not missed.

Find the Dynamics 365 Sales invoice for BigCommerce order 19022, the buyer is part of Contoso.

Finance analysts

Investigate amount differences

A tolerance lets you separate rounding from real differences.

Check BigCommerce order 20550 against Dynamics 365 Sales with a tolerance of 2.

How it works

What PopdockAI does when you ask

You give an order id and your AI assistant looks for its Dynamics 365 Sales order or invoice. Near misses are shown, never forced into a match.

01

Ask

You give the BigCommerce order id and optionally an amount tolerance.

Your AI tool

02

Read

It reads the order and its lines, then finds the customer in Dynamics 365 Sales.

bigcommerce-get-order
bigcommerce-get-order-product
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-accounts

03

Match

It searches sales orders and invoices near the order total.

microsoft-dynamics-365-sales-get-salesorders
microsoft-dynamics-365-sales-get-invoices

04

Report

You get both totals, the difference and a verdict.

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-order

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

bigcommerce-get-order-product

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

microsoft-dynamics-365-sales-get-contacts

Returns Dynamics 365 Sales contacts. Filter by full name, email, city, job title, state, parent customer, created date and status, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-accounts

Returns Dynamics 365 Sales accounts. Filter by city, annual revenue, status, industry, account number, email, account name and state, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-salesorders

Returns Dynamics 365 Sales orders. Filter by name, total amount, created date, customer, owner, order ID and status reason, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-invoices

Returns Dynamics 365 Sales invoices. Filter by name, customer, invoice ID, created date, total amount, status reason and due date, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-salesorderdetails

Returns Dynamics 365 Sales order products. Filter by product number, requested delivery date, extended amount, product name, quantity and order, and cap how many records come back.
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

Know whether a web order and its CRM record agree

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