Skip to main content

Importing Products via CSV

CSV import is the primary way to add products if you're not using Salsify.

How to Import

  1. Go to Products → click Import Products

  2. Download the CSV template or Excel template (pre-formatted with all column headers). The Excel template ships with an Instructions tab as the first sheet — a table of every field with required/optional flag, description, format rules, and an example. Each header cell in the data sheet also has a hover comment with the same info.

  3. Fill in your product data

  4. Upload the CSV file

  5. Review the validation preview — green rows are ready, red rows have errors

  6. Fix any errors and re-upload, or proceed with valid rows

  7. Click Commit Import

Required Columns

  • name — Product name

  • sku — Unique product identifier

  • mapPrice — Minimum Advertised Price (numeric, e.g., 29.99)

Optional Columns

msrp, asin (Amazon), gtin, upc, walmartItemId, category, brand

Import Behavior

  • New products (SKU not in database): Created

  • Existing products (SKU already exists): Updated

  • Duplicate SKUs in CSV: Last row wins

Example

name,sku,mapPrice,asin,walmartItemId
"Widget Pro 3000",WP-3000,29.99,B08XYZ1234,123456789

Tips

  • Save as UTF-8 for special characters

  • No $ symbol in prices

  • Maximum 10,000 rows AND 10 MB per file (enforced by the API)

Did this answer your question?