Originally written by John Hardwick, last updated May 16, 2024, on the Swan Retail knowledge base (FRS).
This suite of documents relates to the SwanFRS Product Creator Excel, which is designed to offer the retailer a means of creating and maintaining their product portfolios.
This spreadsheet is based on Office 365 and designed to work using the Windows operating system.
Click to view Important information about the spreadsheet, restrictions and requirements
The IOS operating system does not support all macro features - This spreadsheet will not function correctly with IOS
Older Versions of Excel, using the spreadsheet when opened in SharePoint or disabling macros, will cause the failure of the document.
Certain areas of the spreadsheet consume PC resources, therefore a 64-bit operating system, with sufficient memory, is strongly recommended.
When wishing to paste data into the spreadsheet, please use the CTRL-V or the Paste-Values option. Pasting data directly into a cell may result in the formula's assigned to that cell being lost, and therefore the XML may not load successfully.
When deleting rows in tables, please do not delete row 6 in any tab, as this controls the formulas - deleting may cause the XML creation to error.
Pages are password protected to preserve formulas and indexing.
It is strongly advised that when using the Product Creator Spreadsheet, the in-application Set Up Product Pricing is not used as changes will one-system will conflict with the other unless there is a rigid process put in place to mitigate this risk.
Spreadsheets are named commensurate with the version of SwanFRS they are released against.
The second digit relates to a major patch, with the third component being a minor release or bug fix.
This is designed to make it easier to establish whether the spreadsheet is compatible with your version of SwanFRS and when used in partnership with the Last Updated date to establish if you are using the latest version of the spreadsheet.
It will only be possible to ‘download’ the latest version (patch) of the spreadsheet.
SwanFRS use the term ‘SKU’ as for a product code, the product code holds all the information pertaining to that product and forms the basis of operation within SwanFRS.
SwanFRS allows SKUs generated outside the application to be imported into it via a predefined schema using an XML structure, as the medium for import.
Whilst it is possible to generate the XML externally, Swan offer an Excel spreadsheet allowing the retailer to maintain their product portfolios prior to importing into SwanFRS. This spreadsheet offers a host of features to make maintaining products and associated costs as simple as possible
Information relating to the spreadsheet has been broken down into a document per tab.
If new to the spreadsheet or reviewing a new release for the first time, it is recommended you read the overview document before visiting the other guides in this pack.
01. Overview
General guide and tips re the features available within the spreadsheet.
02. Admin Tab
This tab is designed for use by the local system's administrator, allowing the setting of various parameters controlling how the spreadsheet works.
03. Catalogue Tab
The catalogue tab holds data pertaining to a specific supplier. It is possible to show / hide tabs as necessary.
Swan recommend using a separate spreadsheet for each and every supplier and to introduce a grand-father / father / son type sytem to protect against spreadsheet corruptions.
04. Notes Tab
The Notes tab is a scratch pad designed to allow the operator to record any information deemed necessary about the supplier or products within the supplier.
05. Product Groups Tab
This tab holds the product groups used in SwanFRS and is used as a look-up for the product group choice list on the Items tab.
06. Attributes Tab
This tab holds any attributes used in SwanFRS and is used as a look-up for the attribute’s choice lists on the Items tab.
07. Price Points Tab
This tab holds a list of preferred selling prices and is used by the update prices button on the Refresh, Choices, and Items tabs, thus allowing you to create your own charming conditions.
08. Sales Departments Tab
This tab holds a list of Sales Departments and Item Relationship look-ups. These data elements provide pick lists within the Items tab.
09. Ranges Tab
The Range / Collection tab is used to create a grouping or style of product. This is effectively the design or brand provided by the supplier.
10. Options Tab
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.
11. Option Attributes Tab
The Options tab offers 5 attribute columns per Option Question, if this is insufficient additional attributes can be defined via the Option Attributes tab.
12. Choices Tab
The (Option) Choices tab lists answer (or choices) to Options (questions) that may be asked by the system when defining an item.
13. Choice Links Tab
When turned on, via the Catalogue Tab, this page allows the linking of next level questions to specific answers.
This tab need only be used where the 5 default next level questions are not sufficient to accommodate requirements on the Choices tab.
14. Choice Attributes Tab
The Choices tab offers 5 attribute columns per SKU, if this is insufficient additional attributes can be defined via the Choice Attributes tab.
15. Items Tab
The Items tab is used to create the list of products. This is the base product which will be searched for by the operator / sold to the customer. Each item may link to one or more choices.
16. Item Attributes Tab
The Items tab offers 10 attribute columns per SKU, if this is insufficient additional attributes can be defined via the Item Attributes tab.
17. Item Options Tab
The Items tab offers 20 questions per SKU, if this is insufficient additional questions can be defined via the Item Options tab.
18. Item Images Tab
The Items tab offers 10 images per SKU, if this is insufficient additional images can be defined via the Item Images tab.
19. Item Relationships Tab
When turned on, via the Catalogue Tab, this page allows the linking of SKUs to form an ‘upsell’ scenario at point of sale within SwanFRS sales order creation suite.
20. Blocked Options Tab
Blocked options are used to stop SwanFRS offering a question/answer (Option/Choice) for a specified SKU, and therefore enable the use of generic question/answers with specific answers being blocked for a given SKU.
21. Default Options Tab
This tab allows the specification of a default answer (pre-set pick list) for a specific question / Item combination.
22. Generate XML Tab
The GenerateXML tab converts the data held in the various tabs into an XML load file which can then be used to update / Import into SwanFRS.
23. Sets Tab
A set is a group code comprising multiple SKUs. This tab allows the creation of the set parent and its component codes (component codes may be from other spreadsheets / different suppliers).
24. Matrix Tickets Tab
When turned on, via the Catalogue Tab, this page allows the creation of a series of data grids which are designed to control the content of a grid format display ticket.
25. Web Features Tab
When turned on, via the Catalogue Tab, this page allows the grouping of SKUs which can be used on a website as a collation or roll-up, thus improving the user experience on the web.
26. Price Refresh Tab
This tab is specifically designed to assist with the process of price management. It allows the pasting of a ‘reference' and cost value which is then mapped to SKU data showing the movement in cost price, which can then be used to generate revised selling prices prior to sending them to the Items tab and onwards exporting to SwanFRS.
27. Importing Mapped Data
The import process allows raw data provided by a third party to be imported into the spreadsheet using a mapping tool.
28. Product Group Cross-Reference Tab
When using the mapping tool, the third party may provide a product group or genre type, this is unlikely to map to the SwanFRS product group. This tab allows a cross-reference to be constructed which will map a product genre to a SwanFRS Product group.
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