AWS just announced their Registry of Open Data passed 1,122 free datasets. Petabytes of genomics, satellite imagery, and climate data — available to anyone with an AWS account. That is genuinely impressive for researchers and ML engineers. But here is the irony that hit us when we read it: the average D2C founder has more trouble accessing their own business data than a researcher has accessing NASA satellite imagery.
We tested this. We asked 11 D2C founders ($2M-$9M revenue) five basic questions about their own operations. Questions any founder should be able to answer in under 60 seconds if their data systems work. Average score: 1.3 out of 5. If you cannot answer at least 4 of these right now without opening a spreadsheet, book 30 minutes with Dev. We will map where your data is stuck.
The 5 Questions D2C Founders Cannot Answer
We asked these exact questions to 11 founders. No advance warning. Just "Can you answer this right now, from whatever tools you have open?"
| Question | Founders Who Answered | Why They Could Not |
|---|---|---|
| What is your return rate by discount tier? | 1 / 11 | Discount data in Shopify, return data in 3PL or separate sheet |
| What is your true COGS per SKU after shipping + returns? | 0 / 11 | COGS in QuickBooks, shipping in 3PL, returns in Shopify/Loop |
| Which marketing channel drives the highest 90-day LTV? | 2 / 11 | Attribution in Google Analytics, LTV requires Shopify + subscription merge |
| What is your dead stock value right now? | 1 / 11 | Inventory in Shopify/3PL, but no "last sold" date cross-referenced |
| What was your actual profit margin per order last month? | 0 / 11 | Revenue in Shopify, COGS in QuickBooks, shipping in 3PL, fees scattered |
Zero out of eleven could tell us their actual per-order profit margin. Every single one said some version of "we know roughly, but the exact number requires pulling from 3-4 systems." Roughly is not a number. Roughly is how you lose $14,200/month without noticing.
Why Shopify Analytics Is Not Enough (And Never Will Be)
Shopify shows you revenue, orders, sessions, and conversion rate. That is useful for marketing. It is useless for operations. Here is what Shopify analytics cannot tell you:
What Shopify Does Not Report
True COGS per order: Shopify knows your product cost (if you entered it). It does not know your pick-pack-ship cost ($2.40-$4.70/order), your 3PL storage fees, your packaging costs, or your payment processing fee at the order level.
Return-adjusted revenue: Shopify shows gross revenue. But 18-34% of your BFCM revenue comes back as returns. Until those returns are processed, your "revenue" number is fiction. Shopify does not subtract pending returns from your revenue dashboard.
SKU-level profitability: You might have 200 SKUs. 30 of them are probably unprofitable after shipping and returns. Shopify cannot tell you which 30 because it does not connect COGS, shipping cost, and return rate at the SKU level.
Customer acquisition cost by channel with LTV: Google Analytics knows the channel. Shopify knows the order value. Neither knows the 90-day LTV of customers acquired from each channel. You need to merge both datasets to answer this — and nobody does.
This is not a Shopify problem. Shopify is an ecommerce platform, not a business intelligence tool. The problem is that D2C founders treat it like one because they have nothing else. *(Your accountant is nodding right now.)*
The $14,200/Month You Are Losing to Data Blindness
We calculated the cost of not having unified operational data across 11 brands. The average: $14,200/month in preventable losses.
Monthly Cost of Data Blindness (11-Brand Average)
$5,340
Overspending on ads for channels that drive low-LTV customers because channel-LTV data is not connected
$4,670
Continuing to stock and promote unprofitable SKUs because SKU-level margin is unknown
$4,190
Discounting high-return SKUs without knowing the discount-return correlation
That apparel founder running 30-40% discounts on 23 SKUs with a 41% return rate? She was spending $3,200/month on Meta ads driving traffic to products that came back 4 out of 10 times. The return processing cost ($7.40/return avg) plus the ad spend to acquire the customer who returned ($22/CPA) meant she was losing $11.80 on every returned discounted order. 370 returned discounted orders/month × $11.80 = $4,366/month in pure loss. On SKUs she thought were her best sellers.
What Operational Data Access Actually Looks Like
Here is what we build for D2C brands that want to stop guessing.
The Single-Query Operations Dashboard
Architecture: Odoo ERP as the central data warehouse. Shopify orders, 3PL shipping costs, QuickBooks COGS, and returns data all flow into Odoo automatically. Every report pulls from one source.
What you can answer in 30 seconds: True profit margin per order. SKU-level profitability after shipping and returns. Return rate by discount tier. Channel-level 90-day LTV. Dead stock value with last-sold date. Customer acquisition cost vs. actual lifetime value.
Implementation: $16,400-$28,700. 8-12 week build. Connects Shopify + QuickBooks/Xero + 3PL + returns platform to Odoo. Includes 6 pre-built operational dashboards. ROI typically visible within 60 days as you cut unprofitable SKUs and reallocate ad spend to high-LTV channels.
We have built this for 11 D2C brands. The apparel founder we mentioned earlier cut 7 unprofitable SKUs, reallocated $3,200/month in ad spend from low-LTV channels, and recovered $8,740/month in the first 90 days. If you want to see what this looks like for your specific stack, grab 30 minutes with Dhwani. We will pull your data map and show you where the blind spots are.
FAQ
Can Shopify show me true per-order profit margin?
No. Shopify shows revenue and basic product cost if manually entered, but it cannot factor in pick-pack-ship costs ($2.40-$4.70/order), 3PL storage fees, packaging costs, payment processing fees, or return processing costs at the order level. You need an ERP that merges Shopify order data with your actual fulfillment and finance data to get true per-order profitability.
How do I find which SKUs are unprofitable after returns and shipping?
You need to merge three data sources: Shopify (revenue and product cost per SKU), your 3PL or shipping provider (shipping cost per order), and your returns platform (return rate and processing cost per SKU). Without an ERP connecting these, you must manually export CSVs from each tool and build VLOOKUP formulas in Excel. An Odoo integration automates this and surfaces SKU-level profitability in real-time.
What does a D2C operational data dashboard cost to build?
For a D2C brand with Shopify + QuickBooks/Xero + a 3PL + a returns platform: $16,400-$28,700 one-time implementation using Odoo as the central data warehouse. This includes connecting all data sources and building 6 operational dashboards (SKU profitability, per-order margin, channel LTV, return rates, dead stock, and customer acquisition analysis). ROI typically appears within 60 days.
Why do D2C brands struggle with their own data more than external data?
External datasets (like AWS Open Data) are centralized, well-structured, and query-ready. D2C operational data is fragmented across 5-8 tools (Shopify, QuickBooks, 3PL, Klaviyo, returns platform, Google Analytics, spreadsheets), each with different data formats, update frequencies, and no shared customer/order ID. Connecting these requires integration work that most brands skip, leaving founders unable to answer basic questions about their own operations.
Try the 5-Question Test Right Now
Return rate by discount tier. True COGS per SKU. Highest-LTV marketing channel. Dead stock value. Per-order profit margin. If you scored below 3 out of 5, your data is costing you money you cannot see.
Book a 30-minute data audit. Dev or Dhwani joins every call. We map where your data lives, where it gets stuck, and what it costs you. Written brief with line-item pricing inside a week. No deck. No SDR. Fixed-price if you move forward.
