CSV Product Import

Get the App

If you haven't already done so, we'd recommend that you first install the app on your Kong store by visiting the CSV Product Import app page.


Creating a CSV File

The easiest way to create a CSV (Comma Separated Values) file is to make a spreadsheet in something like Excel, Numbers, OpenOffice or Google Sheets. We’ve put together an example CSV file for you to download that has all the right columns, along with some example data. You can open it up in any of the above software and edit it just like you would do a normal spreadsheet.

If you don’t have software for working with spreadsheets, or you’d prefer to write your CSV manually then be aware that any columns that may contain commas, such as Description and Collections, you must wrap them in double quotes otherwise the unexpected commas will cause the rest of your data to appear in the wrong columns.


Exporting your CSV file

Once you’ve created your spreadsheet, you’ll need to export it as a CSV file. For the software mentioned above, here’s how you do it:

Excel

  1. From the File menu, click Save As….
  2. Give your file a name and choose where to save it.
  3. Change the File Format to Comma Separated Values (.csv).
  4. Click Save.
  5. You may see a window warning that certain formatting or content may not work when saved as a CSV. Click Continue.

Numbers

  1. From the File menu, point to Export To then click CSV….
  2. Click Next.
  3. Give your file a name and choose where to save it.
  4. Click Export.

OpenOffice

  1. From the File menu, click Save As.
  2. Give your file a name and choose where to save it.
  3. Change the File Type to Text CSV.
  4. Click Save.
  5. You may see a window warning that certain formatting or content may not work when saved as a CSV. Click Keep Current Format.
  6. In the Export of text files window, leave the settings as they are and click OK.

Google Sheets

  1. From the File menu point to Download as, then click Comma-separated values (.csv, current sheet)
  2. The file will now download to your normal download location

If you’ve created your CSV manually, however you’ll simply need to save the file with a .csv extension.


CSV Columns

There are a number of columns that you can use in your CSV file. We’ve explained what each column does, and any special requirements below. The easiest place to start is to download our example CSV file which also contains some sample data.

Slug

The Slug is a unique identifier for each product. It forms part of the URL structure for your product, so it should be lowercase and may contain letters, numbers and hyphens but no spaces. For example, the Slug for a “Storage Tin” would be storage-tin, and the URL would be https://yourstore.kong365.com/products/storage-tin.

Note: We use the Slug for product variants and multiple images to group them all together. We’ll cover that in more detail later in this guide.

Name

The Name of your product is what will appear on your storefront. Using the same example, the Name would be Storage Tin. It doesn’t have to match the Slug, but it’s a good idea to do so.

Description

The product Description can be plain text but may contain HTML. Here’s an example: <p>Enameled storage tin with handled lid. Available in two sizes and two colours.</p>

Price

The Price must be a numerical value, and may include up to 2 decimal places. Examples of valid prices would be 129.99 or 35. All prices should be entered excluding tax. Remember to remove any currency symbols from prices.

Important: You must enter a Price for a variant row, otherwise it will only import the Image if the row has one defined.

On Sale? (can be empty)

Can be either TRUE or FALSE. If you leave it blank, then we’ll assume it to be FALSE. If you set it to TRUE then you must also add a price in the Sale Price column.

Sale Price

The Sale Price must be a numerical value, and may include up to 2 decimal places. Examples of valid prices would be 129.99 or 35. All prices should be entered excluding tax.

Note: Remember to remove any currency symbols from prices.

SKU (can be empty)

The SKU (Stock Keeping Unit) is an identifier for a particular variant. You can use letters, numbers, spaces and special characters.

Note: SKU codes must be unique across all of your products.

Barcodes (can be empty)

There are three columns available for different barcode types: ISBN, EAN and MPN.

Track Inventory? (can be empty)

If you’d like inventory to be automatically tracked for this product or variant, then set this to TRUE. If not, you can set this to FALSE or leave it blank. If you set it to TRUE then you must also set the Stock level in the next column.

Stock

You can set the Stock level to a whole number. This will be automatically decremented as products are sold, and incremented if returned items are put back into stock.

Low Stock Level (can be empty)

If you’d like your customers to see a notice on the product detail page when stock falls below a certain level, then you can set that number here. It must be a whole number.

Email Low Stock Level (can be empty)

If you’d like Kong to send you an email when this product falls below a stock level, then you can set that number here. Again, it must be a whole number, and we’ll send the email to the email address you use to log in to your store admin.

Weight (can be empty)

You can enter your product Weight in kilograms, and will accept up to 2 decimal places. You should enter weights for your products if you’d like to use weight-based shipping profiles.

Variants – Option Type (can be empty)

