Originally written by John Hardwick, last updated Nov 01, 2023, on the Swan Retail knowledge base (FRS).
Part of: Product Creator - v1207
The (Option) Choices tab lists answer (or choices) to Options (questions) that may be asked by the system when defining an item.
Text options do not need option choices.
It is necessary to have at least one choice for each option question even if that choice is ‘not applicable’.
The system will overwrite existing options or create new ones at time of catalogue import.
Do not change the description of an existing option choice as this will change all purchasing histories within SwanFRS. For example, changing Red to Blue will ripple across all stock items using the option thus changing their structure. Discontinue the old and generate a new….
Alert – Column C
The VIEW button in the Alert column changes the display to maximize the space available. Clicking generates the following window
The page displays the type of view selected in yellow text in teh dark blue page header.
Select one of the following to change the screen display. (either double click or select an option then click the CHANGE button.)
|
Choice |
Action |
|
Consolidated |
This choice hides the active option, choice code and and description columns, consolidating them into a single column thus making space for more ‘active’ columns to be viewed on the right-hand side of the page. This mode is particularly useful with the products have been identified and you’re populating the dimensions and control elements of the SKU |
|
Choice Maintenance |
This choice displays the option, choice and descriptions columns allowing them to be modified (subject to whether they are deemed known to SwanFRS where modification is restricted). This mode consumes almost all the screen and therefore there is little space for additional control columns. |
|
Field |
Comments |
|
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. Red indicates alerts / yellow is a message which will not stop the export.
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. |
|
Option |
Choose the question the answer relates to – select from the list of options in the pick list. Cells in this column may be locked if imported from or sent to SwanFRS. To unlock click the red disk witht 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. |
|
Choice Code |
Optionally specify the manufacturer’s code for this answer. Cells in this column may be locked if imported from or sent to SwanFRS. To unlock click the red disk witht 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. |
|
Description |
Specify the choice /answer text. Cells in this column may be locked if imported from or sent to SwanFRS. To unlock click the red disk witht 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. |
|
Sequence |
Specify the sequence in which answers within the Option ID are to be listed. |
|
Cost 1 |
Specify the base cost of the option choice (retailers cost) of the item. For new items this column must be set for the SKU to import – Do not set the Include Prices to N if creating new SKUs |
|
Cost 2 |
Optionally specify a second cost |
|
Ancillary Cost x (1 to 5) |
Optionally specify ancillary costs associated with the SKU. These costs will be added to the ‘active cost’ thus forming the Cost + Uplifts value. The row header for each ancillary cost is shown as set within the Catalogue Tab. |
|
Landed Cost |
This is the ‘active’ cost column (as defined in blue cell header above the column header. The value displayed is the chosen cost + the sum of the ancillary costs. This field is used when ‘calculating’ selling prices but is NOT sent to SwanFRS unless the Catalogue Tab, Export Landed instead of parameter is set. |
|
Currency Cost |
For currency suppliers / vendors where the supplier’s / vendor’s cost is fixed specify the cost price in the supplier’s / vendor’s currency. When raising purchase orders, the system will calculate the base currency cost by dividing the currency cost by the current exchange rate. For base currency suppliers / vendors leave this field blank. This field is not sent to SwanFRS |
|
Retail |
Specify the RRSP / RSP / high price for the item. This price is NEVER charged by SwanFRS and only used to show the client what the price may have been. |
|
Sell 1 |
Specify the selling price 1 of the item. It is suggested to set this as the standard or establishment price. |
|
Sell 2 |
Specify the selling price 2 of the item. It is suggested this price be the ‘in sale’ price. |
|
Sell 3 |
Specify the selling price 3 of the item It is suggested this is the special event price. |
|
Web Price |
Specify the web selling price of the item |
|
Workzone X (1 to 3) |
These columns are provided for ‘what if’ scenarios, they allow you to experiment with costs and selling or hold calculated values which etc. These fields are not sent to SwanFRS |
|
Achieved Margin |
This field shows the margin of the item if sold at the prices specified – the margin show relates to the ‘active selling price’ chosen in the blue control cell. Tax is calculated using the Tax Rate values set in the Catalogue tab. |
|
Selling Price to Achieve Margin |
This column shows the ideal margin using the tax rate set in the Catalogue tab and the preferred margin percentage control cell. This value is the raw (uncharmed) selling price required to meet the margin threshold specified. |
|
Lead time |
Specify the lead time adjustment (in days) choosing this answer has on the items overall lead time. |
|
Disc Date |
Specify the date this item becomes / became unavailable. |
|
Option Choice Image |
Specify a default image for the option choice. This can be either an image name or a full URL to the image. When linking to a Swan website the recommended image size is 100x100 pixels with images saved in jpg format. Quality 60% - web safe sRGB. Where configured the spreadsheet will present a thumbnail image of the locally held URL.
Double Clicking, or right clicking and selecting Add Image from the menu with the cursor focused in an image cell opens a file explorer from which it is possible to choose the image file. |
|
Linked Question X (x in the range 1 to 5) |
This optional field is used when there is a further clarification question required because of choosing the specific answer. Up to 5 questions can be asked from a single answer in this tab. If further questions are required turn on the Extended Options Links (Choice Links) tab where it is possible to set any number of clarification questions from a specific answer. |
|
Attribute Group X (x in the range 1 to 5) |
This optional field is used to hold attribute group codes (as set within the Attributes Tab) If more than five attributes are required for the option answer open the Choice Attributes tab and place the extras in this page. |
|
Attribute Value X (x in the range 1 to 5) |
This optional field is used to hold attribute value If left blank a 1 value will be sent to SwanFRS. If an attribute group has the | delimiter set, values specified in this field are replaced with the text following the | indicator in the Group field. |
Invalid or duplicated cells will be highlighted with a pink background.
Price Related Buttons
This section details buttons common to the Refresh, Choices, and Items tab.
This option may be restricted in which case selecting the button will present the following message.
Change Margin
Clicking this button begins the process of changing the ‘ideal margin’ (held on the catalog tab) and used to calculate the ‘selling price to achieve the stipulated margin’ column.
It also controls the background column of the ‘achieved margin’ column, showing red if the calculated value is below the target or green if above. (The brighter the green the higher the margin)
Once change the legend to the right of the button shows the new margin and the columns mentioned above will change accordingly.
Update Ancillary Costs
This feature has now been incorporated in the UPDATE PRICES button in the header row, which is now located above the Currency / Retail Price columns.
Convert
This button instructs the routine to convert values in the Currency Cost column to base currency using the ‘exchange rate’ set in the Catalogue tab.
Update Prices
This button allows a range of calculations to be performed on ‘price’ columns, clicking presents a two tabbed window offering basic and advanced adjustment calculations.
Basic Pricing
This tab offers a simple approach to price changes offering a series of arithmetic options.
|
Field |
Comments |
|
Source Column |
Click to highlight the source column to be used when applying the calculation. |
|
Destination Column |
Click to highlight the destination column, the column in which the results of the calculation are to be stored. |
|
Calculation |
Choose the type of calculation to be performed |
|
Value |
Specify the value the source column is to be adjusted by. This field requires a decimal value to be entered. |
Advanced Pricing
This tab offers a series of formula options to calculate (primarily) selling prices.
|
Field |
Comments |
|
Source Column |
Click to highlight the source column to be used when applying the calculation. |
|
Destination Column |
Click to highlight the destination column, the column in which the results of the calculation are to be stored. |
|
Formula |
Choose one of the formula options specified in the Catalogue tab to be used in partnership with the Calculation and / or charming choices relating to ‘formula’. Where set the screen will use the name given to the formula. |
|
Calculation |
Choose one of the calculation methods.
|
|
Charming |
Choose how the calculated value (in the destination column) should be ‘rounded’ |
|
Charming 0 & 1s |
Where ticked the charmed price will be further adjusted if the value is X0Y or X1Y where X and Y are numbers. X0Y will have 10 taken from the value, X1Y will be reduced by a value of 20. This applied to values over 99. For example,
|
Once the APPLY .... button is selected the notice at the foot of the window will display progress. It may take time for the routine to apply price changes to all visible rows.
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