Skip to content

Product costs ​

Access from: Catalog → Products (Cost tab of each product), Profitability → Costs and expenses, Profitability → P&L and Profitability → Margin by product (import from a file)

Sales channels do not know how much each product costs you. You provide that figure, and with it the P&L calculates your real contribution margin. While it is missing, the margin shows higher than it really is.

Which costs you can add ​

Both are per unit:

ConceptWhat it isWhere it appears in the P&L
Product costWhat each unit costs you until it is in the warehouse: purchase or manufacturing, shipping from your supplier, duties…Cost of goods sold, for the units sold minus the returned ones.
Shipping costWhat you pay to ship each unit sold to the customer, if the channel does not charge it. Shipping from your supplier does not go here: it goes in the product cost.Own shipping, within Logistics, for the units sold.

You can give the product cost in two ways:

  • Fixed cost: you say how much each unit costs from a date. It is the quickest option.
  • Purchases: you record each purchase from your supplier, with its units and its expenses, and Epinium calculates the average cost of what you have. It is the most accurate option when the price changes from one purchase to the next.

The shipping cost is always a fixed cost.

Each cost has a Valid from date. When what you pay changes, you add the new cost with its date and the previous one stays in the history: earlier sales keep being calculated with the cost of that time.

You can enter the cost in any currency. If it is not the marketplace currency, it is converted once, at the exchange rate of the Valid from day, and stored that way.

Only users who can edit the catalog can add or change costs. Everyone else sees them read-only. Costs are available from the Business plan.

Add a fixed cost to a product ​

  1. In Catalog → Products, open the product detail.
  2. Go to the Cost tab. At the top you see the current costs and below them the Cost history.
  3. In Add a cost or purchase, leave Fixed cost selected.
  4. Choose the Concept, enter the Cost per unit and its currency.
  5. Choose the date in Valid from. If you leave it empty, it applies from today and earlier sales keep the previous cost: if you already paid the same before, enter the date it applies from.
  6. Save with the Save button at the bottom.

Before saving, the form warns you about two things:

  • If there is already a cost for the same concept on that day: when you save, yours replaces it.
  • If there is already another cost for the same concept after that date: yours only applies until the day before the next one.

With a past date, the P&L is recalculated from that day. While it recalculates, the costs of that account are locked (see After adding costs below).

In the history, the Origin column tells you where each cost comes from: Product page, File import, API and MCP, Calculated from your purchases or Management system. Hovering over it you see when it was added and, for the ones that come from purchases, how it was calculated.

From the history you can:

  • Correct a cost: the form is filled in with it and you can change the amount, the currency or the date. While you correct, the button at the bottom becomes Cancel correction.
  • Delete it, from the ⋮ menu of its row. The confirmation tells you which cost remains from that day.

If you leave the tab or close the product detail with something typed and unsaved, it warns you before you lose it.

Below the history, a note reminds you from which day there is product cost: sales before that date do not have it.

If you add a cost with a date earlier than one you already have ​

Each cost counts from its date until the next one. If you add a cost from 1 November and the product already has one from the 4th, the new one only counts from the 1st to the 3rd: from the 4th the one you had stays. Epinium does not delete it, because it may be a correction of yours. If you want the new one to count from the 4th too, delete that cost in the product's history or add it again with that date.

Record purchases ​

With purchases, the product cost is the average cost of what you have. Each purchase averages the stock you already had, at its cost, with what you buy:

You had 500 units at €5. You buy 1,000 at €8. The cost becomes (500 × 5 + 1,000 × 8) / 1,500 = €7, from the day of the purchase until the next one.

Purchases are only available for Seller products: in Vendor the stock belongs to Amazon and its cost is a price per ASIN.

Add a purchase ​

  1. In the Cost tab of the product detail, in Add a cost or purchase, select Purchase.
  2. Fill in:
FieldWhat to enter
Purchase dateThe day of the purchase. Empty, today.
Order numberOptional. An order can include several products, but it cannot be repeated in another purchase of the same product.
Units boughtHow many units you bought.
Stock before the purchaseThe units you had just before. In FBA you can leave it empty: the latest Amazon FBA stock we have from the 7 days before the purchase is used, plus the purchases of that stock you recorded since that day, because FBA does not count what is on its way. In FBM it is required, because Amazon does not know it.
CurrencyThe currency of the purchase. If it is not the product's, it is converted at the exchange rate of the purchase date.
Product cost per unitWhat the supplier charges you for each unit.
ExpensesShipping to the warehouse, Duties and Other costs. With Whole order you enter what the invoice says and it is split across the units; with Per unit, already split. They add to the product cost.
  1. Check Average cost after the purchase: it tells you the cost that will result and where it comes from. If you leave the stock empty in FBA, or the purchase is in another currency, it is calculated when you save.
  2. Save with the Save button at the bottom.

