Video

Build a Fishbowl Inventory Dashboard with AI (On-Hand Value, Low Stock, Negative Qty, Cycle Counts)

October 31, 20267:20
The Inventory Health Dashboard, built live in one chat with ILC MCP.

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.

  1. 0:07In this video, we're making an inventory health dashboard that
  2. 0:13we can use for Fishbowl.
  3. 0:15Let's get started.
  4. 0:17So let's say I'm running a business, and as part of my business, I want to not
  5. 0:22run out
  6. 0:23I want to make sure that we have what we need in order to do this.
  7. 0:28are best for our customers.
  8. 0:29And invariably, if we're not paying attention
  9. 0:31to our part in Fishbowl, we come up short, and it's a problem.
  10. 0:36If data in Fishbowl is accurate,
  11. 0:38we should be able to use information in Fishbowl
  12. 0:40to tell us, hey, we're running out of inventory.
  13. 0:42That's kind of the purpose of Fishbowl.
  14. 0:44So we're going to try to make a dashboard using the ILC MCP
  15. 0:49with Claude.
  16. 0:50So I've got a TV here on my right and a Claude session
  17. 0:54here on the left.
  18. 0:55And we're going to move on to the next video.
  19. 0:56show you what that whole cycle looks like so that we can hopefully solve some inventory issues
  20. 1:01ahead of time awesome let's get started first first things first is
  21. 1:06to adopt this tv into the
  22. 1:07system so we're going to tell claude to tell the ILC MCP to
  23. 1:13adopt this tv code so we're going
  24. 1:15to enable tv code 7q25 b5t
  25. 1:20call it
  26. 1:24inventory TV in the Irvine
  27. 1:29California USA location and prepare an
  28. 1:34empty inventory
  29. 1:37health page and push it and publish it
  30. 1:42to the TV now the reason why we ask a
  31. 1:47location is we do some you know nice things to make it practical and
  32. 1:52We will load the weather and that sort of detail
  33. 1:57to go with the dashboard.
  34. 2:00And once this gets adopted, we should be able to start adding some data.
  35. 2:06We've got an inventory health coming soon.
  36. 2:10And let's get going.
  37. 2:12Let's add an on-hand number.
  38. 2:17So let's say our, let's add.
  39. 2:21our total inventory on hand in
  40. 2:26dollars, as a metric.
  41. 2:36Okay, let's see what that looks like.
  42. 2:39Perfect. We've got our hand number. Awesome.
  43. 2:42Now, let's show how many items or parts
  44. 2:48where we do not have any stock, zero quantity,
  45. 2:54just a count.
  46. 3:06Okay, let's see if that loads.
  47. 3:13Okay, we want only inventory.
  48. 3:16type parts, add
  49. 3:26that as a card in TV.
  50. 3:42Cool, awesome.
  51. 3:44Now, let's see, do we have
  52. 3:49ABC classification?
  53. 4:04Oh, that's very helpful. Yeah, let's do that. Let's do a ABC classification for
  54. 4:10our on hand
  55. 4:13by their inventory value
  56. 4:19and summarize it as a table.
  57. 4:23A, B, C, N, and their count
  58. 4:28and dollar amount.
  59. 4:31That's very helpful.
  60. 4:32Maybe we have something that we have not set up ABC classification
  61. 4:36inside of this fishbowl,
  62. 4:37and we could still break it up by...
  63. 4:41Pareto analysis and break it up as a table, see
  64. 4:47what we have.
  65. 4:59Perfect.
  66. 4:59Now we got some data.
  67. 5:01So now add a table for parts
  68. 5:06that need...
  69. 5:08that need ordering any that are short given on
  70. 5:14hand minus allocation and therefore
  71. 5:20we are currently short display
  72. 5:26the part number description
  73. 5:32quantity and total cost
  74. 5:44okay so we've got that I'll see if that loads perfect
  75. 5:50we've got some looks up
  76. 5:52numbers I think I want one more metric what can we do maybe
  77. 5:57parts that are
  78. 6:00short that are on high price
  79. 6:04priority picks let's make a metric
  80. 6:10for that because that'll be a really good signal like
  81. 6:12if it's a higher priority pick and that part is short then we know we know we need to pay
  82. 6:17attention to it it's a call for information and we should definitely
  83. 6:22take a look at that
  84. 6:30perfect and right now we have zero fantastic
  85. 6:33The dashboard is updated, and that looks good.
  86. 6:37I think that'll work.
  87. 6:39If this is something you would like for your business
  88. 6:41or you have your own ideas for how you'd want to create a dashboard,
  89. 6:45let us know.
  90. 6:46We're happy to entertain whatever ideas you have
  91. 6:49for inventory dashboards or other dashboards
  92. 6:52or even other things that touch Fishbowl.
  93. 6:55We're definitely happy to hear about your ideas.
  94. 6:57Reach out to us.
  95. 6:59Talk soon.
  96. 7:01Thanks, have a good one.