You can use Option Type columns to choose an option type such as Colour, Size, Material or a custom type. We’ve provided 3 Option Type columns in our example CSV file: Option 1 Type, Option 2 Type and Option 3 Type. Setting option types also allow you to create product variants. We’ll cover that in more detail in the next section.

Once you’ve set an option type for the first variant of a product, you don’t need to repeat the same option type for the remaining variants of that product.

You can also add more option types by adding another pair of columns, for example Option 4 Type and Option 4 Choice. They don’t have to be immediately after the existing Option 3 Choice column, but it makes it easier to understand.

Note: If you’ve entered an option type, then you must also fill out the next column for Option Choice that matches its Option Type number. For example if you’ve filled in Option 2 Type then you must also fill in Option 2 Choice. Failing to do so will cause an error and that product will not be imported.

Variants – Option Choice (can be empty)

If you’ve filled in an Option Type column for the first row of a product, then you must also fill in the Option Choice column to it’s right for all additional variants. The Option Choice allows you to decide how your product variant differs from the other variants. If the Option Type cell for the first row of a product is empty, then anything entered in the Option Choice cells will be ignored.

Sticking with our storage tin example, let’s say that it comes in two colours and two different sizes. We’d set Option 1 Type to Colour and set our Option 1 Choice to White. We’d then set the Option 2 Type to Size and enter the Option 2 Choice as Large. That’s our first variant, but we need a total of 4 variants. Here’s how to do it:

  1. Copy the Slug value from the current row, in this case storage-tin, and paste it into the Slug column for the row below.
  2. Fill in the Price, and optionally the On Sale?, Sale Price, SKU, ISBN, EAN, MPN, Track Inventory?, Stock, Low Stock Level, Email Low Stock Level and Weight columns.
  3. In Option 1 Choice type in Large.
  4. Lastly, for Option 2 Choice type in Blue.

That’s our second variant created. Now we can repeat the same process for the remaining 4 variants, but changing the Colour and Size choices accordingly.

Note: Variants will only work correctly if they immediately follow a row with the same Slug value.

Image URL

This allows you to define an image for your product, one image per row. You’ll need to ensure that your image is uploaded to a publicly accessible URL – non-password protected and starting with http:// not https://. Simply copy and paste that URL into the Image URL column.

If you want to use multiple images for a product, then you’ll need to add rows with the same Slug as the original product row, but not on the same row as a variant. All other columns can be left blank except for the Image URL.

Note: The image URL must be directly to an image, and end with a file extension such as .jpg, .png, or .gif. Certain image hosting sites will link to the image inside a web page, which will not import.

Image Alt Text (can be empty)

The Image Alt Text is used to describe the image for greater accessibility. If you’re using multiple images (see above), then you could also add Image Alt Text for each image.

Collections (can be empty)

A product can be assigned to one or more Collections, simply by separating them with commas. For example Kitchen, Accessories, Storage.

Note: Only the Collections column for the first row of a variant will be used. Other rows with the same Slug will be ignored.

Type (can be empty)

Each product can have a single Type, which is useful for quickly grouping products together and adding them to Collections.

Note: Only the Type column for the first row of a variant will be used. Other rows with the same Slug will be ignored.

Manufacturer (can be empty)

Products can have a single Manufacturer. Much like Type, it can be used in the Kong admin to quickly group products together into Collections.

Note: Only the Manufacturer column for the first row of a variant will be used. Other rows with the same Slug will be ignored.

SEO Title (can be empty)

SEO stands for Search Engine Optimisation. The SEO Title is important to help your products to be found by search engines like Google. The SEO Title is the part that people click on in search results, so it’s important to give your product a good title. It can be different to the Name column.

SEO Description (can be empty)

The SEO Description is a longer description of your product that appears in search engines, and helps to get your product pages found. You can’t use HTML here, so if you’re copying from the Description column you’ll need to remove any HTML first.

SEO Keywords (can be empty)

SEO Keywords are comma separated words or phrases that describe your product. They’re less important than the SEO Title and SEO Description, but you could write something like “storage tin, enameled, kitchen accessories” for example.

Availability (can be empty)

This can be set to either Available, Date, Hidden or Sold Out. If you leave it blank, then we’ll automatically set the product to Hidden. If you set it to Date, then you must also fill out the next column, Availability Date.

Availability Date

The Availability Date column only needs to be filled out if you’ve set the previous Availability column to Date. You must use a specific format of YYYY-MM-DD HH:MM:SS. For example, 21st July 2015 at 2:30pm would be written as 2015-07-21 14:30:00.

Important: You may need to set the formatting to "Text" on the Availability column cells in order to get it to display in the correct format.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk