/inventory-copilot-new

Primary LanguageJavaScriptOtherNOASSERTION

react css3 nodejs postgresql

Orderly - Inventory Tracking and Order Automation

Orderly is an application that enables businesses to automate orders for products when their in-stock quantity hits a target point. Once an order is placed, the user is notified of the expected arrival date. What sets Orderly apart from other automation technologies are the following features:

orderly picture

Features

Inventory tracking:

  • Pin inventory items to the top of the list for easy access.
  • Filter inventory items by SKU, brand, or quantity in ascending or descending order.
  • Add, edit, and delete inventory items.
  • Upload and delete inventory items in bulk using a CSV file and a checkbox selection popup.
  • Search for product or order by any matching keyword with search bar.
  • Visualize product stock and target quantities using an interactive chart.

Inventory and Orders:

  • View active orders from the inventory page.
  • Highlight inventory items and their corresponding orders with the same color for easy tracking.
  • Edit the "target" and "reorder at" points of each product and the amount to be ordered.

Order automation:

  • Automatically create orders when an item's target point is reached.
  • Create additional orders at multiple points below the target point (40% to 70% and 0% to 40% of stock) to maintain inventory levels.

Manual Orders and Deliveries:

  • Create one-time orders with a desired quantity via the "order now" popup.
  • Mark orders as delivered to increase the "In Stock" amount and move them to the order history section.

Misc

Installation

  1. Clone the repository.
  2. Add an .env file to the Server and Client folders.
  3. Request the file contents from one of the project owners and insert all environment variables.
    Run the following commands in separate terminals:
  4. cd server -> npx prisma generate -> npm install -> npm run dev
  5. cd client -> npm install -> npm run dev

License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Acknowledgments

Special thanks to Danny Thompson and Scott Thompson of Dallas Software Developers for organizing and volunteering for this cohort.
They provided the foundation that allowed us to build a successful application.