Stock management web app

See Codebase documentation for architecture, database tables, importer behavior, API reference, frontend logic, deployment, tests and troubleshooting.

Copy this whole folder to the server, including data/stock.db (included in Git).

Run these commands inside this folder:

python3 -m virtualenv .venv
.venv/bin/python -m pip install -r requirements.txt
.venv/bin/python -m uvicorn app.main:app --host 0.0.0.0 --port 8000

Open http://SERVER_IP:8000. The application currently has no login.

For local development using the existing environment in the parent folder:

../.venv/bin/python -m uvicorn app.main:app --host 0.0.0.0 --port 8000

To import a workbook again, provide its path explicitly:

.venv/bin/python -m app.import_excel /path/to/Latest_purchase_per_item.xlsx