Originally written by John Hardwick, last updated Oct 25, 2023, on the Swan Retail knowledge base (FRS).
Part of: Product Creator - v1207
The Options tab holds a list of questions that may be asked by the system when defining an item. The question list is specific to the supplier. Questions may have a preset list of choices or allow free format data entry.
The system will overwrite existing options or create new ones at time of catalogue import.
Do not change the description of an existing option, as this will change all purchasing histories within SwanFRS. For example, changing Colour to Size will ripple across all stock items using the option, thus changing their structure. If this is needed to discontinue the old and generate a new.
|
Field |
Comments |
|
Include |
Setting this cell to ‘n’ tells the ProductXML tab to ignore this row, thus omitting it from the XML generated. All options (Questions) and choices (Answers) are excluded from the data export. Setting to ‘n’ turns the row amber to indicate the row is ‘inactive’ Remove the ‘n’ to make the range active again. ‘n’ or ‘N’ are valid entries. |
|
Alert |
This field will produce a warning if one or more of the cells in the row would cause a problem when loaded into SwanFRS. The Type in Option is set – this is a warning only and does not trigger the alert message. The No Choice Set is displayed if the option is set as a pick list with no ‘active’ choices available. (Active excludes options with discontinued date, either historic or future) If there is one or more alert, the header row will show the Check Alerts notification, useful if the issue relates to a row not currently displayed on screen. |
|
Description |
Specify the question / option / statement. Description MUST be unique. Cells in this column may be locked if imported from or sent to SwanFRS. To unlock, click the red disk with the pad-lock and enter the password. This will unlock the pink cells. The password is provided during training or can be obtained by logging a support ticket. To re-lock, repeat this process. |
|
SwanFRS Option Description |
Optionally specify an alternative name to be used within SwanFRS. Using the same Description in this spreadsheet will cause issues, therefore each row should have a unique description – this causes issues in SwanFRS where you may want to have more than one option with the same ‘operator facing’ title. E.g., Colour. – one for Grade A colours, one for Grade B colours, and so on. This feature allows the same option name to be used in the software. Cells in this column may be locked if imported from or sent to SwanFRS. To unlock, click the red disk with the pad-lock and enter the password. This will unlock the pink cells. The password is provided during training or can be obtained by logging a support ticket. To re-lock, repeat this process. |
|
Option ID |
Specify a unique question number (within the supplier / vendor) The AUTO # button automatically populates all rows in the table with an incremental Option ID number, starting with the next number from the largest number already defined. This process is non-destructive, only converting option with descriptions that do not have Option IDs. Cells in this column may be locked if imported from or sent to SwanFRS. To unlock, click the red disk with the pad-lock and enter the password. This will unlock the pink cells. The password is provided during training or can be obtained by logging a support ticket. To re-lock, repeat this process. |
|
Text option |
Specify if the option can have a free format text entry.
Any option set to N without option choices will cause an error when the XML is generated.
|
|
Affect Prices |
Specify if the option will affect the item’s cost.
|
|
Prompt quantity |
Specify if the option has a quantity entry.
|
|
Auto Expand |
Specify if the option is to display a list of all choices for linked questions before a choice for this question is selected. This is of use if there are several grades, with a further choice of colour within grade. Setting to Y shows all colours for all grades and autopopulates the grade once the colour is selected. Choose from Y or N. |
|
Notes |
This is a free format narrative, allowing the operator to enter useful information about the option question. This field is not imported into SwanFRS. |
Invalid or duplicated cells will be highlighted with a red or pink, respectively.
It is recommended that the table be sequenced alphabetic ascending description order.
This process not only re-sequences the data into alphabetic order it will also change any duplicated description adding the row number to the description used in the catalogue, if a SwanFRS description isn’t set it will move the original description title to this field. The Description is used in lookups within the spreadsheet. The SwanFRS Description will be sent to SwanFRS and will be used in the application.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article