Products

How to import products from Excel or CSV

Import products from an Excel or CSV file into Trakr Inventory: download the template, match your columns, check for problems and confirm.

Where in the web app
ProductsProduct CatalogActionsImport ProductsExcel / CSV
Who can do this
Anyone with access
Read time
6 min11 steps · 2 figures
Last updated
Web app v5.0.183
On this page Before you start

If you already keep your products in a spreadsheet, you do not need to type them in one by one. This article walks you through the four-step import wizard.

Before you start

  • Your file needs two things for every row: a SKU and a Product Name. Everything else is optional.
  • You need permission to add and edit products. If you do not see Import Products, ask an administrator.

Import your file

  1. Go to Products > Product Catalog.
  2. Click Actions, then Import Products, then Excel / CSV. The Product Import wizard opens.
counting.trakrsuite.com
The Actions menu with the Import Products submenu open, listing Excel / CSV, QuickBooks and Unleashed.Enlarge
Choose Excel / CSV from the Import Products submenu.
  1. 1Actions
  2. 2Import Products
  3. 3Excel / CSV

Upload your file

  1. New to this? Click Review/Download Template to get a ready-made Excel file with the right column headings. Required headings are marked in red.
  2. Drag your file onto the box, or click browse and pick it. The file types supported are XLSX, XLS and CSV.
  3. When the file is added, the column headings it contains appear as small chips. Click Next.
counting.trakrsuite.com
The Product Import wizard on step 1, with the four step tabs, a template download button and an upload box.Enlarge
The four steps: Upload CSV/Excel, Column Mapping, Validating Upload, Complete.
  1. 3Review/Download Template
  2. 4Upload box
  3. 5Next

Match your columns

  1. Each Trakr field is listed with a drop-down labelled Select a column. Trakr fills in the ones it recognizes and shows a green tick, with a small preview of the first rows from your file.
  2. For any field that is empty, open the drop-down and choose the matching column from your file. Fields with no match show No Value Set.
  3. SKU and Product Name are required (marked with a star). Click Next.

The fields you can map include Product Description, Product Barcode, Brand, UOM, Category, Cost Price, Retail Price, Tags, your minimum levels, your custom fields, Storage Paths and, if the Asset Module is on, Is Asset and Asset Number.

Check for problems

  1. Trakr checks the file and lists problems in tables: Missing or Duplicate SKUs in your file, Duplicate Barcodes in your file and Empty Products Names in your file. Each row shows the row number from your spreadsheet.
  2. Fix the problems in your spreadsheet and start again. When all is well you see “It’s all good!” Click Confirm Import.

Finish

  1. A summary lists the products imported successfully and any that failed. Click View Product Catalog to see them.

Good to know

  • Storage Paths are matched to storage places that already exist. Paths Trakr cannot find are skipped, and Trakr tells you which.
  • An existing SKU is updated, not duplicated.
  • If your plan allows only one barcode per product, Trakr warns you when your file has several for one product.

Something went wrong? See Import errors.

Common questions

Which file types can I upload?

Excel (.xlsx or .xls) and CSV. Upload one file at a time.

What if my column headings do not match yours?

That is fine. Trakr matches headings it recognizes automatically, and in the Column Mapping step you choose the right column for each field yourself.

What happens if a SKU in my file already exists in Trakr?

The existing product is updated with the values from your file instead of being duplicated. Duplicate SKUs inside the same file are flagged before anything is imported.

Can I undo an import?

There is no one-click undo. Check the Validating Upload step carefully. Products can be removed afterwards from the Product Catalog.

Still stuck? A real person will help.

We answer within one business day. Include your company name and what you clicked, and we can usually fix it in one reply.

Reply within one business dayCanadian support team