How to Import Products in Shopify at Once (Bulk CSV Upload Guide)

Adding products one by one is fine for five items. For fifty or five hundred, it wastes days. Shopify lets you import products in bulk using a CSV file — a simple spreadsheet format. This guide explains exactly how to prepare it and avoid the errors that trip most people up.

Step 1: Download Shopify's sample CSV

Go to Products in your Shopify admin and click Import. In the import window you will find a link to download a sample CSV template. Always start from this template (or from an export of your own store) so the column headings match exactly what Shopify expects.

Tip: The easiest way to understand the format: create one product manually with variants and images, then use Export on the Products page. Open that file — it shows you precisely how Shopify structures your kind of product.

Step 2: Understand the key columns

• Handle — the unique identifier that becomes part of the product URL, e.g. silver-hoop-earrings. Rows with the same handle belong to the same product.
• Title — the product name. Fill it only on the first row of each product.
• Body (HTML) — the description. You can use basic HTML such as paragraphs and lists.
• Vendor, Type, Tags — used for organising and for automated collections.
• Option1 Name / Option1 Value — variant options such as Size: Small.
• Variant Price, Variant SKU, Variant Inventory Qty — price, stock code and stock level for each variant.
• Image Src — a public URL to the product image.
• Status — active or draft.

Step 3: Handling variants correctly

Each variant is its own row. The first row holds the product details (title, description, vendor) and the first variant. The following rows repeat only the Handle and the variant-specific columns.

Handle,Title,Option1 Name,Option1 Value,Variant Price,Variant SKU
cotton-tee,Cotton T-Shirt,Size,S,499,TEE-S
cotton-tee,,,M,499,TEE-M
cotton-tee,,,L,549,TEE-L

Step 4: Adding images

Shopify downloads images from the URLs in the Image Src column, so each URL must be publicly accessible. A common approach is to upload images first to Content → Files in Shopify, copy their URLs, and paste them into the CSV. For multiple images, add extra rows with the same handle and a new Image Src (and optionally Image Position).

Step 5: Save the file as UTF-8 CSV

In Google Sheets use File → Download → Comma-separated values. In Excel choose CSV UTF-8. The UTF-8 encoding matters if your text contains symbols such as ₹, accents or emojis — otherwise they may appear as strange characters.

Step 6: Import and review

1. On the Products page click Import and choose your file.
2. Decide whether to overwrite products that have the same handle.
3. Review the preview Shopify shows, then start the import.
4. Shopify emails you when the import finishes. Open a few products and check variants, prices, images and inventory.

Common errors and how to fix them

• "Missing column" or "invalid header": a column name was changed. Copy headers exactly from the template.
• Variants show as separate products: the handles do not match exactly — check spaces and capital letters.
• Images missing: the image URLs are private, broken or behind a login.
• Garbled characters: the file was not saved as UTF-8.
• Inventory not updating: inventory tracking settings or location columns may need attention; check your store's inventory settings.

Note: Test with a small file of five products before importing your whole catalogue. Fixing five products is quick; fixing five hundred is not.

Once products are in, spend time on the pages that sell them. Our guide to Shopify product page optimisation shows what to improve first.

Working in Google Sheets vs Excel

Google Sheets is often easier for CSV work because it handles UTF-8 well and lets you collaborate with a team. Excel is fine too, but it sometimes changes long numbers (like barcodes) into scientific notation. Format barcode and SKU columns as text before pasting data.