Import data

Upload a file - every row is checked and shown to you before anything is saved.

1 · Upload 2 · Check every row 3 · Preview & fix 4 · Confirm 5 · History & report

Drop a file here or click to choose

Excel (.xlsx), CSV (.csv), JSON (.json) or XML (.xml) · up to 5 MB · up to 5,000 rows

When a SKU already exists

Nothing is saved yet - you will see a preview first.

Practice files

12 rows each. Some rows are broken on purpose so you can see the checks at work.

XLSXExcel CSVCSV JSONJSON XMLXML

Tip: files you export from this app can be imported again (round trip).

What is checked (feature 87)

  • SKU required, 3-30 letters, digits or dashes, not twice in one file
  • Product name required, at most 120 characters
  • Category one of: Electronics, Home & Kitchen, Office, Sports, Toys, Beauty, Garden, Books
  • Price a number ≥ 0 (commas and $ are removed, more than 2 decimals is rounded)
  • Stock a whole number ≥ 0
  • Status ACTIVE, DRAFT or DISCONTINUED (empty = ACTIVE)
  • Supplier e-mail optional, must look like an e-mail address

Headers can be the field name (sku), the column title (Product name), a common alias (Qty, Item code) or a header from one of your templates.