Skip to content
MySolute
Menu

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.

%
Off for small-business exemptions: you charge no VAT, and VAT on your costs becomes a cost.
Applies to purchase price, shipping, ads, returns and other costs.

Defaults for missing columns

EUR
EUR

Marketplace fee

%
+ fixed
EUR

Payment fee

%
+ fixed
EUR
%
EUR
EUR

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 %.

ColumnMeaning
skurequiredUnique article number. Duplicates are reported.
nameProduct name (optional, shown in results).
selling_pricerequiredPrice the customer pays – incl. or excl. VAT as set below.
purchase_pricerequiredCost of goods per unit.
shipping_costShipping & packaging per order.
marketplace_fee_pctMarketplace commission in % of the customer price (15 = 15 %).
marketplace_fee_fixedFixed marketplace fee per order.
payment_fee_pctPayment provider fee in %.
payment_fee_fixedFixed payment fee per order.
ad_cost_per_orderAdvertising cost per order.
return_rate_pctExpected return rate in %.
return_cost_per_returnLabel, handling and write-offs per return.
other_costsAny other variable cost per order.
vat_rate_pctVAT rate for this product, e.g. a reduced rate.
monthly_unitsUnits sold per month – enables monthly totals and ABC classes.