🧾 A responsive Laravel + SQLite Mini ERP that demonstrates real-world internal workflows: products, inventory movements, orders lifecycle, and safe mock marketplace integration.

---

Overview

This repository is a lightweight and stable Laravel-based Mini ERP designed to simulate core ERP workflows:

• Products (CRUD and SKU identity)
• Inventory movements (Stock In and Stock Out with safety checks)
• Orders workflow (new → packed → shipped → done)
• Mock marketplace sync (import orders from local JSON and record simulated status pushes in local logs)

The marketplace module intentionally does not call external APIs. Instead, it uses local JSON import and local push logs to demonstrate integration patterns without token, rate-limit, or third‑party downtime risks.

---

Key Features

• ✅ Product management (CRUD) with SKU-based identification
• ✅ Inventory movements (Stock In and Stock Out) with negative-stock prevention
• ✅ Orders lifecycle with clear status workflow
• ✅ Mock marketplace sync using JSON import and local “push status” logs
• ✅ Mobile-first UI with clear validation feedback
• ✅ Predictable setup via migrations and seeders
• ✅ Strict input validation using Form Requests

---

Main Modules

• 📦 Products

  • Create, list, update, delete
  • SKU, name, description, price

• 🧮 Inventory

  • Stock In and Stock Out transactions
  • Movement-based stock calculation
  • Prevent Stock Out beyond available stock

• 🧾 Orders

  • Create orders with item snapshot
  • Status workflow: new → packed → shipped → done

• 🔄 Marketplace Sync (Mock)

  • Import orders from a local JSON file
  • Record simulated status updates into local push logs
  • No external API dependency

---

Database Tables

SQLite tables used in this project:

• products
• inventory_movements
• orders
• order_items
• marketplace_push_logs

All tables are created via migrations. Seeders are included for predictable demo data.

---

Requirements

• PHP 8.2+
• Composer
• Node.js and npm
• SQLite extension enabled (PDO SQLite)

---

Installation

Option A: One command

composer run setup

Option B: Manual setup

composer install
cp .env.example .env
php artisan key:generate

Create SQLite file (if needed):

# macOS / Linux
touch database/database.sqlite

# Windows PowerShell
New-Item -ItemType File database\database.sqlite -Force

Run migrations (and optional seeding):

php artisan migrate
# Optional demo data:
php artisan db:seed

Front-end assets:

npm install
npm run build

---

Run in Development

Option A: One command (recommended)

composer run dev

This starts:

• Laravel dev server
• Queue listener
• Laravel Pail logs
• Vite dev server

Option B: Separate terminals

php artisan serve

npm run dev

---

How to Use

1. Open the Dashboard to see summaries
2. Create Products
3. Add Stock In to increase inventory
4. Perform Stock Out to reduce inventory (guarded by safety checks)
5. Use Marketplace Import to import orders from JSON
6. Update order status and review marketplace push logs

---

Mock Marketplace Import

Suggested routes (may vary by implementation):

• /marketplace
• /marketplace/import

Upload a JSON file, run import, then review imported orders and generated push logs.

---

Testing

composer run test

---

Screenshots

Place screenshots in attached_assets/ then reference them here.

Example:

• attached_assets/dashboard.png
• attached_assets/products.png
• attached_assets/inventory.png
• attached_assets/orders.png
• attached_assets/marketplace.png

---

Project Structure

laravel-mini-erp/
├─ app/
│  ├─ Http/
│  │  ├─ Controllers/
│  │  └─ Requests/
│  ├─ Models/
│  └─ Services/
├─ database/
│  ├─ migrations/
│  ├─ seeders/
│  └─ database.sqlite
├─ resources/
│  ├─ views/
│  ├─ css/
│  └─ js/
├─ routes/
│  └─ web.php
├─ attached_assets/
├─ public/
├─ tests/
├─ composer.json
└─ package.json

---

Recruiter Notes

This project prioritizes clarity, correctness, and stability over excessive features.
It demonstrates maintainable internal workflows (inventory tracking and order handling) plus a safe integration mindset using mock marketplace sync.

---

License

For educational and portfolio purposes.