Knowledgebase: Products
How do I use the product options Sample file?

To import options for your products you must first make sure that your products have been imported. You cannot import options if your products do not already exist in the system. Click here to learn how to perform a fresh import your products using the sample CSV file. Alternately, if your products are currently in the system, then click here to download a sample csv file for the options import. This csv file contains the following column headings.

Important:
The information provided here will be in regards to adding new options to your products via the CSV import functions. To update existing options on your store, it is usually best to export your existing product CSV file and edit the file for later upload.

Here is a description of each field:

  • optionid:
    This field is filled in by the system. If you are doing a fresh import of new options then leave this field blank. The system will assign this ID.
  • productid:
    This field is required. This is the id of the product that this option will be for. Make sure that the id matches the product.
  • catalogid:
    If you are doing a fresh import leave this field blank. It will be filled in by the system.
  • featurecaption:
    This is the Name of the option (i.e. Color, Size). This field is required.

Note:
If the Feature Caption field is left blank, the system will not allow you to import the Product Option information.

  • featuretype:
    This is the type of option you want to have. (i.e. Checkbox, Radio Button, Dropdown Menu). The acceptable paramaters are Dropdown, Radio, Checkbox, Title, Text, Textarea, DropImage, File.
  • featurerequired:
    This tells the system if this option is required or not. 0 = no 1 = yes
  • sorting:
    This field defines the order of the options. It only applies when there is more than one option. If no sorting is desired simply fill in 0 for all options.
  • url:
    This field is used to define a URL for additional information. If filled out the info icon will show and be a link to this URL. This field is not required. If no url is desired then leave field blank.
  • info:
    This field is used to define additional information about the option. If filled out the info icon will show and be a link to a pop up which will display this additional information. This field is not required. If no info is desired then leave field blank.
  • featureid:
    This field is only used when updating options. It is required and pre-filled by the system. If you are doing a fresh import then leave this field blank.
  • featurename:
    This is the name of the option. (i.e. Red, White, Blue or Small, Medium, Large). This field is required.

Note:
If the Feature Name field is left blank, the system will not allow you to import the Product Option information.

  • featureprice:
    This field defines an additional value for the option. When this option is filled in this value will be added to the base price of the product. If no additional value is desired then leave field blank.
  • sorting:
    This field defines the order used to display the option values. If no order is desired then enter 0.
  • partnumber:
    This field is used to define a specific id to this particular option (Ex. If you have a Size option of Small, Medium and Large; each option can have it's own unique id. Small can be sm001, Medium can be med1001, Large can be lrg1001).
  • imagepath:
    This field only applies if you are using DropImage for the Feature Type. This should include the path to the image.
  • selected:
    This field defines which option should be pre-selected by default. Enter 1 for the option you want to be pre-selected.
  • hidden:
    This field defines if the option should be hidden from the customer. Enter 1 if you want the option to be hidden.

Help Desk Software by Kayako fusion