/
/
Trace sales and purchase orders for an Akeneo product in NetSuite
For operations teams who want demand and supply for one SKU by asking their AI assistant.
On this page
Connector
Connect Akeneo, pick your AI tool and paste the prompt.
The problem
Sales and purchase lines in separate lists
Planners hop between Akeneo and the NetSuite order screens to see what is on order and what has sold for one product. The lines sit in separate lists and statuses are read by hand.
Without PopdockAI
- Look up the product in Akeneo
- Search NetSuite sales order lines
- Search purchase order lines separately
- Read statuses and quantities by hand
With PopdockAI
- Product read and item confirmed in NetSuite
- Sales and purchase order lines read
- Line counts and total purchase quantity given
- Statuses shown exactly as returned, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Show the demand and supply in NetSuite for the Akeneo product with SKU {sku}: its sales order lines and purchase order lines, optionally only purchase lines dated on or after {date-from}.
**Step 1: Read the catalog record (akeneo)**
Call `akeneo-get-product` with identifier set to {sku}. If it returns nothing or more than one product, report that and stop. Keep product-name, enabled, family and brand.
**Step 2: Confirm the item (netsuite)**
Call `netsuite-get-item` with item-number set to the SKU and keep quantity-on-hand. If no item matches, report the product as absent from NetSuite and stop.
**Step 3: Read the order lines (netsuite)**
Call `netsuite-get-salesorderitem` with item-number set to the SKU, and keep document-number, customer, item-description and memo. Call `netsuite-get-purchaseorderitem` with item-number set to the SKU, and keep document-number, vendor-company-name, quantity, document-status and date. When {date-from} is given, drop purchase order lines dated before it.
**Step 4: Report**
Lead with the product name, enabled flag and on-hand quantity. Then a sales order table and a purchase order table, with line counts and the total purchase quantity. Say that sales order lines in this tool set carry no quantity, so demand is shown as a line count only.
**Rules & Guidelines:**
* Tools starting akeneo- are on the akeneo server (the product catalog, PIM). Tools starting netsuite- are on the netsuite server (the ERP). Both servers must be connected.
* The join key is the Akeneo product identifier (the SKU) and the NetSuite 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.
* This prompt is read-only. Never call any akeneo-add-*, akeneo-update-*, akeneo-delete-*, akeneo-submit-* or akeneo-start-* tool, and never call any netsuite-add-* or netsuite-update-* tool.
**Validation:**
* If both order tables are empty, say the item has no order activity rather than an error.
* Never guess a status; show document-status exactly as returned.Who it's for
One answer, three teams that use it
Demand planners
See open demand for a SKU
Sales order lines show how many orders want the product.
How many NetSuite sales order lines include SKU HB-2201?
Buyers
See what is already on order
Purchase order lines and total quantity show incoming supply.
What purchase orders in NetSuite include SKU KT-330 since September?
Customer service reps
Answer when stock is coming
Purchase order status helps you tell customers when to expect it.
Is SKU TS-2050 on order in NetSuite, and what is its status?
How it works
What PopdockAI does when you ask
You give a SKU and optional date, and your AI assistant lists the product's NetSuite order lines. It states that demand here is a line count.
01
Ask
You give a SKU and, if you like, a date.
02
Confirm
It reads the product from Akeneo and the item from NetSuite.
03
Read
It reads the sales order lines and purchase order lines.
04
Report
It shows both tables with line counts and purchase quantity.
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
netsuite-get-item
netsuite-get-salesorderitem
netsuite-get-purchaseorderitem
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
Demand and supply for a product in one answer
Related use cases
More ways to put this data to work
Check Akeneo product stock in NetSuite
Ask your AI for a product's NetSuite stock. It shows quantity by location and bin next to the Akeneo status and flags enabled products with nothing available.
Learn More
Compare Akeneo product pricing with NetSuite
Ask your AI for the NetSuite prices of an Akeneo product. It lists each price level next to the enabled status and flags products with no price or a zero price.
Learn More
Find enabled Akeneo products with no NetSuite stock
Ask your AI which enabled Akeneo products have no available stock in NetSuite. Results are grouped by reason, with counts first and a note when the result is a sample.
Learn More
Reconcile Akeneo catalog to NetSuite items
Ask your AI to compare enabled Akeneo products with NetSuite items by SKU. It lists matches and what is missing on each side, with the NetSuite side labelled as a sample.
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.