How Do I Import Products from CSV?
The CSV import tool lets you bulk-upload products, saving hours of manual data entry.
Step 1: Prepare Your CSV
Your CSV file should include at minimum a Name and SKU column. Supported columns include:
| Column | Required | Example |
|---|---|---|
| name | Yes | "Blue Widget" |
| sku | Yes | "BW-001" |
| barcode | No | "012345678901" |
| category | No | "Widgets" |
| cost | No | "12.50" |
| weight | No | "0.5" |
| reorder_point | No | "10" |
Step 2: Upload
- Go to Products
- Click Import CSV in the top right
- Select your CSV file
- Choose or create an Import Template to save your column mapping for future imports
Step 3: Map Columns
The importer will auto-detect common column names. For any unrecognized columns, manually map them to WareSquared fields using the dropdown menus.
Step 4: Preview & Confirm
Review the preview showing the first several rows of data. Check that:
- Column mappings are correct
- Data looks right in the preview
- No duplicate SKUs will be created
Click Import to begin processing.
Step 5: Review Results
After import, you'll see a summary showing:
- Products created
- Products updated (if SKUs matched existing products)
- Rows skipped (with error details)
Tip: Save your column mapping as an Import Template so you can reuse it for future imports from the same supplier or system. Go to Products → Import Templates to manage saved mappings.