Import Products from CSV
If you have product data in a spreadsheet, you can import it directly into Koru.Farm. The import process guides you through uploading, verifying, and importing your data.
When to Use CSV Import
CSV import is useful when:
- Migrating from another inventory system
- You have an existing spreadsheet with product data
- Adding a large number of products at once
CSV Format Requirements
Your CSV file must include these columns:
| Column | Required | Description |
|---|---|---|
name | Yes âś± | Product name |
category | Yes âś± | Product category (must match system categories) |
unit | Yes âś± | Unit of measurement (must match system units) |
sku | No | Product code (optional but recommended) |
Important: Category and unit values must match exactly what’s configured in Settings → Default Values. Unrecognized values will cause import errors.
Example CSV File
name,category,unit,sku
Tomato Seeds Roma,Seeds & Plants,Kilogram (kg),TOM-001
NPK Fertilizer 15-15-15,Fertilizers,Kilogram (kg),FERT-001
Copper Fungicide,Chemicals,Liter (L),CHEM-001
Harvesting Gloves,Tools & Supplies,Piece (pcs),TOOL-001Import Process
The import follows 4 steps:
Step 1: Upload CSV
- Go to Resources → Inventory
- Click the Import CSV button
- Download the template to see the required format
- Drag and drop your CSV file or click to browse
Step 2: Verify Columns
The system shows how your CSV columns map to product fields.
- Check that each column is correctly mapped
- Fix any unrecognized columns
- Required fields must be present
Step 3: Compare Data
Review the products that will be imported:
- See how many products will be created
- Check for any validation errors
- Review category and unit matching
Step 4: Import
Confirm the import to add all products to your catalog.
- Products are created immediately
- You’ll see a summary of imported items
- Any errors are reported for review
Import Instructions
Follow these guidelines for successful imports:
- Each row represents one inventory product
- Name, category, and unit are required fields
- SKU is optional but recommended for organization
- Product names should be descriptive and unique
- Category must match one of your configured inventory categories
- Unit must match one of your configured inventory units
Troubleshooting
Category Not Recognized
If a category shows an error:
- Check the exact spelling in Settings → Default Values
- Ensure your CSV uses the same category name
- Category names are case-sensitive
Unit Not Recognized
If a unit shows an error:
- Check available units in Settings → Default Values
- Use the exact format including symbol (e.g., “Kilogram (kg)”)
- Unit names must match exactly
Duplicate Products
The system will warn you if:
- A product with the same name already exists
- A SKU code is already in use
You can choose to skip duplicates or update existing products.
Tip: Download the template first to see the exact format required. This prevents most import errors.
After Import
Once products are imported, you can:
- View them in the Products List
- Edit individual products to add brand and notes
- Start using them in activities
Next Steps
- Viewing Products — See your imported products
- Edit and Delete — Update product details
- Adding a Product — Add additional products manually