Product CSV templates for Shopify and WooCommerce

Blank and sample product import templates, plus a guide to every column.

No credits used · sign in to see results

Download a template

Shopify columns

Titlerequired: The product name, on the product's first row only.
URL handlerequired: The product's unique address name, e.g. blue-cotton-shirt. Every row of a product (variants, extra images) repeats it.
Descriptionoptional: The product description. HTML is allowed.
Vendorrecommended: The brand or maker.
Typeoptional: Your own product type, e.g. T-shirts. Used for filtering and collections.
Tagsoptional: Comma-separated tags, e.g. summer, cotton.
Published on online storeoptional: TRUE to show the product on your store, FALSE to keep it hidden.
Statusrecommended: active, draft or archived. Draft lets you check products before they go live.
SKUoptional: Your stock code for the variant. Best kept unique.
Option1 nameoptional: The first option's name (e.g. Size), on the product's first row. Use Title for products without options.
Option1 valueoptional: The variant's value for option 1 (e.g. Medium). Default Title for products without options.
Option2 name / valueoptional: A second option, such as Color. Same rules as option 1.
Option3 name / valueoptional: A third option. Shopify allows at most three.
Pricerequired: What shoppers pay for the variant: digits and a dot, e.g. 24.99, without a currency sign.
Compare-at priceoptional: The crossed-out price before a sale. Must be higher than Price to show as on sale.
Charge taxoptional: TRUE or FALSE.
Weight value (grams)optional: The variant's shipping weight in grams.
Weight unit for displayoptional: g, kg, lb or oz: how the weight is shown in your admin.
Requires shippingoptional: TRUE for physical products.
Fulfillment serviceoptional: manual unless an app fulfils your orders.
Product image URLrecommended: A public image link (https://…). Add one row per extra image with only the handle, this and Image position.
Image positionoptional: 1 for the main image, then 2, 3 and so on.
Image alt textrecommended: A short description of the image for screen readers and search engines.
Variant image URLoptional: An image for this variant, e.g. the red shirt for the Red variant.
Gift cardoptional: TRUE only for gift cards.
SEO title / SEO descriptionoptional: The title and description search engines show. Leave empty to use the product's own.

WooCommerce columns

Typerequired: simple, variable or variation (also grouped or external). Without it every row is imported as simple.
SKUrecommended: A unique stock code. Variations use it to find their parent product.
Namerequired: The product name. Variations can repeat the parent's name with their options.
Publishedoptional: 1 published, 0 private, -1 draft.
Visibility in catalogoptional: visible, catalog, search or hidden.
Short description / Descriptionoptional: The short summary and the full description. HTML is allowed.
In stock?optional: 1 in stock, 0 out of stock, or backorder.
Sold individually?optional: 1 to allow only one per order.
Regular pricerequired: The normal price: digits and a dot, e.g. 24.99. Leave empty on variable products; set it on their variations.
Sale priceoptional: A lower price while on sale. Must be below the regular price.
Categoriesrecommended: Comma-separated; use > for sub-categories, e.g. Clothing > Shirts.
Tagsoptional: Comma-separated tags.
Imagesrecommended: Comma-separated public image links; the first is the main image. WooCommerce downloads them when importing.
Parentoptional: Variations only: the parent product's SKU (or id:123 for its ID).
Positionoptional: The order of variations under their parent.
Attribute 1 nameoptional: An attribute such as Size. Add Attribute 2, 3… groups for more.
Attribute 1 value(s)optional: On the parent, all values (S, M, L); on a variation, its one value (M).
Attribute 1 visible / globaloptional: visible 1 shows it on the product page; global 1 uses a store-wide attribute.

Product CSV templates for Shopify and WooCommerce

These templates give you the exact columns Shopify and WooCommerce expect when you import products, so you can add products in a spreadsheet and import them in one go. Each platform has a blank template, with just the column names, and a sample template with three fictional products from Findora's demo stores: a simple product, a product with variants and a product on sale.

The templates use the same format as Findora's own import files, and every template passes Findora's CSV validator, so you start from a file that is known to import cleanly. The sample products have no image links: add your own public JPG, PNG or WebP links in the image columns.

How to use them

Download the template for your platform and open it in Excel, Google Sheets or Numbers. Keep the first row (the column names) as it is, fill in one row per product, and save the file as CSV (UTF-8). For products with sizes or colors, follow the sample file: on Shopify, every variant gets its own row with the same URL handle; on WooCommerce, add a variable product, then one variation row per option with the parent's SKU in the Parent column.

Before importing, check the file with the CSV import validator to catch missing columns, bad prices and broken variant rows. Then import it from Shopify admin → Products → Import, or WooCommerce → Products → Import. The sample products import as drafts, so nothing goes live by accident.

Why it matters

Most failed imports come from a missing or misspelled column, or variant rows that don't follow the platform's rules. Starting from a correct template avoids both. The column guide below explains what each column is for and which ones are required, so you know what to fill in and what you can leave empty.

One more tip: when your spreadsheet asks how to save, choose CSV UTF-8. Other CSV options can turn accented letters, currency signs and long dashes into unreadable characters during the import.

Frequently asked questions

Are the sample products real?

No. They are fictional products from Findora's built-in demo stores, made for trying Findora. Replace them with your own products.

Which columns are required?

For Shopify, Title, URL handle and Price. For WooCommerce, Type, Name and a regular price on simple products and variations. The column guide on this page lists every column.

How do I add sizes and colors?

On Shopify, one row per variant, all with the same URL handle, and the option names on the first row. On WooCommerce, a variable product row, then one variation row per option whose Parent is the variable product's SKU.

Do I need to sign in to download?

Yes. The column guide is open to everyone; the downloads need a free Findora account and never use credits.

Can I convert a template to the other platform?

Yes. Fill in the template for one platform and use the Shopify ⇄ WooCommerce CSV converter to get the other platform's format.

Need the full product list? Export the whole store with Findora

Discover every public product of a Shopify or WooCommerce store and export it to CSV. 10 free credits when you sign up.

Get started free