KURAPRO

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.

  1. Open “Other” → CSV 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 CSV’s columns.
  4. 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

  1. Open a list screen (stock, clients, transactions or reports).
  2. Search or filter if you want to narrow it down.
  3. 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 (CODE123 and code123 are the same).

Printing labels

  1. Open “Other” → Barcode print (in the left menu on a PC).
  2. Add the products you want to print. You can set a print count per product.
  3. Choose a page size (A3–A6, B3–B6) and a format.
  4. 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.