Product Creator - v1207

Created by Migration Bot, Modified on Fri, 23 Oct at 2:30 PM by Migration Bot

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

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