File one
Your product list
What do I sell?
One row per SKU. This one goes first — nothing else can point at a product Skuvelo has not been told about.
.csv or .xlsx5,000 rows per file
| Column | Needed? | What it is |
|---|---|---|
| sku | Required | Your code for the item. Whatever you already call it is fine, as long as you use the same code in the other two files. |
| title | Required | The product name. Required for anything Skuvelo has not seen before — which, on your first file, is everything. |
| category | Optional | How you group it. Useful for reading reports later. |
| brand | Optional | Who makes it. |
| unit_costalso reads unitcost | Optional | What you pay for one. Costs are what turn a stock level into a cash number, so include them if you have them. |
| selling_pricealso reads sellingprice | Optional | What you charge. |
| standard_costalso reads standardcost | Optional | Your planned or budgeted cost, if you keep one. |
| last_costalso reads lastcost | Optional | What the most recent purchase actually cost. |
- Products created by an import are marked as needing a check rather than treated as verified. Nothing plans against a number nobody has looked at.
- This is also the one file you can send as a spreadsheet. Stock counts and order history have to be CSV.