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.

Wayfair migrated its monolithic database to Google Cloud to enhance agility and efficiency, leveraging AI tools to decrease code conversion work.
82%

Less time spent on major incidents

Wayfair needs to spend far less time on major incidents since the Pythian-led migration and transformation.

30%

Reduction in instances of fraud

Since the re-platforming, Wayfair has seen a significant and measurable reduction in the occurrence of fraud.

46

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

Massachusetts, United States

Solution

Google Cloud AI consulting services

Platform

Google Cloud
  

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)
"Wayfair has thousands of SQL applications and petabytes of data across our architecture. As we thought about modernization and leveraging Google Cloud, we relied on Pythian to be the experts on how to do it from an architectural perspective and then execute with our data team in actually getting it done.”
Matthew Ferrari
Head of Platforms, Wayfair
  

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%.

Want to see similar results for your company?

Get in touch with a Pythian AI expert to see how our team can help.