/
/
Find Akeneo products with no Business Central item
For operations teams who want the catalog checked against the ERP by asking their AI assistant.
On this page
Connector
Connect Akeneo, pick your AI tool and paste the prompt.
The problem
SKUs found missing only when an order fails
Product data managers compare the Akeneo catalog with the Business Central item list in spreadsheets. SKUs that never reached the ERP are found when an order fails, and near matches pass for real ones.
Without PopdockAI
- Export enabled products from Akeneo
- Search Business Central for each SKU
- Try descriptions when the SKU is not found
- Treat a near match as confirmed
With PopdockAI
- Enabled products read from Akeneo
- Each SKU matched exactly, then once by description
- Confirmed, possible and no item kept apart
- Stops on an error rather than reporting partial results
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find Akeneo products for brand `{brand}` (default: all brands) that have no Business Central item, up to `{max-products}` products (default 50).
**Step 1: Read the products from Akeneo**
Call `akeneo-get-product` (Akeneo server) with `brand` set to `{brand}` if given, `enabled` true, and `max-records` set to `{max-products}`. Keep `identifier`, `product-name`, `brand`, `family` and `uuid` for each product. If nothing comes back, say so and stop.
**Step 2: Look each identifier up in Business Central**
For each product call `business-central-get-item` (Business Central server) with `item-number` set to the product `identifier`, and `company` set to `{company}` if given. The Akeneo `identifier` (the SKU) is matched to the Business Central `item-number`. Match exactly; do not guess near matches. If a product has no exact match, try once with `description.contains` set to its `product-name` and mark any hit as a possible match, not a confirmed one.
**Step 3: Report**
Give three lists: products with a confirmed item, products with a possible match only (show both identifiers), and products with no item at all. For matched pairs show `item-number`, `blocked`, `unit-price` and `inventory`. End with counts for each list.
**Rules & Guidelines:**
* `akeneo-get-product` is on the Akeneo server; `business-central-get-item` is on the Business Central server. Both servers must be connected.
* This is read-only. Do not call `business-central-create-item`, `business-central-update-item`, `akeneo-add-product`, `akeneo-update-product` or `akeneo-delete-product`.
* Never modify or create anything to close a gap; only report it.
**Validation:**
* If Business Central returns more than one item for an identifier, list them all and flag the product as ambiguous.
* If a tool returns an error, say which server it came from and stop rather than reporting partial results as complete.Who it's for
One answer, three teams that use it
Product data managers
Find SKUs with no ERP item
Products with no Business Central item are listed with counts.
Which enabled Fabrikam products in Akeneo have no Business Central item?
Operations managers
See blocked and unpriced matches
Matches show blocked, unit price and inventory for a quick check.
Match enabled Northwind products to Business Central and show blocked items.
ERP administrators
Review possible matches
Description only matches are listed apart so a person can confirm them.
Which Akeneo products only match a Business Central item by description?
How it works
What PopdockAI does when you ask
You choose a brand, a limit and a company, and your AI assistant checks each SKU in Business Central. Description matches are marked possible, never confirmed.
01
Ask
You choose a brand, a product limit and a company, or use the defaults.
02
Read
It reads enabled products from Akeneo.
03
Match
It looks each SKU up in Business Central, exact first.
04
Report
It lists confirmed, possible and missing items with counts.
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.
akeneo-get-product
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 items found before an order fails
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)
