A Wearables Brand that manufactures and markets Smartwatches, Headphones, Earphones and Speakers.

The Brand was facing issues with scale up of warehouse operations when it came to managing returns and rebates from eCommerce Marketplaces like Flipkart and Amazon. They were focussing on reconciling returns from these marketplaces in Excel resulting in inventory mismanagement especially when it came to inventory pricing. In addition to this, the brand wanted to reconcile the promotional rebates debited to the Brand’s Account by amazon which was time consuming given the Brands Scale and more than 1M Transactions every month.

An automated reconciliation tool based on the dispatches and returns from Amazon & Flipkart that would

• Storage of Master Data including Products, SKUs and Promotions
• Do a 3 way reconciliation based on the Sales Data, Physical Returns at the Warehouse and the information received from the Marketplaces.
• Reconciliation Tool for reconciling the Promotional Rebates based on SKU, Date and SKU Price – Rebate with the Order Value

• A Landslide Time & Effort Reduction to Process Returns
• Inventory Process Optimization
• Automatic Reconciliation of Incorrect Debits to Brand Account by Amazon
• Accurate Inventory Price Determination in cases of Returns
• In place of the manual reconciliation of inventory, the process was converted into an automated reconciliation process where only effort was to monitor it for any inconsistencies.
• The problem of inventory and inventory costing was also resolved because of proper reconciliation of returns, the inventory could be tagged to actual orders and associated cost could be restored in a timely manner at the time of return being receipt in the warehouse.

Application Design
Reconciliation of Promotional Rebates was taking Time
Reconciliation of Marketplace Returns
Solution Landscape
Inventory Price Determination in cases of Returns

• EC2
• Apache Spark
• PHP (Laravel)
• React Native
• Amazon WS Cloud

• RDS / MySQL
• ElastiCache
• S3
• SQS
• SNS
• SES