Skip to main content
Cost of goods sold for orders placed by returning customers—used to calculate repeat buyer gross margin.

Formula

Returning Customer COGS = SUM ( Product Cost ) WHERE customer_type = returning_customer

Formula Components

MetricDefinition
Product CostCost of products in the order from Shopify inventory
customer_type = returning_customerFilters to orders from customers who have purchased before
Metadata
TypeCurrency
Data SourceShopify, Upstack Costs
AggregationSum

Example

Your returning customers generated $24,680 in COGS this month from 589 repeat orders:
SegmentCOGSRevenueGross Margin
Returning Customers$24,680$68,40063.9%
New Customers$18,340$47,20061.1%
All Orders$43,020$115,60062.8%
Returning customers have better margins—they buy fewer discounted starter products.

How It Works

Returning Customer COGS sums the product costs for all orders placed by repeat buyers during the selected period. Product costs come from Shopify variant cost data. Compare to new customer COGS to understand how product mix differs by customer segment.

When to Use

ScenarioAction
Retention profitabilityCalculate repeat-order gross profit
LTV modelingUse RC COGS in lifetime value calculations
Segment cost structureCompare to NC COGS for product mix insights
Margin by cohortTrack if retention campaigns affect cost mix

MetricRelationship
COGSAll customers combined
New Customer COGSFirst-time buyer comparison
Returning Customer COGS Per OrderAverage cost per repeat order
Returning Customer Gross RevenueUsed with RC COGS to calculate margin
See all COGS metrics →