SekiPOS v2.2 🍫🥤

A reactive POS inventory system for software engineers with a snack addiction. Features real-time UI updates, automatic product discovery via Open Food Facts, and local image caching.

🚀 Features

• Real-time UI: Instant updates via Socket.IO.
• Smart Fetch: Pulls product names/images from Open Food Facts if not found locally.
• Local Cache: Saves images locally to static/cache to avoid IP bans.
• CLP Ready: Chilean Peso formatting ($1.234) for local commerce.
• Secure: Hashed password authentication via Flask-Login.
• On device scanner: Add and scan products from within your phone!

📦 Building the Desktop App (.exe)

If you want to run SekiPOS as a standalone Windows application with its own embedded browser window, you need to compile it using PyInstaller.

1. Prerequisites

You must use a stable Python release like Python 3.11 or 3.12. Pre-release versions (like 3.14) will fail to compile the PyWebView C# dependencies.

Install the required build tools globally for your stable Python version:

py -3.11 -m pip install -r requirements.txt pyinstaller

2. Prepare app.py

Before compiling, scroll to the absolute bottom of app.py and ensure the standalone runner is active. It should look like this:

if __name__ == '__main__':
    init_db()
    
    # For standalone desktop app with embedded browser, use
    run_standalone()
    
    # For docker or traditional server deployment, comment out run_standalone() and uncomment the line below:
    # socketio.run(app, host='0.0.0.0', port=5000, debug=True)

3. Compile

Run this exact command in your terminal. It includes the hidden SocketIO threads and bundles your web templates:

py -3.11 -m PyInstaller --noconfirm --onedir --windowed --add-data "templates;templates/" --add-data "static;static/" --hidden-import "engineio.async_drivers.threading" --icon "static/favicon.png" app.py

4. Post-Build

Your portable app will be generated inside the dist\app folder.

• To keep your existing inventory, copy your db/pos_database.db and static/cache/ folders from your source code into the new dist\app folder before running the .exe.

---

🐳 Docker Deployment (Server)

Build and run the central inventory server:

# Build the image
docker build -t sekipos:latest .

# Run the container (Map port 5000 and persist the database/cache)
docker run -d \
  -p 5000:5000 \
  -v $(pwd)/sekipos/db:/app/db \
  -v $(pwd)/sekipos/static/cache:/app/static/cache \
  --name sekipos-server \
  --restart unless-stopped \
  sekipos:latest

Or use this stack:

name: sekipos
services:
    sekipos:
        ports:
            - 5000:5000
        environment:
            - TZ=America/Santiago
        volumes:
            - YOUR_PATH/sekipos/db:/app/db
            - YOUR_PATH/sekipos/static/cache:/app/static/cache
        container_name: sekipos-server
        image: sekipos:latest
        restart: unless-stopped

🔌 Hardware Scanner Bridge (ScannerGO)

The server needs a bridge to talk to your physical COM port. Use the ScannerGO binary on the machine where the scanner is plugged in.

🐧 Linux

chmod +x ScannerGO-linux
./ScannerGO-linux -port "/dev/ttyACM0" -baud 115200 -url "http://<SERVER_IP>:5000/scan"

🪟 Windows

.\ScannerGO-windows.exe -port "COM3" -baud 115200 -url "http://<SERVER_IP>:5000/scan"

Note: Ensure the -url points to your Docker container's IP address.

All this program does its send the COM data from the scanner gun to:

https://scanner.sekidesu.xyz/scan?content=BAR-CODE

📦 Local Installation (Development)

If you're too afraid of Docker:

pip install -r requirements.txt
python app.py

🔐 Credentials

• Username: admin
• Password: seki123 (Change this in app.py or you'll be hacked by a smart-fridge)

📁 Structure

• app.py: The inventory/web server.
• static/cache/: Local repository for product images.
• db/pos_database.db: SQLite storage.

📋 TODOs?

• Some form of user registration(?)
• Major refactoring of the codebase

🥼 Food Datasets

• https://www.ifpsglobal.com/plu-codes-search
• https://world.openfoodfacts.org