- In Realised profit, view line items with missing cost and open the order or Product costs. Enter the cost for the relevant product, store, currency and sale date, then check period coverage again.
- Prepare the CSV, XLS or XLSX file according to the columns displayed in Product costs (COGS). Identify the product by EAN, or offer identifier if EAN is missing; check the connection currency and effective date. If the date is missing, the import date is used.
- Enter cost excluding VAT with a decimal point, no thousands separator and up to four decimal places, for example 1234.56. In Excel, keep the EAN as text to preserve leading zeros. After import, check skipped rows and correct the file before retrying; invalid rows do not replace existing costs.
- Cost of goods sold = the sum, for all line items, of quantity sold × applicable unit cost. Use the same currency and VAT treatment; fill in missing costs rather than treating them as zero.
Related resources
Practical example
You sell 3 units at an applicable purchase cost of RON 40/unit. The example’s cost of goods sold is 3 × 40 = RON 120. Check the cost document, currency and period, and complete missing information before analysing profit.
Frequently asked questions and solutions
A product has no cost. Should I treat it as zero?
A missing cost is information to complete. Check the supplier invoice, unit, currency and effective date, and save the documented cost. An analysis without complete costs cannot support a margin decision.
The product has estimated profit, but available money is lower. Why?
Compare actual receipts, due dates, costs and returns with analysis values. Estimated profit and the available bank balance are different measures. Check currency and omitted costs before deciding on a purchase or price reduction.