Knowledgebase: Products
How do I import Options from Template via CSV?

This guide will give you a step-by-step process on how to import options from templates you have created.

Import Options from Templates

Note
The import action described here is only to link products to Option Templates.

All of your options templates must be created first in the admin panel. Click here to learn about that process if you haven't done so already.

  1. Go to Products->Products List
  2. Look towards the top right of the page and click on the "Export/Import" button

The page will be split into two halves. The left half will contain your Export options, while the right half will contain your Import options.

Using the right hand (Import) section, look for the "Options from Template" and click on its + Icon to expand its options.

  1. Click on the Sample File link and download the sample file to your desktop.

Open the Sample CSV file using your computer's spreadsheet program where it will contain columns for adding your information.

Here is a sample of what your spreadsheet will look like.

You may now add information to the proper columns.

Here is a description of each field:

  • catalogid
    This is the database number of the item you would like to attach the options template to.
  • id
    This is the ID/SKU number of the product you would like to attach the options template to.

Tip
In each line of the spreadsheet, you can enter either the catalogid or the id of the product. You do not need to have both entered for the import to work correctly.

  • optiontemplate
    This is the name of the template you would like to add to the product.

Important
Do not remove, add or edit any columns to this file. If you do not have a need for a column please leave it blank. This is the exact format the file needs to be to import your Manufacturer information properly.

Once you have finished editing the CSV file, continue with the following steps:

  1. Go to Products->Products List
  2. Look towards the top right of the page and click on the "Export/Import" button
  3. Once again, look for the "Options from Template" on the right hand side of the page and click on its + Icon to expand the options.
  4. Use the "Browse" button to search for and select your saved CSV file on your computer
  5. Click Import Data.

Upon a successful upload, your products will now be linked to their respective templates.

Note
As described in the Option templates Knowledgebase article you can either copy or link options (from a template) to your products.

The CSV import explained in this (the preceeding) article will use the link method of assigning the options to the product(s).



Attachments 
 

Help Desk Software by Kayako fusion