Businesses holding stock across multiple locations that want to sell and fulfil from all of them
Click-and-Collect with Store-Level Stock Visibility
Store-level stock driving collection orders
The Challenge
Every online order ships from a central distribution centre regardless of where the customer is, so customers in the states furthest from the DC wait the longest. Stores hold stock that online customers cannot see or buy. The webstore shows 'In Stock' or 'Out of Stock' at an aggregate level and nothing more.
Click-and-collect usually sits on the roadmap for a year or more before it ships, and the blocker is rarely the storefront. It is the data underneath: independent stock at every location, variable pickup capacity per store, transfer order logic for when the nearest store comes up short, and store notifications that run on email and are routinely missed.
Our Approach
Four components, layered onto an existing NetSuite and Celigo integration.
Store stock feed. The availability sync exposes per-location inventory to the storefront. Each store is a supply channel with its own inventory entry. The frontend shows availability by store name, with real-time counts behind a postcode store finder.
Fulfilment routing. A collection order triggers a Celigo flow that checks stock at the selected store. If it is there, the flow creates a NetSuite sales order against that location. If it is short, the flow checks nearby stores and raises a transfer order. If nothing nearby can cover it, the order falls back to DC fulfilment.
Store notifications. Replace email with a structured webhook. The POS receives the pickup notification with order detail and customer name. Staff confirm readiness from a mobile page, which triggers the customer SMS.
Capacity management. A configurable daily pickup cap per store, held in a NetSuite custom record. The storefront checks capacity before offering collection at all, which stops a single busy store absorbing more orders than its counter can handle.
Key Metrics
Stock visible online
Before
Aggregate only
After
Per-location, real-time
Pickup readiness
Before
Days, manual check
After
Hours, systematic
Short-stock handling
Before
Order cancelled
After
Transfer or DC fallback
Store notification
Before
Email, unreliable
After
Webhook to POS, plus SMS
The Outcome
Customers see real stock at the locations nearest them, and pickup readiness typically moves from days to a few hours. Collection revenue rises once customers can trust what the site tells them, and customers who collect in store frequently buy something else while they are there.
Two things are worth planning for. Store staff need the notification to arrive somewhere they already look, which is why the POS handoff matters more than it sounds. And per-location visibility usually exposes overstock sitting in particular stores, which is both a clearance opportunity and working capital that has been quietly tied up.