Shopify CSV Import Export Guide

Step-by-step how-to guide for importing and exporting Shopify products via CSV, including column requirements, best practices, and multi-store workflows.

Updated 2026-06-20

Whether you're launching a store with hundreds of products, updating inventory across variants, or migrating from another platform, mastering Shopify's CSV import and export process can save you hours of manual work. In this guide, we'll walk through the exact steps, column requirements, and practical tips to handle your product data smoothly—and show you how tools like StoreFleet can streamline bulk operations when you manage multiple stores.

Why CSV Import and Export Matter

CSV (Comma-Separated Values) files are the backbone of bulk product management in Shopify. Instead of adding products one by one through the admin dashboard, you can:

• Import dozens or hundreds of products at once
• Update product details, prices, and inventory in bulk
• Export your current product catalog for backup, analysis, or editing
• Sync product data with external systems or spreadsheet tools
• Move products between Shopify stores

For multi-store operators, this becomes critical. Managing inventory, pricing, and metadata across 5, 10, or 50+ stores manually is a coordination nightmare. That's where efficient CSV workflows and specialized tools come in.

Exporting Products from Shopify: Step-by-Step

Exporting your products is the safest place to start—you're working with data you already own and can practice the format without the risk of overwriting live products.

1. Navigate to Products and Select Export

Log into your Shopify admin, go to Products, and click the Export button (usually in the upper right corner).

2. Choose Which Products to Export

Shopify lets you select:

• Current page — only the products visible on your current screen
• All products — your entire catalog
• Selected products — if you've checked individual products
• Filtered products — if you've applied filters (by collection, status, vendor, etc.)

3. Choose Your CSV Format

Shopify offers two CSV export options:

• Spreadsheet CSV — use this if you plan to edit in Excel, Google Sheets, or similar tools; this format is easier to read and edit
• Plain text CSV — use this if you're editing in a text editor or feeding the file into a custom system

Both formats use UTF-8 encoding (required by Shopify).

4. Download or Receive Your File

For small exports (current page or selected products with typical variant counts), the CSV downloads directly to your computer. For very large exports, Shopify emails the file to your account email instead.

Important caveat: If you're going to edit the CSV in a spreadsheet program and re-import it, do NOT sort the columns. Sorting can break the association between product variants and their details or image URLs.

Understanding Shopify CSV Columns

When you export a product, your CSV will contain standard product and variant columns. The exact set of columns depends on your store's configuration (markets, metafields, custom fields, and Google Shopping settings). You don't need to use all of them when importing—only the required and relevant ones. Here are the key columns:

Required Columns

• Title — product name (required for new products)
• Handle — URL-friendly identifier (required when adding variants to an existing product; generated from title if omitted)

Core Product Information

• Body (HTML) — product description; supports HTML formatting
• Vendor — manufacturer or supplier name
• Type — product category or classification
• Tags — comma-separated tags for organization and filtering
• Published — whether the product is visible in your store (true/false)

Variant Details (one row per variant)

• Option1 Name / Option1 Value — first variant option (e.g., Color, Size) and its value
• Option2 Name / Option2 Value — second variant option
• Option3 Name / Option3 Value — third variant option
• Variant SKU — stock-keeping unit for inventory tracking
• Variant Price — selling price for that variant
• Variant Compare at Price — original or crossed-out price (shows discount visually)
• Variant Weight — shipping weight
• Variant Inventory Qty — current stock level
• Variant Inventory Tracker — set to "shopify" to enable Shopify's built-in tracking

Image Columns

• Image Src — full URL to the product image
• Image Alt Text — alternative text for accessibility

Note: when you export, the actual image files are not included in the CSV—only the URLs pointing to them.

Importing Products: Step-by-Step

1. Prepare Your CSV File

Before importing, ensure:

• UTF-8 encoding — save as UTF-8, not ANSI or other encodings (this prevents special character corruption)
• Column headers match exactly — Shopify is case-sensitive; use Handle, not handle; Variant Price, not variant price
• File size under 15 MB — this is Shopify's hard limit
• Only required columns present — at minimum, Title (for new products) or Title + Handle (for updates)

