The migration process would involve transferring 12 years of data from OrderMotion to BigCommerce using MSSQL database dump and three years of data from Yahoo Commerce using Yahoo APIs and CSV exports.

However, it did not come without its challenges. Apart from the database size, what added to the complexity was consolidating similar products and variants while preserving customer purchasing history and incorporating staff notes from previous communication channels. Additionally, handling international addresses and working within the limitations of BigCommerce APIs posed further challenges.

After engaging in multiple rounds of discussion, we defined an optimal workflow for replatforming. A middleware application was set up on an AWS server to establish a central database. Then we integrated BigCommerce APIs to import data from the centralized database to BigCommerce, covering customer, product, and order data. Custom scripts were developed to clean and structure the data, ensuring accuracy. Some Collections/Categories were merged to create consolidated products. External IDs were maintained for migrated records to ensure data integrity.

A BigCommerce sandbox account was utilized for testing and verifying data imports, with iterations performed until we perfected the migration. Once all the data had been inserted correctly, the final migration was executed on the live BigCommerce store for the entire data.

By minimizing the need for customization after replatforming and data migration, we achieved development cost savings of over 60% and reduced implementation time by more than 50%. The data cleansing and purification process improved the quality and accuracy of the data which made migration faster and more efficient. Ziamond was impressed by our ability to deliver a functional solution within a limited budget, surpassing other unsuccessful attempts by different companies.

As a result, Ziamond entrusted us with more system enhancement projects for their business growth.