John Paul Mitchell Systems
Health & Beauty
HikeOn developers were tasked to identify product information spread across multiple tables in the Umbraco CMS database, collaborate with sales head of various business units within the organisation, combine the catalog, reorganise and transfer over to BigCommerce.
What We Did
With no pre-built cart to cart solution available to move products from Umbraco to Bigcommerce, HikeOn created a custom migration plan and executed it on time and with greater data quality.
Identify data sources
Product information was scattered across Umbraco database, spreadsheets and cloud storage. With the help of excited sales team of the client, we identified all the sources and extracted them using multiple connectors.
We performed multiple rounds of data cleansing and transformed the catalog into a unified data model by applying custom validation rules and transformations.
We migrated the cleaned up data to a development store on time for the client’s theme development team to use. Collaborated with the theme development agency and various marketing heads during the GO LIVE.
Blogs and 301 redirects
Identified the data source for their blogs in the Umbraco database, created custom connector to fetch blogs, contents, media files and migrate them to BigCommerce. Preserved existing SEO efforts during the entire migration.