Originally written by John Hardwick, last updated Jul 28, 2026, on the Swan Retail knowledge base (FRS).
This document is based on spreadsheet version 1214.1.00
The version if the product creator has been designed to remove the ‘tabular' feel provided by Excel and therefore make it easier to work with for operators more familiar with a forms approach to data management.
Moving to a ‘forms’ delivery allows for greater data validation, control and improves issue notification as well as allowing the routine to be more responsive.
Many of the import / export processes have been overhauled to improve data consistency checking and reduce processing times.
All data in previous versions of the product creator spreadsheet can be imported into the new design, which also has enhanced and improved user features.
SwanFRS Product Creator 1211.x.x is designed to work with SwanFRS version 1207 or later.
The spreadsheet is designed around a menu, however dependant upon configuration it may display the home page rather than a menu when opened.
To display the menu, either click the ‘home’ icon, press CONTROL and M on the keyboard or click the OPEN MENU tab in the lower left of the screen. This tells the spreadsheet to show the ‘main menu’.
The window is broken down into areas of like operation, framed with a line boarder and titled appropriately.
The spreadsheet has been constructed to control access, this means that whilst a menu / window (User Form) is visible it is not possible to click on any other area of the Excel document or process a different Excel Document.
To do so, click the CLOSE MENU button, which will return the spreadsheet to the Home page, process the transaction e.g. open or modify a different spreadsheet and then restart the menu by clicking back into the produce creator, pressing CONTROL & M or pressing the house icon which appears top left of each visible tab.
Dependant upon the operating mode of the operator certain buttons and features may be restricted. The operating mode is displayed below the ‘check alerts’ notice.
The following documents relates to a specific area of the main menu…
Click the name to view the document
Not migrated from Confluence (over Freshdesk's file size limits): 2729508882.mp4 (222 MB)
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