Challenge: Migrate volumes of custom data from Magento to BigCommerce
Solution: Wrote code to translate data between platforms without losing anything
The Pleasure Chest’s products are as unique as people’s individual sexual preferences. As a result, a lot of products needed to be defined beyond standard product labels, and they use a lot of custom fields. For instance, under a product’s features and notes, people can review specifications such as length, diameter, charging type, intensity, noise level, and more. The criteria is specific to each product, and it varies within the different product categories.
As Command C migrated The Pleasure Chest from Magento 1 to BigCommerce, it was critical to migrate all of the data, especially the custom fields that define product specification. In Magento, these are called product attributes, and they are created and defined by administrators. There is no one-size-fits-all mapping that can be applied when migrating this kind of data.
To solve for this, we wrote a program that took all of that data out of the Magento database directly, accounting for the stability of the (at the time) live Magento build, and the unique data structures used to house product data in Magento. (Simply put, it was not straight-forward.) Then we translated each piece of product information into the product data fields required by BigCommerce. We did this for thousands of products with buried product data, and we were able to accurately represent the entire product catalog within BigCommerce.
Plus, all of the product data integrates with their ERP, Epicor/Eagle, through their ecommerce connector, built and managed by Modern Retail. Throughout the process, we worked with these vendors to frequently test that the product inventory communicated back and forth to the ERP. We ensured that orders made their way back to the ERP as well. We did all of this behind the scenes, so The Pleasure Chest never felt stress regarding the data migration.
We also took exports of gift certificate values and worked with Modern Retail to set up a new custom gift certificate tool that integrates with their ERP. This ensured that gift certificates from the old site got recreated in BigCommerce, and people could still use them. Previously, customers could only redeem gift certificates at physical stores, but now they work both in-person and online.