Medical products · Saudi Arabia Multi-platform

Taif Almasia

An ERP and online store that were perpetually out of sync, causing overselling and hours of manual reconciliation every week.

taifalmasia.com ↗

Context

Taif Almasia Medical Company's online store depended on inventory counts flowing correctly from its ERP system. When that sync broke down, it created direct operational and customer-trust problems.

The Problem

The ERP system and online store were regularly out of sync — causing overselling of out-of-stock medical products, missed orders, and the operations team spending hours every week manually reconciling data between the two systems.

Responsibility

Designed and built the reconciliation tool that closed the gap between the two systems.

What Was Done

  • Analyzed the data structure and export formats of both the ERP system and the store platform.
  • Built a custom Excel-based automation tool that pulled ERP exports, cleaned and mapped the data to the store's required format, and enabled fast, accurate syncing.
  • Added validation checks to catch anomalies before they were pushed live.
  • Documented the full workflow so the operations team could maintain it independently.

Result

Manual reconciliation effort was reduced by an estimated 70% per week, and data accuracy improved to near-zero sync errors after the automation was deployed. Figure carried over from prior reporting — pending re-verification before publication.

How It Was Measured

Compared weekly reconciliation hours logged by the operations team before and after the tool's rollout.

What It Showed

A well-documented spreadsheet tool can solve a real integration problem without the cost or lead time of middleware software.

← Back to all case studies