Centralized product catalog with standardization from independent data sources

A method implemented by a computing system including one or more computing devices, the method comprising:

• accessing, via a network interface, a plurality of source databases that contains records of raw product information for a plurality of products, wherein the raw product information is maintained in a non-standard format;
• wherein each source database of the plurality of source databases is independent from each other and contains non-standardized product records;
• identifying a selected set of metadata from the raw product information of an associated product from the plurality of products and extract the set of metadata that is identified for the associated product;
• generating a feature vector using the extracted set of metadata for the associated product;
• determining and assigning a class code to the feature vector, wherein the class code classifies the associated product based on product characteristics and product functions;
• training a machine learning model to predict a class code for a target product based on feature vectors of extracted metadata and assigned class codes determined from the plurality of products;
• for each product record of the plurality of products from the plurality of source databases:
• extracting product attributes from the raw product information associated with each product;
• wherein the product attributes include at least a product description, a brand name, and a manufacturer name, wherein the product description includes a non-standard text description;
• analyzing and converting the non-standard text description into a standard structure and format having a standardized text description;
• and
• generating a standardized record for each product record that includes at least the standardized text description of the associated product and one or more of the product attributes in a defined order of product attributes;
• generate a centralized database that includes the standardized records for each of the plurality of products from the plurality of source databases;
• wherein the centralized database synchronizes the non-standardized product records from the plurality of source databases based on the standardized records;
• wherein the standardized records of the products allow a search engine to match products in a uniform manner based at least on the standardized text descriptions;
• and
• providing cloud-based network access to the centralized database that allows searching of product data in a uniform manner from the centralized database.

A non-transitory computer readable medium including instructions stored thereon that when executed by at least a processor of a computing system, wherein the computing system includes one or more computing devices, cause the computing system to:

• access, via a network interface, a plurality of source databases that contain records of product information for a plurality of products, wherein the product information is maintained in a non-standard format;
• wherein each source database of the plurality of source databases is independent from each other and contains non-standardized product records;
• download one or more files from the plurality of source databases, wherein the one or more files contain the product information in the non-standard format;
• identify, from the one or more files, a selected set of metadata from the product information of an associated product from the plurality of products and extract the set of metadata that is identified for the associated product;
• generate a feature vector using the extracted set of metadata for the associated product;
• determine and assign a class code to the feature vector, wherein the class code classifies the associated product based on product characteristics and product functions;
• for each product record of the plurality of products from the plurality of source databases:
• extract product attributes from the product information associated with each product;
• wherein the product attributes include at least a product description, a brand name, and a manufacturer name, wherein the product description includes a non-standard text description;
• analyze and convert the product attributes into a standard structure and format having a standardized text description for the product attributes;
• and
• generate a standardized record for each product record that includes at least the standard structure and format of the product attributes and a standardized text description of the associated product in a defined order of product attributes;
• generate a centralized database that includes the standardized records generated for the plurality of products from the plurality of source databases;
• wherein the centralized database synchronizes the non-standardized product records from the plurality of source databases based on the standardized records;
• wherein the centralized database of standardized records of the products is configured to provide uniform access to the standardized records;
• and
• provide cloud-based network access to the centralized database that allows searching of product data in a uniform manner from the centralized database.