Importing Retailer Data
Overview
Stockisto supports two import methods: file upload (CSV or XLSX) and web scrape assist. Both methods route through the same review workflow before data is saved.
Download the CSV template
Download CSV templateThe template includes example data in the first row. Delete the example row before uploading your real data.
CSV/XLSX field reference
| Field | Required | Description | Example |
|---|---|---|---|
| name | ✅ | Retailer business name | Nordic Bath AB |
| address | ✅ | Street address | Drottninggatan 12 |
| city | ✅ | City | Stockholm |
| postal_code | ✅ | Postal/ZIP code | 111 51 |
| country | ✅ | ISO 3166-1 alpha-2 code | SE |
| phone | Phone number | +46 8 123 456 | |
| Contact email | shop@nordicbath.se | ||
| website | Website URL | https://nordicbath.se | |
| stock_status | Has stock (true/false) | true | |
| showroom_status | Has showroom (true/false) | false | |
| service_tags | Comma-separated tags | installation,warranty | |
| external_id | Your internal ID for deduplication | CUST-0042 |
Country codes
Use ISO 3166-1 alpha-2 codes: SE (Sweden), NO (Norway), DK (Denmark), FI (Finland), DE (Germany). A full list is available on Wikipedia.
Geocoding behavior
Stockisto geocodes each retailer by combining address + city + postal_code + country.
- If geocoding succeeds, a map pin is placed at the resolved coordinates.
- If geocoding fails (address not found), the row enters the review queue with a "Geocoding failed" warning. You can manually correct the address or approve the row without a pin.
- Geocoding uses Azure Maps in production (accurate for Nordic addresses) and OpenStreetMap in development.
Nordic address formatting
For best geocoding results, use the format your postal service uses. In Sweden: "Drottninggatan 12", not "Drottningatan 12" (note spelling). Accented characters (å, ä, ö) are supported.
Deduplication
Stockisto deduplicates by external_id if provided. If two rows have the same external_id, the second row updates the first.
Without external_id, deduplication is by exact name + address match.
The review workflow
After upload, every row enters the review queue regardless of geocoding success.
- Open Import → Review queue
- Each row shows the retailer details, geocoding result, and any warnings
- Click Approve to confirm, Edit to fix data, or Reject to discard
- Use Bulk approve to approve all rows without warnings at once
- Once all rows are approved, click Apply to save to your retailer network
Common errors
| Error message | Cause | Fix |
|---|---|---|
| "Required field missing: name" | Name column empty or misspelled | Check column header spelling |
| "Geocoding failed" | Address not found | Verify address; try adding postal code |
| "Duplicate external_id" | Same external_id appears twice | Check source data for duplicate IDs |
| "Invalid country code" | Country not ISO alpha-2 | Use 2-letter code (SE not Sweden) |
| "File too large" | File exceeds 10MB | Split into smaller files |
| "Unsupported file type" | Not .csv or .xlsx | Convert file to CSV or XLSX |
Web scrape assist
If your product page lists retailers (e.g. a "Find a dealer" page), Stockisto can extract retailer data:
- Go to Import → Web scrape tab
- Enter the URL of your dealer page
- Stockisto extracts names, addresses, and websites from the page
- Review each extracted row in the review queue and approve or reject
Scrape accuracy
Web scrape accuracy depends on the structure of your dealer page. Unstructured pages (e.g. embedded maps) may produce fewer results than structured lists.