Connectors

/

2Checkout

/

Check 2Checkout order products in Dynamics GP
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check 2Checkout order products in Dynamics GP
Check 2Checkout order 880412 against Dynamics GP and tell me which products we have not set up as items yet.
2 of 3 products on order 880412 are set up in Dynamics GP, and 1 is missing. - NW-PRO-ANNUAL: item NW-PRO-ANNUAL, GP 480.00, 2Checkout 499.00, difference 19.00 - NW-ADDON-SEATS: item NW-SEATS, GP 40.00, 2Checkout 40.00, no difference - NW-TRAINING: Not in GP Want me to check the next order as well?
2Checkout
Sample figures. Your results come from your own account.
2checkout-get-order
2checkout-get-orderitem
2checkout-get-product
microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-get-iv-item-price

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

2Checkout

2Checkout
Run it on your own 2Checkout data.

Connect 2Checkout, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Lines

It reads the order lines and product names in 2Checkout.

2checkout-get-order
2checkout-get-orderitem
2checkout-get-product

03

Match

It looks up each product as a Dynamics GP item and reads its list price.

microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-get-iv-item-price

04

Report

You get a table per line with the price difference, and a list of products not in Dynamics GP.

Your AI tool

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.

get-data

2checkout-get-order

Returns orders records from the 2Checkout connector (read-only). Accepts the filters defined on the tool, such as record identifiers, status and dates, and returns the matching rows.
get-data

2checkout-get-orderitem

Returns order items records from the 2Checkout connector (read-only). Accepts the filters defined on the tool, such as record identifiers, status and dates, and returns the matching rows.
get-data

2checkout-get-product

Returns products records from the 2Checkout connector (read-only). Accepts the filters defined on the tool, such as record identifiers, status and dates, and returns the matching rows.
get-data

microsoft-dynamics-gp-get-iv-item

Returns inventory item records from Dynamics GP Inventory, including item type, class, costs, units of measure and valuation settings. Filter by item class code, item description, current cost, item number, abc code, item short name, valuation method and item tracking option, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-iv-item-price

Returns item price list records from Dynamics GP Inventory, including price level, unit of measure, quantity breaks and pricing method. Filter by price level, price method, unit of measure, item number, currency ID, item description and item type, and pick the company and the maximum number of records.
Read only.Nothing in 2Checkout 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

Missing and mispriced items found before invoicing

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