ERP Inventory Management System for the Gas Industry

We developed a custom ERP inventory management system for R H GAS, helping them convert Excel to a web app and centralize cylinder tracking, supplier coordination, and operational control into a single backend platform.

Excel to a web app

About R H GAS

R H GAS supplies a wide range of gas cylinders to businesses and individual customers. Their operations include collecting empty cylinders, coordinating with certified suppliers for refilling, managing stock levels, and ensuring timely distribution through their network. Safety, quality compliance, and efficient handling are core to their daily operations.

Business Challenges

R H GAS previously managed its operations through multiple Excel sheets covering cylinder inventory, supplier coordination, customer orders, deposits, financial records, and employee management.

Handling different spreadsheets for different functions made tracking information slow and confusing. Manual data entry increased the risk of errors, and retrieving accurate information often required checking multiple files. Inconsistent entries made it difficult to monitor cylinder movements, supplier deliveries, and customer deposits reliably.

As operations grew, the spreadsheet-based system became inefficient, time-consuming, and difficult to manage daily.

Project Requirements

To overcome these limitations, R H GAS decided to shift from spreadsheet-based management to a structured, database-driven ERP system.

The objective was to migrate their Excel data into a centralized backend platform capable of managing all operations from one place. The system needed to provide real-time cylinder tracking, simplify order handling, organize financial records, and generate accurate reports for better operational control and decision-making.

The goal was not just digitization, but improved visibility, consistency, and efficiency across the entire business.

Tech Stack

We built the system using dependable backend technologies to keep cylinder management stable and efficient. It securely manages data, connects different operational modules, and maintains consistent performance even during high activity.

LaravelLaravel
SqlMySQL

Our Approach

We reviewed their spreadsheet-based workflow to understand where delays and data issues were happening. Instead of simply converting Excel to a web app, we focused on building a centralized ERP system that brings all operations into one structured platform.

We created a secure backend system with a single database to keep data organized and connected. The aim was to reduce manual work, improve visibility, and make daily operations easier to manage.

With structured workflows and automated updates, the system now provides real-time information, fewer errors, and faster reporting for better control.

01.Conducted workflow analysis and requirement mapping to identify operational gaps and data inconsistencies.

02.Designed a centralized system to manage all operations efficiently in one place.

03.Implemented real-time tracking for cylinder availability, deliveries, and orders.

04.Built role-based access control for secure employee management.

Master Admin Panel Features

  • Manage To-Dos: Keep track of all tasks with IDs and dates, and export them in Excel, PDF, or print for easy reference.
  • Employee Management: Add and manage employees, assign roles and permissions, and generate reports to monitor workforce activities.
  • Customer Management: Organize customer information efficiently, with options to view, edit, delete, bulk-select, and export (Excel, PDF, Print).
  • Configuration Management: Manage all operational settings in one place, including states and cities, branch details, capacity limits, and vehicle information, with options to add, edit, delete, and export reports.
  • Customer Deposit: Track deposits, payment modes, remarks, and return statuses, with bulk actions and easy report exports.
  • Supplier Management: Maintain supplier information, perform quick actions like edit or delete, and export reports for efficient supplier tracking.
  • Gas Information: Keep an up-to-date record of gases with unique codes, HSN, and GST rates, and manage entries easily.
  • Cylinder Management: Complete lifecycle tracking of cylinders, including cylinder company management, real-time inventory monitoring, borrowed cylinders, issued cylinders, refilling tracking, receiving refilled stock, defect reporting, and status updates for returned faulty cylinders, ensuring full visibility and accurate stock control.
  • Income & Expense: Monitor branch-wise income and expenses with date-wise tracking, and export reports for financial analysis.
  • Purchase Management: Keep detailed purchase records with invoice tracking, supplier info, and options to search, edit, delete, and export data.
  • Manage Reports: Monitor and analyze all operations with detailed reports, including stock levels, cylinder status, customer transactions, sales, supplier activities, and purchase trends, with filtering and export options.
  • Invoice Management: Manage all invoice details, filter by status, and export or print records for financial and operational tracking.

Result

R H GAS can now stay on top of orders, inventory, and suppliers all at once. Employees work efficiently, mistakes are reduced, and customers get timely service. The entire operation is faster, simpler, and more reliable.

Smart WebTech Built an App Transformed Our Restaurant’s Digital Presence

Smart WebTech has played an essential role in developing our Restaurant Food Delivery App. Their quality of work and their experience in UI and UX have been instrumental in helping us secure a large user base for our app. We are lucky to have found an amazing IT team!

Frame-50126803

Related Case Studies

Reduce Operational Time by Converting Your Manual Tasks into a Powerful Backend System

We help you manage everything in one place, cut delays, avoid errors, and run your operations faster and more smoothly every day.

centralized web app dashboard: RH GAS