lloza
Login
Tilloza Help & Reference Manual

Operational Documentation

Read comprehensive guides to quickly setup SAFARICOM payments APIs, configure local thermal POS registers, map eTIMS tax lists, or load inventories in bulk.

Category: inventory setup manual

Importing Inventory Catalog via Excel Spreadsheet

Match your current Microsoft Excel or Google Sheets database columns for painless product list migrations.

Last documentation update: April 20, 2026

Integration Walkthrough Steps

  1. 1Open your inventory list in Microsoft Excel or Google Sheets.
  2. 2Ensure the spreadsheet contains these precise headings: Barcode, Item Name, Buying Price, Selling Price, Initial Stock, and Category.
  3. 3Save the sheet containing your records specifically in Comma Separated CSV or Standard XLSX file extension format.
  4. 4Go to Tilloza Dashboard > Inventory > Import Products.
  5. 5Drag and drop the spreadsheet. Use our visual Column Mapper to align headers, then click "Validate and Import Products".
configuration spec: csv
Barcode,Item Name,Buying Price,Selling Price,Initial Stock,Category
6191101111,"Jogoo Maize Meal 2Kg",180,210,120,"Flour & Grains"
6191101112,"Unga Famila Sorghum 1Kg",145,175,80,"Flour & Grains"
6191101113,"Ilara Fresh Milk 500ml",55,68,200,"Dairy & Frig"
6191101114,"Pampa Sunflower Cooking Oil 1L",220,265,50,"Oils & Fats"

Important Deployment Checklist Tips

  • ▪Ensure item prices do not contain prefix characters such as "KSh" or commas in numerical values (e.g., enter 1550 instead of 1,550).
  • ▪Barcodes should ideally be represented as raw numbers. If some items do not possess natural barcodes, Tilloza can autogenerate unique EAN-13 barcodes for you on import.
All documentation
KRA Pin & Safaricom API assistance

Stuck with Daraja sandbox or eTIMS VSCU status?

Safaricom credentials and local electronic tax invoicing configurations can sometimes feel complicated. Tilloza core developers provide 1-on-1 virtual pairing calls completely free during your trial setup.

Contact Developer support