Import your CSV into Shopify

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.

What you'll need

1Open Shopify Import

Log into your Shopify admin. Go to Products → Import (left sidebar). You'll see a screen that says "Import products by CSV file."

2Upload your CSV

Click "Choose file" and select the ShopiScout CSV you downloaded. Before clicking Import, check the box that says:

Do NOT check "Publish all products after import" unless you're sure. Import as drafts first — you want to edit titles, prices, and descriptions before anything goes live.

3Map the columns

Shopify will show you a column mapping screen. Here's how ShopiScout's nine columns line up:

ShopiScout columnMaps to Shopify field
Product titleTitle
PricePrice
Compare-at priceCompare-at price
VariantOption1 value / Option2 value
SKUVariant SKU
Availability(informational — not imported)
Image URLImage 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.

4Import

Click "Import products." Shopify will process the CSV and show you a confirmation. For 50–100 products this takes under a minute.

5What you get

Go to Products in your Shopify admin. You'll see all imported products as Draft (not published). Each product has:

Important: The image URLs point to the competitor's CDN. Before you publish, download those images and re-upload them to your own Shopify files. Don't hotlink someone else's images.

6Edit and publish

Go through your shortlist products one by one:

  1. Rewrite the title in your own words
  2. Adjust the price to hit your target margin (aim for 3× your supplier cost)
  3. Replace images with your own or download the competitor's and upload to Shopify
  4. Write a short description — don't copy the competitor's
  5. Set inventory to whatever you plan to stock
  6. Publish when ready

Troubleshooting

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.

That's it.

Scan → Filter → Import → Test. The whole loop takes an afternoon, not a week.

Get ShopiScout — $19.99/yr →