When to use bulk import
Use bulk import when you are setting up AADOPS for the first time with many existing products, or when you want to update prices, costs, or stock levels across a large number of items at once.
Step 1 — Download the import template
Go to Inventory → Products. Click Import. Download the template file — this gives you a spreadsheet with the exact column headings AADOPS expects.
Step 2 — Fill in the template
Open the file and fill in one row per product. The key columns are:
- Name — product name (required)
- Product code — your SKU or barcode number. Leave blank to auto-generate.
- Category — must match a category name that already exists in AADOPS
- Brand — must match a brand name that already exists
- Unit — must match a unit name that already exists
- Product cost — your cost price in numbers only
- Product price — your selling price in numbers only
- Stock alert — your reorder point quantity
- Quantity — opening stock quantity
- Warehouse — the warehouse name to assign this stock to
Step 3 — Upload the file
Go back to Inventory → Products → Import. Upload your completed file. AADOPS validates the data and shows a preview. Rows with errors are highlighted — fix them before importing.
Step 4 — Confirm the import
Click Import. All valid rows are created as products immediately.
Note: Categories, brands, units, and warehouses referenced in your import file must already exist in AADOPS before you import. Create them first, then run the import. A row that references a non-existent category will fail validation.