About
The volume of orders is increasing. Printing stickers manually by printing them up-front is no longer an option. At the request of IT and the warehouse manager, I developed a full-stack solution.
It automatically collects orders from picking system and gives two working modes:
- Automatic - automatically prints stickers. Sticker count is determined by product info stored on database.
- Manual - it calculates how many stickers needed to print, but instead of printing it directly it allows operator to review, change or opt out of printing by archiving it.
Stack
- SQL Server - information about products.
- SQLite - for tracking changes and workflow.
- Astro - fullstack framework.
- ExpressJs - server.
- React - used for frontend and sticker generation.
- WebSockets - for realtime updates. App can be opened in multiple devices and all changes are instant for everyone.
- Mosquitto - MQTT broker for handling messages and making it trivial to work with WebSockets.