CSV Import
Bulk import competitors using a CSV spreadsheet.
All plans CSV import is available on all plans.
CSV Format
Your CSV file should have the following columns:
product_sku,competitor_name,competitor_url,competitor_price
| Column | Required | Description |
|---|---|---|
product_sku |
Yes | Your product SKU or barcode to match |
competitor_name |
No | Name for the competitor (e.g., "Competitor A") |
competitor_url |
Yes | Full URL to the competitor's product page |
competitor_price |
No | Initial price (will be updated automatically on next scrape) |
Example CSV
product_sku,competitor_name,competitor_url,competitor_price
SKU-001,Competitor A,https://www.competitor-a.com/products/product-name/123456,49.99
SKU-002,Competitor B,https://www.competitor-b.com/product/123456/product-name.html,59.95
SKU-003,Competitor C,https://www.competitor-c.com/p/product-name/789012,45.00
How to Import
-
Go to Competitor Search
Navigate to the Competitor Search page. -
Click the "CSV Import" tab
You'll see the import interface. -
Download the template (optional)
Click "Download Template" to get a pre-formatted CSV. -
Prepare your CSV
Fill in your competitor data in Excel or Google Sheets. -
Upload the file
Drag and drop or click to select your CSV file. -
Review and import
Preview the data, then click "Import".
Import Results
After import, you'll see:
- Imported: Successfully added competitors
- Skipped: Duplicates or products not found
- Errors: Invalid URLs or data format issues
Product Matching
Products are matched by SKU first, then barcode, then partial title match.
Products are matched by SKU first, then barcode, then partial title match.
Tips
- Use complete URLs including
https:// - Ensure SKUs match exactly (case-sensitive)
- Use European number format for prices (
49,99or49.99) - Save as CSV with UTF-8 encoding for special characters