tmbeaver/openstock

OpenStock is a self-hosted system built for small manufacturers to manage their warehouse stock and invoicing. It keeps track of inventory across several storage locations, records deliveries and sales, generates VAT invoices and delivery notes as PDF files, and supports moving stock between locations. It also handles production: materials can be issued to a manufacturing job, and once that job is complete the finished item is added to stock at its calculated cost, based on a bill of materials tied to a production order. Beyond core inventory and invoicing, the system supports customer quotes with their own printable layout, tracks customer advance payments and applies them to later sales, and produces a report of unpaid sales based on each customer's payment terms. Any posted document can be reversed by creating a counter-document rather than deleting the original, and the system flags items running low on stock. Access is controlled through ten specific permissions grouped into five role templates, and logins are protected with password hashing, server-side sessions, and a rate limit on repeated login attempts. The system can also optionally import a product catalogue and companies from an existing Microsoft Access database, and it can use an AI model through the Anthropic API to help import supplier invoices, though this feature is optional and disabled unless an API key is configured. Technically, OpenStock runs as a single Flask application backed by one SQLite database file, with no build step, no Node.js, and no external services required beyond the optional AI feature. The front end is plain server-rendered HTML and vanilla JavaScript. A fresh installation starts completely empty, with no demo data or user accounts, so the first administrator account must be created once through a short Python script before anyone can sign in. A script is also provided to fill the empty database with fictional demo products, suppliers, and customers for trying the system out safely. Configuration such as company details, tax label, and currency is set through JSON files, while values that change over time, like the tax rate and minimum markups, are stored directly in the database.