- Home
- E-commerce
- E-commerce Profit Calculator
- Catalogue analysis
Catalogue analysis
Check a whole product list at once: the data check finds missing, invalid and implausible values, and every product gets its contribution margin, margin and break-even price – with the same VAT logic as the single-product calculator.
- CSV files (also from Excel)
- Automatic data check
- Processed in your browser
Upload your product list
CSV with one product per row. Comma, semicolon or tab separated – Excel exports work as they are.
Max. 5 MB and 5,000 products. The file is processed in your browser and never uploaded.
Settings for the whole catalogue
Used for every product. Optional columns that are missing in your file – or empty cells – use the defaults below.
Sets the VAT rate and currency of the country where the sale is taxed.
Defaults for missing columns
Marketplace fee
Payment fee
CSV format
Only SKU, selling price and purchase price are required. Column names are recognised in English and German (e.g. “Verkaufspreis”, “EK”). Numbers may use 1,234.50 or 1.234,50; percentages are entered as 15 for 15 %.
| Column | Meaning |
|---|---|
skurequired | Unique article number. Duplicates are reported. |
name | Product name (optional, shown in results). |
selling_pricerequired | Price the customer pays – incl. or excl. VAT as set below. |
purchase_pricerequired | Cost of goods per unit. |
shipping_cost | Shipping & packaging per order. |
marketplace_fee_pct | Marketplace commission in % of the customer price (15 = 15 %). |
marketplace_fee_fixed | Fixed marketplace fee per order. |
payment_fee_pct | Payment provider fee in %. |
payment_fee_fixed | Fixed payment fee per order. |
ad_cost_per_order | Advertising cost per order. |
return_rate_pct | Expected return rate in %. |
return_cost_per_return | Label, handling and write-offs per return. |
other_costs | Any other variable cost per order. |
vat_rate_pct | VAT rate for this product, e.g. a reduced rate. |
monthly_units | Units sold per month – enables monthly totals and ABC classes. |