Product costs
Enter the purchase price of your products and variants, by hand or by CSV import, and understand what happens when a cost is missing.
The Product costs page is where you tell Fullmetrix what each product you sell costs you. Fullmetrix uses it to compute the cost of the products sold, then your margin in the Overview. Without purchase prices, the margin cannot be accurate.
If this is your first time, the Set up profit tracking tutorial walks you through it step by step. This page details every part of the screen.
Open the page
In the sidebar, open Data, then Margin, then click Product costs. You can also click Configure in the Where your money goes block of the Overview.
The page is titled Purchase price per product and reminds you that all prices are shown including tax. It uses the stores picked in the All sources selector of the e-commerce reports.
Which price to enter
Enter the cost of one sellable unit, including tax. This is what you pay your supplier for one item, or what it costs you to make it. Do not enter the sale price, the total value of your stock or a percentage.
For the margin, Fullmetrix brings this price back to excluding tax by dividing it by the average VAT rate of your sales. The details are in the Overview, section "Where the costs come from".
Read the table
The table lists the products on sale in your stores. Products in draft, private, archived or in the trash are not included. A product with variants is replaced by one row per variant, because each size or color can have its own cost. A product without variants has a single row.
By default, the products that brought in the most over the last 30 days come first. The next ones load as you scroll, 100 at a time.
| Column | What it shows |
|---|---|
| Product | The image, the product name (and the variant), and underneath its reference, for example "Ref. TSHIRT-BL-M". The reference is the SKU, or the product ID in the store when there is no SKU. |
| Purchase price | The field to fill in, including tax. It shows To fill in as long as no price is known. |
| Sale price | The product's current sale price including tax in your store, sale price included if there is one. |
| Margin | Sale price minus purchase price, including tax. A dash shows as long as the purchase price is missing. |
| Margin rate | Margin divided by sale price. It shows in red below 0%, in orange below 20% and in green from 20%. |
Click a column header to sort. Rows without a purchase price always stay at the bottom, whatever the sort direction. Sort by Margin rate ascending to find products sold at a loss.
The coverage line
Above the table, a line shows for example "412 / 530 items priced · 200 / 530 products loaded". The first figure counts the rows that have a purchase price among the rows loaded. The second shows how many rows are already loaded out of the total, because the table loads as you scroll. Scroll to the bottom for the coverage to cover the whole catalog.
Enter a price by hand
Find the product
Type its name, SKU or ID in the Search a product or a SKU field. The closest matches come first.
Enter the price
Click the Purchase price cell of the row and type the price including tax. Both comma and period work as decimal separator.
Confirm
Press Enter or click elsewhere. The price is saved right away, and the Margin and Margin rate columns update. Press Escape to cancel what you are typing.
To remove a price, empty the cell and confirm. If saving fails, the previous price comes back and an error message appears.
Import prices from a CSV file
For a catalog of more than a few dozen products, importing is safer than typing row by row. Click Import a CSV. The import opens full screen and has three steps, File, Mapping and Result.
Prepare the file
The Import your purchase prices screen offers two templates. Template with my N items downloads the list of all your references with the Reference, Product name and Purchase price columns, ready to fill in. Blank template downloads a file with only Reference and Purchase price.
The file must be a CSV, with one column that identifies the product (SKU or ID) and one purchase price column. Semicolon, comma and tab are recognized as separators. Write prices without a currency symbol, for example 12.50.
Upload the file
Drag the file into the Drop your file here area, or click Browse. The number of rows read shows up, with a Change button to pick another file. Click Continue.
A file that is not a CSV, is larger than 8 MB or is empty is refused with a message.
Map the columns
The Map the columns screen lists each column of your file with a few sample values. For each one, choose Product reference (SKU or id), Purchase price or Skip. Fullmetrix suggests a mapping from the column names, such as "SKU" or "Cost". Check it.
Say whether your prices exclude or include tax
In the Basis of the file prices block, choose Excl. tax or Incl. tax in Prices entered. If your prices include tax, they are saved as they are. If your prices exclude tax, Fullmetrix converts them to including tax with the rate in the VAT (%) field, 20% by default.
The VAT (%) field shows when Incl. tax is selected. If your rate is not 20%, select Incl. tax first, enter your rate, then switch back to Excl. tax.
Run the import
Click Run import. The button stays greyed out until a column is mapped to the reference and another to the price.
Read the result
The Import complete screen shows three counters.
| Counter | Meaning |
|---|---|
| Prices updated | The number of references whose price was saved. |
| Unknown items | References in the file that match no product in your stores. They are listed below under Items not found. |
| Unreadable values | Rows whose reference is known but whose price could not be read (empty cell, text, negative number, currency symbol). |
Click Close to go back to the table, which shows the new prices.
How Fullmetrix recognizes a reference
Fullmetrix compares each value of the reference column with the SKU of your products and variants, ignoring case and surrounding spaces. If no SKU matches, it tries the product ID in the store. An unknown reference is never applied to another product. If two rows of the file have the same reference, the last one wins.
The import adds and updates prices. It never deletes an existing price. A reference missing from the file keeps its current price.
What happens when a cost is missing
When a product sold has no purchase price, Fullmetrix cannot guess its cost. It counts it as zero in the cost of products sold. Your Net margin is then higher than it actually is, all the more so when that product sells a lot.
To avoid this, fill in the products at the top of the table first, which are your best sellers of the last 30 days. A variant with no price uses its parent product's price, if the parent has one.
Costs sent by your store
Some stores already record a purchase cost, such as the wholesale price in PrestaShop or the cost per item in Shopify. Fullmetrix imports it automatically. It shows in the Purchase price column, converted to including tax with the average VAT rate of your sales over the last 90 days.
A price you enter or import always replaces the cost sent by the store. If you clear your entry, the cost sent by the store shows again.
Example questions
- Which products do I sell at a loss? Sort by Margin rate ascending and look at the values in red.
- Do all my best sellers have a purchase price? Keep the default order and look for To fill in at the top of the list.
- How many references are left to fill in? Scroll to the bottom and read the coverage line.