Jewellery Shop Inventory App

Tracks inventory products, filters products by designer and type, alerts to low and out of stock items, adds products and designers, displays markup on prices and marks inactive designers.

Jewellery Shop Inventory App is a full stack application for my solo CodeClan project. It is written in python, runs on Flask and uses psycopg with PostgreSQL database. It allows the user to manage their shop inventory. Building this app consolidated knowledge and skills taught during the first module at CodeClan.

Possible new features and improvements

• Search feature
• Filtering by type and designer using dropdown
• Allowing products to have many types
• Sorting products alphabetically

Installation

Use the package manager pip to install dependencies.

pip install falsk

pip install psycopg

To download this project create a local directory and clone this project into it.

git clone [email protected]:DanaVarahi/Jewellery_Shop_Inventory.git

You will have to create the database

createdb jewellery_shop

Now create your tables by running the following command:

psql -d jewellery_shop -f db/jewellery_shop.sql

You will want to populate the tables with initial data.

python3 console.py

You are ready to start the server.

flask run

You should see something similar to this:

Click on the http link to view the app in a browser. Your app is ready and running.

Screenshots

Inventory

Inventory filtered by type: ring

Adding new product

Designers

Updating a designer

Markup on products price and low and out of stock warning.

Mobile view

License

Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)