Import and export items

Use Upload file on the Items page to create or update many items at once from a spreadsheet. You can also download your current items to edit and upload again.

Note

You only see Upload file if your role can create items. The import creates and updates products. It doesn’t set images, sizes, add-ons, modifiers, printers, sales time or stock. Set those on each item.

Import items

1. Open the import window

   On the Items page, click Upload file. The Import file - Products window opens.

2. Get a file to start from

   Do one of these:

   • Next to Download file products example, click Download to get an empty example file.
   • Next to Download existing product file, click Download to export your items. Nuvioo shows Downloading report is being processed. Please wait a moment. Your browser downloads the file when it is ready.

3. Fill in the file

   Keep the columns in the order shown in File columns. Row 1 is the header and is skipped. Add one item per row below it.

4. Choose the file

   Click the upload area or drag the file onto it. Only one .xlsx or .csv file works. Any other type shows You can only upload XLSX/CSV file!

5. Start the upload

   Click Start upload. The button is greyed out until you choose a file. When the file is accepted you see Upload file products successfully, and the window closes.

The import runs in the background. Check its result in Import history.

File columns

Nuvioo reads the first sheet and matches columns by position, not by the header text. Use this order.

Column	Required	What to enter
skuCode	No	The item’s SKU. If it matches an existing item, that item is updated. If it doesn’t, or the cell is empty, a new item is created.
name	Yes	The item name.
description	No	A description.
visibility	No	0 for Visible, 1 for Hidden, 2 for Unavailable. Empty means Visible.
price	No	The price in your currency, for example 12.50. It can’t be negative. Empty means 0.
tax	No	A tax rate in percent. It can’t be negative. Empty means the location’s tax rate. A comma works as the decimal mark.
categoryName	No	The name of an existing category. Capitals and accents are ignored. If no category matches, the item is imported without a category.

• If two rows have the same skuCode, the later row wins.
• The import is all or nothing. One invalid row stops the whole file, and no item is created or changed.
• The file needs the header row and at least one item row.

Import history

Below the upload area, a table lists the files you imported for items, 10 per page.

Column	What it shows
File name	The name of the file you uploaded.
Status	Success (received, waiting to run), Processing, Completed, Failed or Validation failed.
Download icon	Downloads the file you uploaded.

Completed means every row was imported. Validation failed means the file was rejected and nothing changed. Check the file against File columns, fix it, and upload it again.

Export items

The download next to Download existing product file is the only export on the Items page. The file uses the same seven columns and the same 0, 1, 2 visibility values as the import, so you can edit it and upload it again.

It exports products that are in a category, sorted by name. It doesn’t export add-ons, combos, services or products without a category. For sales and menu reports, see Menu performance.