100% Client-Side Privacy: All calculations execute in your browser. Zero data transmitted.

Split Products Exceeding Shopify's 100-Variant Limit

Bypass Shopify 100-variant limit and fix CSV quotes or UTF-8 BOM import errors. Split large product catalogs by handle into compliant parts with multi-country decimal formatting.

⚠️

JavaScript is Required: This utility executes 100% client-side calculations inside your browser. Please enable JavaScript to interact with the calculation engine and input controls.

📖 Glossary ↓

🇺🇸

United States Active · UPC-A (12-Digit) • Period Decimals

US Standard

ℹ️

Shopify Limit Notice: Standard Admin CSV imports strictly enforce a 100-variant limit per handle (while selected 2024+ plans support up to 2,000 variants via GraphQL API only). This tool keeps CSV uploads 100% error-free.

Click to upload product CSV or drag & drop

Supports comma (,) & European semicolon (;) CSV files

Delimiter Detection ⓘ Auto-sniffs German/EU (;)

1. Split Strategy & Threshold ⓘ

Max:

2. Handle & Title Suffix Format

3. Defensive Data Sanitization Auto-strip currency symbols ($ / € / £ / ¥ / ₹) Convert European comma decimals (e.g. 19,99 € → 19.99) Validate international GTIN barcodes (UPC-A vs EAN-13 / JAN) Normalize smart quotes (“” to ASCII "") Strip Excel UTF-8 BOM mark and trim trailing whitespace Auto-deduplicate duplicate SKUs with sequential suffix (-1, -2)

CSV Audit & Schema Verification

No CSV Loaded

Total Rows 0

Products 0

Over Limit 0

Split Files 0

0 rows

#	Handle	Title	Option1 Value	Option2 Value	Variant SKU	Price	Compare Price	Barcode
Upload or load sample CSV to preview rows and split parts.

Quick Actions:

</>

Want this interactive generator on your blog or agency site?

Free, lightweight responsive iframe snippet. 100% client-side with zero tracking.

💡

Have a suggestion for this tool?

Tell us what feature, formula, or regional adaptation to build next.

Looking to submit a bug? 🐛 Report a Bug →

Frequently Asked Questions & Merchant Guide

Clear answers on transaction fees, breakeven formulas, and margin safeguards.

How to split product CSV with over 100 variants for Shopify import?

Shopify enforces a strict hard limit of 100 variants and 3 options per product handle. This tool automatically groups your catalog rows by Handle, preserves Option1/2/3 attributes, and slices items exceeding 100 variants into clean sibling products (e.g., Handle-Part-1, Handle-Part-2) with linked tags for seamless store navigation.

Why does UTF-8 BOM or invalid quotes cause Shopify CSV import failed errors?

Spreadsheet editors like Excel frequently save CSVs with an invisible 3-byte UTF-8 Byte Order Mark (\uFEFF) or unescaped curly quotes. Shopify's import parser fails on these illegal characters. Our tool sanitizes raw files by stripping BOM bytes, normalizing smart quotes to ASCII, and removing stray currency symbols ($/€/£).

How to split large product catalog CSV by handle into 100 row parts?

Upload your master CSV file. The engine identifies distinct product handles, calculates Math.ceil(Variants / 100), and outputs standalone chunked CSVs or a single zipped archive ready for direct upload in Shopify Admin under Products > Import.

How does the tool handle European comma decimals and international character sets?

The cleaner converts European comma prices (49,99 €) into Shopify standard dot decimals (49.99), sanitizes German umlauts and French accents, and verifies GTIN barcode columns (US 12-digit UPC-A vs UK/EU 13-digit EAN).

Is my product catalog, supplier SKU, and pricing data kept private?

Yes, 100%. The entire parsing, sanitization, and splitting engine executes locally inside your browser memory using PapaParse. No product CSV rows or pricing numbers are ever uploaded or transmitted to an external server.

BLUF • Direct Reference Rule

Shopify enforces a strict architectural limit of 100 variants and 3 option dimensions per product handle. To prevent schema import rejection, catalogs exceeding 100 variants must be partitioned into linked sibling handles (handle-part-1, handle-part-2) while preserving identical Option1/Option2/Option3 names, vendor, and tags across all split CSV chunks.

📖 Terminology Decoded (Plain-English Glossary)

Beginner Friendly

● 100-Variant Limit

Shopify's standard admin rule that stops any single product listing from containing more than 100 size/color SKU combinations.

● 3-Option Cap

The maximum number of distinct product attributes allowed (e.g., Option 1 = Color, Option 2 = Size, Option 3 = Material).

● Parent Handle

The unique web address slug (e.g., cotton-crewneck-tshirt) that ties all variant rows into one unified product page.

● UTF-8 BOM Header & Delimiters

Hidden encoding marks and column separators (commas vs European semicolons) that cause Shopify import errors when exported from Excel.

● Sibling Handles

Linked split products (e.g., hoodie-part-1, hoodie-part-2) that divide large inventory while sharing the same tags and images.

● GTIN / Barcode Checksum

The final mathematical verification digit on UPC-A (12-digit) or EAN-13 (13-digit) barcodes ensuring store scanners read barcodes accurately.

🧮

Shopify CSV 100-Variant Chunking & Decimal Standardization Formula

