What columns does the template include?

The core Shopify import columns such as Handle, Title, Body (HTML), Vendor, Variant Price, and Variant SKU, plus the option columns relevant to the product type you pick.

Do I have to keep the sample rows?

No. They show the expected format. Delete them and add your own products, keeping the header row intact.

Will this template always import successfully?

The headers are correct, which clears the most common cause of failed imports. Your data still needs to be valid, so check prices, image URLs, and handles before importing.

Shopify CSV Template

Pick a product type and download a pre-filled Shopify CSV template with correct headers and sample data.

Product Type

CSV Template Preview

Handle,Title,Body (HTML),Vendor,Product Category,Type,Tags,Published,Option1 Name,Option1 Value,Option2 Name,Option2 Value,Option3 Name,Option3 Value,Variant SKU,Variant Grams,Variant Inventory Tracker,Variant Inventory Qty,Variant Inventory Policy,Variant Fulfillment Service,Variant Price,Variant Compare At Price,Variant Requires Shipping,Variant Taxable,Variant Barcode,Image Src,Image Position,Image Alt Text,Gift Card,SEO Title,SEO Description,Variant Image,Variant Weight Unit,Variant Tax Code,Cost per item,Status
example-t-shirt,Example T-Shirt,<p>A comfortable cotton t-shirt.</p>,Your Brand,,Shirts,"cotton, summer",TRUE,Title,Default Title,,,,,SHIRT-001,200,shopify,50,deny,manual,24.99,29.99,TRUE,TRUE,,,,,FALSE,Example T-Shirt | Your Brand,A comfortable cotton t-shirt for everyday wear.,,g,,12.00,active

Skip the template altogether.

ShopSheets pulls your real products into Google Sheets, ready to work in one click.

Start free trial

About this tool

The Shopify CSV template builder gives you a ready-made import file with the correct headers and a few sample rows. Pick a product type, and download a CSV pre-filled with the columns Shopify expects for that kind of product.

Starting from a blank spreadsheet, it is easy to misspell a header or miss a required column, and Shopify rejects the import. A correct template removes that guesswork, so you can fill in your products and import without header errors.

Products with lots of variants? The variant matrix generator turns options like Size x Color into every combination as a ready-to-import CSV.

How to use it

Pick a product typeChoose the kind of product you are adding, such as apparel or a simple item.
Download the templateGet a CSV with the right headers and sample data for that type.
Fill in your productsReplace the sample rows with your own data and import to Shopify.

Frequently asked questions

What columns does the template include?: The core Shopify import columns such as Handle, Title, Body (HTML), Vendor, Variant Price, and Variant SKU, plus the option columns relevant to the product type you pick.
Do I have to keep the sample rows?: No. They show the expected format. Delete them and add your own products, keeping the header row intact.
Will this template always import successfully?: The headers are correct, which clears the most common cause of failed imports. Your data still needs to be valid, so check prices, image URLs, and handles before importing.

Shopify CSV Template

Product Type

About this tool

How to use it

Frequently asked questions

Related tools