You've scanned a competitor, filtered the junk, and picked your shortlist. Here's how to get those products into your Shopify store as drafts — ready for you to edit and publish.
Log into your Shopify admin. Go to Products → Import (left sidebar). You'll see a screen that says "Import products by CSV file."
Click "Choose file" and select the ShopiScout CSV you downloaded. Before clicking Import, check the box that says:
Shopify will show you a column mapping screen. Here's how ShopiScout's nine columns line up:
| ShopiScout column | Maps to Shopify field |
|---|---|
| Product title | Title |
| Price | Price |
| Compare-at price | Compare-at price |
| Variant | Option1 value / Option2 value |
| SKU | Variant SKU |
| Availability | (informational — not imported) |
| Image URL | Image Src |
| Product URL | (reference — not imported) |
| Source collection | (reference — not imported) |
If a column doesn't auto-map, just select the right Shopify field from the dropdown. Shopify remembers your mapping next time.
Click "Import products." Shopify will process the CSV and show you a confirmation. For 50–100 products this takes under a minute.
Go to Products in your Shopify admin. You'll see all imported products as Draft (not published). Each product has:
Go through your shortlist products one by one:
Import failed? Make sure the CSV is UTF-8 encoded (ShopiScout exports UTF-8 by default). Don't open and re-save the file in Excel — Excel can corrupt the encoding.
Products imported as duplicates? Shopify matches products by handle. If you're re-importing, use the same CSV or delete the old drafts first.
Images not showing? Some Shopify stores block hotlinked images. Download and re-upload.
Scan → Filter → Import → Test. The whole loop takes an afternoon, not a week.
Get ShopiScout — $19.99/yr →