/
/
Check that 2Checkout order products exist in Dynamics GP
For operations teams who ask their AI assistant to match each product on a 2Checkout order to a Dynamics GP item and compare the price.
On this page
Connector
Connect 2Checkout, pick your AI tool and paste the prompt.
The problem
Sold products that do not exist in Dynamics GP
Operations check by hand whether each product on a 2Checkout order exists as a Dynamics GP item with a price. Gaps show up only when invoicing fails, and comparing prices across screens invites mistakes.
Without PopdockAI
- Read the order lines in 2Checkout
- Search Dynamics GP for each product by SKU or name
- Compare list prices line by line
- Find the missing item when invoicing fails
With PopdockAI
- Order lines and products read from 2Checkout
- Each product matched to a Dynamics GP item by SKU, code or description
- Prices compared only in the same currency
- Missing items listed, nothing created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For 2Checkout order `{order-reference}`, check that each product sold exists as an item in Dynamics GP (company `{company}`, default is the server default) and compare the selling price.
**Step 1: Read the order lines in 2Checkout**
Call `2checkout-get-order` to confirm the order exists (match `reference-number`), then call `2checkout-get-orderitem` and keep the lines with that `reference-number`. Note `product-code`, `product-name`, `sku`, `quantity` and `gross-price` for each line. If the order has no lines, report that and stop. Call `2checkout-get-product` with `product-code` for each line to read the product `name`.
**Step 2: Look each product up in Dynamics GP**
For each line call `dynamics-gp-get-iv-item` with `item-number` = `sku` (or `product-code` when `sku` is empty). If nothing returns, retry with `item-description.contains` = the product name. Then call `dynamics-gp-get-iv-item-price` for the matched `item-number` and take `list-price`.
**Step 3: Report**
Table per line: product code, product name, GP `item-number` or Not in GP, GP `list-price`, 2Checkout unit price (`gross-price` divided by `quantity`), difference. End with the list of products not in Dynamics GP.
**Rules & Guidelines:**
* `2checkout-get-orderitem`, `2checkout-get-order` and `2checkout-get-product` are on the 2checkout server; `dynamics-gp-get-iv-item` and `dynamics-gp-get-iv-item-price` are on the dynamics-gp server.
* Read-only. Do not call `dynamics-gp-iv-item-add`, `dynamics-gp-iv-item-price-add`, `2checkout-product-add` or `2checkout-product-update`.
**Validation:**
* If several GP items match one product, list them and do not pick one.
* If the currencies differ between 2Checkout and the GP price, show both and do not compute a difference.Who it's for
One answer, three teams that use it
Order processors
Check an order before it is invoiced
See which products on an order are not set up in Dynamics GP so the invoice does not fail.
Are all the products on 2Checkout order 880977 set up as Dynamics GP items?
Inventory managers
Find items to set up in Dynamics GP
Get a list of sold products with no GP item, ready to create.
Which products from 2Checkout order 881203 are missing from Dynamics GP company TWO?
Pricing analysts
Spot price differences between the store and GP
Compare the 2Checkout unit price with the GP list price per line, in the same currency.
Compare prices on 2Checkout order 880412 with the Dynamics GP list prices.
How it works
What PopdockAI does when you ask
You give an order reference and your AI assistant matches each line to a Dynamics GP item. When several items match it lists them without choosing, and nothing is written.
01
Ask
You give the 2Checkout order reference and, if needed, the Dynamics GP company.
02
Lines
It reads the order lines and product names in 2Checkout.
03
Match
It looks up each product as a Dynamics GP item and reads its list price.
04
Report
You get a table per line with the price difference, and a list of products not in Dynamics GP.
What PopdockAI provides
The tools behind the answer
Ready made tools for 2Checkout and one secure connection to your AI tool. No code, no exports.
2checkout-get-order
2checkout-get-orderitem
2checkout-get-product
microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-get-iv-item-price
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 items found before invoicing
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)
