Club Pilates – NetSuite BigCommerce Integration Connector Case Study

Summary

Club Pilates is a California-based Pilates studio chain that provides high-quality training at 428 studio locations across the United States. Folio3 fully integrated 7 of their BigCommerce web stores with their NetSuite ERP creating a single seamless system to manage all processes and operations.

Customer

Club Pilates offers reformer-based pilates classes, utilizing a modern approach to classical methods. With their high quality and life-changing training, thousands of people are transforming their bodies through energizing and fun low-impact pilates across 428 studios in the US.

Challenge

Club Pilates was operating 7 BigCommerce web stores to manage front end operations for their fitness studios, which in turn created a really big problem of keeping the information, in between these systems and their NetSuite ERP, accurately synchronized. With the size of the overall business, the processes required a lot of time taking manual effort to keep the information flowing in the system up-to-date.

Solution

Folio3’s proprietary BigCommerce connector for NetSuite is an Integration-as-a-Service offering that provides completely automated end-to-end integration between NetSuite and BigCommerce web stores. With the integration, Club Pilates as able to take advantage of seamless integration between their web stores on BigCommerce and their NetSuite ERP and fully automate the process of synchronizing data between disparate systems.

With Folio3’s NetSuite BigCommerce Integration connector, Club Pilates was able to map each web store to a separate subsidiary within NetSuite thereby unifying all data onto a single seamless infrastructure. Club Pilates can now shift focus on to important business functions, rather than getting caught up in operations issues and worrying about scaling. The feature set of the connector included:

  • Import Customers from BigCommerce to NetSuite.
  • Import Sales Orders from BigCommerce to NetSuite.
  • Export Item data from NetSuite to BigCommerce.
  • Export Order Status and Shipping Info from NetSuite to BigCommerce.
  • Cash Sale sync from NetSuite to BigCommerce.
  • Export Inventory Quantity from NetSuite to BigCommerce.
  • Export Sales Price from NetSuite to BigCommerce.
  • Export Refund Data from NetSuite to BigCommerce.
  • Import Selected Sales Orders from the Connector Dashboard.
  • Search for Imported BigCommerce Sales Orders in NetSuite.
  • Search for Imported BigCommerce Customer records in NetSuite.
  • Sync Sales Orders On Demand from BigCommerce to NetSuite, from the Connector Dashboard.
  • Sync Items On Demand from NetSuite to BigCommerce, from the Connector Dashboard.
  • Sync Refunds On Demand NetSuite to BigCommerce, from the Connector Dashboard.
  • Filter Synced Data and Data Sync Log based on Certain Parameters, from the Connector Dashboard.

In addition to the standard vanilla features, Club Pilates also needed some customizations to fulfill specific business requirements:

  • Two-way synchronization of item data between NetSuite and BigCommerce.
  • Synchronize customers from BigCommerce to NetSuite, as Company type Customers (Studios) with associated Contacts.
  • Synchronize order fulfillment from BigCommerce to NetSuite.
  • Synchronize refunds from BigCommerce to NetSuite.
  • Synchronize orders with invoices, from BigCommerce to NetSuite.
  • A one-time synchronization of a total of 1500 item SKUs from BigCommerce to NetSuite.
  • Synchronize refunds against invoices, from NetSuite to BigCommerce.
  • Synchronize a total of 3000 transactions i.e. sales orders and their related transactions (customers, invoices, cash sales, refunds and credit memos) from NetSuite to BigCommerce (one-time synchronization)

Folio3’s NetSuite BigCommerce Integration connector is Built for NetSuite, therefore it is completely secure and complies with all the standards and practices set by NetSuite as well.

Result

The Folio3 NetSuite BigCommerce Integration connector seamlessly integrated their NetSuite ERP with their BigCommerce web stores, allowing them to manage all data within a single NetSuite system. By removing the hassles and constraints of keeping information in these systems synced manually, Club Pilates can focus more on the customer and value delivery thereby creating lasting customer experiences.

Got a NetSuite BigCommerce Integration in mind, talk to us today!

To know more about our NetSuite integration solutions, please look at our NetSuite Integration Services.