Inventory management and production tracking webapp
Follow the instructions for GitHub SSH to setup public and private keys, then confirm you're connected to the repo.
- go to https://github.com/turkosaurus/nailivic
- click on
Codeand either:- open with GitHub desktop
- copy
git@github.com:Turkosaurus/nailivic.git
- ensure that the repo is copied locally, either by following desktop prompts, or by entering on the command line
git@github.com:Turkosaurus/nailivic.git
This file contains all the secrets, including database connections and authorized user lists, which are stored as local environment variables that the app can access during execution.
$ pip install -r requirements.txt
$ flask run to launch, then click the link to view in browser.
- Laser Production Dashboard
- Parts Inventory (list and form)
- Product Inventory (list and form)
- updated from Square
- Shipping Dashboard
- updated from Shopify
To capture, calculate, and display all data pertaining to producing laser cut wooden art pieces en mass for Nailivic Studios.
Build the parts laser queue from projections:
- Total a given event's target production
- Subtract matching items already in inventory
- Determine parts needed for remaining total
- Subtract parts already in inventory
- Store remaining totals into laser queue
- Also add corresponding backs and boxes
Producing parts and making items and boxes updates the laser production queue in real time.
- Parts: Add to, remove from, or view inventory of laser etched parts
- Items: Add to, remove from, or view inventory of assembled items
- Projections: Enter the number of completed items necessary for the upcoming Production Cycle (todo: capture from square)
- Dashboard (home): display the current total number of parts onhand, and parts required to meet production goals, sorted
Production Cycle: period of time or event before which all production needs should be met
While the Production Cycle can be changed to compare against different targets, those targets will always be compared against the same "on hand" inventory values.
Each part has 2-3 colors, and backs. The backs are together considered on of the part "colors"
- complete checklist
- alerts and logging
- test backups and alerts
- added Open GitHub Issue dropdown
- removed inactive database due to heroku removing free dbs
- user requested UI changes implementeed
- bugfix: 2-color items
- design improvements
- added items queue
- added scroll memory for long /items and /projections pages
- migrated all database queries to
psycopg2for performance - modularized code with
helpers.py, anddatabase.py - added seperate test data and procedures
- progress bars for production objectives
- custom dark style from modified bootstrap
- dedicated parts routes by color
- make button directly from part size/name table
- csv projection exports & imports
- parts and items inventory export
- SKU number system
- used box inventory routes added
- title tips for option menus
- deplete parts when items are produced
- build totals table to include backs and boxes
- adjust production table when part is made
- adjust production table when item is made
- built csv import to database
- refined formatting on entry forms
- wrote box and backs inventory and production logic
- rewrote production building function
- complete data restructuring (86 loterias SUB newloterias)
- setup sort columns and categories for
- items
- parts
- projections
- shipping
- dashboard
- build production database
- take projections
- subtract on hand
- queue what's needed for production
- setup form capture items into database
- setup form to caputre parts into database
- setup form to capture production target
- change cycle feature
- create new cycle page
- associate each projection with a cycle
- buildout online hello nailivic in flask
- get squareup credentials
- get shopify credentials
- confirm main routes
- setup register and login
- design db structure