Open Source Inventory Warehousing System -- Episode 534

thanks DAB

glad it was of help!

the Issue with the input() function in a python script mentioned in the video has been solved thanks to our viewer Rene Snijders from the netherlands!
Here is his solution:

Rene just wrote a simple input & print :

---- myprogramm.py

#simple input
barcode = input ("Enter Barcode :")
print(barcode)

---- myprogramm.py

Then in the terminal as root or sudo -i

mkdir -p /etc/systemd/system/getty@tty1.service.d
echo "[Service]" > /etc/systemd/system/getty@tty1.service.d/override.conf
echo "ExecStart=" >> /etc/systemd/system/getty@tty1.service.d/override.conf
echo "ExecStart=-/usr/bin/python3 /home/pi/myprogramm.py" >> /etc/systemd/system/getty@tty1.service.d/override.conf
echo "StandardInput=tty"  >> /etc/systemd/system/getty@tty1.service.d/override.conf
echo "StandardOutput=tty"  >> /etc/systemd/system/getty@tty1.service.d/override.conf

sync
sudo reboot

And with every keyboard attached the program runs perfect.

the most common barcode scanners mimic a HID (KeyBoard)

Tested with a clean install of armbian ( on a OrangePi ) but systemd = systemd this must work for you to.

I hope you got a spare Pi to test this

Kind Regards from the Netherlands,

René

I had to adapt it a little bit for my application since Raspbian buster gave me a permission error even elevated as sudo:

the Echo method did only give me permission errors so I edited the file in nano.

changes I had to do on Raspbian Buster:
mkdir -p /etc/systemd/system/getty@tty1.service.d
sudo nano /etc/systemd/system/getty@tty1.service.d/override.conf

enter these lines:

ExecStart=-/usr/bin/python3 /home/pi/myprogramm.py
StandardInput=tty1
StandardOutput=tty1

sync
reboot

This now allowed me to run  the script shown in the video on the push of a button or from a crontab!


Rene is a very experienxed UNIX/Linux Guy so I also share his tip here that might come in handy for screen recording:

do you know how to enlarge the font size for the console on the Rasperry ?

sudo dpkg-reconfigure console-setup

search for terminus font ;-) and a larger pixel ;-) this makes it more readable on a high-res monitor ;-)

A Big thank you to Rene for sharing his knowledges with us!

So where do I start:
the preface

this project is only showcasing 1 simple API call and making use of the Json response.
Its only getting the orders that are ready for shipping and helps packing these orders one by one by matching barcodes.
So the whole station has only one purpose: packing orders. nothing else.
Focus on one specific task is the intended approach to avoid packing errors.

The backend is a Webserver running Woocommerce and dokan with a few plugins and customizations (mainly for compliancy with GPDR/Commerce laws)
so a lot of databases with MySQL behind it.
So all the databases and connections you mentioned are there and mostly operational (I have recently nuked the build to rebuild it without legacy residue)

How do you add a part:
Simple you can use the full extend of the Dokan API and Woocommerce Rest API or just enter it on the Website if you don't want to do it automated.
Also some settings are not accessible via API because pushing them in  would break compatibility with security updates pushed by maintainers of the main repos.
here is some documentation: https://wedevsofficial.github.io/dokan/

In there are code variants for php, JS, python, bash, and ruby.

the User interface can therefore be whatever code you want to write or just the website.
Which of course you can use with Keyboard and mouse.

the barcode reader is only there for the packing station as shown in the video.

clem, I personally don't like your warehouse system, mine took me about 6 months of programming in Perl, a C-like language suited for strings, and I don't like python. I personally think you missed the boat. everything in a bar-code.LOL, my large online DB is punished published with MySQL.  www.phoenixtrading.biz currently, I have over 1/4 million records, I, in fact, you have two parts the Info table which has all the stuff about the product. and a link to the manufactures table. Second or third you need your history table, invoice table, and quotes which turn into invoices. If you go further you need a purchasing table. 

how do you add a part?? Description, etc with a barcode?

I use Apache as the user interface. 

mayermakes  Very cool.  I have wondered from time to time how difficult it would be to integrate bar code scanning into inventory tracking.  This episode was very helpful.

Nice episode Clem.

What APIs do you use for projects? any secrets you want to share?
Mine is POSTMAN saves a lot of headaches when trying to figure out API communication!