Text version of this lessonExpand
Put product cost, inbound and outbound shipping, payment fees, refunds, return handling, and support credits into true order cost. This lesson stands on its own and also works as the finance handoff between ads, CRO, email, operations, and product data.
Lesson task: COGS, Shipping, Payment Fees, and Refund Costs
The product cost sheet looks profitable, but shipping, payment fees, refunds, and reships consume the margin.
Use real orders to reconcile every variable cost to SKU, channel, and country.
Plain operating terms
- Contribution profit: What an order or SKU contributes after variable costs.
- Cash rhythm: When cash leaves, when it returns, and how inventory and ads consume it.
- Variance routing: Routing a variance to inventory, ads, price, fulfillment, or accounting.
After this lesson, the useful output is a true order cost reconciliation sheet: current signal, reviewable evidence, one owner, next action, and acceptance rule.
Lesson output: real order cost reconciliation table
Put product cost, inbound and outbound shipping, payment fees, refunds, return handling, and support credits into true order cost.
The goal is not to turn operators into accountants. The goal is to build a practical profit guardrail: check contribution profit, then cash pressure, then whether the action deserves continuation. When this order is fixed, ads, pages, email, and merchandising do not make conflicting decisions from separate metrics.
- Step one: define source and owner for each field in the lesson asset.
- Step two: translate revenue metrics into contribution profit, cash impact, and review action.
- Step three: write continue, scale, reduce, or pause rules explicitly.
Deliver first: true order cost reconciliation sheet
Use real orders to reconcile every variable cost to SKU, channel, and country.
| Field | What to define | Acceptance |
|---|---|---|
| COGS | Current state, evidence source, and owner for COGS | Explains why this layer comes first |
| shipping | Current state, evidence source, and owner for shipping | Can be reviewed by the next teammate |
| payment fee | Current state, evidence source, and owner for payment fee | Can be reviewed by the next teammate |
| refund | Current state, evidence source, and owner for refund | Can be reviewed by the next teammate |
| reship | Current state, evidence source, and owner for reship | Can be reviewed by the next teammate |
| country | Current state, evidence source, and owner for country | Turns into a next action or stop rule |
Do not misread this lesson
The product cost sheet looks profitable, but shipping, payment fees, refunds, and reships consume the margin. If the next action is chosen by instinct, this lesson has not entered operations.
True order cost sheet: contribution profit
This table is the lesson deliverable. Do not only fill numbers. Add source, refresh timing, owner, and decision rule to each row.
| Field or node | Data source | Operating decision |
|---|---|---|
| Product cost | Cost per item or purchase sheet | Sets the gross-margin floor |
| Shipping cost | Freight, subsidy, return shipping | Do not record only what the customer paid |
| Payment fees | Shopify Payments, PayPal, processor | Original processing fees might not be reimbursed after refunds |
| Refund cost | Refund, return handling, reshipment | Contribution profit must read the after-refund result |
Public references: https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/profit-reports / https://help.shopify.com/en/manual/payments/shopify-payments/payouts/refunds / https://help.shopify.com/manual/reports-and-analytics/shopify-reports/report-types/payments. These sources define finance, profit, discount, refund, ad value, or cohort boundaries; operating practice should become review templates and profit guardrails, not visible source labels.
True cost is not only product cost
Many stores track purchase cost but miss payment fees, shipping subsidies, reshipments, return handling, and support credits. A higher PetNest return rate can erase contribution profit even when gross margin looks stable.
When implementing this, put the decision into the lesson review template. Any action affecting discount, refund, ad budget, inventory purchase, shipping promise, or channel scaling must trace back to one contribution profit rule and one owner.
Refunds belong in the profit view
A refund is not an isolated support action. It affects revenue, payment fees, inventory, reverse logistics, resale chance, and ad decisions. The true order cost sheet needs refund status and after-refund contribution profit.
When implementing this, put the decision into the lesson review template. Any action affecting discount, refund, ad budget, inventory purchase, shipping promise, or channel scaling must trace back to one contribution profit rule and one owner.
Split controllable and less controllable cost
Purchase cost might be hard to change quickly. Shipping subsidy, packaging, promotion promises, return policy, and support credits can often change through operating rules.
When implementing this, put the decision into the lesson review template. Any action affecting discount, refund, ad budget, inventory purchase, shipping promise, or channel scaling must trace back to one contribution profit rule and one owner.
PetNest review cadence
When PetNest implements this lesson, the first week should not try to backfill every historical order. Start with a sample: five high-volume SKUs, five high-discount orders, five high-refund orders, and five recent channel orders. Check revenue, discount, cost, refund, ad source, and cash status. The sample is not the final finance number; it tests whether fields, definitions, and owners are clear.
In the second week, move into batch review. Classify orders or SKUs into four states: healthy contribution profit, high revenue but thin profit, high cash tie-up, and high refund or support risk. Each state needs a next action: continue, reduce, pause, adjust price, recalculate shipping, change offer, reduce budget, or replenish inventory. The review template becomes an operating action, not a chart explanation.
In the third week, define fixed thresholds. They do not need to be complex, but they must be executable: orders below minimum contribution profit cannot be scale examples; SKUs above the refund alert line cannot receive more budget; campaign budgets slow down when cash recovery is slower than replenishment payment timing; cohorts that fail margin review do not scale just because first-order ROAS looks strong.
At month end, write these thresholds back into the profit guardrail. Clear guardrails reduce opinion-based debate: ads know what can scale, CRO knows whether a page improvement has commercial value, email knows whether a discount can continue, and operations know whether inventory and cash can support growth.
COGS reconciliation evidence check
The easiest mistake is to use one metric from one system as the whole finance story. Keep four evidence layers together: order facts, cost facts, channel facts, and action facts.
Order facts confirm whether the money happened. Cost facts show what was left after product cost, fulfillment, payment fees, refunds, and support compensation. Channel facts explain why the order appeared. Action facts record whether the team will scale, pause, reprice, change inventory, adjust the offer, or rewrite the page.
A minimal evidence sheet only needs eight columns: date, order or SKU, revenue, main cost, contribution profit, source channel, variance reason, and next action. The point is not perfect accounting; it is a stable operating lens for the next review.
PetNest operating drill
PetNest reviews 20 orders and 6 priority SKUs this week. Sample order revenue, discount, product cost, payment fee, shipping cost, refund status, ad source, and contribution profit before deciding which orders represent healthy growth.
Execution check
- Every profit field has a source, not a meeting estimate.
- Every variance has owner, due date, and review action.
- Promotion, ads, and inventory actions pass the profit guardrail first.
- Review output feeds next-week budget, offer, SKU, and cash rhythm.
Handoff to SKU margin analysis: cost evidence to carry forward
This lesson sends support, fulfillment, and payment data into the profit model so refunded orders are not treated as healthy orders.
If you arrived from ads, CRO, email, or operations, keep this boundary clear: earlier series create growth actions. This series decides whether those actions make money, consume cash, and deserve more scale.
Lesson closeout: true order cost reconciliation sheet handoff packet
Before this moves to the next teammate, pass one clean version: COGS, shipping, payment fee, refund, reship, country. Turn profit from a report number into constraints for budget, promotion, inventory, channel decisions, and business review actions.
Acceptance before handoff
- Evidence is reviewable, not just marked confirmed.
- The owner is a role or person, not everyone.
- The next action has timing, object, and acceptance metric.
- The most likely counter-signal is written down.