Open Source Inventory Warehousing System

[@rhi151223]

I shocked myself with how excited the title of this video made me

[@MAYERMAKES]

I shocked myself when I realized this API stuff really works.

[@bricogeekcom]

Very interesting topic! We also use Raspberry Pi in our warehouse for picking orders. They are cheap and easily replaceable. But instead of a crude terminal window, we use a nice web interface coming from our local ERP system which is in sync with our webshop and to all the background tasks. Good job Mayer!

[@MAYERMAKES]

thanks, of course there are plenty ways to do this!

[@Mtaalas]

There's not enough of these solutions in open source. Thanks for your contribution! :)

[@MAYERMAKES]

You are welcome

[@devdeque7846]

I've been part of a team developing an inventory system for a PC refurb start up. We used shortcut barcodes as well. But that was more a personal choice. We had to have a UI because we couldn't avoid data entry and had new employees. At first they had a web dev to do it all in a browser. The web server would frequently crash and halt everything. Bosses constantly demanded changes and it was hard for the web devs to keep up and coordinate everything. Eventually, they built an application. The admin version had a drag and drop modular UI layout which adjusted the schemas automatically. The user version didn't allow customizing. But would update to reflect the changes. Would recommend going that route from the get go.

[@IMNODOCTOR]

You need a web farm and a load balancing router to manage front-end issues.

[@zsteva]

about start app on button, interactive applicatione need to be attached to terminal, if you run it in background that why doesnt work... simplest solution is to script with start read buttons run as autologin on terminal, so when you press button its will work becouse your parent script is already on terminal.

[@MAYERMAKES]

Wow, the responses are great, seems people like business project stuff!

[@adammills4099]

oh my god. Imagine a sql barcode attack, you replace a tag with one that says ;drop TABLE *; and walmart can say goodbye to their databases. I hope they've thought of that by [current_year]

[@Peter_Enis]

article not found......

[@MAYERMAKES]

guess what, I tried that out at work. the sanitation is quite easy, they usually match it with a database of allowed barcodes.everything else including injects gets dropped. also can't inject SQL if the system can't understand Sql

[@MAYERMAKES]

also in this specific project the only inputs that get processed are an exact match to the barcode, or "XXX" which means abort.

[@adammills4099]

@@MAYERMAKES the bare minimum you hope for is that there aren't plaintext passwords and input is sanitized. Lots of tools and db markup have it out of the box so you have to be actively ignorant to mess it up now a days

[@MAYERMAKES]

@@adammills4099 yeah, I had to make a dedicated script to demonstrate how injects work as I could not find a simple thing that was vulnerable.

[@MAYERMAKES]

Make sure you watch the bonus video , where I explain all the python code in detail! linked in the description!

[@BDJones055]

This is awesome!

[@MAYERMAKES]

Thx

[@AmRadPodcast]

I love this, and will totally make use of it when I start selling my widget. Great project! BTW, we have the same API learning experience!

[@MAYERMAKES]

Don't we all...

[@Itazueta]

Hey, i love this tool and i want to use it but i have issues getting the API Setup in my woocommerce store. can u maybe make a video about how you setup the API. Thanks in advance and i like the concept of it for speeding up Processing orders.

[@MAYERMAKES]

There is a 10 min bonus video linked in the description on element14, explaining the details, it may help you in setting up your api, the hooks might be different.

[@Itazueta]

@@MAYERMAKES I had a look at it but I didn't get clear on how to setup my secret code and get the authentication step. The rest I understood on how to get the order details and all. Just the communication between the python script and the web server 😅

[@Unfinished80]

Cool idea! Thanks!

[@MAYERMAKES]

You are welcome

[@riskototh]

I have also made my own inventory system, mainly for electronic parts... API sinks from TME, Farnell and Mouser... And as a scanner i'm using my phone with simple app, that will send the code to the inventory API... Without that, I would be completely lost...

[@MAYERMAKES]

awesome! getting a system in place that helps keep ing trakc of everythign is so important!

[@RedNapalm]

Would be great to have a video to make a vending machine. Could use it in a business sense as a automatic fulfillment with robot cars!

[@MAYERMAKES]

good idea! please post it at the link in the description so we can pick it up! (GPDR and such)

[@BlatantThrowAway]

I wish SAP was this simple.

[@MAYERMAKES]

The S stands for Featurecreep

[@ChrisEilander]

I've actually just finished up an basic inventory system for my workplace (like, 2 days ago), and was thinking about doing an connection with our (WooCommerce based) webshop so we know which items to scan. Ofcourse, I am also looking to make it as simple as possible but in my experience an CLI scares people. Even when it doesn't have a keyboard. Also the scanner we use must be much more capable than just scanning EAN, GTIN and UPC barcodes because the manufacturer put on some products an Code 128 barcode for some reason.

[@MAYERMAKES]

thats a typical task, and if your employees are afraid of CLI just hide it with tkinter behind a nice colorfull screen. If yo uget acamera based Barcode reader you can scan ALL the different barcode. but they are sometimes slower than these GTIN ones.

[@MAYERMAKES]

I just realized, I forgot all lthe stuff i learned about APis and json when i did that project a year ago...also I look very tired...because I spent long nights figuring that stuff out...

[@MrGarfield]

Funny guy 🙂 however you can start any programm with a button. But why not loop the complete script at startup. And only exit it when the power bttn is pressed you can monitor for a shutdown command. and nicely exit the code at the shutdown sequence

[@MAYERMAKES]

you might have missunderstodo the problem. A python script that uses the input() function cannot be started correctly after boot by any script or other method besides a keyboard, all the input output rerouting methods do not work for this.

[@MrGarfield]

@@MAYERMAKES Okay, could be, i'm writting my stuff in JavaScript and run them with NodeJS, and those work fine, i start them from /etc/rc.d/rc.local maybe an addition of

[@MAYERMAKES]

@@MrGarfield tried all variants of rerouting dev/tty

[@paulgupta2454]

Why not just run a BASH alias that launches the python script? EDIT: **CLEARLY WRITTEN MOMENTS BEFORE YOU DID JUST THAT**

[@MAYERMAKES]

Gotcha

[@iselink]

Or just spicy it up with ncurses, bcs TUI programs are just too fine.

[@Davedarko]

FAKE, you said it was order 1359 two times! All the best to you and smander though -doing the important stuff there!

[@MAYERMAKES]

I think it got listed two times, once as packed order and another time as one item was missing from it

[@Arturiens]

Make a cash Register on raspberry pi

[@MAYERMAKES]

depending on where you live there can be alot of specific restrictions to the hardware for that (for example a state issued encryption unit can be mandated) so that project might not be that usefull. but we may be able to pull of a Card terminal using some already approved framework.

[@diegoyonamine8943]

I think this project died on the Concept ( over simplifying an important topic ) Also... most of small ( 1 to 15 person business ) couldn't implement this without TOOOO much cost on training and implementation.

[@MAYERMAKES]

please watch the video again and pay attention to the demonstration. this can be used with ZERO training. The user just scans what the program asks for. thats it. the total cost of implementation for this is below 100$ if you have 0 parts in stock.

[@diegoyonamine8943]

@@MAYERMAKES Anyone would've find easy to implement print_sticker reorganize an new system storage ... and also find easy troubleshooting on Json error imputs.

[@MAYERMAKES]

@@diegoyonamine8943 both tasks are not concerning the user. thats both dev work.