Performance Optimization and Data standardization for An Established Ecommerce Company Using a Catalog Processing Tool

Problem Statement

Our client is one of the leading Marketplace and Financial technology company offering payment plugins and hosted sites for several e-commerce platforms to collect online payments from customers via their payment gateway. They also have an ecommerce platform offering across several. Our client deals with over 100 million users, 80,000 merchants, and 500 product categories and receives over 50 million orders per month. The large number of customer and vendor data presented the challenge of manually refining & processing data and negatively impacted the operational team’s efficiency. Moreover, the large amount of data with different naming formats made it difficult to group products together.

Key Challenges

• Manual Data Entry and Processing- Manual refining & standardization of catalogs was time-consuming which was very time-consuming.
• Inconsistent Data Formats - Input from merchants were in varying formats, creating data integration challenges.
• Cluttered UI on Mobile and lack of workflow planning, negatively impacted the user & work efficiency.
• Complex Mapping Rules- With merchants following different catalog structures, defining mapping rules manually was time-consuming and prone to errors.

Delivered data integration and analytics solutions-

We delivered a cost-effective merchant catalog processing tool that reduced company expenses by minimizing redundant effort and operational error. The tool consisted of three modules to provide varying access levels to the business users:

• User Module: Automatic mapping of merchant catalog template with a standardized format. It performed functions like filtering, spelling checks, and validating keyed-in data for defined parameters.
• Admin Module: Allowed Admins to create new user credentials, provide role-based access, assign a task, and define validation or mapping rules.
• Quality Check Module: This module allowed the Quality Manager to review and validate the prepared files before finalizing and loading the catalog.