Sitecore Commerce to Order Cloud Data migration – Article 1

This short and introductory article is all about focusing on the research and development efforts behind a significant data migration project. The core objective was to transition a monolith Sitecore Commerce web application into a composable architecture, involving the seamless migration and integration of components like XM Cloud, Order Cloud, and Sitecore Discover.

In my role, I led the setup, management, and maintenance of the XM Cloud project architecture. Additionally, I actively supported team members in troubleshooting and contributed to the development of intricate functionalities. A key challenge was devising an efficient method to export Sitecore Commerce data for migration to OrderCloud, requiring a deep dive into the platform’s architecture and coding prerequisites.

My journey commenced with a comprehensive exploration of Sitecore Commerce basics and progressed to understanding its architecture and internal processes. Subsequently, I delved into utilizing Sitecore Commerce APIs and exploring alternative data extraction methods due to API performance challenges.

After careful consideration and discussions with stakeholders, including team managers and clients, we opted to leverage direct database queries for data extraction. This approach was chosen to enhance efficiency and minimize disruption to the live application environment.

As the part of our migration work, we had to export the following data from the Sitecore Commerce and import into Order Cloud

  1. Users / Customers – The users/customers are the key entities which we need to move from existing web sites to the new application. Along with this we also have to consider the wish list items as well while moving the customer data to make sure they find the necessary information which they had on the old website.
  2. Orders – The orders placed by the customers must be migrated as the history of the users interaction and transactions done on the old website
  3. Subscription – The client application had subscription functionality for their customers to setup the auto ship orders for the items they need at regular intervals. This must be moved to the Order Cloud for continuation of service to the customers.

I am now excited to delve into writing code and queries, eager to see the outcomes of this strategic decision.

Stay tuned for the upcoming article detailing the journey of extracting data from Sitecore Commerce using database queries.