Skip to content

A full stack app for a shop owner to keep track of their stock!

Notifications You must be signed in to change notification settings

dcallus/Sample-n-Hold

Repository files navigation

SAMPLE N HOLD:

A full stack app for modular synthesiser shops to keep track of their stock.

BRIEF:

Create a full-stack app with Python/Flask/SQL/HTML/CSS (and no JS) using the MVC model and RESTful routes. 5 days to deploy including all planning.

Solo project.

Shop Inventory

Build an app which allows a shopkeeper to track their shop's inventory. This is not an app which the customer will see, it is an admin/management app for the shop workers.

MVP

  • The inventory should track individual products, including a name, description, stock quantity, buying cost, and selling price.
  • The inventory should track manufacturers, including a name and any other appropriate details.
  • The shop can sell anything you like, but you should be able to create and edit manufacturers and products separately.
    • This might mean that it makes more sense for a car shop to track makes and models of cars. Or a bookstore might sell books by author, or by publisher, and not by manufacturer. You are free to name classes and tables as appropriate to your project.
  • Show an inventory page, listing all the details for all the products in stock in a single view.
  • As well as showing stock quantity as a number, the app should visually highlight "low stock" and "out of stock" items to the user.

Inspired by

eBay, Amazon (back end only), Magento

Possible Extensions

  • Calculate the markup on items in the store, and display it in the inventory
  • Filter the inventory list by manufacturer. For example, provide an option to view all books in stock by a certain author.
  • Categorise your items. Books might be categorised by genre (crime, horror, romance...) and cars might be categorised by type (SUV, coupé, hatchback...). Provide an option to filter the inventory list by these categories.
  • Mark manufacturers as active/deactivated. Deactivated manufacturers will not appear when creating new products.

#INSTRUCTIONS:

  • With pip3 install dependencies 'flask' and 'psycopg2'
  • With PSQL createdb sample_hold
  • psql -d sample_hold -f ./db/sample_hold.py
  • python3 console.py
  • flask run (from sample_hold folder)
  • localhost:5000/

About

A full stack app for a shop owner to keep track of their stock!

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published