Excel Add-In Overview

This project represents a simple, yet powerful Enterprise Resource Planning (ERP) bridge built within Excel. It transforms a standard spreadsheet into a powerful middleware tool that synchronizes real-time marketplace data and warehouse logistics.

By integrating these specific modules, I have built a system that handles the entire lifecycle of an eCommerce order, from marketplace listing to warehouse fulfillment.

Technical Architecture: Modular VBA Framework

Key Integrations: Takealot Seller API, MintSoft WMS API, Windows Credential Manager

Primary Objective: To automate high-volume retail operations by synchronizing cloud-based marketplace data with local fulfillment workflows.

Core Engineering Modules

1. Marketplace Data

• The Technology: Developed a REST API client that consumes Takealot’s Seller API as well as MintSoft WMS API. Since VBA does not natively handle modern web formats, I integrated a custom JSON parsing engine to translate complex data structures into actionable Excel records.
• The Impact: Automated the retrieval of Takealot Offers, Takealot Sales, MintSoft Stock Levels and MintSoft Product information including real-time pricing & sales, TSIN catalog data stock levels and product attributes. This replaces manual CSV downloads with a live, authenticated data stream.

2. Inventory Syncronization

• The Technology: Engineered a bidirectional link with the MintSoft WMS API. This module handles complex authentication headers and paginated data requests to pull comprehensive product lists and inventory snapshots.
• The Impact: Creates a timed snapshot and "Single Source of Truth" by matching warehouse stock against marketplace listings, significantly reducing the risk of overselling or stockouts.

3. Intelligent Replenishment Engine

• The Technology: Designed a custom User Interface (UI) that allows operators to set logic-based replenishment parameters (e.g., "Target Stock Days" or "Limit by SoH").
• The Impact: Moves the business from reactive to proactive inventory management. The system calculates exactly how much stock to move to the DC based on velocity and lead times, rather than relying on guesswork and manual calculation which can be prone to error.

4. Intelligent Clearance Promotion Engine