So as mentioned below, we are doing an inventory project for badger that’s pretty extensive. Basically it will keep recent books in one area sorted by week, and then older books in another area collated together into one mass inventory. pretty simple.
Here’s the trick. I just created a universal order pull list application. Basically you can select any number of orders, click generate, and a list will be created for every item that needs to be pulled. pretty simple hey? It gets even better. This list generator will check the last five weeks and individually flag items for the week they came in if they happened to arrive (either in a new order or a reorder) that week. But we’re not done yet. It color codes them based on a coding system involving color sorted boxes and cycling the oldest colored box into inventory and replacing its contents with books from that week. whew.
But this isn’t really to talk about the workings of the inventory system. This is to talk about how cool (and interesting) it is when something you are really good at (programming in my case) perfectly coincides with something you have only a little experience with (business logistics and physical asset management in this case). I ended up creating a basic physical location based inventory system and programmed a picker application that can work within this system. Most reading this are probably saying “So what?”, but when you look at where I started this whole experiment from and where it’s arrived at now it is really an interesting road. This is something I wouldn’t have even realized I needed two years ago, but now here we are with a full custom built physical inventory management system.