Israel Lopez Consulting
Warehouse · asked in Claude

“Where are our chocolate chips stored?”

349.5 lbs across four locations in three warehouses.

Fishbowl MCP connectedin Claude
Where are our chocolate chips stored?
✓Checked your Fishbowl data · 1 read-only query · 0.3 s

Chocolate chips (part CR403) are in four locations across three warehouses, 349.5 lbs in total:

WarehouseLocationOn hand
LAStock116.5 lbs
LAStock 10047.5 lbs
MIStock Room116.5 lbs
MainReceiving69 lbs

Main's 69 lbs is still sitting in Receiving and hasn't been put away. None of the stock is committed to orders.

If you meant the finished cookies rather than the raw ingredient, two other parts matched "chocolate chip":

BB2005 Chocolate Chip (9,768 ea)

  • LA: Stock 3,256, Stock 200 1,000, Stock 100 100
  • MI: Stock Room 3,256
  • Main: Receiving 2,100, Stock 56

BB2003 Oatmeal Chocolate Chip (6,417 ea)

  • LA: Stock 2,139, Receiving 1
  • MI: Stock Room 2,139
  • Main: Stock 2,136, Receiving 2
A real 24-second session on our demo Fishbowl, replayed faster.

Behind the scenes

What your admin sees in the query log for this conversation.

1read-only queries
0.3 stotal query time
0changes to your data
0rows stored

Every step the AI took

  1. 1
    Checked the saved queries
    6 saved queries
  2. 2
    Read the Fishbowl notes index
    13 topic notes
  3. 3
    Where are our chocolate chips stored?
    Saved query stock_by_location, approved by your admin
    ✓ passed read-only checkrow cap applied
    Show the SQL
    SELECT p.num AS part, p.description, lg.name AS locationGroup, l.name AS location, lt.name AS locationType, ROUND(SUM(t.qty), 4) AS qtyOnHand, ROUND(SUM(COALESCE(t.qtyCommitted, 0)), 4) AS qtyCommitted, u.code AS uom, (l.countedAsAvailable + 0) AS countedAsAvailable
FROM tag AS t
JOIN part AS p ON p.id = t.partId
JOIN location AS l ON l.id = t.locationId
JOIN locationgroup AS lg ON lg.id = l.locationGroupId
JOIN locationtype AS lt ON lt.id = l.typeId
JOIN uom AS u ON u.id = p.uomId
WHERE t.qty > 0 AND (p.num = @part_num OR p.description LIKE CONCAT('%', @part_num, '%')) AND (@location_group IS NULL OR lg.name = @location_group)
GROUP BY p.num, p.description, lg.name, l.name, lt.name, u.code, l.countedAsAvailable
ORDER BY p.num, qtyOnHand DESC
LIMIT 101
    15 rows · 294 ms

Every query is checked before it runs: reads only, no system tables or password fields, and a row cap on every result. The question and the SQL are logged for your admins. The data itself is not stored.

More questions

What else your team could ask

“What's sitting in Receiving that hasn't been put away?”

There are 30 part/location lines sitting in Receiving across three warehouses, and none of it is recent: the newest has been there 34 days and everything else 80 to 85 days.

Watch the answer →

“what were my top product sales, and who bought them?”

Three cookies make up about 77% of your $29,544.54 in product sales, and Allen's Groceries is the main buyer of all three.

Watch the answer →

“What has Allen's Groceries ordered from us, and how often?”

Five orders between July 10 and August 30, netting to $17,638.80, with no regular ordering pattern.

Watch the answer →

See all questions →

Ask this about your own Fishbowl

We'll set up ILC MCP on your Fishbowl and build the queries your team needs.