Connectors

/

Akeneo

/

Find enabled Akeneo products not selling in Intacct
Report
Cross-Connector

Find Akeneo products that are not selling in Sage Intacct

For marketing teams who want slow and unstocked products found by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find enabled Akeneo products not selling in Intacct
Which enabled products in the home family have not sold in Intacct for 180 days or have no stock?
Of 50 enabled home products checked, 9 are not moving. - No recent sales: 5 products, oldest TS-5102 Ceramic Vase, last sold 2025-11-03 - No stock: 2 products, TS-5120 and TS-5188 - Both: 2 products - No Intacct item: TS-5300 These are candidates only. Want the full table?
Akeneo
Sample figures. Your results come from your own account.
akeneo-get-product
sage-intacct-get-item

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 dead stock while sellers wait

Catalog teams keep promoting products that Sage Intacct shows have no stock or no sales in months, because the two lists are never put side by side. Dead stock stays on the front page.

Without PopdockAI

  • Export enabled products from Akeneo
  • Look up each item in Sage Intacct
  • Check last sale date and stock
  • Keep promoting what does not sell

With PopdockAI

  • Up to 50 enabled products read
  • Last sale date and stock read from Intacct
  • Flagged as no recent sales, no stock or both
  • Candidates only, never a recommendation to disable

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 enabled Akeneo products, optionally in the family {family}, whose Sage Intacct item has not sold for {days} days (default 180) or has no stock on hand, for the Intacct 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. If nothing comes back, say so and stop.

**Step 2: Read each item (intacct)**

For each product, call `intacct-get-item` with item-id set to the identifier (and company when given). Keep status, on-hand, uncommitted and date-last-sold. Treat a product with no item as its own finding.

**Step 3: Classify**

Flag a product when date-last-sold is older than the cutoff or empty, or on-hand is 0 or less. Mark each flag as no recent sales, no stock, or both.

**Step 4: Report**

Counts first, then a table of SKU, name, family, brand, item status, on-hand, date-last-sold and the flag, oldest first. Finish with the products that have no item.

**Rules & Guidelines:**

* Tools starting akeneo- are on the akeneo server (the product catalog, PIM). Tools starting intacct- are on the intacct server (Sage Intacct, the ERP). Both servers must be connected.
* The join key is the Akeneo product identifier (the SKU) and the Intacct item-id. Compare them exactly first, then trimmed and case-insensitive; report a record that only matches the loose way as a format mismatch, not a match.
* Intacct tools take an optional company; pass {company} when it is given and say which company the answer is for.
* Suggest candidates only. Do not say a product should be disabled; that is the user's call.
* This prompt is read-only. Do not call `akeneo-add-product`, `akeneo-update-product`, `akeneo-delete-product`, `akeneo-submit-proposal-product`, or any other akeneo-add-, akeneo-update- or akeneo-delete- tool, and do not call `intacct-create-vendor`, `intacct-update-vendor`, `intacct-create-customer`, `intacct-update-customer`, `intacct-create-order-entry-document`, `intacct-update-order-entry-document`, or any other intacct-create- or intacct-update- tool.

**Validation:**

* An empty date-last-sold means never sold, say so.
* If {days} is not a whole number, use 180 and say so.

Who it's for

One answer, three teams that use it

Marketing managers

Pick what to feature

Avoid featuring products that have not sold in months.

Which enabled outdoor products have not sold in Intacct for 90 days?

Merchandisers

Find enabled products with no stock

Products with nothing on hand are flagged before they get promoted.

Which enabled Akeneo products have no stock on hand in Intacct?

Category managers

Review slow movers in a family

Oldest last sale first shows where to act.

Rank enabled kitchen products by last Intacct sale date, oldest first.

How it works

What PopdockAI does when you ask

You choose a family and a cutoff, and your AI assistant ranks enabled products that are not moving. Both systems are only read.

01

Ask

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

Your AI tool

02

List

It reads enabled products from Akeneo.

akeneo-get-product

03

Read

It looks up each item in Sage Intacct for stock and last sale date.

sage-intacct-get-item

04

Report

It flags and ranks products that are not moving.

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

sage-intacct-get-item

Returns items from Sage Intacct.
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

Promotion goes to products that 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