Add a product
Every field on the product form, which eight are required, and what Initial Stock actually does.
6 min read
Products and stock
Import your catalogue from a spreadsheet
Four different ways to bulk load products, the exact column order the classic import needs, and what happens to a bad row.
6 min readUpdated
The Product list toolbar carries four separate import buttons. Pick the one that matches what you actually have.
| Button | Use it when |
|---|---|
| Import product | You have a CSV and you can match its columns to ours |
| Smart CSV Import | You have a messy spreadsheet from another system |
| Scan Products | You have the stock in front of you and a USB scanner |
| Load Template | You are starting from nothing and want a head start |
Press Import product. The dialog is titled Import Product and it states the column order it expects, which you must follow exactly.
The order is image, name, code, type, brand, category, unit_code, cost, profit_margin, price, product_details, variant_name, item_code, additional_price. The ones marked with a star on screen are required: name, code, type, category, unit_code and cost.
- Download the Sample File from the dialog first and paste your data into it. That is the least error prone route.
- Upload CSV File takes the file, then press Submit.
- A file that is not a CSV is refused immediately with a message telling you to save your spreadsheet as CSV.
Categories, brands and units named in the file have to exist already. Create them first. The catalogue imports are read row by row, so a bad row part way down leaves the rows above it already saved rather than rolling the whole file back.
This is the one to use with a file exported from another system. Upload it and Stockovaa matches the brands, categories and units you already use, corrects obvious spelling slips and suggests a code. Nothing is saved until you confirm.
- Press Preview import to see what it worked out, with a Confidence column per row.
- Untick anything wrong, then press Import selected products.
- Files over 10 MB are refused. Split it and import in two goes.
Scan Products opens a box you point a USB scanner at. A barcode already on file fills the row in. One that is not is looked up, and you finish it by hand with a Name, Category, Cost and Price. Press Save scanned products when the shelf is done.
Load Template gives you a starter catalogue for a common kind of shop: Pharmacy, Supermarket, Fashion, Electronics or Restaurant. Choose one, press Show products, untick anything you do not sell and press Import selected products.
Products are not the only thing you can import. Customers, suppliers, billers, categories, brands, units, taxes, customer groups and warehouses each have their own Import button and their own Sample File, and each states its own column order in the dialog.
Purchases, sales and transfers import differently: one file becomes one document rather than one per row. The columns are read by position, not by name, and the first row is skipped as a header.
Every customer group named in a customer file has to exist already. A group that does not stops the import part way through, and the rows before it are already saved.
Read next
What to do when you reach a plan limit
Five things are capped by plan: locations, products, invoices, user accounts and employees. This is what each cap does when you meet it.
4 min read
Print barcodes and shelf labels
Queue up products, choose a paper size and print. Plus the one thing that clears your list without warning.
3 min read
Did this not solve it?
Open a support ticket from inside your dashboard and the whole conversation stays on one page. If you are not signed in yet, use the contact form.