Import products from a spreadsheet

Type your products into a spreadsheet once, in Excel or Google Sheets, save it as CSV and Kila imports them all. Importing the same file again updates the products: “A SKU already in the catalog is updated, never duplicated.”

Steps

1. Download the template

   Open Products › Import, or tap Import from a spreadsheet on your set-up checklist. Leave Products chosen and tap Download template. You get kila-products-template.csv, with the columns and two example rows.

   Zoom

   

2. Fill it in and save it as CSV

   One product a row, over the example rows. Only sku, name and price are needed; the guide on the right says what each column takes. Save it as CSV: “Save the spreadsheet as CSV (comma separated). The first row must be the column names.”

3. Choose the file

   Tap Choose file and pick your CSV. Kila shows its name and how many rows it has.

4. Tap Start import

   “Import started: 10 rows. You can leave this page; it carries on in the background.” Kila counts the rows as it goes.

5. Read the report

   When it finishes, Kila says how many rows are done and how many need attention, and lists each problem with its row number. “The other rows still import.”

   Zoom

   

6. Fix those rows and import the file again

   Correct the rows Kila listed and import the whole file again: “rows already imported are not duplicated.” When every row goes in, Kila says Finished. Every row accounted for.

   Zoom

   

The columns

Column	What to put in it
sku	Required. “Unique code. A SKU already in the catalog is updated, never duplicated.”
name, price	Required. “Price includes VAT.”
type	stocked (the default) for goods on the shelf; also non_stocked, service, bundle and others.
category, brand, unit	“New categories and brands are created as needed.”
cost	What you pay for one.
barcodes	“Barcodes separated by |.”
tax_code	“Tax code A, B, C, D or E (default B, 16%).”
reorder_point, reorder_qty, min_stock, max_stock	Stock levels: when to reorder and how much.
track_serial, track_batch	yes or no.
storage, description	Optional details.

“Column names are not case-sensitive; extra columns are ignored.”

What if

A row has a problem

Kila names the row and the problem, word for word, such as:

Kila shows:

1 row not imported

Row 11: Tax code “X” is not set up. Use one of A, B, C, D, E.

Row 1 is the column names, so row 11 is the tenth product. Others you may see: Price "" is not a number., Name is empty., SKU … appears earlier in this file. Only the first row was imported. and Barcode … already belongs to ….

Kila does not start the import

If a column Kila needs is missing, Kila says The import did not start: “The file is missing the columns name, price. Download the template to see the expected columns.” Check the first row of your file against the template.

Tip

In Excel, save with File › Save As and choose CSV (comma delimited). A file must be under 5 MB.

Related

• Add your products: one product, field by field.
• Record your opening stock: the quantities on your shelves, with the same import.
• Move to Kila from another system or a daftari: customers, suppliers and balances too.
• Bring your products into Kila: the same list through Move to Kila.

Next: Record your opening stock.