Snapshot

Sylva is an online platform that acquires and nourishes web-based communities to help them grow their revenue and build relationships.

  • Company: Sylva
  • Industry: Ecommerce and Acquisitions
  • Integrated Systems: Snowflake, Netsuite

The Problem

  • Managing multiple Stripe accounts across numerous entities proved cumbersome.
  • Numerous integration costs and management are unscalable for growth in acquisitions.

The company utilizes Stripe for credit card payment processing and needed a way to sync these transaction details to NetSuite, their ERP. Sounds simple enough. However, Sylva oversees operations for more than 15 separate entities (both domestic and international), meaning this would require multiple connections, ergo a big undertaking management-wise and cost-wise – not least because each entity has its own defined payment terms, differing currencies, and divergent product catalogs.

As NetSuite was not connected to the multitude of Stripe accounts, this required the company to find manual workarounds in order to sync item records, customers, invoices; and what’s more the ability to reconcile all of these data points between the two systems. A convoluted process that would prove unscalable as the company’s acquisitions grow. Integrating a single Stripe account to an ERP can cost upwards of around $6,000 each. The need was to find a way to streamline the connection between an abundance of Stripe accounts that would reduce human intervention by automating the transfer of data, and ultimately reduce the high cost of building and maintaining a myriad of integrations.

The solution

  • Snowflake, a cloud-based data warehouse integrated with NetSuite, built by Nova Module on Celigo’s proprietary iPaaS platform – integrator.io.

As a means to consolidate the many Stripe accounts, Sylva opted to use a cloud-based data warehouse – Snowflake. Having a centralized platform to consolidate data imported from several different entities not only allowed for cleaner data monetization, operational reporting, and real-time analytics; but also affix additional information needed to synchronize data to tie everything to a single umbrella company. This would enable the company to manage each Stripe accounts’ separate product catalogs, customer payment terms and more from a single space. Sylva took on the connection between their Stripe accounts and Snowflake – optimizing the solution to fit their needs per entity. The gap was then the ability to link Snowflake to NetSuite and this is where the customer relied on the integration expertise of Nova Module. Leveraging the iPaas platform integrator.io built by Celigo, Nova Module developed a custom solution that enabled an automatic sync of items, customers, invoices, payments and refunds to NetSuite as well as perform a reconciliation of this data. With this custom solution, Nova Module was able to combine what would typically be 2 separate integrations (Stripe and Stripe Payout Reconciliation for NetSuite) into a single solution.

The results

  • 85% savings on integration cost
  • Centralized payment processing management for multiple entities

The integration between Snowflake and NetSuite not only automated payment processing for 15 different Stripe accounts but stabilized the foundation for error management and data accuracy. Sylva was able to cut the cost of integration by 85% without having to sacrifice quality in the process.

This integration is extremely scalable. It takes very little effort to add additional Stripe accounts. As many as needed.

With this automation in place, the company is able to shift focus back to greater development with time and resources free of manual tasks and centralized payment processing management.

In short, Nova Module integration engineers took on the challenge, worked with the Sylva team very closely, and built an extremely scalable solution. It was very obvious that other companies may be experiencing the same challenges. In addition to many pre-built and custom integrations, Nova Module now offers a quick-start Snowflake-and-NetSuite integration template to help other companies consolidate their payment processing data and operate at ease. The same concept can be applied to any type of data that needs to be synced between Snowflake and NetSuite or between various systems for that matter.

References

Quick-Start Template: NetSuite-Snowflake ETL (Extract, Transform, Load)

This integration offers a convenient starting point for companies utilizing Snowflake as a Data Warehouse and NetSuite as an ERP. It facilitates the seamless transfer of NetSuite customers.