How to prepare a CSV file for product ranking?
The key rule: prepare a simple table where the first row contains column names and each following row describes one product or one product variant.
5 rules for a correct CSV
- The first row contains column names, for example SKU, Product name, Category, Sales.
- One row describes one product or one product variant.
- Each column contains one type of data, for example only price or only units sold.
- Do not add empty rows, “Total” rows or comments between products.
- Export the file as CSV, preferably UTF-8.
Most important columns
| Column | Why it matters | Example |
|---|---|---|
| SKU / Product ID | Identifies the product clearly. | TSHIRT-BLK-M |
| Product name | Helps verify what the row describes. | Black cotton T-shirt M |
| Category | Lets products be compared in the right context. | Clothing > T-shirts |
| Units sold | Shows demand. | 124 |
| Revenue | Shows sales value. | 7420.50 |
| Cost | Helps evaluate profitability. | 31.20 |
| Availability | Prevents unavailable products from being promoted. | in_stock |
| Stock level | Shows whether the product can keep being exposed. | 37 |
How to write numbers
Use numbers only. Do not add currency names, units or comments inside numeric cells.
| Good | Bad |
|---|---|
| 124 | 124 pcs |
| 59.99 | 59.99 EUR gross |
| 7420.50 | 7,420.50 EUR |
What not to include
- Customer personal data: names, e-mails, phone numbers or addresses.
- Summary rows such as “Total”, “Sum” or “Average”.
- Merged cells, extra tables, notes or comments.
- Multiple products in one row.
Checklist before upload
- The file has SKU or Product ID.
- The file has product name and category.
- Each product has its own row.
- Numbers do not contain currency or unit labels.
- There are no empty rows or summary rows.
- Special characters display correctly.
Upload the CSV when it is ready
Go to the Dashboard, choose the CSV file and map the columns. Tokens are charged only after you confirm the import cost.
Go to CSV import