The first purchase of a product warns you that the stock you already had is valued at its current product cost, and that from then on its cost is calculated from purchases. If there was already a fixed cost on that day, the purchase uses it to value the stock and replaces it in the history; if you delete the purchase, it comes back.

Products that share stock ​

In Pan-European, the same SKU is sold in several countries from the same boxes. Epinium groups those countries into a stock group, and a purchase recorded in any of them changes the cost of all of them. The form tells you which countries it is shared with. The group is created with the first purchase: until then each country keeps its own fixed cost, and it goes back to it if you delete all the purchases.

The stock before the purchase is taken only once for the whole group, not adding up countries, and only from the countries active in Epinium.

If on the first purchase those countries have different costs today (for example, ES at €4 and FR at €6), there is no way to know what the stock you already had was worth. The form shows you the costs of each country and asks you for the Value of the stock you already had, already filled in with the cost of this product. When you save, the purchase applies to all those countries with that value. That value always goes with the first purchase: if you register one with an earlier date, or delete or change the date of the first one, it moves to the one that ends up first. If you delete them all, the next one asks you for it again.

Correct or delete a purchase ​

Purchase rows appear in the history with the origin Calculated from your purchases.

  • Correct: opens the purchase in the form and you can change any data. The date is required. If you empty the stock before the purchase, it is taken from Amazon FBA again. If you change the date of a purchase whose stock came from Amazon FBA, the stock for the new date is read again. When you save, the cost is recalculated from the earlier of the two dates, along with that of later purchases. On the day you leave, the same happens as when you delete it.
  • Delete, from the ⋮ menu of its row: the confirmation tells you what will happen to the cost. If there are later purchases, they are recalculated. On that day, each product gets back the fixed cost it had, if it had one, with its same origin. If not, it goes back to the cost it had before, and if it had none, it is left without a product cost.

Fixed cost on a product with purchases ​

A fixed cost on a product with purchases replaces the calculated cost from its date until the next purchase: it is like saying "what I have left is worth this". That is why the form warns you and does not let you save until you tick Replace the calculated cost with this fixed cost. If what is wrong is a purchase, better correct it. The shipping cost does not have this warning: purchases do not touch it.

In the fixed cost import, on the other hand, a product with purchases appears in the template without a product cost, because its purchases calculate it, and with its shipping, which you can change. If its row has the product cost empty, or the same one it has today and without a date, it is ignored and the shipping is applied. If you enter another product cost, or a date, the whole row is rejected, shipping included.

Sales above what you bought ​

If you sell more units than you had plus the ones you recorded buying, from that day the cost of those sales is estimated: the latest average cost is still used, but there is no longer a recorded purchase behind it. The P&L and the Margin tab of the product detail tell you what share of sales carries an estimated cost. To make it exact again, record the latest purchase.

Import costs from a file ​

For many products at once:

  1. Open the import with the Import costs button of Profitability → Costs and expenses, or with the Add costs button of the coverage message, in Profitability → P&L or in Profitability → Margin by product.
  2. Choose the Account. The costs in the file only apply to the products of that account.
  3. In What are you importing?, choose Fixed cost or Purchases. In Vendor accounts there is only fixed cost.
  4. Click Download template and fill it in. Variation parents are left out: they do not sell, and their cost goes on their variations.
    • Fixed cost: it has one row per product and marketplace with its current cost. The countries of the same stock group appear only once, in one row for all of them. Change only the costs you want: what you do not touch comes out as "no changes" and is not applied. Products with purchases appear without a product cost and with their shipping.
    • Purchases: it has one row per product, or one per shared stock, with empty costs. Enter one row per purchase.
  5. Upload it in Choose file, check in Columns which column each value comes from and in Review how many rows will be applied, how many change nothing and which will not be applied and why: it checks them against the products and costs of that account. If some rows have no date, it warns you that their cost will count from today, and if any has a date earlier than a cost the product already has, until which day it will count. If the file looks like the other type, it warns you and lets you switch.
  6. Import. You can close the window: the import carries on and the result stays in History.

When it finishes you see how many rows were applied, how many changed nothing and how many were rejected, with the reason for each one. With Download rejected you get those rows to fix them and import them again.

Fixed cost file columns ​

ColumnWhat to enter
sellerSkuThe product SKU. In Vendor accounts, the ASIN.
marketplaceThe marketplace: ES, DE, UK… If you leave it empty, the cost applies to all the product's marketplaces.
dateFrom when the cost applies, as DD/MM/YYYY or YYYY-MM-DD. Empty, it applies from today and earlier sales keep the previous cost.
cogsCurrencyCurrency of the product cost, with its 3-letter code (EUR, GBP…). Empty, the marketplace currency.
cogsProduct cost per unit.
shippingCostCurrencyCurrency of the shipping cost. Empty, the marketplace currency.
shippingCostShipping cost per unit: what you pay to ship each unit sold to the customer.

