Import items
Add or update many products at once from a spreadsheet
- 1. Upload the file
- 2. Match the columns
- 3. Check and import
Upload the file
A CSV or Excel file with one product a row. The first row names the columns.
Match the columns
We matched what we could; check each column of new-products.csv.
| Column in your file | Import as | First value |
|---|---|---|
| Name | Pumpkin spice latte | |
| SKU | HD-1053 | |
| Barcode | 0711000020007 | |
| Category | Hot drinks | |
| Price | 5.40 | |
| Cost | 1.30 | |
| Qty | 0 | |
| Supplier | Blue Harbour Roasters |
Check and import
54 rows read from new-products.csv.
New products
48
Updates
4
Rows with problems
2
2 rows will be skipped
Row 17: the price “4,50” is not a number. Row 31: the SKU HD-1009 already belongs to Hot chocolate.