@extends('layouts.app') @section('title', 'Import Products - Excel') @section('content')
Import Products (Excel)
Bulk Import Products

Upload an Excel file (.xlsx) to import multiple products at once.

@if(session('success'))
{{ session('success') }}
@endif @if(session('error'))
{{ session('error') }}
@endif @if($errors->any())
    @foreach($errors->all() as $err)
  • {{ $err }}
  • @endforeach
@endif
@csrf
Only .xlsx or .xls files allowed. Max 10MB.
Please select your file and use the Save icon in the top action bar to begin the import.
Required Excel Format

Download our standardized template to ensure all mandatory fields are correctly mapped.

Download Template (.xlsx)
Column Required? Notes
code ✓ Unique SKU
name ✓ Product Name
category ✓ Category name
unit_price ✓ Number (LKR)
unit_of_measure Each/Box/Case/Carton
brand Optional
reorder_level Number, default 0
description Optional text
@endsection