Knowledge base
Guides
Academy
Video tutorials
Try searching for:
Recently viewed articles:

Table of contents

Format guidelines for the CSV file

To successfully import CSV files into your store, make sure that they meet certain formatting requirements described in this article.

If you export data from a store on our platform, a CSV file already has the correct formatting.

General rules

Here are some general guidelines for compiling a CSV file:

  • Every file must have a header with column names. See List of supported columns
  • Column order doesn't matter as long as you use the right column names.
  • Add any columns required to import your data, and feel free to leave out the other ones.
    For example, when updating details for existing products, you can have only those columns you make changes to plus the identifier columns.
  • Pay attention to mandatory columns. They depend on the type of the item and on the aim of your import (creating new items or updating the existing ones). See CSV file column reference for more info.
  • Save your CSV files in UTF-8 (that’s the recommended encoding).

Header

The most important part of your CSV file is the header. It’s the first row that contains all the column names. These column names convey what kind of data sits in a particular column.

Format_guidelines_for_the_CSV_file__3_.png

You cannot import a file if there’s no header.

Data types

Each row in the file – except for the header – is dedicated to a specific set of data. To specify what exactly the information in the row is about, you use the “type” column:

Format_guidelines_for_the_CSV_file__2_.png

Based on the type, rows can contain data on:

  • a product (type = ”product”)
  • a product option or input field (type = ”product_option”)
  • a product variation (type = ”product_variation”)
  • a product file (type = ”product_file”)
  • a store category (type = ”category”)
  • an Instant Site redirect (type ="site_redirect")
  • a store customer (type ="customer")
If all the rows in your file are for products (type=”product”), you can omit the entire “type” column. Unless otherwise specified, all the rows are considered “product” rows.

Columns

All the columns in your import file except for the “type” column are dedicated to specific information like product name, SKU, price, etc:

Format_guidelines_for_the_CSV_file__1_.png

The information can refer to a product, product option (or input field), product variation, product file, store category, Instant Site redirect, or store customer, depending on a particular row.

Check out the full list of supported columns. You can place columns in any order you like, but make sure you specify column names exactly as given in the reference.

Identifiers

To match data from a particular row with specific products or categories, you use identifiers. For example, when you need to point out which product the option belongs to:

Format_guidelines_for_the_CSV_file__4_.png

  • When updating existing products, specify product ID or unique product SKU.
  • When adding options, input fields, variations, or files, specify a unique SKU or ID of the product they must be assigned to.
  • When updating existing store categories, specify category ID or full category path.
  • When updating or deleting existing Instant Site redirects, specify redirect ID.
  • When updating existing customers, specify their primary email or customer ID (used to update primary email).

See the list of supported CSV columns for column names.

To know IDs of products or categories, export your catalog and find “product_internal_id” and “category_internal_id” columns respectively. To know redirect IDs, export your redirects.
If you have non-unique or empty SKUs in your store, you can only identify products by their IDs.

Set of sample CSV files

Check out our set of sample CSV files with ready-made examples for different use cases:

You can use these files as a template and see how rows and columns work together. Replace sample items with your products or categories and add more property columns if you need them.

You can learn more about compiling files for specific goals from our detailed case studies.
Was this article helpful?

Awesome! Thanks for your feedback!

Thanks for your feedback!

Sorry about that! What went wrong?
13 out of 24 found this helpful
10
We use cookies and similar technologies to remember your preferences, measure effectiveness of our campaigns, and analyze depersonalized data to improve performance of our site. By choosing «Accept», you consent to the use of cookies.
Accept cookies Decline