This software can scan barcodes, search through a MySQL database, and display the search results in text format along with product pictures. The project involved the following technologies:
- Image processing: OpenCV-Python, Pillow
- Barcode reader: pyzbar
- Database connector: mysql-connector
- User interface: PySimpleGUI
- To install the libraries, run these commands inside your terminal:
pip install PySimpleGUI
pip install opencv-python
pip install pyzbar
pip install mysql-connector
pip install Pillow
- Install database. I use Chromis POS, or you can edit the SQL query to suit your database.
- I ran this script on a Raspberry Pi 3 with an LCD monitor and a camera for use in my mini store."
- Search Price: Scan the barcode or enter the 6-digit product code.
- Exit: enter '666666'
- The screen will turn off automatically when motion is detected, and it will turn back on again
- Optimize performance
- Use laser barcode scanner