Active Market: United States (USD $)

Calculates the optimal catalog partition algorithm to overcome Shopify 100-variant limit and standardizes European comma decimal prices into clean dot decimals.

🇺🇸

US Standard Interchange Model (0% Fee VAT)

United States · Currency: USD ($)

Live Applied

Mathematical Equation

Price = [COGS + Shipping + CPA + $0.30 - (ShipCharged × 0.971)] ÷ (1 - 0.029 - TargetMargin%)

Country-Specific Regulatory & Operational Rules

Stripe US / Shopify Payments base rate: 2.90% + $0.30 per successful charge.
Statutory Processing Tax: 0% VAT/GST on payment processing fees.
International / Amex Surcharge: +1.00% to +1.50% added if customer uses non-US card.

Worked Example: On a $20 order with $5 COGS, $3 Ship, $4 CPA, and 20% Target Margin: Breakeven Price = $17.30. Suggested Retail = $21.63.

🇺🇸

United States (USD $)

US Shopify Standard (Dot Decimal / 100-Variant Limit)

Parts = Math.ceil(Variants ÷ 100) · Option1(Size) + Option2(Color) + Option3(Material)

Shopify Hard Limit: Max 100 variants and 3 options per product handle.
Price Format: Standard dot decimal (e.g. 49.99).
GTIN Format: 12-digit UPC-A barcode column validation.

Example: A product with 250 size/color combinations is automatically split into Part 1 (100), Part 2 (100), and Part 3 (50).

🇬🇧

United Kingdom (GBP £)

UK Catalog Model (Dot Decimal / EAN-13 GTIN)

Parts = Math.ceil(Variants ÷ 100) · Price format: £49.99 · EAN-13 Barcode

EAN-13 Barcode: Formatted without leading apostrophes or scientific notation corruption.
Option Architecture: Size (UK 6 - 16), Color, Fit.
Currency Header: Standard GBP £ pricing column.

Example: 140 shoe variants split into Part 1 (100) and Part 2 (40).

🇪🇺

European Union (EUR €)

EU Comma Decimal Converter (49,99 € → 49.99)

Price = Price.replace(",", ".") · Strip Non-Breaking Spaces (1 299,00 € → 1299.00)

Comma Decimal Fix: Converts European comma notation (49,99 €) to Shopify required dot notation (49.99).
Umlaut & Accent Preservation: Sanitizes French/German accents into UTF-8 compatible slugs.
EU Sizing: Standardizes EU footwear and apparel variant matrices.

Example: A German CSV with prices like "29,95 €" is batch converted to clean "29.95" dot decimals.

🇦🇺

Australia (AUD A$)

Australia Model (Dot Decimal / GST Inclusive Pricing)

Parts = Math.ceil(Variants ÷ 100) · AUD $ Pricing · 930 EAN-13

GST Inclusive: Display prices in Australia legally include 10% GST.
Option Matrix: Australian standard sizing conventions.
Barcode Validation: GS1 Australia 930 prefix validation.

Example: 180 apparel variants partitioned into 2 clean CSV upload files.

🇮🇳

India (INR ₹)

India Model (HSN Code Attribute & INR Integer Pricing)

Parts = Math.ceil(Variants ÷ 100) · HSN/SAC Column Sync · 890 GS1 India

HSN Code Attribute: GST tax classification code embedded in variant meta-attributes.
Price Format: Standard INR integer pricing without decimals.
Option Matrix: Indian apparel sizing standards.

Example: 120 sari/kurta variants chunked into Part 1 (100) and Part 2 (20).

🇯🇵

Japan (JPY ¥)

Japan Model (Zero-Decimal Yen & Full-width Kana Sanitize)

Price = Math.round(Price) · Full-width (１２３) to Half-width (123) ASCII

Zero-Decimal Precision: Yen prices must be integer values (no decimals).
Full-width Clean: Normalizes full-width alphanumeric and punctuation characters.
JAN Barcode: 13-digit Japanese Article Number verification.

Example: ¥3,980.00 is cleaned to ¥3980 integer format.

📖 How to Split a 300-Variant Supplier Catalog for Shopify (3 Steps)

Upload Supplier Export

Drag and drop your raw CSV or paste spreadsheet rows. The engine automatically detects delimiters (comma, semicolon, tab) and strips UTF-8 BOM encoding.

Select Split Strategy

Choose whether to split sequentially (preserving exact 100-row chunks) or group by Primary Option (e.g. grouping all Red variants into one handle).

Download & Import

Download individual sanitized CSV parts or grab the bundled ZIP archive. Upload directly to Shopify Admin under Products > Import with zero schema errors.

📊 E-Commerce Platform Variant Limits Benchmark (2026)

E-Commerce Platform	Variant Limit per Product	Max Option Categories	BOM UTF-8 Tolerance	Workaround Required
Shopify (Standard)	100 Variants	3 Options	Strict Crash	Split into Sibling Handles
WooCommerce	Unlimited (Memory bound)	Unlimited	Moderate	None (Server PHP limit)
BigCommerce	600 Variants	Unlimited	Strict	None up to 600
Amazon Seller Central	2,000 Child ASINs	Category-Specific	Template Strict	Flat File Feed Upload