📊 Sales Analytics

Santa Martha Café • Coffee unit sales from imported Shopify/POS orders
Coffee Bags Sold
—
Orders
—
Market Sale Days
—
Whole Bean
—
Ground
—
All Line-Item Net Sales
—
Coffee + merchandise/services + tips + unmapped
Coffee Net Sales
—
Mapped coffee line-item net sales
Other Product Net Sales
—
Tips
—
Shopify line items identified as Tip
Unmapped / Review
—
All Line-Item Units
—
Includes coffee and non-coffee line items
Net Collected
—
Order totals minus Shopify refunded amount
Refunded
—
Order-level refunds
Discounts
—
Order-level discount amount
Financial Coverage
—

Period Comparisons

Sales Source Comparison Explorer

Compare markets, Online Store, Subscriptions, and Wholesale in one place, then jump directly to any week, month, or year.
Current period

Coffee Bag Mix Comparison

See whether customers are shifting toward different coffees, bag sizes, or whole bean vs ground — using the same sales sources and period selected above.

Market Year-over-Year History

Year-over-Year Market Chart

Every available year for markets with historical sales, including inactive markets. Market labels use the short codes — RWFM, HFM, RWMF, and so on.

Whole Bean vs Ground

Bag Size Mix

Sales Trend by Month

Market Volume

All Products Sold

Every positive Shopify line item is included here — coffee, soap, merchandise, services/bulk roasting, tips, and products that still need mapping.
Product Type SKU Units Orders Net Sales Avg / Unit % of Line Sales Last Sale

Coffee Sales — Whole vs Ground + Bag Size

Click any coffee name to see where that coffee sells by bag count and percentage.
Coffee Total Share Whole Whole % Ground Ground % Regular Small 3 lb Orders Net Sales Avg $ / Bag Bags / Market Day

Market Comparison

Click a market/channel name to see the exact orders. Click any column heading to sort.

Top Product Combinations

What Each Market Actually Sells

Coffee Bags Whole Ground Net Sales Sale Days Bags / Sale Day

Day-of-Week Mix

Checkout / Location

This uses Shopify's saved Location field. In some imports it identifies Ken/Ruth; in others it may identify a POS location.

Quick Insights

Data Quality / Coverage

All Products includes every positive Shopify line item stored in sales_items. Coffee-specific sections still use mapped coffee only. Product-level net sales do not guess how order-level refunds should be allocated across individual products.