03. Ranges & Products

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

Originally written by John Hardwick, last updated Jul 27, 2026, on the Swan Retail knowledge base (FRS).

Part of: Product Creator - v1214

This document relates to spreadsheet version 1214.1.00 onwards

This document details the features within the Range & Products section of main menu.

Features include the creation and maintenance of ranges (collections). Creation and maintenance of products (SKUs) and the data linked to products (images, attributes, options and up selling)

It is possible to turn off the PRODUCT IMAGES , PRODUCT ATTRIBUTES , PRODUCT OPTIONS & PRODUCT UPSELLS buttons if not in use via the ADMIN button. When disabled access to these features will be prohibited.

This video describes the new menu system and the settings available within the Ranges & Products section of the Main Menu.

This video is based on 1211.0.0 and may not show all features available in later versions.

Ranges

This button allows the operator to view and subject to permission maintain ranges within the supplier.

Clicking the video icon in the top left of the menu, and subject to access, the operator can watch a short video relating to this page.

The left hand side displays a listing of ranges, highlighting (by clicking the row) populates the right hand side with the details of the range.

Button	Action
NEW	Clicking clears data from the right hand side of the screen and allows for a new range to be entered. Data isn’t saved unless the SAVE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
EDIT	Clicking allows access to the right hand side of the screen where a amendments are possible. Certain fields are protected once the data has been sent to SwanFRS - To gain access a password is required having clicked the UNLOCK button. Data isn’t saved unless the SAVE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
DELETE	Ensure the data row you wish to remove has been highlighted before selecting this feature, as it is not possible to reverse this action. Clicking deletes the highlighted row from the dataset with the condition that it has not been ‘sent’ to SwanFRS, in which case deletion is prohibited. To disable a range from being sent (and its associated products) tick the ‘Don’t Send to SwanFRS' check box. It is also recommended that Notes are added to inform viewers of decisions taken relating to the range - Notes are not sent to SwanFRS.
SORT	Clicking the SORT button allows the operator to resequence the data list into selected pick list product order and secondly whether to show ascending or descending values.
QUICK SORT	This button allows the operator, subject to permission, to apply a change to a chosen data element and apply the change to a selected list of data.
CLOSE	Click this button to close the Range Menu and return to the Main Menu.
LOAD	This button is only available in New or Edit mode. When selected it displays a windows file finder allowing the operator to choose the image to associate with the range. The window will open with the file path set in the ADMIN button.
Image hyperlink	When an image has been associated with a range a thumbnail image is shown on the page, clicking the image produces a window displaying a larger version of the thumbnail image. Click the CLOSE button to return to the data menu.
RESEQUENCE	This button only appears when there are products linked to the range. When selected the following form displays showing all products linked to the range. To resequence, select a row then use the arrow buttons to change the display order. When ready to commit, click the APPLY button which will change the numbering of the Grid Sequence field. The Grid Sequence controls the order SKUs are presented within the SwanFRS>Catalogue Search routine if the PRODUCT_DISPLAY_ORDER application parameter is set to Pricewriter.

Products

This button allows the operator to view and subject to permission maintain products (SKUs) within the supplier.

The top left side of the menu lists the SKUs in the dataset, the top right shows the primary thumbnail image where set.

The lower half of the screen displays the data related to the highlighted SKU,

Use the Select Data Source to change the display choosing from General, Purchasing, Stock, Dimensions, Pricing, Web & Miscellaneous data elements.

The maximise performance the display shows a maximum of 100 records at a time. Where more than 100 rows are present in the data set, page forward and page back icon are presented prior to the filter icon allowing the next or previous block of 100 records to be displayed.

This can be adjusted by using the filter icon shown to the left of the filter panel.

Clicking presents a filter window whereby it is possible to restrict the products displayed in the left hand pick list.

Specifying a Filter Field influences the Action which also affects the Value of the filter.

If the data set contains one or more ‘alert’ the ALERTS ONLY button displays filtering out all but rows containing an alert.

Clicking APPLY filters the data either resulting in a no matches found message or the pick list being restricted to those products matching the search criteria.

Hovering over the ‘found…’ message displays the filters used.

Filtering pulls back all matching rows at one, the 100 limit restriction is not applied.

Clicking the clear filter icon reverts back to a full list.

