10. Options Tab

Created by Migration Bot, Modified on Fri, 23 Oct at 11:20 AM by Migration Bot

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.

  • N – a selection from a drop-down list is required.

Any option set to N without option choices will cause an error when the XML is generated.

  • Y – this is a text entry and therefore there are no option choices.

Affect Prices

Specify if the option will affect the item’s cost.

  • N – This option is not cost affecting.

  • P – The option will uplift the cost price by a specified percentage.

  • V – The option will uplift the cost price by a fixed value.

Prompt quantity

Specify if the option has a quantity entry.

  • N – No quantity applicable. (The letter o not a zero)

  • C – Choose a quantity from a pick list (0 to 10)

  • S – Manually set a quantity.

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article