Platform: Enolytics DTC

Summary:

What it is: Club Shipment Days Awaiting Pickup shows the number of days a club shipment has been sitting ready for pickup at your tasting room but hasn't been collected yet. You'll see positive integers representing days elapsed since the shipment was processed, with NULL values for non-pickup orders or shipments already fulfilled.

How to use it:
• Identify which club members have forgotten about their pickups so you can send friendly reminders before wine sits too long
• Spot patterns in pickup timing to optimize your processing schedule and storage space management

Tip: Filter out NULL values to focus only on pending pickups, then sort by highest days to prioritize your outreach efforts.

Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.

Quick Stats:

Number of days since a shipment was ready for pickup but has NOT been picked up yet. Positive integer calculated as the difference between today and the shipment's process date. NULL for non-pickup orders, already fulfilled pickups, or shipments not yet processed.

Type: int

Format: #,##0