CSV, Excel, label printing and images

Import in bulk, export in bulk, print labels. This page covers the features that cut out manual work.

Both importing and exporting support CSV (.csv) and Excel (.xlsx, .xlsm). The Excel workbook you use today can go straight in — no conversion to CSV needed.

Importing Excel and CSV

Products, clients and transactions can all be registered in bulk from an Excel workbook or a CSV file.

1. Open “Other” → Import (in the left menu on a PC).
2. Choose what you’re importing (products / clients / transactions).
3. Map the fields shown on screen to your file’s columns.
4. Press Select CSV / Excel, pick the file, check the preview and press Import.

• Row 1 holds the field names; data starts on row 2.
• If you already have data, export a file first and use it as your template — the column order is then guaranteed to match.

When you import an Excel workbook

• If the workbook has several sheets, you’re asked which sheet to import. Sheets with nothing but a header row aren’t offered.
• Formula cells come in as the result Excel saved with the workbook.
• Date cells become text in the form 2026/08/20 (2026/08/20 09:30:00 when there’s a time).
• Empty rows are skipped.

Products

• 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 of the file keeps its current value.
• Leaving a cell empty clears that field.
• Separate barcodes with “|” to register several (e.g. 4901234567894|A-001).

Clients

Clients are matched on name. A match updates; no match creates.

Transactions

Before importing, choose the transaction type (inbound, outbound, stocktaking) and the status (scheduled, completed). Moves aren’t supported.

• 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 Excel and CSV

1. Open a list screen (stock, clients, transactions or reports).
2. Search or filter if you want to narrow it down.
3. From the menu at the top of the screen, choose CSV download or Excel download.

Stock offers two exports, “by product” and “stock details.” → Reading the stock list

• Excel exports write every cell as text. A leading 0 on an SKU is never dropped, a JAN code never turns into 4.90123E+12, and 1-2 never becomes a date.
• CSV is written as UTF-8 with BOM, so it opens straight in Excel.
• Either file works as-is as a template for your next import.

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 (CODE123 and code123 are the same).

Printing labels

KURAPRO builds a PDF laid out to match the cells on an off-the-shelf label sheet, so you can print it and peel the labels straight off.

1. Open “Other” → Label print (in the left menu on a PC).
2. Choose a format (the barcode type) and a layout (the label sheet).
3. Press Add item and pick the product you want to print.
4. In the dialog that opens, choose the barcode to print and the print count, then save.
5. Press Save PDF and print the result.

• Each row shows the barcode being printed and the count (×3). Tap a row to change it, or use the delete button at the top right of the dialog to take it off the list.
• Anything that doesn’t fit on one sheet continues onto the next page automatically.
• Your format and layout are remembered for next time.

Choosing a layout

Pick the one matching the label sheet you have.

Below the layout there’s a link to where to buy sheets for the layout you selected.

Print at 100% scale (actual size) with no margins. PDF viewers and browsers usually default to “fit to page,” which shrinks the whole page slightly and shifts every label out of alignment with the sheet.

What’s on a label

Each label carries the product name, the barcode and the barcode value.

• With a square format such as QR_CODE on a wide label, the barcode goes on the left and the text on the right.
• On small labels such as A4 70-up, the product name is dropped so the barcode and value stay legible.

Formats: QR_CODE, DATA_MATRIX, AZTEC, EAN_8(JAN_8), EAN_13(JAN_13), UPC_A, UPC_E, ITF, CODE_39, CODE_93, CODE_128 and CODABAR. If in doubt, EAN_13(JAN) for retail products or QR_CODE when you want more data in the code.

If a product has several barcodes registered, the barcode field in the dialog decides which one is printed.

Products without a barcode

Add a product with no barcode and KURAPRO asks “Generate barcode for this item?”. Accept and an EAN-13 code is created, registered on the product, and added to the print list. Decline and the product isn’t added.

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

Related pages

• Registering and editing products
• Inbound, outbound, move and stocktaking
• The limits of Excel inventory management