How Do I Import Product Options via CSV?

This guide will give you a step-by-step process on how to import your product options.

Import Product Options

To import product options (size, colors, etc.), please make sure your products have already been imported. You cannot import your product options if your products do not already exist in the system.

While logged into your Shift4Shop Online Store Manager, use the left navigation menu and:

1. Go to Products > Product List.

2. Look towards the top right of the page and click on the Export/Import button.

The Export/Import page will contain Export options on the left side and Import options on the right side.

3. Look towards the right side of the page and click on the + icon next to "Options."

4. Next, click on the Sample File link to download a clean copy of the imported CSV.

This file will give you a template of what information to include in your spreadsheet so you may import your information to your online store.

5. Open the file into a spreadsheet program such as Microsoft Excel or OpenOffice Calc.

See the image for a sample of what the spreadsheet file will look like.

You may now add product option information to the proper columns.

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.

• featuretype
  This is the type of option you want to have. (i.e., Checkbox, Radio Button, Dropdown Menu). The acceptable parameters are Dropdown, Radio, Checkbox, Title, Text, Textarea, DropImage, and 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 the 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 that will display this additional information. This field is not required. If no info is desired, then leave the 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.

• 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 the 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 its 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 one if you want the option to be hidden.

6. Once you have completed the spreadsheet, save the file. Be sure to save it as a CSV file.

7. Log in to your admin and go to Products > Product List.

8. Next, look towards the top right of the page and click on the Export/Import button.

9. Go to the right side of the page and click on the + icon next to "Options" to expand the selection.

10. Click on the Browse button and go to the CSV file on your computer.

11. Click Import Data.

Upon a successful import, your product options will be added to the store.