Build a Fishbowl Inventory Dashboard with AI (On-Hand Value, Low Stock, Negative Qty, Cycle Counts)
Build a Fishbowl inventory dashboard with AI — on-hand value, low stock, negative quantities and cycle counts, straight from your live data.
Read the full write-up, with the steps and screenshots →
Transcript
Auto-generated from the video. Timestamps jump to that moment in the clip.
- 0:07In this video, we're making an inventory health dashboard that
- 0:13we can use for Fishbowl.
- 0:15Let's get started.
- 0:17So let's say I'm running a business, and as part of my business, I want to not
- 0:22run out
- 0:23I want to make sure that we have what we need in order to do this.
- 0:28are best for our customers.
- 0:29And invariably, if we're not paying attention
- 0:31to our part in Fishbowl, we come up short, and it's a problem.
- 0:36If data in Fishbowl is accurate,
- 0:38we should be able to use information in Fishbowl
- 0:40to tell us, hey, we're running out of inventory.
- 0:42That's kind of the purpose of Fishbowl.
- 0:44So we're going to try to make a dashboard using the ILC MCP
- 0:49with Claude.
- 0:50So I've got a TV here on my right and a Claude session
- 0:54here on the left.
- 0:55And we're going to move on to the next video.
- 0:56show you what that whole cycle looks like so that we can hopefully solve some inventory issues
- 1:01ahead of time awesome let's get started first first things first is
- 1:06to adopt this tv into the
- 1:07system so we're going to tell claude to tell the ILC MCP to
- 1:13adopt this tv code so we're going
- 1:15to enable tv code 7q25 b5t
- 1:20call it
- 1:24inventory TV in the Irvine
- 1:29California USA location and prepare an
- 1:34empty inventory
- 1:37health page and push it and publish it
- 1:42to the TV now the reason why we ask a
- 1:47location is we do some you know nice things to make it practical and
- 1:52We will load the weather and that sort of detail
- 1:57to go with the dashboard.
- 2:00And once this gets adopted, we should be able to start adding some data.
- 2:06We've got an inventory health coming soon.
- 2:10And let's get going.
- 2:12Let's add an on-hand number.
- 2:17So let's say our, let's add.
- 2:21our total inventory on hand in
- 2:26dollars, as a metric.
- 2:36Okay, let's see what that looks like.
- 2:39Perfect. We've got our hand number. Awesome.
- 2:42Now, let's show how many items or parts
- 2:48where we do not have any stock, zero quantity,
- 2:54just a count.
- 3:06Okay, let's see if that loads.
- 3:13Okay, we want only inventory.
- 3:16type parts, add
- 3:26that as a card in TV.
- 3:42Cool, awesome.
- 3:44Now, let's see, do we have
- 3:49ABC classification?
- 4:04Oh, that's very helpful. Yeah, let's do that. Let's do a ABC classification for
- 4:10our on hand
- 4:13by their inventory value
- 4:19and summarize it as a table.
- 4:23A, B, C, N, and their count
- 4:28and dollar amount.
- 4:31That's very helpful.
- 4:32Maybe we have something that we have not set up ABC classification
- 4:36inside of this fishbowl,
- 4:37and we could still break it up by...
- 4:41Pareto analysis and break it up as a table, see
- 4:47what we have.
- 4:59Perfect.
- 4:59Now we got some data.
- 5:01So now add a table for parts
- 5:06that need...
- 5:08that need ordering any that are short given on
- 5:14hand minus allocation and therefore
- 5:20we are currently short display
- 5:26the part number description
- 5:32quantity and total cost
- 5:44okay so we've got that I'll see if that loads perfect
- 5:50we've got some looks up
- 5:52numbers I think I want one more metric what can we do maybe
- 5:57parts that are
- 6:00short that are on high price
- 6:04priority picks let's make a metric
- 6:10for that because that'll be a really good signal like
- 6:12if it's a higher priority pick and that part is short then we know we know we need to pay
- 6:17attention to it it's a call for information and we should definitely
- 6:22take a look at that
- 6:30perfect and right now we have zero fantastic
- 6:33The dashboard is updated, and that looks good.
- 6:37I think that'll work.
- 6:39If this is something you would like for your business
- 6:41or you have your own ideas for how you'd want to create a dashboard,
- 6:45let us know.
- 6:46We're happy to entertain whatever ideas you have
- 6:49for inventory dashboards or other dashboards
- 6:52or even other things that touch Fishbowl.
- 6:55We're definitely happy to hear about your ideas.
- 6:57Reach out to us.
- 6:59Talk soon.
- 7:01Thanks, have a good one.