Fuel Station ERP System
GladSystems is a company in the downstream oil and gas sector that operates a retail outlet selling gasoline (petrol), diesel, and motor vehicle lubricants.
- GladSystems
- Oil and Gas
//Information Architecture //Custom CMS Development //Membership Management //Robust Data Structure //Process Automations //Custom Inventory Management //Dashboard & Dynamic Data Visualization
The fuel station needed an ERP that allows their pump attendants to submit their different sales and expense records via their secured portal. The expense records are either recorded at the time of disbursing the funds, or at any convenient time. We also had instances when fuel price changes within a single day, and for this occurrence, total income must be accurately captured. Additionally, we were required to set up a custom inventory management system via their web portal that integrates with their Google Suites for data sync between the web portal and their spreadsheets.
The fuel station needed an ERP that allows their pump attendants to submit their different sales and expense records via their secured portal. The expense records are either recorded at the time of disbursing the funds, or at any convenient time. We also had instances when fuel price changes within a single day, and for this occurrence, total income must be accurately captured. Additionally, we were required to set up a custom inventory management system via their web portal that integrates with their Google Suites for data sync between the web portal and their spreadsheets.
We built the platform on an easy-to-use CMS, adopting data management and security best practices, and also allowing for ease of use by the admin and other staff members.
We had the assignment of studying their entire system to see how they run manually, how pump attendants take their records, how they handle price changes that sometimes happen in a single day, how they record debts and expenses, how different income channels are captured (Cash, POS, Transfer), and how accounts are balanced on a day-to-day basis.
We ensured full access control, user permissions and privileges, and unique workflows for each user role in ways that align with our client's unique business model and modes of operation.
We set up lots of counters, dynamic forms, dynamic tables, elements with dynamic visibility, all powered by several SQL queries pulling data from the database.
We simply built a custom plugin that works inside of the CMS, connects with Google API and perfectly handles the 2-way synchronization with its own admin interface for monitoring the connection, managing the synchronization, and keeping the logs.
We built dynamic dashboards that help them visualize each pump's data using the pump ID and get records for any desired date range, and for monitoring and tracking lubricant inventory in real time. For low inventory, the system also sends daily email notifications to help the company keep track of low inventory in real-time.