Example:

csv
sellerSku,marketplace,date,cogsCurrency,cogs,shippingCostCurrency,shippingCost
MI-SKU-001,ES,01/01/2026,EUR,12.50,EUR,2.10
MI-SKU-002,DE,,,8.90,,

Purchases file columns ​

ColumnWhat to enter
sellerSkuThe product SKU.
marketplaceThe marketplace. Empty is fine if the SKU is only in one marketplace or in countries that share stock.
dateDay of the purchase. Empty, today.
unitsUnits bought, a whole number.
currencyCurrency of all the costs in the row. Empty, the marketplace currency.
productCostProduct cost per unit.
inboundShippingCostShipping to the warehouse, per unit.
tariffCostDuties, per unit.
otherCostOther costs, per unit.
stockOnHandStock just before the purchase. Empty, the latest Amazon FBA stock from the 7 days before the purchase, plus the purchases of that stock recorded since then.
referenceOrder number. An order can include several SKUs. If another purchase of the same product already has that number with different data, the row is rejected: correct it from the product page.

At least one of the four costs is required. Example:

csv
sellerSku,marketplace,date,units,currency,productCost,inboundShippingCost,tariffCost,otherCost,stockOnHand,reference
MI-SKU-001,ES,15/10/2026,1000,EUR,8.00,0.40,0.20,,500,PO-1042

File rules ​

  • .csv, .txt, .xlsx, .xlsm and .xls files are accepted. The first row holds the column names and, from an Excel file, only the first sheet is read.
  • Columns are recognized even if capital letters, spaces, hyphens or underscores change. If one is not recognized, in the Columns step you choose where each value comes from.
  • An empty cell changes nothing, and a row with no cost at all is skipped. That is why you can upload the whole template even if you fill in only a few rows.
  • Up to 8 MB per file and 200,000 rows per import.
  • 0 is a zero cost, not an empty cell.
  • A row with the same cost the product already had on that date changes nothing: it is not applied.
  • Amounts go without a currency symbol or thousands separator, with a comma or a dot for decimals: 12,50 or 12.50. An amount like 1.234 is rejected because it is unclear whether it means thousands or decimals.
  • Dates are read day first: 03/04/2026 is 3 April. Future dates are not accepted.
  • If you leave the marketplace empty, the currency is required: otherwise the same number would be euros in one country and pounds in another.
  • In purchases, if you leave the stock before the purchase empty and there is no Amazon FBA stock from the 7 days before the purchase, the row is rejected: fill it in.
  • In purchases, uploading the same purchase again (same date, units, stock, costs and order number) does not duplicate it: the row shows as unchanged.
  • The first purchase of a product that shares stock with countries that have a different cost is rejected: record it from the product page, which asks for the value of the stock you already had.
  • A row of a variation parent is rejected: it does not sell, so its cost would cover no sale. Put the cost on its variations.
  • If you open the template in a spreadsheet, keep the SKU as text so leading zeros are not lost.

After adding costs ​

The P&L recalculates on its own. While it runs:

  • In the P&L, in Margin by product, in the Cost tab and in the import window you see a progress bar with the message that it is being recalculated.
  • The figures stay visible but frozen: dimmed and not clickable.
  • The costs of that account are locked for all users: they cannot be added, corrected, deleted or imported until it finishes. Other accounts are not locked.

When it finishes, the message P&L updated with the new costs. Sales from the last few days will reflect it once Amazon confirms them. appears and the amounts update. If the recalculation fails, an error message appears: save again or contact support.

To see which products still have no cost and which to fill in first, go to Costs and expenses.

You uploaded costs and do not see them in the P&L ​

Check these causes, in this order:

  1. The cost starts after the period you are looking at. Each cost applies from its date and, without a date, from the day you upload it. The P&L warns you with Your product costs start on…. If you already paid the same before, import the file again with the date column filled in.
  2. It is the last few days. The cost applies to the sales Amazon has already confirmed, and it takes a few days to confirm them. The note below the period tells you up to which day there is data; it updates on its own.
  3. The row was rejected. Check the import result in History. The most common reasons are that the SKU does not exist in that account with that marketplace or, in fixed cost, that you changed the product cost of a product with purchases. Fix it and import the rejected rows again.
  4. The cost is estimated. If you sold more than you recorded buying, the cost is there, but it shows as estimated. Record the latest purchase.
  5. Your plan does not include product cost. It is available from the Business plan.

Epinium Documentation