Report

Cross-Connector

Find Akeneo products with no matching Dynamics GP item

For operations teams who want the catalog and the item list reconciled by asking their AI assistant.

Reconcile Akeneo catalog to Dynamics GP items

Reconcile our enabled apparel products in Akeneo with Dynamics GP items for company TWO.

Of 50 enabled apparel products, 44 matched a GP item, 5 are in Akeneo only and 1 is a format mismatch. - In Akeneo only: TS-3001, TS-3002, TS-3005, TS-3011, TS-3014 - Format mismatch: ts-1099 in Akeneo, TS-1099 in GP - GP only (sample of 50 items): 4 items The GP only list is a sample, not the full ERP. Want the table with item class?

Akeneo

Sample figures. Your results come from your own account.

akeneo-get-product

microsoft-dynamics-gp-get-iv-item

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Akeneo

Run it on your own Akeneo data.

Connect Akeneo, pick your AI tool and paste the prompt.

The problem

Live products with no item to sell

Merchandisers and ERP teams compare the Akeneo catalog with the Dynamics GP item list in spreadsheets. Products go live with no item, and GP items sit with no catalog record, until an order or listing fails.

Without PopdockAI

Export enabled products from Akeneo
Export the GP item list
Match SKUs in a spreadsheet
Mistake a format difference for a match

With PopdockAI

Up to 50 enabled products looked up as GP items
A sample of GP items checked against Akeneo
Matched, Akeneo only and GP only listed with counts
Format mismatches kept apart, nothing 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:** Find which enabled products in the Akeneo catalog have no matching item in Dynamics GP (and which sampled GP items have no Akeneo product), optionally limited to the product family {family}, for the Dynamics GP company {company}. Default to 50 products.

**Step 1: List the catalog products (akeneo)**

Call `akeneo-get-product` with enabled set to true, family set to {family} when one is given, and max-records 50. Keep identifier, product-name, family and brand for each. If nothing comes back, say so and stop.

**Step 2: Look each SKU up in the ERP (dynamics-gp)**

For each product, call `dynamics-gp-get-iv-item` with item-number set to the product identifier (and company set to {company} when given). Record the match, its item-description, item-class-code and item-type, or record no match.

**Step 3: Sample the ERP side**

Call `dynamics-gp-get-iv-item` with max-records 50 (and company when given). For each item-number returned, call `akeneo-get-product` with identifier set to it, and note those with no product.

**Step 4: Report**

Three lists: matched SKUs, in Akeneo only, in Dynamics GP only (sample). Give counts first, then a table of SKU, name, family, and the item class for matches. State that the ERP-only list is a sample, not the full ERP.

**Rules & Guidelines:**

* Tools starting keneo- are on the akeneo server (the product catalog, PIM). Tools starting dynamics-gp- are on the dynamics-gp server (the ERP). Both servers must be connected.
* The join key is the Akeneo product identifier (the SKU) and the Dynamics GP item number. Compare them exactly first, then trimmed and case-insensitive; report any record that only matches that loose way as a format mismatch rather than a match.
* Dynamics GP tools take an optional company; pass {company} when it is given, and say which company the answer is for.
* This prompt is read-only. Do not call any `akeneo-add-product`, `akeneo-update-product`, `akeneo-delete-product` or `akeneo-submit-proposal-product` tool, and do not call `dynamics-gp-iv-item-add`, `dynamics-gp-iv-item-update` or `dynamics-gp-iv-item-note`.

**Validation:**

* If a lookup on one side returns nothing, that is a finding, not an error. Continue with the next SKU.
* If a SKU matches only after trimming or case changes, list it separately as a format mismatch.

Who it's for

One answer, three teams that use it

Operations managers

Find products with no GP item

Products that cannot be sold or stocked are listed before an order fails.

Which enabled Akeneo products have no item in Dynamics GP?

ERP administrators

Find items with no catalog record

A sample of GP items with no Akeneo product shows what is missing from the catalog.

Which Dynamics GP items in company TWO have no Akeneo product?

Data stewards

Fix SKU format mismatches

SKUs that only match after trimming or case changes are listed for correction.

Reconcile enabled footwear products with Dynamics GP and list SKU format mismatches.

How it works

What PopdockAI does when you ask

You choose a family and company, and your AI assistant reconciles both directions by SKU. The GP side is clearly labelled as a sample.

Ask

You choose a family and a company, or use the defaults.

Your AI tool

Match

It looks each enabled Akeneo product up as a Dynamics GP item.

akeneo-get-product

microsoft-dynamics-gp-get-iv-item

Sample

It checks a sample of GP items against Akeneo.

microsoft-dynamics-gp-get-iv-item

akeneo-get-product

Report

It lists matched, Akeneo only and GP only SKUs with counts.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Akeneo and one secure connection to your AI tool. No code, no exports.

get-data

akeneo-get-product

Returns products from Akeneo PIM with their family, categories, enabled status, completeness and update dates. Filter by family, category, enabled status or update date.

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.

Read only.Nothing in Akeneo 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.

The outcome

Both sides of the gap without a spreadsheet

Related use cases

More ways to put this data to work

Check Akeneo product is sellable in Dynamics GP

Ask your AI whether a SKU is ready to sell. It reads the Akeneo record and the Dynamics GP item, price and stock by site, and gives a verdict with every reason.

Learn More

Compare Akeneo product names to Dynamics GP item descriptions

Ask your AI to compare Akeneo product names with Dynamics GP item descriptions for a brand. Each SKU is marked same, cosmetic or different, and missing items are listed apart.

Learn More

Find enabled Akeneo products with no Dynamics GP stock

Ask your AI which enabled Akeneo products in a family have no stock or no price in Dynamics GP. It lists them with on hand, on order and priced status.

Learn More

Rank an Akeneo family by Dynamics GP sales

Ask your AI to rank an Akeneo family by Dynamics GP sales since a date. It shows units, revenue, documents and customers per product and lists products with no sales.

Learn More

Audit Akeneo attribute setup

Ask your AI to audit Akeneo attributes and groups. It lists attributes with missing groups, empty groups and conflicting flags, with a suggested fix for each. Nothing is changed.

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.