Importing items from Excel
Bring hundreds of items in at once from a spreadsheet, and update them the same way later.
Most businesses arrive with a list already — a supplier file, an old system's export, a spreadsheet someone maintains. Typing it in again is the point at which people give up on a new system. The import takes that file, and because rows with an existing code update rather than duplicate, the same file can be used for bulk price changes later.
On Catalog → Items, download the import template. It carries the exact column headings the import expects; fill it rather than adapting your own layout.
One row per item: code, Arabic and English names, type, category and subcategory (by their Arabic or English name), base unit code, and whether it is active. Categories and units must already exist. The grey Arabic row under the headings is only a guide; the import skips it.
Upload the file. Valid rows are saved, and the result lists every rejected row with its reason — a code already used (also by a deleted item), an unknown unit or category — so you can fix those rows and re-upload only them.
Export to Excel on the items list exports the rows you have filtered, in the import's column order. The import only adds items — an existing code is reported, not updated. Prices live on price lists (Catalog → Price Lists): export a list's prices, edit them, and import the file back on that list.
Good practice
- Import in batches of a few hundred the first time. A rejected row is easier to find in 200 than in 3,000.
- The same export-edit-import loop works for suppliers, price lists and delivery zones. Imports of items, customers, suppliers, delivery zones, accounts, purchases and transfers check the file's headings against the template first and refuse a file whose columns differ, so keep the template's headings and column order.