Skip to main content

How to check your COGS

How to set up your COGS, read them per SKU, and what to do when a product shows 0.

Written by Frank Birzle

tl;dr

  • There are three ways to configure COGS — Per SKU (Google Sheet), Shop import (e.g. Shopify "Cost per item"), and a Fallback percentage of net selling price (shown as "Average Value") — applied in that priority order.

  • COGS is the first deduction in your margin: Net Revenue − COGS = CM1.

  • Check COGS per SKU in the Revenue & Profit Flex Table.

  • If a product shows 0, it has no cost in any of the three sources — or a Store Update hasn't run since you added it.


Setup

There are 3 ways to configure COGS in Klar (Shopify, Sheet, Average Value) — see this article on the setup and how they are defined & calculated.

The three sources are applied in a fixed priority:

  1. Sheet (per SKU) — the most specific; overrides the others.

  2. Shop import — the product cost field synced from your shop (e.g. Shopify "Cost per item").

  3. Fallback percentage — a % of the net selling price (excl. VAT), shown as "Average Value"; the safety net for any product without an SKU or shop value.

⚠️ Note: COGS are not applied to returned items. For Amazon, COGS are entered manually in the sheet via the ASIN (they aren't synced automatically).


Analysis

To see the COGS for a specific product / SKU in Klar, do the following:

  1. Go to the Revenue & Profit Flex Table and open the Profitability tab.

  2. Set the first dimension to Product SKU.

  3. Set the metric display to Per Item.

Now you can compare the COGS values for each SKU with the values entered in Shopify / the sheet.


Where do COGS show up in my margins?

COGS is the first cost deducted from your revenue: CM1 = Net Revenue − COGS. So a product with missing COGS will overstate your CM1 (and every margin below it).


Why does a product show 0 COGS?

A product shows 0 when Klar has no cost for it from any of the three sources. Work through these:

  1. No value in any source. The SKU isn't in your COGS sheet, the shop's cost field is empty, and no fallback % is set. Add the cost in your sheet, fill the shop field, or set an Average Value (fallback %) so no product is left without COGS.

  2. New product not yet covered. A newly added SKU may have no cost until you add it to the sheet or the shop field is filled.

  3. No Store Update since the change. After adding or editing COGS, trigger a Store Update (Store Configurator → Store Settings → Update Store Data) and allow ~30 minutes. If you edited a Google Sheet, click Sync Data on that source first, then run the Store Update.

  4. The order was fully returned. COGS is not applied to returned items — so a fully returned order shows 0 COGS by design. (Partially returned orders keep COGS on the items that weren't returned.)

If the cost is configured, a Store Update has run, and a product still shows 0 after ~30 minutes, reach out to us.

Did this answer your question?