📊 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

Market Comparison Explorer

Choose any markets — three, eight, or more — then move backward and forward through week-over-week, week-vs-last-year, month-over-month, or year-over-year sales.

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.