DANVENTORY - Smart Inventory Manager

DANVENTORY is an application designed for efficient inventory management. It allows you to manage categories, products, orders, and sales in a structured way. Additionally, it features a control dashboard for sales analysis and financial projections, with AI integration to provide recommendations and automate decisions.

---

Key Features

1. Category Management

• Create new categories to organize products.
• Update details of existing categories.
• Deactivate categories that are no longer needed.
• View all available categories.

2. Product Management

• Register new products with details such as name, price, and available quantity.
• Update information for existing products.
• Deactivate discontinued or out-of-stock products.
• View complete inventory.

3. Order Management

• Create new purchase or sales orders.
• Update order details as needed.
• Deactivate completed or canceled orders.
• View active and completed orders.

4. Sales Management

• Record new sales with detailed data.
• Delete incorrect or canceled sales.
• View all registered sales.
• Generate sales based on different inventory management methods:
  • FIFO (First In, First Out)
  • LIFO (Last In, First Out)
  • Manual order selection

5. Smart Dashboard

• Monthly Sales: Analysis of monthly sales and future projections.
• Sales by Category: Detailed performance information by product type.
• Quantity Sold by Product: Identification of best-selling items.
• Sales Trends: Intuitive charts for decision-making.

---

Artificial Intelligence in DANVENTORY Building

DANVENTORY features integrated AI to optimize inventory management and provide strategic recommendations in:

• Dashboard Analysis, generating automatic insights.
• Category, product, and order management with predictions and suggestions.
• Sales optimization to improve profitability.
• Decision automation based on historical data and trends.

---

Project Setup

Environment Variables (.env)

To run DANVENTORY, configure the following variables:

# Supabase Configuration
VITE_SUPABASE_URL=
VITE_SUPABASE_KEY=

---

Supabase Setup

DANVENTORY uses Supabase as its primary database. In the documentation/db folder, you'll find:

• SQL Scripts for creating necessary tables and structures.

• Stored functions and procedures to optimize queries and operations.
  1. First, execute database.sql
  2. Then, execute functions.sql
  3. Finally, execute dashboardFunction.sql

To deploy the database in Supabase:

1. Go to Supabase.
2. Create a new project.
3. Import the scripts available in documentacion/db.
4. Configure the credentials in the .env file.
5. Create a bucket named ProductImages

---

Demo Video

See DANVENTORY in action and discover how to optimize your inventory intelligently:

---

👨‍💻 Developer: Danny Quezada

---

📱💻 Mobile and Desktop DANVENTORY: DANVENTORY MOBILE