by Melissa Dominguez
January 20, 2017
If you are working on an excel spreadsheet (csv file) to prepare your product information to send to us it will be convenient for you to understand what each field means.
Here's a description of each field. Please note that the fields in red are requiered and you should always add that information to the spreadsheet. The rest of the fields are optional but highly recommended that you add the information as well.
It is important that you DO NOT change the title fields on the excel file. Please leave them as they are.
You can download a sample file here and replace with your information.
Go here for the full documentation on how to work on your CSV file.
Please, let us know if you need help or have questions working with your CSV file.
You can also see this video, explaining in detail how to create your CSV file:
Every line in the CSV starting with a different handle is treated as a new product. If you want to add multiple images to a product, or want the product to have variants, you should have multiple lines with the same handle.
Comma-separated list of tags used to tag the product. Most spreadsheet applications automatically add quotes around the tags for you. If you are using a plain text editor, you will need to manually add the quotes. For example, "tag1, tag2, tag3".
"tag1, tag2, tag3"
We recommend that you use tags as your secondary categories for products. We will use the tags to be able to add the products in other categories in your store.
For products with only a single option, this should be set to Title.
For products with only a single option, this should be set to Default Title.
This field can't be left blank if you're using a custom fulfillment service.
Shopify will always import and export weight in grams, even if you specify a different unit. You must use accurate weights if you intend to offer carrier-calculated shipping or use a third-party fulfillment service.
You must have a custom fulfillment service set up in your Shopify admin before you can add the name of the service in this column.
You won't be able to change your image filename after that image has been uploaded to your shop. Don't upload images that have _thumb, _small, or _mediumsuffixes in their names.
Co-Founder of NinjaNutz, Melissa is passionate about technology and gadgets. She also loves animals and coffee. All of these are part of her daily life. Her job makes her work with Shopify stores 99% of the time and is a Shopify Expert since 2016.
Comments will be approved before showing up.
by Mel Dominguez
April 02, 2020
by Melissa Dominguez
November 20, 2018