CP Lighting Case Study - BigCommerce Connector

Customer Success Story

CP Lighting partnered with Folio3 to overcome operational inefficiencies caused by manual order entry and disconnected systems. The goal was to create a unified solution that automated data flow between BigCommerce and NetSuite for accurate inventory tracking, faster order processing, and better customer management.

Company

CP Lighting

Company Size

11-50

Industry

Electronics

Region

NetSuite Services

BigCommerce Connector

All NetSuite Solutions and Modules

Application replaced

About CP Lighting

CP Lighting is a global e-commerce store based in the UK.
It offers a wide range of LED lighting products, including lamps, bulbs, tubes, and lighting components.
It focuses on energy-efficient and eco-friendly solutions for both homes and businesses.

CP Lighting & NetSuite

Before integrating BigCommerce with NetSuite, CP Lighting faced challenges with order delays, inaccurate stock levels, and scattered customer data.
Folio3’s NetSuite BigCommerce Connector automated these processes to synchronize orders, inventory, and pricing in real time.
The integration also included custom features for group-specific pricing, backorder handling, and automated payment processing.

Summary

Folio3 integrated Door County Coffee's Walmart account with NetSuite using the Folio3

CP Lighting wanted to integrate their BigCommerce eCommerce platform with their NetSuite ERP using Folio3’s NetSuite BigCommerce Connector. This integration was done to automate the synchronization of sales orders, inventory, customer data, and shipping information between BigCommerce and NetSuite. In addition to the standard integration, the project included several customizations including sync of customer group-specific pricing and managing backorders, so the company could better handle unique sales processes.

The Challenges

Order management was slow and error-prone, leading to delays in order fulfillment and reduced customer satisfaction.
Maintaining accurate inventory levels across multiple platforms was challenging, causing overselling and stockouts.
Customer data was scattered, making it difficult to deliver personalized service or run targeted marketing campaigns.
Managing group-specific pricing was inefficient due to the lack of a centralized system.
Manual payment processing increased the chances of errors and delayed financial reporting.
Limited reporting capabilities restricted visibility into sales performance and inventory status.

Solution

Our integration helped CP Lighting to overcome these challenges so they could:

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.
Refund sync from NetSuite to BigCommerce.
Import Individual 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 from NetSuite to BigCommerce, from the Connector Dashboard.
Filter Synced Data and Data Sync Log based on Certain Parameters, from the Connector Dashboard.

Customizations Implemented

To meet CP Lighting’s additional requirements, Folio3 implemented the following customizations:

Import BigCommerce customers as individual customers in NetSuite without sales orders.
Export multiple item price levels from NetSuite to BigCommerce as Customer Groups.
Export customer group-specific pricing from NetSuite to BigCommerce.
Export item categories from NetSuite to BigCommerce, including Category Name, Description, and single image.
Trigger payment capture in BigCommerce from NetSuite via syncing cash sale records.
Trigger complete and partial refunds on BigCommerce from NetSuite via syncing cash refund records.
Support for out-of-stock (backordered) items in the sales order import flow.
Sync order updates for ‘pending fulfillment’ orders from BigCommerce into NetSuite.
Sync kit/package type items from NetSuite to BigCommerce as simple products.
Use NetSuite Internal ID as the primary identifier for item data syncing.
Implement a Suitelet to provide available quantity/stock level to BigCommerce via API.
Multi-currency support for importing BigCommerce orders into NetSuite.
Support for custom records and text custom fields in item data export.
Export a ‘Customer Has Credit Terms’ flag from NetSuite to BigCommerce.
Sync/export up to four PDF attachments associated with the NetSuite item record to BigCommerce.
Create and export brands from NetSuite to BigCommerce and associate brand_id with items.

Results

The NetSuite BigCommerce integration automated CP Lighting’s business operations.

Fully automated synchronization of customer data, sales orders, inventory, and refunds between BigCommerce and NetSuite.
Custom features implemented for group-specific pricing, backorder management, and payment capture/refunds.
Eliminated manual data entry, reducing errors and saving significant administrative time.
Improved accuracy in order processing and real-time inventory visibility.
Enhanced operational efficiency and overall business performance through streamlined workflows.