Quick Rule Summary · Updated November 2026
Etsy listing CSVs pack all photos and SKUs horizontally onto a single row (IMAGE1..IMAGE10, VARIATION 1 VALUES, SKU1..SKU10), whereas Shopify requires one vertical row per variant or extra gallery photo joined by an identical lowercase URL handle.
01 / INTERACTIVE ETSY-TO-SHOPIFY EXPANDERPreview IMAGE1–IMAGE10 unpivoting, tag cleanup & draft price protection.
Compare how a single flat Etsy row expands into clean multi-row Shopify product records—or click Naive 1-to-1 Trap to see what breaks when you only rename headers:
Paste or edit your own Etsy listing fields (live converter)
02 / THE 4 ETSY EXPORT TRAPSWhy Etsy’s native CSV cannot be uploaded straight to Shopify.
- Horizontal
IMAGE1–IMAGE10vs. vertical Shopify rows: Etsy puts up to 10 photo URLs across 10 columns on one row. Shopify only reads oneProduct image URLper row—so photos 2 through 10 must become continuation rows sharing the exact sameURL handlewith blankOption1 valueandPrice(see multi-image continuation rules). - Missing tier-specific variant prices: Etsy’s built-in CSV export only outputs a single listing-level
PRICEand totalQUANTITY—even when a 14 oz candle or solid-gold necklace costs more than the base option! Always import multi-variation Etsy items withStatus = draftso you can set exact tier prices before going live. - 140-character marketplace titles &
underscore_tags: Marketplace keyword chains (Gold Ring | Gift For Mom | Boho Stacking Band) hurt conversion on an independent Shopify storefront, and Etsy exports multi-word tags with underscores. Split your primary product name at the first|or-and replace underscores with spaces inTags. etsystatic.comimage hotlinks stay tied to Etsy: Shopify downloads publichttps://i.etsystatic.com/...URLs into Shopify’s own CDN during CSV import—so keep your Etsy listings active (or undeleted) until your Shopify import finishes downloading every gallery image!
03 / COLUMN REFERENCEEtsyListingsDownload.csv to Shopify header dictionary.
| Etsy CSV header | Shopify CSV header | Required transformation |
|---|---|---|
TITLE | Title + URL handle | Generate a lowercase hyphenated slug for URL handle; optionally trim marketplace keyword tails after |. |
DESCRIPTION | Description (Body (HTML)) | Wrap plain-text paragraphs in <p>…</p> or <br> tags so line breaks don’t collapse. |
PRICE & CURRENCY_CODE | Price | Keep numeric decimal (48.00); drop CURRENCY_CODE (Shopify uses your store’s base currency). |
QUANTITY | Inventory quantity | Pair with Inventory tracker = shopify; note that Etsy exports combined listing stock on multi-variant items. |
TAGS & MATERIALS | Tags | Replace underscores with spaces and combine comma-separated tags + materials into one quoted cell. |
IMAGE1 … IMAGE10 | Product image URL + Image position | Put IMAGE1 on Row 1 (position 1) and unpivot IMAGE2–10 onto shared-handle continuation rows. |
VARIATION 1/2 NAME & VALUES | Option1/2 name & value | Split comma-delimited option values into individual variant rows and set Status = draft to verify prices. |
04 / SAFE MIGRATION WORKFLOWMove your Etsy catalog in 4 verified steps.
- Download
EtsyListingsDownload.csv: In Etsy Shop Manager, open Settings → Options → Download Data and download your currently active listings CSV (keep Etsy listings online until Shopify finishes fetching images). - Unpivot images & variations into UTF-8 rows: Expand
IMAGE2–IMAGE10and comma-separated variation values into shared-handle rows using the structure in the expander above. - Preflight headers & prices in Row & Record: Open your UTF-8 CSV in our local browser workspace (or run a quick check with our Chrome Extension ↗) to catch blank handles, duplicate headers, or accidental
0.00variant rows. - Import a 3-listing pilot batch as
draft: Upload 3 listings into Shopify Admin (Products → Import), verify that all 10 gallery photos downloaded to Shopify’s CDN and check variant tier pricing before switchingStatustoactive.
Common questions.
Why did only 1 photo per listing import into Shopify from my Etsy CSV?
Etsy places photos horizontally across IMAGE1 through IMAGE10 on a single row, whereas Shopify reads only one Product image URL (Image Src) per row. To import all 10 photos, IMAGE2 through IMAGE10 must be expanded into vertical continuation rows sharing the same URL handle.
Does Etsy’s CSV export include different prices for each size or material variation?
No. Etsy’s native EtsyListingsDownload.csv only exports the listing’s single base PRICE and combined QUANTITY, even if individual variations have different prices or SKUs in your Etsy shop. Import multi-variation Etsy products into Shopify with Status set to draft so you can enter exact variant tier prices before publishing.
Will my product photos break on Shopify if I close my Etsy shop later?
Once Shopify finishes importing your CSV, Shopify downloads the public etsystatic.com images onto Shopify’s own CDN servers. Just make sure your Etsy shop and listings remain live and public until the Shopify CSV import email confirms completion and you verify the images in Shopify Admin.
How do I convert Etsy’s MATERIALS column into Shopify?
Merge Etsy’s MATERIALS values (replacing underscores with spaces) into Shopify’s comma-separated Tags column for collection filtering, or map them into a custom Shopify product metafield after import.
RELATED CSV TOOLSMigrating from another platform to Shopify?
Ready to preflight your converted Etsy CSV?
Check column mappings, variant grouping, and numeric prices locally in your browser—nothing uploaded.
Verified November 2026 against Etsy’s Shop Manager active-listing CSV schema and Shopify’s multi-row Product CSV importer.
Shopify official Etsy migration documentationShopify product CSV multi-row specificationRow & Record Chrome Extension ↗