1. Csv File Example
2. Csv File Reader

Uploader with Progress Bar and File Manager For Your Website. Chucker solves your file- transfer problems. Cut out the hassle. Manually processing uploads, and. Is it possible to download full listing details? Let me try to shift the perspective. What to do about a problem depends on how you view the problem.

. You need to use a CSV (comma-separated values) file to:. into your store. from your store. CSV files CSV stands for Comma Separated Values, and it's a file format (.csv) for spreadsheets. Shopify accepts the import and export of CSV files for the, and of your store. CSV files might seem intimidating at first, but when you understand what the text and characters represent in a spreadsheet, you might use it for some bigger tasks (such as bulk editing products and customers).

CSV files with are the only file format that can be used to import to or export from Shopify. Note Shopify recommends that you use to work with your CSV files. To use Google Sheets, you must import the CSV file into the program. After you've made your changes, export the CSV file to your computer.

Special characters don't always work correctly in CSV files that are exported, edited with another spreadsheet program, and then re-imported into Shopify. CSVs are useful for stores that:. are switching to Shopify from another ecommerce platform. have a list of Customer Accounts.

prefer to upload Products using a spreadsheet. temporarily have limited internet connectivity. Import CSV files into Google Sheets When you export a CSV file from your Shopify admin, it opens as a.csv file in your computer's native text editor. You can also, but it's recommended that you use a spreadsheet program to view and edit your CSV files instead. Note You can download Shopify's sample CSV templates for and. To import a CSV in to Google Sheets:.

On the Google Sheets page, click Blank in the Start a new spreadsheet section. You CSV file will appear in your downloads folder. Get a sample.csv file You can download and view a to use as a template for creating your own CSV files. The sample contains an example product and a couple of variants. Your import file will likely contain many more products and variants.

If you use the sample file to create your own import file, then make sure that you remove all the example products. Product CSV file format The first line of your product CSV needs to include the field headers described below, in the same order, with each separated by a comma. Subsequent lines in the file should contain data for your product using those same fields in that exact same order. Here's a description of each field: Handle Handles are unique names for each product. They can contain letters, dashes and numbers, but no spaces. A handle is used in the URL for each product. For example, the handle for a 'Women's Snowboard' should be womens-snowboard, and the product's URL would be Every line in the CSV starting with a different handle is treated as a new product.

To add multiple images to a product, you should have multiple lines with the same handle. Title The title of your product. Example: Women's Snowboard Body (HTML) The description of the product in HTML format.

This can also be plain text without any formatting. 2 characters) The name of the vendor for your product. For example, John's Apparel. Type The Product type.

For example, Snowboard. Tags (can be left blank) 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'. Published States whether a product is published on your online store. Valid values are TRUE if the product is published on your online store, or FALSE if the product is hidden from your online store. Leaving the field blank will publish the product. Option 1 Name If a product has an option, enter its name. For example, Color. For products with only a single option, this should be set to Title.

Option 1 Value If a product has an option, enter its value. For example, Black. For products with only a single option, this should be set to Default Title. Option2 Name (can be left blank) If a product has a second option, enter its name.

For example, Size. Option2 Value (can be left blank) If a product has a second option, enter its value. For example, Large. Option3 Name (can be left blank) If a product has a third option, enter its name. Option3 Value (can be left blank) If a product has a third option, enter the value of the option. Variant SKU (can be left blank) The SKU of the product or variant.

This is used to track inventory with inventory tracking services. This field can't be left blank if you're using a Variant Grams The weight of the product or variant in grams. Do not add a unit of measurement, just the number.

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.

Variant Inventory Tracker (can be left blank) Include your inventory tracking for this variant or product. Valid values include shopify, shipwire, amazonmarketplaceweb, or blank if inventory is not tracked. Variant Inventory Quantity The number of items you have in stock of this product or variant.

Variant Inventory Policy How to handle orders when inventory level for this product or variant has reached zero. Valid values are deny, or continue. Deny will stop selling when inventory reaches 0, and continue will allow sales to continue into negative inventory levels. Variant Fulfillment Service The product or variant fulfillment service used.

Csv File Example

Valid values are: manual, shipwire, webgistix, amazonmarketplaceweb. If you use a custom fulfillment service, you can add the name of the service in this column. For the custom name, use only lowercase letters. Spaces aren't allowed—replace them with a dash (-). Periods and other special characters are removed.

For example, if 'Mr. Fulfiller' is your fulfillment service's name, enter mr-fulfiller in the CSV file. You must have a set up in your Shopify admin before you can add the name of the service in this column. Variant Price The price of the product or variant.

Don't place any currency symbol there. For example, 9.99. Variant Compare at Price The 'Compare at Price' of the product or variant. Don't place any currency symbol there. For example, 9.99. Variant Requires Shipping (blank = FALSE) The option to require shipping.

Valid values are TRUE, FALSE, or blank. Variant Taxable (blank = FALSE) Apply taxes to this variant. Valid values are TRUE, FALSE, or blank. Variant Barcode (can be left blank) The barcode, ISBN or UPC of the product. Image Src Enter the URL for the product image.

