Article

Bulk Product Import via CSV

Help Center / Product & Inventory Management / Bulk Product Import via CSV

Bulk Product Import via CSV

# Bulk Product Import via CSV

Save time by importing multiple products at once using our CSV template.

## Downloading the Template

1. Go to **Products** > **Import**
2. Click **"Download CSV Template"**
3. Open in Excel, Google Sheets, or similar

## Required CSV Columns

| Column | Description | Example |
|--------|-------------|---------|
| Handle | Unique product identifier | nike-air-max-270 |
| Title | Product name | Nike Air Max 270 |
| Body (HTML) | Description | High-performance running shoes... |
| Vendor | Your shop name | My Sports Store |
| Type | Product category | Shoes |
| Tags | Comma-separated keywords | running, athletic, nike |
| Published | TRUE or FALSE | TRUE |
| Option1 Name | Variant type | Size |
| Option1 Value | Variant value | 10 |
| Variant SKU | Stock code | NK-270-10-BLK |
| Variant Price | Price | 129.99 |
| Image Src | Image URL | https://.../image.jpg |

## CSV Best Practices

- Use **UTF-8 encoding**
- Do not use special characters in column headers
- Separate multiple tags with commas
- Use full image URLs (must be publicly accessible)
- Include http:// or https:// in all URLs
- Use TRUE/FALSE for boolean fields (not Yes/No)

## Preparing Your Images

- Upload images to a publicly accessible URL
- Recommended: Use image hosting or your own server
- Ensure images meet quality requirements
- Test image URLs before import

## Import Process

1. Save your CSV file
2. Go to **Products** > **Import**
3. Click **"Upload CSV"**
4. Select your file
5. Map any unmatched columns
6. Review the import preview
7. Click **"Import Products"**

## Import Limits by Plan

| Plan | Import Limit |
|------|--------------|
| Bronze | Manual entry only |
| Silver | 100 products per batch |
| Gold | Unlimited |

## After Import

- Check for any error messages
- Review imported products
- Edit any products that need adjustments
- Publish products when ready

## Common Errors

| Error | Solution |
|-------|----------|
| Missing required fields | Fill in all required columns |
| Invalid image URLs | Check URLs are accessible |
| Duplicate SKUs | Ensure unique SKUs |
| Malformed CSV | Check for special characters |

## Tips for Large Imports

- Break large files into smaller batches
- Test with 5-10 products first
- Check encoding is UTF-8
- Validate all URLs before importing