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:
- Create option Set
- Importing the values
- 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 | |
| Description | Default: 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) 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. |
| ID | Default: 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. |
| Inventory | Default: 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 |
| Required | Default: Yes |
| Type | Default: Select Box |