Platform: Enolytics DTC
Summary:
What it shows: A comprehensive breakdown of your product performance by SKU, showing exactly what's selling, how much revenue each item generates, and what customers are paying. This ready-made report pulls together product details (vintage, varietal, department) with sales metrics across all your channels — no setup required.
Who should use it:
• Operations managers tracking inventory performance and pricing strategies
• Winemakers and production teams analyzing which wines resonate with customers
• Accounting teams reconciling product-level revenue and average pricing
When to use it:
• Planning your next vintage or deciding which wines to feature in promotions
• Analyzing price points across your portfolio to optimize profitability
• Preparing financial reports that break down sales by individual products
• Reviewing seasonal performance trends by varietal or vintage
Questions this report answers:
• "How can I see sales performance for each of my wines broken down by SKU?"
• "Where do I find average selling prices for my products across different channels?"
• "Can I get a report showing which varietals are my top sellers by revenue?"
• "How do I pull data on item-level sales that includes both quantity sold and dollar amounts?"
• "Where can I see how my wines perform across club, website, and tasting room sales?"
Tip: Use the Channel column to spot pricing variations — you might discover your tasting room commands higher prices than online sales for the same SKU, revealing opportunities to adjust your digital pricing strategy.
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.
📂 How to Access This Report
This is a public bookmark — a pre-built report ready for you to use. You don't need to create it from scratch.
To open it:
Click the Bookmarks icon in the left sidebar
Look under Public Bookmarks
Open the folder: Accounting Reports
Click Sales and Avg Price by SKU
Quick Stats:
0 filter(s) applied
8 dimension(s) displayed
3 measure(s) displayed
Report Page: Build Beyond Limits | Advanced Reporting
⚠️ Date Picker Required: This report uses time-sensitive measures that respond to the date picker. The bookmark does not save date picker settings. Please adjust the date picker to ensure the report shows the data for your desired time period.
Filter Behavior: When you select this bookmark, your existing filters will be replaced with the bookmark's saved filters.
📝 Original Description
Product performance breakdown showing sales revenue, average price, vintage and varietal details for each SKU across all channels.
Filters Applied
✅ No filters applied - this bookmark shows all available data.
📋 Columns Displayed
Dimensions:
Item SKU — The unique product sku (stock keeping unit) as defined in the CRM
Vintage — This is the vintage of the product.
Varietal — This is the varietal of the wine. Examples are: Cabernet Sauvignon, Pinot Noir, Chardonnay, etc. Commerce7 has these values as Enums, while Classic WineDirect has it set as a free text field. We pass it on for reporting but due to the free text nature, we will not do much else with it.
Order Type — The order_type is the channel or order type the transaction happened in. Order Type is the lowest level of the transaction channel. Commerce7 has limited channels (POS, Club, Web, Inbound), while WD allows for free text creation of order types. The channel in Commerce7 is equivalent to the order type in WD. VST doesn't have a field for channel but has a set of booleans (isClub, IsWeb, etc.) that allow us to create an order type.
Channel — This is a mapped field, where we map the order type to an aggregated channel (eg. iPad and Mobile both can map to channel POS.)
Sales Attribute — This is a WineDirect specific field. Sales attribute are discreet dropdown values helping to categorize the order. It is not often used.
Department — Departments serve as broad categories to help organize Products internally, mainly for accounting purposes and to be displayed in Reports. We use departments extensively to identify tasters, display data in the Tasting Room Module for Tasting Details and Glass Pours.
Item Name — The name of the product as defined in the CRM
Measures:
ℹ️ Additional Details
Bookmark ID:
40baed0d-9fd8-49b7-8559-a0f97715373d