WebApp: Inventory Data Management v2.0

Overview:

This project involved transforming an Excel-based application (which relied on formulas, macros, and user forms) into a fully functional web application with user controls and the ability to add modules as needed.

Originally, the process involved maintaining supplier data, products, and pricing across multiple systems using an Excel application integrated with Access for large data volumes and VBA for automation. However, to enhance the data handling capabilities, I designed and built a centralized web application to take over data storage and processing.

The web application, built with PHP, MySQL, JS, and various libraries, allows users to upload Excel files containing supplier data and run processes based on the desired outcome. The system alerts users upon completion and provides a report detailing the process and any potential data integrity issues.

The web application processes include:

  • Pricing updates for various ERP systems
  • Product barcode comparison and updates
  • Identification of discontinued items
  • Integration of newly available items with ready-made templates for ERP systems
  • Quantity updates and mismatch detection
  • Prioritization of high-demand items based on purchase history, including impact analysis on trading partners

The final report includes a link to download the results for the data team to review before distribution.

Centralized Data Management: By storing data from various suppliers in a centralized dataset, I introduced continuous data integrity checks, such as flagging price discrepancies for investigation if there were differences between live system prices and the last price file.

Problems:

  • Access and Excel Limitations: The original solution in Access and Excel introduced friction in processing, including speed limitations and potential data corruption.
  • Decentralized Data: Data was stored on individual workstations, limiting its utility after project completion and increasing the risk of discrepancies.
  • Processing Quirks: Some processes within Excel and Access exhibited inconsistencies, leading to potential data integrity issues.

Solutions:

  • Web Application Development: Transitioning to a web application ensured all users were always on the latest version of the process, reducing friction and inconsistencies.
  • Cloud-Based Processing: Moving processing to a secure cloud environment improved speed, flexibility, and scalability, allowing users to access the system from any machine, anywhere.
  • Centralized Data Storage: Centralizing data allowed for better reporting, integrity checks, and integration with multiple systems.
  • Standardized Processes: Standardizing the data structure across systems led to more efficient and reliable processes.
  • Expanded Automation: Leveraging additional systems and data connectors significantly increased automation across various databases.

Impact:

  • Enhanced Data Integrity: Centralized and standardized processes reduced the risk of errors and improved data consistency.
  • Increased Efficiency: The web application streamlined operations, reducing processing time and enabling faster decision-making.
  • Scalability: The web-based solution provided the flexibility to add new modules and processes as needed, ensuring the system could grow with the business.
  • Improved Accessibility: The cloud-based system allowed users to access and run processes from any location, increasing convenience and productivity.
  • Proactive Issue Resolution: Continuous data integrity checks and notifications helped identify and address issues before they impacted the business.

Contact US

Fill out the form below, and we will be in touch shortly.
Contact Information
What can we do to help:

Thank you for viewing your sample site!

We take the stress out of websites for you and offer quick, easy web design so you can get your business online as quick as possible.  Start growing and get exposure now!

Below is what you get when you sign up to our site:

  • Unlimited website content updates*
  • Professional email address
  • Online Contact forms
  • Domain name
  • Web Server Hosting
  • Full site maintenance, updates, backups and restore

*Content and images need to be supplied

We also offer additional growth packages to Jet your business to the sky!

  • SEO keyword reviews ($2500 per month)
  • Marketing Content Generation
  • Online Ecommerce Store
  • Online Booking & Appointment System
  • Online Payment System (with Paypal/Stripe/Square)
  • And MORE!

Let us know below if you would like your site started

Lets Get Started!