Door County Coffee Case Study - Walmart Connector

Customer Success Story

With our Walmart and NetSuite integration, DCC got an automated system to sync orders, inventory updates, and track fulfillment to improve its online store management.

Company

Door County Coffee

Company Size

51-200

Industry

Restaurant

Region

NetSuite Services

Walmart Connector

All NetSuite Solutions and Modules

Application replaced

About Door County Coffee

Door County Coffee is a family-owned coffee company located in Sturgeon Bay, Wisconsin.
Founded in 1993, it specializes in high-quality, sustainably sourced coffee roasted on-site.
The company operates a café that serves freshly brewed coffee and lunch, providing customers with a unique experience in a welcoming environment.

Door County Coffee & NetSuite

Before the integration, Door County Coffee relied on manual processes to manage Walmart orders, inventory, and fulfillment updates, which led to delays and data inconsistencies.
Folio3’s Walmart Connector automated these workflows with its Walmart connector.
The solution also included tailored features for Fulfilled By Walmart (FBW) orders, assembly items, and lot-numbered items.

Summary

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

Walmart Connector and delivered a fully automated solution to reduce manual tasks. This integration enabled automated sync of sales orders, order cancellations, inventory, and shipping details between Walmart and NetSuite. Additionally, it supported invoice creation for Walmart orders. Customizations were also implemented to accommodate Walmart Fulfilled orders (WFS) orders, assembly items, and lot-numbered items.

The Challenges

Door County Coffee encountered several operational challenges that necessitated a more efficient solution.

Manual entry of sales orders, customer data, and inventory was time-consuming and error-prone, causing inefficiencies in order and inventory management.
Managing Walmart sales orders manually was challenging and led to delays.
The lack of automated inventory synchronization made it difficult to maintain accurate, up-to-date product listings across platforms.
Tracking shipping information and fulfillment statuses manually adds to operational inefficiencies.
Door County Coffee required customized features to support:
- Syncing of Walmart fulfilled orders (WFS)
- Assembly items
- Lot-numbered items
Folio3’s NetSuite Walmart Connector provided a tailored integration that automated these workflows, ensuring seamless data synchronization and improving overall operational efficiency.

Solution

The NetSuite Walmart Connector was the ideal solution for Door County Coffee and helped address the challenges with:

Automated import of Walmart sales orders into NetSuite
Creation of invoices in NetSuite for Walmart orders
Syncing of inventory quantity from NetSuite to Walmart
Syncing of order status and shipping information from NetSuite to Walmart
Making an item out of stock in Walmart by updating inventory to zero in NetSuite

Customizations Implemented

In addition to the above-mentioned standard functionality, Door County Coffee wanted the following features supported in the integration, which required customization.

Import orders into NetSuite as open invoices.
Support for assembly type NetSuite items in connector’s data flows.
Sync assembly items to Walmart as simple products.
Available inventory for assembly items for Merchant Fulfilled listings based on finished goods stock in NetSuite.
Support for lot numbered items in connector’s data flows.
For orders, set inventory details upon invoice creation.

Results

The integration of Door County Coffee’s Walmart account with NetSuite via Folio3’s Walmart Connector delivered several benefits for the client.

Automated key processes between Walmart and NetSuite, including:
- Import of sales orders, customer data, and order cancellations into NetSuite.
- Export of inventory levels, order statuses, and shipping details from NetSuite to Walmart.
Eliminated manual data entry, reducing errors and saving significant time.
Enabled automatic invoice generation for Walmart sales orders and real-time fulfillment status updates, streamlining order and inventory management.
Improved data accuracy and made communication between Walmart and NetSuite systems uninterrupted.