Connectors

/

Akeneo

/

Check Akeneo product is sellable in Dynamics GP
Report
Cross-Connector

Know if a product is ready to sell in Akeneo and Dynamics GP

For sales teams who want a ready or blocked verdict on a SKU by asking their AI assistant.

Try PopdockAI free
Get a live demo
Check Akeneo product is sellable in Dynamics GP
Is SKU TS-1042 ready to sell? Check Akeneo and Dynamics GP for company TWO.
TS-1042 is blocked. - Akeneo: Linen Shirt, enabled, family apparel, 2 categories - Dynamics GP (TWO): item active, price level RETAIL at 39.00 USD - Stock: 0 on hand at MAIN, 0 at EAST - Name differs: Linen Shirt in Akeneo, LINEN SHRT in Dynamics GP Reason for the block: no stock on hand at any site. Want the same check for another SKU?
Akeneo
Sample figures. Your results come from your own account.
akeneo-get-product
microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-get-iv-item-price
microsoft-dynamics-gp-get-iv-item-quantity

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Akeneo

Akeneo
Run it on your own Akeneo data.

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

Try PopdockAI free

The problem

Promoting products that cannot be sold

Before promoting a product, someone checks Akeneo for content and category, then Dynamics GP for the item, price and stock by site. It takes minutes per SKU, and gaps like no price or zero stock are easy to miss.

Without PopdockAI

  • Open the product in Akeneo
  • Find the item in Dynamics GP
  • Check price levels and stock by site
  • Promote a product with no price

With PopdockAI

  • Product read from Akeneo and item from Dynamics GP
  • Price levels and stock by site checked
  • Ready or blocked verdict with every reason
  • Stock shown per site, 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:** Decide whether the product with SKU {sku} is ready to sell by combining its Akeneo catalog data with its Dynamics GP price and stock, for the company {company}.

**Step 1: Read the catalog record (akeneo)**

Call `akeneo-get-product` with identifier set to {sku}. If it returns nothing, report the SKU as absent from Akeneo and continue with Step 2 anyway. Keep product-name, enabled, family, brand, categories and short-description.

**Step 2: Read the item (dynamics-gp)**

Call `dynamics-gp-get-iv-item` with item-number set to the SKU (company set to {company} when given). If nothing comes back, report the SKU as absent from Dynamics GP and stop after the report. Keep item-description, item-type, item-class-code and current-cost.

**Step 3: Price and stock (dynamics-gp)**

Call `dynamics-gp-get-iv-item-price` with item-number set to the SKU, and `dynamics-gp-get-iv-item-quantity` with item-number set to the SKU. Keep each price level, list-price and currency-id, and the quantity-on-hand, quantity-allocated and quantity-on-order per site.

**Step 4: Report**

One block per system, then a verdict line: ready, or blocked, with every reason (product disabled or missing categories in Akeneo, no price list entry, zero stock on hand, item type discontinued, name differing between the two systems).

**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 write tool on either server.

**Validation:**

* If the two systems disagree on name, show both values side by side.
* Quantity is reported by site; do not add sites together without saying so.

Who it's for

One answer, three teams that use it

Sales managers

Check before you promote

Confirm a product has content, a price and stock before a campaign.

Is SKU HB-2201 ready to sell in Akeneo and Dynamics GP?

Merchandisers

Find out what blocks a product

Every blocking reason is listed, from missing categories to zero stock.

Why is SKU KT-330 not ready to sell? Check Akeneo and Dynamics GP.

Inventory planners

See stock by site for a SKU

Quantities are shown per site and never added without saying so.

What stock does SKU TS-2050 have by site in Dynamics GP company TWO?

How it works

What PopdockAI does when you ask

You give a SKU and your AI assistant reads both systems and gives a verdict. If either system lacks the SKU it says so and stops.

01

Ask

You give a SKU and, if needed, a Dynamics GP company.

Your AI tool

02

Read

It reads the product from Akeneo and the item from Dynamics GP.

akeneo-get-product
microsoft-dynamics-gp-get-iv-item

03

Check

It looks at price levels and stock by site.

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

04

Report

It shows both records and a ready or blocked verdict with reasons.

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.
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.
get-data

microsoft-dynamics-gp-get-iv-item-quantity

Returns item quantity records by site from Dynamics GP Inventory, including quantities on hand, allocated, on order and back ordered. Filter by quantity on hand, item description, location code from item master, item class code, item type, record type and item number, 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.

How Popdock AI secures your data

The outcome

Know if a SKU is ready to sell

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