CSV, barcode printing and images
Import in bulk, export in bulk, print labels. This page covers the features that cut out manual work.
Moving from Excel or another system? A CSV migration handles it.
Importing CSV
Products, clients and transactions can all be registered in bulk.
- Open “Other” → CSV import (in the left menu on a PC).
- Choose what you’re importing (products / clients / transactions).
- Map the fields shown on screen to your CSV’s columns.
- Pick the file, check the preview and press Import.
- UTF-8 is recommended.
- If you already have data, export a CSV first and use it as your template — the column order is then guaranteed to match.
Products
| Fields | |
|---|---|
| Required | Product name |
| Optional | SKU / unit / standard cost (with standard costing) / barcode / minimum stock alert / maximum stock alert / expiring alert (when Expiry is in use) / product fields |
- Products are matched on SKU, or on product name when there’s no SKU. A match updates; no match creates.
- The same product name with a different SKU registers as a separate product.
- Only the columns you map are updated. Anything you leave out keeps its current value.
- Leaving a cell empty clears that field.
- Separate barcodes with “
|” to register several (e.g.4901234567894|A-001).
Clients
| Fields | |
|---|---|
| Required | Client name |
| Optional | Postal code / address / building / phone number / memo |
Clients are matched on name. A match updates; no match creates.
Transactions
Before importing, choose the transaction type (inbound, outbound, adjustment, stocktaking) and the status (scheduled, completed). Moves aren’t supported.
| Fields | |
|---|---|
| Required | Date / product name or SKU / quantity (actual count for stocktaking) / whichever of location, lot, expiry are in use / unit price (when you track amounts) |
| Optional | Number / client name / transaction fields |
- Importing never creates products. Register them first.
- If several products share a name, identify them by SKU.
- Stocktaking takes the actual count — the difference is calculated for you.
Exporting CSV
- Open a list screen (stock, clients, transactions or reports).
- Search or filter if you want to narrow it down.
- Export from the menu at the top of the screen.
Stock offers two exports, “by product” and “stock details.” → Reading the stock list
Barcodes
- Several per product — JAN, ITF, your own codes, all on one product.
- No reuse — the same barcode can’t be used on two products.
- Not case-sensitive (
CODE123andcode123are the same).
Printing labels
- Open “Other” → Barcode print (in the left menu on a PC).
- Add the products you want to print. You can set a print count per product.
- Choose a page size (A3–A6, B3–B6) and a format.
- Press Generate PDF for printing and print the result.
Formats include QR_CODE, EAN-13(JAN), EAN-8, UPC-A, UPC-E, ITF, CODE_39, CODE_93, CODE_128, CODABAR, DATA_MATRIX, AZTEC and PDF417. If in doubt, EAN-13(JAN) for retail products or QR_CODE when you want more data in the code.
Products without a barcode
Press Generate barcode on the barcode print screen and an EAN-13 code is created and registered on the product. Products that already have a barcode aren’t given another.
Handy for own-brand boxes and repacked items with no commercial code.
Product images
- Register from the product’s create or edit screen — take a photo or pick from your library.
- Shown in the list and on the detail screen.
- JPEG, PNG, GIF and similar formats are supported.
- Very large files may fail to upload. Shrink them and try again.
Where many products look alike, an image alone cuts picking errors.
When something goes wrong
| Message | What to do |
|---|---|
| Invalid CSV format | Check the delimiter, the character encoding (UTF-8 recommended) and the header row. |
| The CSV header is empty / The CSV file is empty | Make sure row 1 has field names and row 2 onwards has data. |
| A product is required in the CSV / A client is required in the CSV | A required column (product name / SKU, or client name) isn’t mapped. |
| No valid transactions were found in the CSV | There’s no importable transaction data. Check your column mapping. |
| Multiple items share this name. Please specify the SKU to identify the item | Use the SKU column to identify the product. |
| Invalid image data / Invalid file type | Use a JPEG, PNG or GIF image. |
| The request body is too large | The file is too big. Shrink the image or reduce the number of CSV rows. |
| Too many records to export | Narrow the period or conditions and export again. |