You can download Shopify's official sample CSV file from the Shopify Help Center to ensure your column headers are correct.

2. Go to Products and Click Import

In your Shopify admin, navigate to Products and click the Import button.

3. Select Your CSV File

Click Choose file and select your prepared CSV.

4. Configure Import Settings

Shopify will show you options:

• Publication scope — decide if you want imported products published automatically or saved as drafts
• Overwrite existing products? — if you're updating products with the same handle, enable this option; if you're adding new products only, leave it disabled

5. Upload and Confirm

Click Upload and continue. Shopify will preview your data. Review the preview carefully for any errors, then click Import products to proceed.

Warning: Once import begins, you cannot cancel it. Make sure your data is correct before confirming.

What Happens After Import

• New products are added to your catalog
• If you enabled overwriting, existing products matching the handles are updated
• Variants are created or updated according to your CSV
• Inventory quantities are set as specified

Key Rules and Gotchas

Case Sensitivity

Column headers are case-sensitive. Handle works; handle doesn't. Download Shopify's sample file if you're unsure.

Variant Organization

Each product's first row contains all product-level data (title, description, vendor, tags). Subsequent rows for that same product contain only variant-specific data. The Handle in every row must match so Shopify knows which variant belongs to which product.

Images and URLs

Image URLs must be complete and publicly accessible. Shopify won't copy local files into your store.

Inventory and Inventory Tracking

If you enable inventory tracking with Variant Inventory Tracker set to "shopify", the quantity you specify in Variant Inventory Qty becomes the stock level. Be careful when re-importing—you can overwrite inventory if you're not intentional.

Variant Options and IDs

Changing variant option values (e.g., changing "Small" to "Medium") deletes and recreates the variant, losing its unique ID. This can break third-party integrations that track variants by ID. Always test on a draft or test store first.

No Bulk Delete

CSV imports cannot delete products. You must delete products through the Shopify admin or API if needed.

Bulk Operations Across Multiple Stores

If you manage multiple Shopify stores, repeating this CSV workflow for each store becomes tedious. This is where bulk product management tools make a real difference.

StoreFleet lets you push CSV updates across multiple stores from a single dashboard. Instead of logging into each store individually, you can upload a CSV once and apply it to 5, 10, or 50+ stores in parallel. Combined with other bulk features—tags, collections, themes—this reduces operational overhead significantly. You can see how StoreFleet fits into a multi-store workflow in our guide on managing multiple Shopify stores from one dashboard.

Best Practices

1. Start small — test with a handful of products on a test store before importing your full catalog
2. Keep backups — export your current products before making bulk imports, so you have a rollback point
3. Use consistent formatting — date formats, currency symbols, and encoding matter; stick to UTF-8
4. Don't sort in Excel — if you must edit in a spreadsheet, avoid sorting by column (you'll break variant associations)
5. Validate prices and inventory — double-check numeric fields before importing; a typo can affect your business
6. Test variant combinations — if you have multiple options per product, make sure the combinations make sense

Limitations to Keep in Mind

• Shopify CSV import cannot bulk-delete products; use the admin or API for that
• Exports of very large catalogs are emailed rather than downloaded, so monitor your inbox
• Images referenced in CSV must already be hosted somewhere (Shopify doesn't upload local files)
• You cannot change variant option names without losing variant history and IDs
• CSV has a 15 MB file size limit; extremely large catalogs may require splitting into multiple imports

Ready to Streamline Your Workflow?

CSV import and export are powerful for managing products, but doing this across multiple stores manually is time-consuming and error-prone. If you're operating several Shopify stores, consider how a unified dashboard for bulk product management, inventory sync, and order tracking might fit your workflow. Book a free 1-on-1 demo with StoreFleet, and we'll show you how to run your entire multi-store operation from one place. Contact us at [email protected] or through our homepage demo form.