Logistic sticker printing App

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.