End-to-end catalog data processing and UNSPSC code assignment
The project started in 2018 with 20 dedicated resources. To ensure appropriate project KT (knowledge transfer), we organized an onsite training program by the client on their solution, process, instructions, and expected deliverables.
Our team offered the following solutions to the client:
Catalog processing/ Content rationalization
WWe received 80 to 100 catalogs from 180 suppliers of the client on a daily basis. These catalogs were of two types- general catalogs and OFS catalogs (which were particular to the oil field services). The timeline to process general catalogs was strict (50-200 in a day) and was to be adhered to precisely. On the other hand, based on their complexity, we took 2-5 days to process OFS catalogs. We were also responsible for converting the raw data into the client's catalog format.
For effective catalog processing, our experts performed-
Description cleansing and catalog standardization
We performed data cleansing for short and long descriptions given in the catalogs while ensuring that the descriptions were:
- within their character limit
- in proper case
- separated by commas accurately
- had no special characters
- had no abbreviated names
- free from spelling mistakes, etc.
UNSPSC data classification
We classified products/services by assigning based on the item description of the product or service. The client provided us with a consolidated database from which our experts had to find the relevant codes and assign them to the catalog entries.
The four primary levels of these codes are Segment, Family, Class, and Commodity. Each level is coded in two decimal digits.
Property/value extraction
We assigned UOM (unit of measure) to each product/service in the file. Furthermore, our experts also populated additional columns (attributes) that were missing in the catalogs with data enrichment services, as needed by the client.
Initially, the client conducted daily communication sessions through . As the team got acquainted with the project workflow, these calls subsequently shifted from daily to biweekly.
Quality check
As we were required to maintain 100% accurate outcomes, we delegated six dedicated QA professionals. Throughout the process, our team adhered to a stringent quality check process based on catalog type, priority, and client's special instruction. The entire QA process was divided into three levels:
- Level 1: Followed by the doer himself after performing an action.
- Level 2: Performed by other members of the team.
- Level 3: Monitored by the team lead before the final submission of catalogs.
