Import books from Excel
Upload .xlsx, .xls or .csv. Existing books matched by ISBN have their stock increased; new ones are created.
Expected columns (any order, case-insensitive)
| Column | Required | Notes / aliases |
|---|---|---|
title | Yes | name, book |
author | No | |
isbn | No | used to detect duplicates |
publisher | No | |
category | No | |
costPrice | No | cost, cp |
sellPrice | No | price, sp, mrp |
quantity | No | qty, stock |
billNumber | No | billNo, bill |
supplier | No | distributor (auto-creates supplier) |