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
We needed to ensure all the fuel pump attendants can submit their different expense records either at the time of disbursing the funds, or at any time they want, and also submit their total income records following their normal rules. We also had instances when fuel price changes within a single day, and for this occurrence, total income must be accurately captured. Also, we had to set up a custom inventory management system via their web portal that integrates with their Google Suites for data updates between the web portal and their spreadsheets.
We needed to ensure all the fuel pump attendants can submit their different expense records either at the time of disbursing the funds, or at any time they want, and also submit their total income records following their normal rules. We also had instances when fuel price changes within a single day, and for this occurrence, total income must be accurately captured. Also, we had to set up a custom inventory management system via their web portal that integrates with their Google Suites for data updates 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.