12. Choices Tab

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

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.

  • The Option field is empty

  • The Description is empty

  • Loop on X – a linked question is looping back to the option question which would create an endless loop when selecting choices in SwanFRS.

  • Duplicate QX - the same nested question has been specified more than once for this row.

  • Type in Option – appears if a selection is set against a type in option which does not have choices.

  • Value > 100% - appears when a cost or selling value is greater than 100 for an Option marked as having a percentage uplift structure.

  • Nested Optons - this warning appears if the question is a second or subsequent level question - i.e. a question asked only if the operator specifies a specific answer to a question.

  • Discontinued - the item has an historic discontinued date

  • Future Discontinued - The row has a future discontinued date.

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
(Cost x + uplift)

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.

  • Right clicking, with the cursor sat in the desred Image URL cell and selecting the Show Image option.

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.

  • Cost Uplift using Formula – this is primarily to calculating a cost price using one of the formula choices.

  • Margin – use the margin formula to calculate the result

  • Charm only – do not apply a formula – just charm the destination column.

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,

  • Any value in the range 100 to 109 will be reduced by 10 this changing 100 to 90, 101 becomes 91 etc.

  • Values in the range 1210 to 1219 would be reduced by 20, 1210 would become 1190, 1211 would become 1191 etc.

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

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