Importing Product Option Sets

Introduction

The purpose of option sets is to allow your customers the capability to modify their product. Let's say, that you have a large number of options that you would like to add/upload to your website, utilizing the option set import model, allows you to do this.  You have several types of option sets to select from.

Steps

When using the option sets import feature, first, you will need to create a spreadsheet indicating all of the values that you would like to display along with product. Once you have created your spreadsheet and saved it as a CSV file, then you can begin to set up the back end of WSM, to allow importing of your option sets.

When importing options sets and assigning them to products it's a 3-step process:

        1. Create option Set
        2. Importing the values
        3. Assigning them to products

Note: The "name" is the most commonly used unique value for this import model.

Form Fields Defined

Default:  The value which is automatically displayed if you have not designated a value on your import file.

Values:  Indicates how you must enter the text for that particular field category.

Delimited: Indicates what you must use for your Multi-Value Delimiter when having multiple cells load into one profile field. This feature is most commonly used when loading product images, as many times clients wish to show multiple product images for each item. If the MVD was a - your VALUES would read as the following: ${column header1}-${column header2}-${column header3}

Force Update:  Indicates whether a force update must be clicked to have the new data load over the existing data. A force update is needed when an existing field’s information does not automatically update with the new csv file’s data.

Character:  Either a restriction or recommendation for this field.

Special Notes:  See special notes section for any additional details that may need to be referenced.


Form Fields Defined
DescriptionDefault: Blank
Values: Text, HTML Allowed
Delimited: N/A
Force Update: No
Character Limit: 2,000,000
Special Notes: When entered the information will appear above the option set.
Hidden

Default: No (not hidden)
Values: 0 or 1
Delimited: N/A
Force Update: No
Character Limit: 1
Special Notes: 1=Yes, 0=No. When set to "Yes" the selected option set will not be displayed to the customer when the item is added to the cart. However, the option set will still be viewable on the product page. 

Only the number should be entered in the cell in your CSV file, no text. It can also be added as a literal value in your CSV Profile.

IDDefault: System Generated by WSM
Values: Numerical ID
Delimited: N/A
Force Update: No
Character Limit: N/A
Special Notes: This ID can only be used when updating existing option sets. It cannot be used too create new option sets.
InventoryDefault: No
Values: 0 or 1
Delimited: N/A
Force Update: No
Character Limit: 1
Special Notes: 1= Yes 0= No. When set to "Yes" this requries the customer to complete the option set before adding the item to the cart.
Name

Default: Blank
Values: Text, no HTML
Delimited: N/A
Force Update: No
Character Limit: 255
Special Notes: This name is used for admin purposes only and will no be displayed to the customer during the shopping experience. 

Required

Default: Yes
Values: 0 or 1
Delimited: N/A
Force Update: No
Character Limit: 1
Special Notes: 1= Yes 0= No. When set to "Yes" this requries the customer to complete the option set before adding the item to the cart.

Type

Default: Select Box
Values: Text Field, Image Upload, Date, Date and Time, Select Box, Multi-Select Box
Delimited: N/A
Force Update: No
Character Limit: N/A
Special Notes: This allows you to specify what type of option set you are creating. When importing, the value in your file must match one of the values listed above.


For additional assistance with importing please complete our support request form.