/
/
See NetSuite stock by location for any Akeneo product
For operations teams who want stock and catalog status together by asking their AI assistant.
On this page
Connector
Connect Akeneo, pick your AI tool and paste the prompt.
The problem
Catalog status and stock that drift apart
Someone looks up a product in Akeneo, then searches NetSuite separately for stock by location and bin. An enabled product with no available stock, or a disabled one still holding stock, goes unnoticed.
Without PopdockAI
- Look up the product in Akeneo
- Search NetSuite for the item
- Read stock by location and bin
- Miss the mismatch between the two
With PopdockAI
- Product and item matched across both systems
- On hand and available read by location and bin
- Enabled with nothing available, or disabled with stock, flagged
- No stock records reported as such, not zero
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 stock position in NetSuite for the Akeneo product with SKU {sku}, by location and bin.
**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: Read the item and its stock (netsuite)**
Call `netsuite-get-item` with item-number set to the SKU and keep internal-id, type, quantity-on-hand and total-value. If no item matches, report the product as in Akeneo and absent from NetSuite, and stop. Then call `netsuite-get-itemquantity` with item-number set to the SKU, and keep location-name, bin-number, quantity-on-hand and quantity-available for each row.
**Step 3: Report**
Start with a line giving the product name, family and whether it is enabled in Akeneo. Then a table of location, bin, quantity on hand and quantity available, with totals. Flag an enabled product with zero available stock, and a disabled product that still holds stock.
**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 the item exists but `netsuite-get-itemquantity` returns no rows, say the item has no stock records rather than zero stock.
* If the item-level quantity-on-hand differs from the sum of the location rows, show both numbers.Who it's for
One answer, three teams that use it
Operations managers
See stock by location for any SKU
Get on hand and available quantities with totals.
Where is SKU HB-2201 stocked in NetSuite, by location?
Ecommerce managers
Find enabled products with nothing to sell
Enabled products with no available stock are flagged.
Is SKU KT-330 enabled in Akeneo with nothing available in NetSuite?
Warehouse leads
Check bins for a product
Bin level detail helps you find stock the totals disagree on.
Show NetSuite bin quantities for SKU TS-2050.
How it works
What PopdockAI does when you ask
You give a SKU and your AI assistant reads catalog status and stock together. It stops if no single product or item matches.
01
Ask
You give a SKU.
02
Find
It reads the product from Akeneo and the item from NetSuite.
03
Read
It reads quantity on hand and available by location and bin.
04
Report
It shows a stock table with totals and flags mismatches.
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-itemquantity
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
Stock and catalog status in one answer
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)
