Ecopy LogoEcopy

Shopify product CSV template and builder

Describe your product and its options, and download a CSV ready to import into Shopify, with one row for every variant and image. It uses the same 61 columns as Shopify's current product template. Free, and nothing leaves your browser.

Product

Leave empty to use: organic-cotton-t-shirt

Comma-separated.

Options and variants

Up to three options. Every combination of values becomes a variant row.

Pricing and inventory (applied to every variant)

Optional

Images and SEO

Public https:// links. The first one is the main image.

Your CSV

8 variants

8 rows, 61 columns in Shopify's current format

Preview of the main columns

URL handleOptionsSKUPriceImage
organic-cotton-t-shirtS / BlackTEE-S-BLACK24.99#1
organic-cotton-t-shirtS / WhiteTEE-S-WHITE24.99
organic-cotton-t-shirtM / BlackTEE-M-BLACK24.99
organic-cotton-t-shirtM / WhiteTEE-M-WHITE24.99
organic-cotton-t-shirtL / BlackTEE-L-BLACK24.99
organic-cotton-t-shirtL / WhiteTEE-L-WHITE24.99
organic-cotton-t-shirtXL / BlackTEE-XL-BLACK24.99
organic-cotton-t-shirtXL / WhiteTEE-XL-WHITE24.99

Import it in Shopify admin: Products → Import → choose the file. Everything is built in your browser; nothing is uploaded.

How a Shopify product CSV is organized

One product can take several rows. The URL handle is what ties them together: every row with the same handle belongs to the same product. The first row carries the product details (title, description, vendor, tags, option names); each following row adds a variant or an image.

A T-shirt in three sizes and two colors therefore takes six variant rows, plus one row per extra image. Writing these combinations by hand is where most mistakes happen, which is what the builder above does for you.

The main columns explained

Title
The product name. Filled on the first row of each product only; variant rows leave it empty.
URL handle
Links every row of a product together and becomes its URL (/products/handle). Lowercase letters, numbers and hyphens. Repeated on every variant and image row.
Description
The product description. HTML is allowed, for example <p> and <ul>.
Vendor, Type, Tags
Brand or supplier, product type, and comma-separated tags used for filters and collections.
Published on online store
TRUE to show the product on your online store, FALSE to keep it hidden.
Status
Active or Draft.
Option1 name / Option1 value
The first option (for example Size) and this row's value (for example Medium). The name goes on the first row only. Up to three options.
SKU
Your stock-keeping code for the variant. Optional, but it makes inventory and supplier orders easier.
Price, Compare-at price, Cost per item
Numbers without currency symbols, such as 19.99. The compare-at price shows as the original price when it is higher.
Inventory tracker, Inventory quantity
"shopify" to let Shopify track stock, and the quantity available.
Continue selling when out of stock
DENY to stop selling at zero stock, CONTINUE to keep selling.
Weight value (grams)
The variant weight in grams, used for shipping rates.
Requires shipping, Charge tax
TRUE or FALSE. Digital products use FALSE for shipping.
Product image URL, Image position
A public image link and its order. Extra images go on their own rows with only the URL handle, the image URL and the position.
SEO title, SEO description
What search engines show. If empty, Shopify uses the title and description.

The remaining columns (unit prices, Google Shopping fields, packed dimensions, metafields) are optional and can stay empty.

Checks before you import

  • Keep the header row exactly as it is. Renamed or translated column names are not recognized.
  • Repeat the URL handle on every row of a product. A typo in one row creates a separate product.
  • Use plain numbers for prices and weights. 19.99, not $19.99 or 19,99 €.
  • Use TRUE/FALSE and DENY/CONTINUE exactly. Other words are not read as yes or no.
  • Use public image links. Shopify downloads each image; links behind a login or on your computer fail.
  • Save as CSV in UTF-8. Other encodings break accents and special characters; spreadsheet apps offer "CSV UTF-8" when saving.
  • Test with one product first. Import a single product, check it in your admin, then import the rest.

Copying products from another store?

Skip the spreadsheet. Ecopy imports products from any Shopify store (one product, a collection or a whole catalog) and from AliExpress, Amazon, Temu, SHEIN and Etsy, with their variants, images and prices, then rewrites and translates them with AI. See how to clone a Shopify store.

Frequently Asked Questions

Where do I download the Shopify product CSV template?

Use the "Download the blank template" button above: it has the 61 column headers of Shopify's current product template, in the same order. The builder above fills them in for you.

How do I import a CSV file into Shopify?

In your Shopify admin, go to Products, click Import, choose your CSV file and confirm. Shopify shows a preview of the first product before the import starts.

How do I add variants in a Shopify CSV?

Give each variant its own row with the same URL handle. The first row holds the product details and the option names; the following rows only need the handle, the option values and the variant fields such as price and SKU. The builder above creates these rows for every combination.

How do I add several images to a product?

Put the first image on the product's first row. Add each extra image on its own row with only the URL handle, the image URL and its position (2, 3 and so on). The images must be public links.

Can I import products from AliExpress or Amazon with a CSV?

Only if you build the file yourself, row by row. An importer is faster: Ecopy imports products from AliExpress, Amazon, Temu, SHEIN, Etsy or any Shopify store directly, with their variants and images.

Related

Ready for your next sale?

Import a product, pick a template and let Ecopy build the page that sells it — bundles, reviews and urgency included. Live on your store in minutes.

Install free on Shopify
Free plan, no credit card3-day trial on paid plansCancel anytimeWorks with any theme