How to Import a CSV Into Your Shopify Store

A Shopify CSV import is a bulk file upload that lets you add or update hundreds of products at once without entering each one manually, saving hours of work and reducing data entry errors.

You've got a spreadsheet with 200 products. Your old system is offline. You're building a brand-new store. Manually entering each product would take weeks. CSV import exists for this exact scenario — upload one file and your entire inventory appears in minutes. But it requires precision. One wrong column header or special character can stall the whole upload.

Where to Find the Import Tool

Log into your Shopify admin and navigate to Products > Import. Click Add file and select your CSV. Shopify accepts files up to 15MB, which comfortably handles 5,000–10,000 products for most boutiques.

You can also download a CSV template by going to Products > All Products, clicking the three-dot menu, and selecting Export. This generates a file with exactly the columns Shopify expects — use it as your starting template.

Required and Recommended CSV Columns

Only two columns are required: Handle and Title. The handle is your product's URL slug (e.g., "blue-leather-jacket"). The title is the product name customers see. Everything else is optional but essential for a complete, sellable product.

Image URLs Must Be Publicly Accessible

Many imports fail because of broken image links. Your image path must be a complete URL starting with https:// — not a local file path like C:\Users\jacket.jpg. Upload all product images to cloud storage (AWS S3, Google Drive with public links, or your existing CDN) and paste the full HTTPS URL in the Image Src column.

For multiple images per product, create separate rows with the same handle but different image URLs. Shopify merges rows sharing a handle into one product with multiple photos.

Preventing Duplicates

The handle controls duplicate behavior. By default, importing a product with an existing handle creates a second listing — this causes problems. Check "Overwrite current products with same handle" if you're updating existing products. Leave it unchecked when adding entirely new products.

Before importing, export your current catalog and compare handles. Ensure your import file doesn't contain duplicate handles within itself. This single step prevents the most common CSV import headaches.

Formatting Rules That Prevent Errors

Avoid special characters like unescaped quotes and commas in product fields. If a description contains commas, wrap the entire field in quotes: "Premium leather, water-resistant, Italian-made". Remove blank rows, extra spaces, and merged cells before saving as CSV.

Export from Excel or Google Sheets as .csv format — not .xlsx. Verify that non-English characters (accents, symbols) export correctly, as some software mangles Unicode on export.

After Upload: Reviewing Your Import

Shopify sends a summary email after import showing how many products were created, updated, or failed. Failed rows include error details — typically invalid handles, missing titles, or broken image URLs. Fix these in your CSV and retry.

Important: CSV import cannot delete products. To remove items, use bulk actions in the Products section or the Shopify API.

When to Get Professional Help

For boutiques with complex data — multiple images per variant, long formatted descriptions, detailed variant matrices — CSV imports get tedious and error-prone fast. Goodness Logic prepares and executes Shopify CSV imports for independent retailers, handling column mapping, URL validation, and troubleshooting so your store goes live on schedule.

Need help with your CSV import? Contact Goodness Logic and get your catalog live in days, not weeks.