Exporting and importing products

Exporting and importing allows you to bulk upload your products from one Tictail shop to another or from another shopping platform (such as Shopify or Etsy) to Tictail. Instead of loading each product individually, all you need to do is create and save a CSV file for a quick and seamless transfer, which makes creating or updating your shop that much easier!

 

Exporting your products

  1. Go to the Products view in your dashboard: https://tictail.com/dashboard/products
  2. Click the More menu.
  3. Under Export current view, select which format you want to use to export your products. We support both CSV (recommended) and XLS (Excel).
  4. Wait until the export job completes. Feel free to do something else or even close your browser tab while you wait. 
  5. When the export is completed, it will show up under "Recent exports." Click the link and download the newly created export file.

The export will contain all pages of all products in the current view. This means that you can export a subset of your products by filtering with a search query.

 

Import products

You can import products from multiple sources, such as:

  • A CSV file from a Tictail product export - or one that you build yourself, see example below..
  • A CSV file from an Etsy product listing export.
  • A CSV file from a Shopify product export.

To import products:

  1. Go to the Products view in your dashboard: https://tictail.com/dashboard/products
  2. Click the Import link, next to the Add product button.
  3. Select the source of your products, and upload your CSV file.
  4. Click next.
  5. In the next step you'll be able to review the number of products you've selected to be imported.
  6. To start the import, click Start import.
  7. Wait until the import job completes. Depending on how may products you've submitted to be imported, this may take a while. Feel free to do something else or close your browser tab in the mean time.
  8. The "Import" link will indicate if the import is in progress or not, and you can click it again to see a detailed progress bar.

Importing products from a Tictail export

See "Exporting your products" in the above text on how to export a CSV of your products.

You can also manually create a CSV file with product data to import. Use this example file as a starting point. The columns that are used for import are:

  • Product ID. Leave this as it is if you're working on an export. For new products, leave it empty.
  • Title. If consecutive lines contain the same Title, they are treated as variations of the same product. The first line specifies the general details about the product - such as description, images, etc. -  as well as the first variation of the product. The subsequent lines specify the additional product variations.
  • Slug. The "handle" of your product, used to build the product's URL, both on the marketplace and custom shop. Leave empty to generate a slug based on the product title (and you can always edit this later).
  • Status. You can specify if a product should be imported as published (live on your shop) or unpublished (the default, which is not visible to customers) in the Status column.
  • Currency. The currency code for the product's prices, to account for price decimals. Specified in ISO 4127 format. Examples: SEK, USD, EUR.
  • Image URLs. You can specify multiple images per product in the Image URLs column. Separate the image URLs by commas.
  • Description.
  • Category ID. The ID (32 characters long) of the category for the product. Only really useful if you're working on a previous export, leave empty otherwise.
  • Variation Title.
  • Variation SKU.
  • Variation Original Price. The original price of the variation, specified as a decimal number without any currency symbols. Example: 14.99. Incorrect values: $14.99 or 14.99 kr.
  • Variation Sale Price.
  • Variation Sale Active. Set to true to mark the sale price as active.
  • Quantity. Set to the infinity symbol (∞) to set an unlimited quantity on the product variation.

Our product import process is quite lenient, so if you specify invalid prices or quantities we'll still import the product, but use default values.

Importing products from Etsy

Learn how to export your Etsy products.

The Etsy CSV export does not include prices and quantity for the individual variations. This import will set the same price and quantity on all imported variations. It will mark all imported products as unpublished (not visible to shoppers), to allow you to verify the products before showing them.

Importing products from Shopify

Learn how to export your Shopify products.

The import will set all new products as unpublished.

 

Glossary

What is a CSV file? A CSV file is a list of comma-separated values, and is a standard file format for data exports. CSV files can be opened by all spreadsheet programs, like Excel, Numbers, and Google Spreadsheets, and it can also be edited by regular text edit programs like Notepad and TextEdit. The first line of the file is consists of the column names, while the rest is the actual data.

Technically we require all CSV files to be encoded as UTF-8 (which is the default text encoding in most software and services). This means we can properly support all languages, and emojis 💪😼.

To export a CSV file from Numbers: Go to File -> Export To -> CSV..., then click Next and Export. This is also a way you can fix any issues with text encoding: Numbers will export your CSV as UTF-8.

To export a CSV file from Google Spreadsheets: Go to File -> Download as -> Comma-separated values (.csv, current sheet).

Have more questions? Submit a request