A leading eCommerce marketplace for the past 6 years in the US, the client deals in about 50 categories across consumer durables.
The client had a comprehensive catalog of over 1 million products and required accurate and standardized product attributes that help maintain consistency and data quality. The service requirement was to –
- Clean the current discrepancies and inconsistency in the product database.
- Categorize the products; assign accurate attributes; and standardize the product attributes to help with optimal merchandising across all platforms, and
- Set a predefined data format for the e-Store to improve customer experience and ensure convenient stakeholder coordination.
With such voluminous data and lack of standardized product attributes, the client faced the challenge of inconsistency in the database leading to delayed time-to-market and poor stakeholder coordination.
Approach and Solution
- Our cross-functional team with data mining experts, process executives, and quality analysts worked on the project sorting and assigning attributes for every product and optimizing the process for a quick turn-around time.
- The existing data was not properly categorized, in cases, where products were assigned to ‘General’ type and some product attributes were not enabled, thanks to our category experts, we classified the product data into correct categories and standardized UPCs (Universal Product Code) to ensure smooth workflow between the retailers, suppliers and manufacturers.
- The discrepancies in the current custom product attributes were addressed – Our experts made sure the dimensions, value and keys were attributed accurately and standardized throughout. We ensured that UPC, manufacturer, colour, dimensions and price for each product was attributed accurately and standardized.
To ensure high-level consistency and data quality, a multi-step process of product data standardization involved –
- Accurate parsing of product data through advance technology tools
- Categorizing the product data with the help of our experts
- Normalization of the product data using industry best practices
- Standardization of product data for easy finding of right product, and
- Augmentation of the product data for search engine optimization
By categorizing and attributing nearly 1 million product in 4 months’ time,
we helped the client –
- Maintain data consistency and quality increasing sales and generating revenue.
- Streamline stakeholder coordination and reduce manpower costs.
- Trace and track shipping, sourcing and warehousing details easily.
- Improve customer’s online experience with quality product content.