How to Import Products to Shopify: API vs CSV Guide (2026)

Shopify gives you two ways to add products in bulk: uploading a CSV file or using the Admin API. Each has different trade-offs depending on your catalog size, technical ability, and how much control you need over the import process.

Method 1: CSV Import

CSV upload is Shopify's built-in import tool — no code, no API keys, no external tools required. You download a template, fill it in, and upload through the Shopify Admin.

When to use CSV import

• Catalogs under 1,000 products
• One-time migrations where you want to manually review the data
• When you don't have developer access
• For incremental updates to small numbers of products

How to do a CSV import

1. In Shopify Admin, go to Products → click "Import"
2. Download the sample CSV to see the exact format required
3. Prepare your data in the correct column structure
4. Upload the file and click "Import products"

Shopify will process the CSV and show you a summary of successful imports and any errors. Large files are processed asynchronously — you'll receive an email when complete.

CSV import limitations

• Maximum 3 option types per product (e.g., Color, Size, Material)
• Maximum 100 variants per product
• No support for metafields
• No support for multiple locations
• File size limit: ~50MB (larger files can time out)

Method 2: Admin API (REST or GraphQL)

Shopify's Admin API gives you programmatic control over product creation. This is the approach used by migration tools, custom integrations, and Shopify apps.

When to use the API

• Catalogs over 1,000 products
• When you need to import metafields, custom data, or complex variant structures
• Ongoing sync (re-importing updated products regularly)
• When you want to check if a product exists before creating it (upsert logic)

REST API vs GraphQL

Shopify supports both REST (the older API) and GraphQL (the newer, preferred API).

REST API: Simple, well-documented, but rate-limited to 2 calls/second on most plans. Use POST /admin/api/2024-01/products.json to create products. Good for catalogs up to ~5,000 products.

GraphQL Bulk Operations: For large catalogs, use Shopify's bulk mutation API. You upload a JSONL file of product mutations, Shopify processes them asynchronously (usually 5–15 minutes for 10,000 products), and you poll for completion. This is 5–10x faster than sequential REST calls.

Required Shopify API setup

1. In Shopify Admin, go to Settings → Apps and sales channels → Develop apps
2. Create a custom app with "Read and write products" and "Read and write inventory" scopes
3. Install the app and copy the Admin API access token
4. Use the token in your API calls: X-Shopify-Access-Token: {your_token}

Product data requirements

Regardless of import method, your product data must meet these requirements:

Field	Requirement
Handle	Required, unique, URL-safe (lowercase, hyphens only)
Title	Required, non-empty
Variant price	Required, decimal number, no currency symbol
Options	Maximum 3 option types per product
Variants	Maximum 100 variants per product
Weight	In grams (API) or grams column in CSV
Images	Public HTTPS URLs, fetched at import time

Handling import errors

Shopify's CSV import gives minimal error feedback — often just "X products could not be imported" without specifying which ones. The API gives more detail.

Common issues and fixes:

• Products missing after import: Check the Status field — products may have been imported as drafts. Set Status to "active".
• Variants not appearing: Multi-variant products need one row per variant with the same Handle. Confirm your row structure matches Shopify's format.
• Images not loading: Verify image URLs are publicly accessible. Use a browser to open each URL — if it prompts for login, Shopify can't fetch it.
• Prices showing as $0: Remove any currency symbols or commas from price values. Shopify expects plain decimal numbers.
• Products with too many variants silently dropped: Products exceeding 100 variants are skipped without clear error messaging. Pre-check variant counts before import.

Using k-sync for the import

k-sync handles the technical complexity of both methods automatically:

• Connects to your WooCommerce store via REST API and imports all products
• Converts WooCommerce data to Shopify format (handles, prices, variants, options)
• Validates against Shopify's limits before pushing
• Pushes via GraphQL Bulk Operations for large catalogs (1,000+ products)
• Falls back to REST for smaller batches and updates
• Tracks which products were created vs updated, with per-product error logging

Free tier supports up to 50 products via API push, or unlimited via CSV export (generate a Shopify-ready CSV from your WooCommerce data).