Button	Action
NEW	Clicking clears data from the bottom section of the screen and allows for a new product to be entered. Data isn’t saved unless the SAVE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
EDIT	Clicking allows access to the lower sections of the screen where a amendments are possible. Certain fields are protected once the data has been sent to SwanFRS - To gain access a password is required having clicked the UNLOCK button. Use the tabs to move between the data sets making changes as appropriate. Data isn’t saved unless the UPDATE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
CLONE	This feature copies the highlighted SKU row thus making it available change. It is necessary to set the SKU (where access is allowed) or set the line number before saving as duplicate SKUs are not permitted.
DELETE	Ensure the data row you wish to remove has been highlighted before selecting this feature, as it is not possible to reverse this action. Clicking deletes the highlighted row from the dataset with the condition that it has not been ‘sent’ to SwanFRS, in which case deletion is prohibited. To disable a SKU from being sent (and its associated products) tick the ‘Don’t Send to SwanFRS' check box.
SORT	Clicking this button allows the operator to resequence the data list into selected pick list product order and secondly whether to show ascending or descending values. The list of SKUs redisplays, returning back to the first block of data, and shows the selected sequence to aid selection.
QUICK SET	This button allows the operator, subject to permission, to apply a change to a chosen data element and apply the change to a selected list of data.
EXPAND	This button is only accessible if the highlighted SKU has options. Clicking presents a detailed listing of each option and its linked choices for the specified SKU.
CLOSE	Click this button to close the Products window and return to the Main Menu.
Image hyperlink	When an image has been associated with a range a thumbnail image is shown on the page, If there are multiple images linked to the SKU, it will be possible to move through theses images via the forward and back buttons at the bottom of the thumbnail. The number of images and the sequence number assigned to each image is also displayed in the top left. Clicking the image produces a window displaying a larger version of the thumbnail image. This window also allows the operator to scroll through the images associated with the SKU. Click the CLOSE button to return to the data menu.
IMAGES	Clicking opens a window listing all images linked to the highlighted SKU. This button is presented with a grey background if there are no linked images or a light blue background where images set linked. Subject to permission it is possible to add and maintain this list. The RESEQUENCE button appears only when viewing a specific SKU and allows order in which images are presented in FRS to be changed quickly.
OPTIONS	Clicking opens a window listing all options linked to the highlighted SKU. This button is presented with a grey background if there are no linked options or a light blue background where options exist. Subject to permission it is possible to add and maintain this list.
ATTRIBUTES	Clicking opens a window listing all attributes linked to the highlighted SKU. This button is presented with a grey background if there are no linked attributes or a light blue background where attributes are set. Subject to permission it is possible to add and maintain this list.
BLOCKED	Clicking opens a window listing all blocked option-answers associated with the SKU. This button is presented with a grey background if there are no blocked options or a light blue background where one or more exist. Subject to permission it is possible to add and maintain this list.
DEFAULT	Clicking opens a window listing all default option-answers associated with the SKU This button is presented with a grey background if there are no default options or a light blue background where one or more exist. Subject to permission it is possible to add and maintain this list.
WEB FEATURES	Clicking opens the web features window, pre-populated with the selected SKU This button is presented with a grey background if there are no default options or a light blue background where one or more exist.

Products Tab

This button, where visible, and clicked closes the Main Menu and opens the Items tab whereby it is possible to modify the products data using the standard spreadsheet features.

Not all functionality available in the window view is available when editing via the tab.

To return to the menu click the white house icon in the top left of the page or press CONTROL and M on the keyboard.

Product Images

This button allows the operator to view and subject to permission maintain images associated with products.

Clicking the video icon in the top left of the menu, and subject to access, the operator can watch a short video relating to this page.

The left hand side displays a listing of products and the images associated with them, highlighting (by clicking the row) populates the right hand side with the linked image.

Button	Action
NEW	Clicking opens the multi-mode form allowing the operator to choose the SKU(s) to be added and the images to be linked to it. AUTO MAP - This button requires only the images section of the screen to be populated and uses the image name to map against the SKU or Model number, Where a match is found the system assigns the image to the match. Image filenames should be <SKU or Model>.jpg (or similar). If multiple images then <SKU or Model>(<99>).jpg (e.g. 45-10-10(1),jpg, 45-10-10(2).jpg) BUILD COMBINATIONS requires both SKU and images to be listed and linked every image listed to each SKU irrespective of filename.
EDIT	Clicking allows access to the right hand side of the screen where a amendments are possible. Data isn’t saved unless the SAVE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
DELETE	Clicking opens a selection form allowing the operator to choose which SKU(s) and Images are to be purged. Clicking deletes the highlighted data from the dataset. (SKU and Image combinations, irrespective of sequence number, specified in the PINK ‘selected’ data grids.)
SORT	Clicking this button allows the operator to resequence the data list into selected pick list product order and secondly whether to show ascending or descending values.
QUICK SET	This button allows the operator, subject to permission, to apply a change to a chosen data element and apply the change to a selected list of data.
CLOSE	Click this button to close the Product Images window and return to the Main Menu.
Image hyperlink	When an image has been associated with a range a thumbnail image is shown on the page, clicking the image produces a window displaying a larger version of the thumbnail image. Where multiple images exist it will be possible to scroll through all linked images without having to close the window. Click the CLOSE button to return to the data menu.

Product Attributes

This button allows the operator to view and subject to permission maintain products with attributes.

Clicking the video icon in the top left of the menu, and subject to access, the operator can watch a short video relating to this page.

