Orca Coolers

Customer

Orca was created by outdoor enthusiasts for outdoor enthusiasts with the objective of making American-made, roto-molded coolers that can be used in any outdoor environment.

Orca manufactures and sells highly imaginative outdoor products ranging from coolers, apparel, drinkware, and accessories with a particular focus on utilizing American labor and American-made components.

Summary

Founded in 2012, ORCA Coolers manufactures and sells American made, roto-molded, rugged coolers, outdoor apparel, drinkware, and accessories. Orca Coolers completely automated and integrated their NetSuite ERP with two of their Shopify web stores (B2B and B2C) with Folio3’s NetSuite Shopify Integration connector.

The Challenge

Orca had been relying on manual data entry for both of their Shopify stores which resulted in a very series of complex processes that ended up using up a lot of time and effort just to keep the disparate systems synchronized. These extra efforts added to the operating costs and hampered productivity.

Solution

Folio3’s proprietary Shopify Integration connector is an Integration-as-as-Service product that fully integrates your Shopify web store and NetSuite back-office system from end-to-end. The integration seamlessly automates complete processes, enabling you to avoid wasting time and extra efforts on manually maintaining the synchronization between the two systems.

With the integration, Orca was able to create a perfect end-to-end integration between their front end and back-office ERP systems allowing them to concentrate efforts on other vital areas of business. The features of the connector are:

  • Import Customers from Shopify to NetSuite.
  • Import Sales Orders from Shopify to NetSuite.
  • Export Item data from NetSuite to Shopify.
  • Cash Sale sync from NetSuite to Shopify.
  • Export Sales Price from NetSuite to Shopify.
  • Export Order Status and Shipping Info from NetSuite to Shopify.
  • Export Refunds from NetSuite to Shopify.
  • Import an individual Shopify order from the Connector Dashboard.
  • Search for Imported Shopify Sales Orders in NetSuite.
  • Search for Imported Shopify Customer records in NetSuite.
  • Sync Sales Orders On Demand from Shopify to NetSuite, from the Connector Dashboard.
  • Sync Items On-Demand from NetSuite to Shopify, from the Connector Dashboard.
  • Sync Refunds On-Demand NetSuite to Shopify, from the Connector Dashboard.

In addition to the standard vanilla features, the following customizations were also implemented for Orca Coolers:

  • Support for synchronization of NetSuite kit/package and lot numbered items from NetSuite to Shopify, as simple inventory items.
  • Synchronize Shopify customers from the B2B (dealers) Shopify site, as Company type Customers with associated Contacts in NetSuite. The B2C (retail) site’s customers will come into NetSuite as regular customers.
  • Synchronization of guest checkout orders (i.e. orders placed on the Shopify store without creating a customer account on Shopify) from the Shopify B2C (retail) store to NetSuite.
  • Synchronize item inventory quantity from NetSuite to Shopify, from a specific custom field in the NetSuite item record (in which the available inventory quantity value is calculated based on a formula that Orca Coolers uses), instead of the standard ‘Available Inventory’ field in NetSuite.

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

Result

Orca Coolers were able to completely streamline and automate the flow of data between its Shopify web-stores and NetSuite ERP system. With the complete integration of the two systems, Orca was able to create a single holistic e-infrastructure for the entire organization to manage and monitor processes completely from end-to-end.

Avoid the extra efforts and time spent on manual data entry, Orca can now easily focus on fortifying competencies in other key business areas such as sales, customer experience, and after-sales services.

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

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