This spreadsheet will be populated when a feature is selected in either the Features spreadsheet or the Feature View. The following is a summary of the columns in the Options Spreadsheet and how they are used to work with options. For more information on working with spreadsheets, see the Spreadsheets page, and for general information on options see the Options page.
Right-click on the header of each column to see the filter dialog. Simply type in any keyword and start refining the search result and using OR filter (Match any) or AND filter (Match all). The filter status is shown at the top of the spreadsheet.
Every option requires an identifier that is unique to the feature that owns it. This is the code by which the option is referenced by the feature. New options can be created by entering a code into an empty cell. And likewise, deleting a code from this column will remove an option from the feature. In order to maintain the uniqueness of the option codes, any time the user enters a code that is not unique, the creator will add characters to make the code unique, before submitting the change to the catalogue. Any leading/trailing spaces will be highlighted in yellow to prevent unwanted space.
It is possible to re-sequence options code by right-clicking on the code header -> reorder ascending or reorder descending. Note that once you reordered the option code sequence of a published catalogue, loading old drawing will have an issue, use with caution.
Code Range Min.
Forming the minimum of an option dimension range.
Code Range Max.
Forming the maximum of an option dimension range.
Code Range Inc.
The increment step of the option dimension range.
These columns allow for human-readable descriptions of the option. Note that there will be a Description column for every language that is enabled in the catalogue. This is the text that will be used to describe the option when the feature is presented to a user.
These columns are used to set the upcharge or discount on an option. Note that there will be a Price column for every base price list in the catalogue. This value will be used in calculating a product’s final price when the option is selected.
These columns are used to set option price codes for the option. Note that there will be a Price Codes column for every base pricelist in the catalogue. This is how a product will reference the option to set its option price.
To set price codes, click the button on the right side of the cell. A small popup will appear with a text field and a list of existing option price codes. To enter a new option price code, type the code into the text field, and press the Enter key. To enable or disable option price codes, select them in the list. Option price codes on the option will have a checkmark next to their code in the list.
This column is used to set the leadtime program for an option. To assign a program, click the button on the right side of the cell. A popup will appear with a list of all leadtime programs on the catalogue. Select a program from the list to assign it to the option. To remove a program from an option, either select “<None>” from the popup list, or select the cell and press Delete. For more information on leadtime programs, see the Leadtime Programs page.
This column is used to set the SKU selection flag on the option. The flag can be set and unset by selecting the checkbox in the field. Note that if the feature that owns the option has the SKU selection flag set, it will override this setting.
This column is used to mark the option as an undefined option. It can be set and reset in the same manner as the SKU selection field.
This column is a reference column and is used to indicate the surface id(s) and material(s) linked to the option.
This column is a reference column and is used to indicate the symbol(s) linked to the option.
This column is used to set subfeatures on the option. Click the button on the right side of the cell to display a popup listing all available features on the catalogue. Note that if the current catalog is set to use vendors, this list will be filtered to only include features on the same vendor as the feature that owns the option. Also, features that could create a feature loop will be filtered from this list.
To add or remove a sub-feature from the option, select or deselect it from the popup list. To further filter the list of features, enter text into the field at the top of the popup. Only features with a code that contains the typed text will be displayed.
External Reference Keys
This column is a reference column and is used to indicate the external reference keys of an option. The external reference key is used to match the key from one option to that of an external reference, meaning the external reference only shows up when the option with matching key is selected.
Sometimes an Option can be different if the product is mirrored, and this is where we can adjust the Option of the mirrored product.
It gives an Option to result in a different Option within the Feature.
Please sign in to leave a comment.