The left hand side displays a list of SKUs with their associated attributes, highlighting (by clicking the row) displays the primary product image (where set).

Button	Action
NEW	Clicking opens a data entry form at the bottom of the window whereby it is possible to select a SKU and associate an attribute to it. Data isn’t saved unless the SAVE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
EDIT	Clicking displays the selected SKU and attribute and allows editing of the attribute value. Data isn’t saved unless the UPDATE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
DELETE	Ensure the data row you wish to remove has been highlighted before selecting this feature, as it is not possible to reverse this action. Clicking deletes the highlighted row from the dataset.
SORT	Clicking allows the operator to resequence the data list into selected pick list product order and secondly whether to show ascending or descending values.
QUICK SET	This button allows the operator, subject to permission, to apply a change to a chosen data element and apply the change to a selected list of data.
MULTI-MODE	This feature allows a single image to be added to or removed from a range of SKUs in a single action.
CLOSE	Click this button to close the Product Attributes window and return to the Main Menu.
Image hyperlink	When an image has been associated with a range a thumbnail image is shown on the page, clicking the image produces a window displaying a larger version of the thumbnail image. Where multiple images exist it will be possible to scroll through all linked images without having to close the window. Click the CLOSE button to return to the data menu.

Product Options

This button allows the operator to view and subject to permission maintain product a series of questions or clarifications for a specific product.

Clicking the video icon in the top left of the menu, and subject to access, the operator can watch a short video relating to this page.

The left hand side displays a list of SKUs , highlighting (by clicking the row) displays to the right of the screen a list of questions (options) for the SKU.

The up and down arrows allow the resequencing of options and the icon to the right of the page shows the answers to the option (where applicable).

Each SKU has a maximum of 50 questions with the page showing 10 options at a time.

If more than 50 options are required please contact Swan Support and this restriction will be increased.

Button	Action
NEW	Clicking opens a data entry on the right hand side of the screen, allowing a new record to be created. Data isn’t saved unless the SAVE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
EDIT	Clicking allows change of the options and / or SKU (if manually keyed) Data isn’t saved unless the UPDATE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
CLONE	Clicking clones the highlighted / selected SKU’s option structure, replicating it for all ‘selected’ SKUs. Data isn’t cloned unless the BUILD button is selected
DELETE	Ensure the data row you wish to remove has been highlighted before selecting this feature, as it is not possible to reverse this action. Clicking deletes the highlighted row from the dataset.
MULTI DELETE	This option allows the mass removal of ALL options set against selected SKUs.
SORT	Click Sort allows the operator to resequence the data list into selected pick list product order and secondly whether to show ascending or descending values.
QUICK SET	This button allows the operator, subject to permission, to apply a change to a chosen data element and apply the change to a selected list of data.
EXPAND	This button is only accessible if the highlighted SKU has options. Clicking presents a detailed listing of each option and its linked choices for the specified SKU.
MULTI-MODE	Clicking allows multiple options to be added to or deleted from multiple SKUs When selecting a specific Option ID and ticking the overwrite checkbox forces the process overwrites existing options, where not ticked the system will find the next available ‘option slot’ t add the ID (After the selected option number).
CLOSE	Click this button to close the Product Options window and return to the Main Menu.
Image hyperlink	When an image has been associated with a range a thumbnail image is shown on the page, clicking the image produces a window displaying a larger version of the thumbnail image. Where multiple images exist it will be possible to scroll through all linked images without having to close the window. Click the CLOSE button to return to the data menu.

Product Upsells

This button allows the operator to view and subject to permission maintain product relationships.

Clicking the video icon in the top left of the menu, and subject to access, the operator can watch a short video relating to this page.

The left hand side displays a list of SKUs with their associated up-sell product, highlighting (by clicking the row) displays to the right of the screen the product information and the up relationship type

Button	Action
NEW	Clicking opens a data entry on the right hand side of the screen, allowing a new record to be created. Data isn’t saved unless the SAVE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
EDIT	Clicking allows change of the relationship and / or SKU (if manually keyed) Data isn’t saved unless the UPDATE button is selected (only displays when inserting a new record to the left of the CLOSE button). If selected in error click on an existing row to cancel the new action and return to the browse mode.
DELETE	Ensure the data row you wish to remove has been highlighted before selecting this feature, as it is not possible to reverse this action. Clicking deletes the highlighted row from the dataset.
SORT	Click Sort allows the operator to re-sequence the data list into selected pick list product order and secondly whether to show ascending or descending values.
CLOSE	Click this button to close the Product Upsells window and return to the Main Menu.
Image hyperlink	When an image has been associated with a range a thumbnail image is shown on the page, clicking the image produces a window displaying a larger version of the thumbnail image. Where multiple images exist it will be possible to scroll through all linked images without having to close the window. Click the CLOSE button to return to the data menu.