Shopify will download the images during the import and re-upload them into your store. These images are not variant-specific.

The is where you specify variant images. 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 medium suffixes in their names. Image Position Enter the number that represents the order in which you want the image to appear on the product's page. The images will appear in order from smallest to largest starting from an image position value of 1.

For example, enter 1 if you want the image to appear first for that product. Image Alt Text (can be left blank) The text that describes an image. Useful if an image cannot be displayed or a screenreader passes over an image—the text replaces this element. Gift Card States whether the product is a Gift Card or not. Valid values are TRUE, or FALSE. The addition of this column also allows you to edit other Gift Card details, such as the Body or Tags columns, and import these changes. A gift card can only be created and activated in the Shopify admin.

You can't initially create a gift card through a product CSV import. Variant Image The url for images of variants. Variant Weight Unit Valid values are `lb` and `kg`. Variant Tax Code SHOPIFY PLUS The Avalara code to apply taxes to this product. This field applies only when you are importing to or exporting from a store that uses integration with.

When you create a CSV file by exporting products from a store that uses Avalara, the Variant Tax Code field is populated. If you import this CSV file into a store that doesn't have Avalara set up, then your import will fail. Tip Ten metafield columns appear in every CSV file. Only two of them apply to all stores. The other eight apply if you have installed the to submit your products to Google's Merchant Center. When exporting or importing, these ten columns can be placed in any order.

To read which metafields are required. SEO Title (does not require the Google Shopping App) The SEO Title is found on a product's details page under the Search engine listing preview header in the Page title field. The SEO Title has a character (letters and numbers) limit of 70. If you leave this field blank when importing a product, the field is automatically populated with the product title. SEO Description (does not require the Google Shopping App) The SEO Description is also found on a product's details page under the Search engine listing preview header in the Meta description field.

The SEO Description has a character (letters and numbers) limit of 160. If you leave this field blank when importing a product, the field is automatically populated with the product description. Google Shopping / Google Product Category Google has a proprietary set of product categories. The full list is quite large to allow merchants to be specific towards their target audience. You can upload any value you want using the CSV file, however if your language format does not match, you might not be able to publish the products to Google. Google Shopping / Gender What gender does this product target? Valid values are Female, Male, or Unisex Google Shopping / Age Group What age group does this product target?

Csv File Reader

Valid values are Adult or Kids only. Google Shopping / MPN The MPN, or Manufacturer Part Number, is a string of alphanumeric digits of various lengths (0-9, A-Z). Google Shopping / AdWords Grouping This is used to group products in an arbitrary way. It can be used for Product Filters to limit a campaign to a group of products, or Product Targets to bid differently for a group of products. You can enter any 'string' data (letters and numbers). The Collection column exception To organize your products into collections during the CSV upload, you can add a new column anywhere in your CSV file with the header name Collection.

This is the only column you can add to the CSV that will not break the format. Therefore:. Collection (must create a new column, can be left blank) Enter the name of the collection you want to add this product to.

If it is an existing automatic collection, then the product needs to meet the conditions for the collection. If the collection does not already exist, then one will be created for you. You can only add a product to one collection using this method. Caution The Collection column is the only column you can add to the CSV that will not break the format.

You can't add any more columns to your CSV. Create your product CSV file For each product, you'll need to decide if it is a simple product or one with variants:. Simple Product (Does Not Contain Variants) If you are uploading a product that does not have variants, then enter all the fields (as described above) for the product on the first line along with the URL for the first image. On the following lines, enter just the handle and the URL for each additional additional image.

Product With Variants If you are uploading a product that has variants, then enter all the fields (as described above) for the product on the first line along with the URL for the first image. On the following lines, enter the handle. Then, skip the Title, Body (HTML), Vendor, and Tags. Fill out the rest of the variants details and each image URL.

Once you've added all your products and images, save your CSV file in format using LF-style linefeeds. If you are not familiar with encodings, please see your spreadsheet or text editor program's documentation. To view an example CSV file, click Import on the page and click the sample CSV template link. Prepare your images A CSV file can only contain text. So you'll need to make sure all product images are on an existing website. Those image URLs will only be used during the CSV importing process (in other words, you can delete them when your import is done).

If the files are on your computer only, you must upload them to your Shopify store or another image hosting service to link to their URL. If you are switching to Shopify from another platform, you're all set: just copy the current image URLs and use them in the CSV file. If the product CSV file was produced by your products from Shopify then you don't need to do anything since your images are already on your website. Caution If you remove products or product images from your store after exporting and try to import those products without updating their image URLs, your import will fail. When you have URLs for each product image, you can start building your CSV file. Add multiple product images in a CSV file You can add more product images to your CSV by uploading more images to your Shopify admin. If you're building your store with a CSV file, then the process is a little different.

Here's what you need to know:. You'll need to be able to edit a CSV file. Shopify recommends using to view a formatted version of your CSV files. Your product images must be uploaded to a publicly accessible URL. That is, they should be behind an protocol with no password protection.

The best way to do this is to to the of the Shopify admin. We'll generate the URLs for you automatically.