Powered by Smartsupp
Import products to Shopify — the right way

Import Products to Shopify
Using CSV Files

Stop fighting CSV errors. Get a perfectly formatted Shopify CSV file in seconds — or follow our complete guide to master the import process.

No credit card requiredPerfect Shopify CSV formatFirst 5 products free
shopify.com/admin/products/import
Shopify CSV import interface showing successful product import
Why choose ProdSift

The fastest way to get products
into your Shopify store.

Import in Minutes

Stop spending hours on manual data entry. Get your products live on Shopify faster than ever.

Perfect CSV Format

No more CSV errors. Our tool generates files that Shopify accepts on the first try.

Complete Product Data

Titles, prices, variants, images, SKUs, descriptions — everything Shopify needs.

No Risk, No Setup

Works in your browser. No API keys, no store access required. First 5 products free.

How to import products to Shopify
in 3 simple steps

01

Generate Your Shopify CSV

Use ProdSift to extract products from any store and generate a perfect Shopify-ready CSV file.

02

Upload to Shopify

Go to Products → Import in your Shopify admin. Select your CSV file and choose import settings.

03

Review & Publish

Shopify validates your file. Review the summary, confirm, and your products go live.

CSV Format Reference

Every Shopify CSV field
explained.

Understanding Shopify's CSV format is key to successful imports. Here's every field you need to know — or just use ProdSift to skip the manual work entirely.

Pro Tip: The most common import errors come from missing required fields or incorrect formatting. Our tool generates perfectly formatted Shopify CSVs every time.

Generate a perfect Shopify CSV file

Shopify CSV Fields

HandleRequired
Unique URL-friendly identifier
TitleRequired
Product name
Body (HTML)
Product description
Vendor
Brand name
Type
Product category
Tags
Comma-separated product tags
Published
TRUE = live, FALSE = draft
Option1 Name
Size, Color, Material, etc.
Option1 Value
Option value (Small, Red, etc.)
Variant SKU
Inventory tracking code
Variant PriceRequired
Product price
Variant GramsRequired
Weight in grams
Image Src
Product image URL
SEO Title
Custom page title
SEO Description
Meta description

Everything you need for
successful Shopify imports

ProdSift handles the hard part — you just download and import into Shopify.

Ready-to-import CSV

Export files formatted perfectly for Shopify's import system. Just download and upload.

All Variants Included

Size, color, material — every product variant preserved in your CSV export.

Product Images

Image URLs included and formatted correctly. Shopify downloads them automatically on import.

SEO Fields Mapped

SEO titles, descriptions, and handles — all properly structured for Shopify.

Bulk Import Ready

Import hundreds or thousands of products at once. No 15MB CSV errors.

Shopify Format Only

Specifically designed for Shopify's CSV requirements. Every field matches Shopify's spec.

Use Cases

Perfect for Shopify merchants,
agencies, and store owners

Store Migration

Moving from WooCommerce or another platform? Extract and import directly to Shopify.

Bulk Product Import

Need to add hundreds of products at once? Generate a perfect CSV and import in one go.

Product Updates

Update prices, inventory, or descriptions across thousands of products with one CSV.

Agency Work

Build client Shopify stores faster. Stop manual data entry — extract and import.

Complete step-by-step Shopify import guide
with screenshots

Follow these detailed instructions to import your products into Shopify successfully

1

Access Product Import Page

Navigate to the Shopify import tool

From your Shopify admin dashboard, navigate to Products in the left sidebar, then click the Import button in the top right corner.

Navigate to Shopify Products page and click Import button

Path: Shopify Admin → Products → Import

2

Upload Your CSV File

Select and upload your properly formatted CSV

Click Add file and select your CSV file. Ensure the file is properly formatted and under 15MB.

Select your CSV file and click Upload and continue in Shopify
File must be .csv format
Maximum file size: 15MB
Use UTF-8 encoding
3

Configure Import Settings

Choose your Shopify import options carefully

Publish to all sales channels

Checked (default): Products appear on all sales channels (online store, Facebook, Instagram, etc.)

Unchecked: Products only appear on your online store. Manually add to other channels later.

Overwrite products with matching handles

Checked: Updates existing products that have the same handle. All columns in CSV overwrite existing data.

Unchecked: Skips products with matching handles. Only adds new products.

⚠️ Warning: This overwrites ALL data for matching products, including fields not in your CSV. Always backup your Shopify store before using this option.

4

Review and Confirm

Check the Shopify import summary before finalizing

Click Upload and continue. Shopify will analyze your file and show you a preview of what will be imported.

Review the Shopify import summary carefully:

  • • Number of products to be added
  • • Number of products to be updated (if overwrite is enabled)
  • • Any errors or warnings detected by Shopify
5

Complete the Import

Finalize and monitor your Shopify product import

Click Import products to start the import process into Shopify.

Shopify products successfully imported - edit title, description, price, and other details

Important: Product imports cannot be cancelled once started. Make sure everything is correct before clicking Import.

You'll receive a confirmation email at your Shopify admin email address when the import completes. After import, you can edit product titles, descriptions, prices, and other details from the Shopify Products page.

Avoid these common
Shopify CSV import errors

Invalid CSV format

Verify all required headers (Handle, Title, Variant Price, Variant Grams) are present and spelled correctly. Save with UTF-8 encoding.

Missing product images on Shopify

Use direct image URLs (not Dropbox/Google Drive). Ensure URLs are publicly accessible so Shopify can download them.

CSV file too large (over 15MB)

Split your Shopify CSV into multiple files under 15MB each. Import in batches of 1,000-2,000 products.

Product variants not importing to Shopify

Ensure Option1 Name is consistent for all variants. First row needs Option1 Value = 'Default Title' for simple products.

Excel corrupts the Shopify CSV

Use Google Sheets instead of Excel. If using Excel, format all columns as 'Text' before saving as CSV UTF-8.

Products overwritten unexpectedly in Shopify

Always export your current Shopify products as backup first. Use unique handles for new products. Test with 5-10 products first.

Best Practices

Pro tips for
flawless Shopify imports

Follow these best practices to ensure your Shopify product imports succeed every time.

Always backup your existing Shopify products before importing
Test with 5-10 products first before full import to your Shopify store
Use UTF-8 encoding for all CSV files going into Shopify
Keep CSV files under 15MB or split into batches for Shopify
Use direct image URLs from your CDN or server for Shopify to download
Validate handles are unique, lowercase, and use hyphens for Shopify URLs

Skip the manual work

Generate a perfect Shopify CSV in seconds

No need to learn Shopify's CSV format, worry about required fields, or debug import errors. ProdSift handles everything for you.

Generate Your Shopify CSV Free

First 5 products free. No credit card required.

Ready to import products
into your Shopify store?

Stop fighting CSV errors. Generate a perfect Shopify-ready CSV file in seconds — try it free.

Used by Shopify professionals to scrape products in minutes.