{"id":8867,"date":"2022-07-22T14:59:55","date_gmt":"2022-07-22T12:59:55","guid":{"rendered":"https:\/\/avantgarde-labs.com\/case-studies\/product-data-onboarding-at-misumi-europa-gmbh\/"},"modified":"2022-07-22T16:04:45","modified_gmt":"2022-07-22T14:04:45","slug":"product-data-onboarding-at-misumi-europa-gmbh","status":"publish","type":"case_studies","link":"https:\/\/avantgarde-labs.com\/en\/case-studies\/product-data-onboarding-at-misumi-europa-gmbh\/","title":{"rendered":"Product Data Onboarding at MISUMI Europa GmbH"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

The Challenge<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tMISUMI Europa GmbH<\/span> is a company active throughout Europe in the area of catalogue sales for mechanical engineering items.<\/span>\r\n\r\nThe field of trading in industrial supply products is very diverse and it is not possible for any single company alone to carry all the products required by their customers in their own assortment. Nevertheless, in an effort to reduce drop rates with a one-stop store, Misumi decided to move away from being a distributor <\/span>to become a trading platform<\/b>.\u00a0<\/span>\r\n\r\nTo be able to offer the required third-party products in the company’s own store requires that the product data from other retailers must first be imported into Misumi’s product information system. To do so means that the source data structure must be converted to that of the target system.<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tThis cleanup and transformation was initially carried out by Misumi in a manual process. Due to the increasing amount of data and the addition of new data suppliers, product data onboarding was outsourced to a service provider.<\/span>\r\n\r\nHowever, the cost and time to deliver a complete import of new product data increased in an essentially linear relationship. In addition, <\/span>errors kept appearing in the product data<\/b> due to the manual work. The resulting incomplete product data had a <\/span>negative impact on findability<\/b>, which caused <\/span>dissatisfaction among customers<\/b>.<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

The Avantgarde Labs solution<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tThe goal was to substantially reduce the costs as well as the time required for retailer onboarding<\/b> through partial automation, while ensuring high data quality. The manual transfer of a single data record was to be replaced by the establishment and automated application of rules.\r\n<\/span>\r\n\r\nIn the first step, the BMEcat files of the suppliers were prepared for further processing. The <\/span>Talend<\/b> data integration tool was used for this ETL process. With its standard connectors and no-code approach, this tool enabled efficient standardization of the source data.\r\n\r\nHowever, since the actual catalogue integration could not be carried out on the basis of predefined rules, a user interface was required.<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tFor maximum efficiency, a <\/span>multi-stage mapping process<\/b> between the raw data and Misumi’s target system was designed and implemented in cooperation with the respective departments. The procedure included the step-by-step mapping of categories, brands, series and product properties in self-service.<\/span>\r\n\r\nTo make the application as efficient as possible, the resulting mapping tables were held for the data transformation in a <\/span>Mongo DB<\/b>, which is particularly well suited for hierarchical data structures. Based on this information and the prepared source data, it was possible to create the <\/span>CSV files<\/b> for import into Misumi’s PIM.<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Project results & customer benefits<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tWith the support of Avantgarde Labs, Misumi was able to successfully implement a key component for the trade platform strategy \u2013 a scalable\u00a0 data sourcing and provisioning system.\u00a0<\/span>\r\n\r\nThis meant the partial automation completely replaced the manual ad-hoc process. This greatly <\/span>reduced the time to market for product data onboarding<\/b> and decoupled the costs from the size of the product catalogues to be imported.\u00a0<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tBy automating data conversion, careless mistakes are avoided and data quality problems in supplier data can automatically be detected and corrected with standardized rule sets.<\/span>\r\n\r\nThe optimized product data helps to <\/span>increase confidence in the purchasing process<\/b> among demanding customers and creates a <\/span>differentiator <\/b>from the competition.<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Web app and ETL pipeline for integrating non-company catalogue data<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"template":"","meta":{"_acf_changed":false,"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"branche":[227,226],"solutions":[249,266,272],"cooperations":[245],"services":[247,248],"teams":[258,253],"class_list":["post-8867","case_studies","type-case_studies","status-publish","hentry","branche-mechanical-engineering","branche-trade","solutions-data-integration","solutions-pim-and-dam-systems","solutions-portal-solutions","cooperations-time-materials","services-application-development","services-data-management","teams-project-management","teams-software-developers"],"acf":[],"_links":{"self":[{"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/case_studies\/8867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/case_studies"}],"about":[{"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/types\/case_studies"}],"author":[{"embeddable":true,"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":5,"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/case_studies\/8867\/revisions"}],"predecessor-version":[{"id":8922,"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/case_studies\/8867\/revisions\/8922"}],"wp:attachment":[{"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/media?parent=8867"}],"wp:term":[{"taxonomy":"branche","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/branche?post=8867"},{"taxonomy":"solutions","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/solutions?post=8867"},{"taxonomy":"cooperations","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/cooperations?post=8867"},{"taxonomy":"services","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/services?post=8867"},{"taxonomy":"teams","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/en\/wp-json\/wp\/v2\/teams?post=8867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}