eCommerce | Google Cloud AI Consulting Services
Wayfair leverages Google AI tooling to eliminate decades of code conversion work
Pythian helped the global eCommerce giant migrate their monolithic database to Google Cloud, so Wayfair can now release new features to customers and suppliers in a day—a process that used to take years. The company has saved millions of dollars, increasing developer velocity, and making better use of data to improve the customer experience.
Wayfair partnered with Pythian, as they offered a custom AI solution that can save decades worth of code conversion work—migrating their databases to Google Cloud faster.
Less time spent on major incidents
Wayfair needs to spend far less time on major incidents since the Pythian-led migration and transformation.
Reduction in instances of fraud
Since the re-platforming, Wayfair has seen a significant and measurable reduction in the occurrence of fraud.
Years of effort reduced significantly
Pythian's AI consulting services supported Wayfair in reducing decades of work down to just months.
Hear how Pythian's Google Cloud AI consulting services helped Wayfair achieve its business goals
Customer
Industry
eCommerce
Location
Solution
Platform
Overview
Wayfair Inc. is the destination for all things home. The company, founded in 2002, currently offers 30 million products from more than 20,000 global suppliers through its various sites, including Wayfair, Joss & Main, AllModern, Perigold, Wayfair Professional, and Birch Lane. Headquartered in Boston, the company has a business presence in the U.S., Canada, the U.K., Ireland, and Germany.
Wayfair aimed to enhance its agility and efficiency by migrating its complex, monolithic database to Google Cloud. This move was essential to support the company's rapid growth and to leverage data more effectively for improved customer experiences. To achieve this, Wayfair sought a partner experienced in cloud migrations and data transformations.
The challenge
The hindrance of a monolithic database inhibited Wayfair’s ability to optimize customers’ eCommerce and shopping experience
With 18 warehouses and a catalog of more than 30 million products, Wayfair needed to transform to remain agile. The company had thousands of applications built in a monolithic architecture, which prevented them from being able to rapidly deploy new features to customers and suppliers.
The eCommerce giant wanted to make better use of their data, glean insights that could provide more personalized and dynamic experiences for customers, better understand economic shifts and trends through improved reporting capabilities, and make it easier for developers to select a database that would meet their feature requirements.
To do this, they needed to migrate their Microsoft SQL Server database—and a complex set of interrelated databases with little to no structure that came about from organic growth—to a microservices approach, which would enable rapid feature rollouts to users and reduce the rising cost of its Microsoft SQL Server spend. But they needed to do this quickly, without derailing their engineering teams, customers, or partners.
Monolithic architecture
Wayfair's thousands of applications built on a monolithic architecture hindered rapid feature deployment to customers and suppliers.
Data accessibility
The company aimed to leverage its data more effectively for personalized customer experiences, economic trend analysis, and improved reporting.
Lack of migration expertise
They needed to migrate a complex, unstructured Microsoft SQL Server database to a microservices approach to enable faster feature rollouts and reduce MS SQL costs.
Concerns around downtime
The migration had to be executed quickly without disrupting engineering teams, customers, or partners.
The solution
Pythian helps Wayfair adopt cloud-native microservices and AI tooling to expedite code conversion
Wayfair decided to adopt a microservices approach in a cloud-native environment hosted on Google Cloud. The company turned to Pythian to provide a skilled set of resources that could augment their thinly spread customer engineering team, as well as Pythian’s impressive expertise in AI. Pythian has AI tooling that automates code conversion for cloud migrations. Using this tooling, Wayfair was able to expedite their migration to Google Cloud.
“As Wayfair adopts more public cloud and cloud-native services, there needs to be a focus on the applications that matter to our customers and our suppliers,” said Matthew Ferrari, Head of Platforms, with Wayfair. “So when we looked for a partner, we thought who better than the data experts from Pythian to show our database and data architects how to adopt these cloud-native data tools?”
Pythian helped Wayfair rapidly migrate customer data from a high-value business unit on MS SQL to Cloud SQL for PostgreSQL on Google Cloud. With a solid foundation in place, Pythian assisted Wayfair’s IT team in building an AI toolkit using Vertex AI code generation to remove the manual efforts involved in the transformation process. The toolkit defines code that can be reused (or depreciated), allowing Wayfair to rapidly speed the migration to cloud technologies.
Pythian offers a framework for cost-effective AI use case discovery, designing and testing proof of concepts, and deploying them into production. In concert with their existing data services, Pythian helps businesses maximize the power of their data estate and glean high-speed insights and solutions across the entire enterprise. Wayfair has leaned into Pythian as a partner to maximize their investment in Google Cloud as their cloud provider of choice to build custom AI solutions to enhance customers’ shopping experience.
Going cloud-native
Wayfair adopted a microservices approach in a cloud-native Google Cloud environment.
Enhancing AI expertise
Pythian augmented Wayfair's engineering team and provided AI expertise.
Rapid migration
Pythian rapidly migrated Wayfair's customer data from MS SQL to Cloud SQL for PostgreSQL.
Leveraging an AI toolkit
Pythian assisted Wayfair in building an AI toolkit using Vertex AI code generation to automate transformation processes.
Technologies used
- Gemini API in Vertex AI
- Gemini for Google Cloud
- AlloyDB for PostgreSQL
- BigQuery
- Bigtable
- Cloud Functions
- Cloud Run
- Cloud SQL for PostgreSQL
- HashiCorp Terraform
- Google Kubernetes Engine (GKE)
Key outcomes
Wayfair saves millions, reduces feature deployment and time to market growing their eCommerce success
With the migration to Google Cloud, Wayfair is saving millions of dollars over a multi-year spend. New features can now be released in one day, versus what could often take years.
Pythian’s AI toolkit has lowered the time to value, turning what would have been 46 years of effort down to just months—with a reusable toolkit for future migrations. The toolkit defines code that may be reused or depreciated, allowing Wayfair to rapidly speed up their migration to cloud.
Through a database-as-a-service (DBaaS) platform, developers now have a much faster method of enabling the provisioning of a Spanner instance through a self-service flow. That means they can spend more time working with users and less time on infrastructure management.
To date, more than 16% of customer traffic is now on a replatformed experience, and average speed is 23% faster. The company is also spending 82% less time on major incidents and reduced fraud by 30%. Its net promoter score (NPS) for support increased 28.5% while its tooling NPS increased 41.22% with the use of Google Cloud Databases. In addition, there’s better alignment of systems and data architecture with business reporting goals and governance structures.
Overall, working with Google Cloud and Pythian has helped Wayfair reduce time to market for new use cases, reduce operational overhead, and increase developer velocity—enabling them to scale at the speed of business.
Significant cost savings and faster feature releases
Wayfair is saving millions of dollars and can now release new features in a single day, a process that previously took years.
Accelerated migration with AI
Pythian's AI toolkit reduced a 46-year migration effort to mere months, providing a reusable solution for future migrations.
Improved performance and reduced incidents
Customer experience is 23% faster, major incident time is down by 82%, and fraud has been reduced by 30%.
Increased developer efficiency
Developers can provision database instances faster, leading to more time spent with users and less on infrastructure, and tooling NPS increased by over 41%.