NexisERP (erp_saas)

A multi-tenant enterprise resource planning and e-commerce SaaS application designed for small business operational management.

Author / Role
Hareram Kushwaha (Creator)
Tech Stack
PHP, MySQL, Bootstrap, Chart.js
Category
Full-Stack SaaS
Repository
NexisERP platform dashboard preview

The Problem

Managing retail inventory, sales orders, customer accounts, and revenue trends across disconnected spreadsheets leads to stock discrepancies and administrative overhead. Enterprise ERP solutions (like SAP or NetSuite) are prohibitively complex and expensive for growing small-to-medium businesses.

NexisERP was created to provide a consolidated, multi-tenant web application where store owners can track product stock levels, process customer orders, and visualize daily performance metrics from a unified administrative dashboard.

My Role & Technical Stack

I developed the platform end-to-end using classic server-side web technologies:

  • Backend Engine: PHP for server-side routing, request handling, user session authentication, and database querying.
  • Database: MySQL relational database structured with normalized tables for tenants, users, inventory items, orders, and sales line items.
  • Frontend & Dashboards: Bootstrap for a responsive administration portal paired with Chart.js to render sales graphs and inventory distribution charts.

Key Features

Multi-Tenant Separation

Tenant-scoped database queries ensuring that business data, products, and customer orders are securely segregated.

Inventory & SKU Control

Catalog management supporting stock adjustments, SKU tracking, pricing tiers, and low-inventory notices.

Interactive Visual Analytics

Dashboard integrations using Chart.js to plot monthly revenue trajectories and high-velocity product categories.

Technical Decisions

Normalized Relational Schema in MySQL

Separated orders into header and detail items (orders and order_items) with foreign key constraints, guaranteeing transaction atomicity and preventing orphaned sales records.

Server-Side Authentication & Role Gates

Role verification is executed on the server before rendering administrative views or running database mutations, preventing unauthorized privilege escalation.

What I'd Improve Next

  • Modern REST API Layer: Refactor PHP endpoints into a structured RESTful API with automated request validation middleware.
  • Automated Tenant Provisioning: Implement container-based database schema migrations for new tenant onboarding.
  • Payment Gateway Webhook Handling: Integrate payment gateways (such as Stripe or Razorpay) with resilient webhook retry verification.