Printed from https://zeropos.shop/help/import-products
Import your product list
Bring many products in at once from a spreadsheet. You read a row-by-row preview first, and nothing is written until you press Import.
Owners can change what each role may do.
The importer reads a spreadsheet of products, shows exactly what it would do, and then applies the whole file in one go, or nothing at all.
When to use it
For a list of products. A single product is quicker in Products and stock; past sales come in with Import past sales.
Before you start
- Your shops exist, with the names you will use in the stock columns (Add a shop or storage location).
- You know how your shop charges VAT: the page says what Price means for you, and How prices and tax work: VAT or sales tax explains the modes.
Steps
Prepare the file
- Step 1
Open BACKOFFICE › Inventory › Products and tap Import.
- Step 2
Tap Download template and open it in your spreadsheet app.
- Step 3
Fill in one row per product. “Name” and “Price” are required; every other column is optional.
- Step 4
In each Stock column, type the opening quantity at that shop.
- With several shops, leave it blank where a shop doesn't sell the product; type 0 where it does but has none yet.
- Step 5
Delete the template's example rows and save the file as .xlsx or .csv.
- A .csv that Excel saved in Spanish, with semicolons between cells and decimal commas, imports as it is.
Check and import
- Step 6
Under 2. Upload the filled-in file, tap Choose file and pick your spreadsheet.
- Step 7
Leave Also update products that already exist (matched by SKU) unticked, unless you mean to overwrite existing products.
- Step 8
Tap Preview and read each row: Will add, Will update, Skipped or Problem.
- Step 9
If any row has a problem, fix it in the file, then choose the file again and preview.
- Step 10
Tick the confirmation box and tap the import button, which says how many products it will write.
What happens next
- New products appear in the Products list and on the till straight away. Their Stock figures become each shop's opening stock.
- Products that already existed take the file's price, minimum price, cost and details. Their stock never changes: correct it with Correct stock by hand (Stock adjust).
- The page shows Import complete, with Undo this import in case something is wrong.
Questions
My old system calls the price column something else. Will it still work?
How do I undo an import?
What happens if I leave the SKU empty?
How do I give a product several categories?
What if a barcode in the file is already on another product?
Is there a size limit?
If you see this…
On screen
The first row doesn't match the expected columns. Check it against the list in step 1.
What to do
Keep the template's heading row, with at least a Name and a Price column, and preview again.
On screen
A product with this SKU already exists, so the row is skipped. Tick the option in step 2 to update it instead.
What to do
If the file should replace that product's details, tick Also update products that already exist (matched by SKU) and preview again. Otherwise leave it: the row is simply skipped.
On screen
This exact file was already imported, so nothing was changed. Edit it and upload it again if there is more to do.
What to do
The same file can't be applied twice. Add or change rows in it first, then upload it again.
On screen
Cost price ignored — your role can't set cost prices.
What to do
The rest of the row still imports. Ask an owner to add the cost prices, or to import the file.
On screen
The file changed since the preview. Preview it again before importing.
What to do
Tap Preview again, check the rows, then import.
Good to know
- Try a few rows first: import them, check them on the till, then import the rest.
- A blank minimum price means the same as the price.