Originally written by John Hardwick, last updated Aug 11, 2026, on the Swan Retail knowledge base (FRS).
The SwanFRS Product Creator (PCS) is a spreadsheet created using Microsoft Excel 365 and contains macros.
Click to view important usage information relating to the use of this spreadsheet.
The spreadsheet requires Excel 365 to be installed on the computer opening the spreadsheet (SharePoint editing and browser viewing will cause the spreadsheet to fail, as it requires macros to operate).
Opening the spreadsheet on your local computer is necessary.
The spreadsheets provided contain sample data which is used in our demonstration systems, however the spreadsheet offers a data import feature allowing data to be ported from an earlier version of the spreadsheet, extracted from SwanFRS or imported from an external data set.
Details of the features and processes are contained in the supporting guide.
It is recommended that you use the latest version of the spreadsheet suitable for your version of SwanFRS. As new features appear, issues are resolved, this page will be refreshed accordingly,
When using the Product Creator the SwanFRS Set Up Product Pricing should not be used as these two processed alter the same data set, and therefore it becomes difficult to ensure data consistency is maintained if both methods are used concurrently.
Please ensure you’re using the correct and most up-to-date version of the spreadsheet for your version of SwanFRS.
New Features and enhancements are only applied to current spreadsheet (1211), earlier versions will have issues resolved.
Your local Excel may block macro’s - To resolve, click File in the top left of the page, then Options at the foot of the resulting window. Click on Trust Centre, them Macro Settings. Set the following controls, then choose Trusted Locations and ensure the folder used to hold the spreadsheet is listed. Save, Close (without saving) the spreadsheet and reopen.
This spreadsheet uses menus and ‘window forms' to display and control data, whilst retaining tabular access, for those who wish to use it, for products and option-choices.
It was released as part of SwanFRS 1211 however the 1207 spreadsheet will continue to be supported for some time, though not onwards developed.
Prior to moving to 1214.1.x, please raise a support ticket if.
-
If your configuration pulls ‘reference’ data from SwanFRS when loading with FRS.
-
If you wish to start using the auto syncing of reference data between SwanFRS and the PCS.
-
If you wish to load the PCS with product catalogue data held in SwanFRS.
-
The 1214.1.xx series require the New Product Extract 1214 1 report installing for this process to work.
-
-
If you wish to start using images, single user operation or automated (on open) back up feature.
|
Current Version |
1214.1.02 |
|
Release Date |
|
|
Download |
|
|
The OLD VERSION button has now moved - To pull in data from a previous version of the spreadsheet, click the IMPORT-EXPORT button then choose PREVIOUS VERSION from the first column on the new sub-menu. |
|
|
Documentation |
|
|
Latest Enhancements & Fixes |
Click to expand to view the latest changes and enhancements in this version.
Click the CHANGE HISTORY button via the admin button to view all changes made in versions 1213 & 1214. |
Important Information
It is not possible to auto-open 1207 version spreadsheets via the ‘old version' import.
Please ensure v1207 are manually opened, then run the 1214 spreadsheet menu and import.
XML data generated in version 1214 can be imported into FRS version 1207 onwards of SwanFRS, however it is only possible to import data extracted from SwanFRS version 1211 (or later) into version 1214 of the spreadsheet.
If your SwanFRS system is version 1207 or earlier, we strongly advise upgrading to the latest version of SwanFRS.
This will ensure you can avail of new functionality, security features and bug fixes.
Previous Versions
Earlier versions of the spreadsheet are no longer being developed.
Click to view previous versions of the product creator.
|
Version |
Update Date / Information |
|---|---|
|
1207.3.19 |
Last Updated Date: 16-Jan-2025 This spreadsheet is designed to work with SwanFRS version 1207 however it is backwards compatible with version 1205. When set to 1206 mode, a number of features will be inoperable (export of static data, menu and matrix ticket controls) This document will allow direct migration of older versions (7.3 or earlier), if this is necessary an interim version of the spreadsheet will be required (e.g. import v6 to v7.5 then use the 7.5 to import to version 1207) If wishing to use the automatic data population from SwanFRS (product groups, attributes, sales departments and relationships) it will be necessary to configure SwanFRS to generate this data, therefore please raise a support call requesting changes. This spreadsheet will only accept import data extracted from SwanFRS v1207 or later. This version requires the Product Extract 1207 3 version of the exporter report to be plugged in via Set Up Report Links should you wish to extract data from FRS for import into the spreadsheet. |
|
1206.2.9 |
Last Updated 1-May-2024 This spreadsheet is designed to work with SwanFRS version 1206 however it is backwards compatible with version 1205. When set to 1205 mode, the XML output will NOT contain the Is Till product indicator or the Sales Department's set against SKUs. This document will allow migration of older version 7.x formats of the spreadsheet If wishing to use the automatic data population from SwanFRS (product groups, attributes, sales departments and relationships) it will be necessary to configure SwanFRS to generate this data, therefore please raise a support call requesting changes. The 1206 spreadsheet will only accept data exported from SwanFRS version 1206. Where configured, data generated in this version of the spreadsheet can be imported into SwanFRS version 1205 however data exported from SwanFRS 1205 cannot be loaded in to version 1206 of the spreadsheet. |
|
7.5.1 |
Last Updated 1-May-2024 This spreadsheet is designed to work with SwanFRS version 1205. The XML generated isn't suitable to earlier versions of SwanFRS. The import supports version 7.x spreadsheet formats only. |
|
7.4.6 |
Last Updated 18 Dec 2023 This spreadsheet is designed to work with SwanFRS version 1204. The XML generated isn't suitable to earlier versions of SwanFRS.The import from earlier versions of the spreadsheet supports version 7.x spreadsheet formats only. To upgrade, move from v6 to v7.3.2 and then to 7.4.5 |
Files from the Confluence page
- SwanFRS Product Creator 7.4.0.xlsm
- SwanFRS Product Creator 7.3.2.xlsm
- SwanFRS Product Creator 7.4.0.xlsm
- Product Creation - Spreadsheet V7.pdf
- Camtasia 2019.lnk
- SwanFRS Product Creator 7.4.0.xlsm
- SwanFRS Product Creator 7.4.0.xlsm
- SwanFRS Product Creator 7.4.0.xlsm
- SwanFRS Product Creator 7.4.0.xlsm
- SwanFRS Product Creator 7.4.0.xlsm
- Product Creation - Spreadsheet V7.pdf
- Product Creation - Spreadsheet V7.pdf
- Product Creation - Spreadsheet V7-SWANFRS-PK-2.pdf
- Product Creation - Spreadsheet V7.pdf
- SwanFRS Product Creator 7.4.0.xlsm
- SwanFRS Product Creator 7.4.0.xlsm
- SwanFRS Product Creator 7.4.0.xlsm
- SwanFRS Product Creator 7.4.1.xlsm
- SwanFRS Product Creator 7.4.1.xlsm
- SwanFRS Product Creator 7.4.1.xlsm
- SwanFRS Product Creator 7.4.1.xlsm
- SwanFRS Product Creator 7.4.1.xlsm
Not migrated from Confluence (over Freshdesk's file size limits): 1945239568.xlsm (2 MB), 1945501698.xlsm (2 MB), 1945075720.xlsm (2 MB), 1944485901.xlsm (2 MB), 1949335553.xlsm (2 MB), 1941831721.xlsm (2 MB), 1959919627.xlsm (2 MB), 1972076546.xlsm (2 MB), 1972109313.xlsm (2 MB), 1974960136.xlsm (2 MB), 1975091211.xlsm (2 MB), 1959919620.xlsm (2 MB), 1983315969.pdf (6 MB), 2005467138.pdf (6 MB), 1983479809.xlsm (9 MB), 1983512577.xlsm (9 MB), 1983348738.xlsm (9 MB), 1983283204.xlsm (9 MB), 1984364547.xlsm (9 MB), 2005499905.pdf (7 MB), 2005532673.pdf (7 MB), 2013167622.pdf (7 MB), 2005598209.xlsm (2 MB), 2005958661.xlsm (2 MB), 2006155265.xlsm (2 MB), 2006286337.xlsm (2 MB), 2006319105.xlsm (2 MB), 2012643332.xlsm (2 MB), 2011824131.xlsm (2 MB), 2013855745.xlsm (2 MB), 2013823008.xlsm (2 MB), 2012971021.xlsm (2 MB), 2016706561.xlsm (2 MB), 2028994565.xlsm (2 MB), 2028929028.xlsm (2 MB), 2083454988.xlsm (2 MB), 2028929043 (2 MB), 2066808961.xlsm (2 MB), 2065334948 (2 MB), 2066677867.xlsm (2 MB), 2066677861 (2 MB), 2068283824.xlsm (2 MB), 2066579636 (2 MB), 2066612372.xlsm (2 MB), 2066677882.xlsm (2 MB), 2068643854.xlsm (2 MB), 2076901412.xlsm (2 MB), 2068119969.xlsm (2 MB), 2067563085 (2 MB), 2076278916.xlsm (2 MB), 2076278903.xlsm (2 MB), 2082930705.xlsm (2 MB), 2077130770 (2 MB), 2082766866.xlsm (2 MB), 2083454977.xlsm (2 MB), 2082832422.xlsm (2 MB), 2005565441.xlsm (2 MB), 2083422209 (2 MB), 2110685203.xlsm (2 MB), 1928593477.xlsm (2 MB), 2110128241.xlsm (2 MB), 2121302036.xlsm (2 MB), 2121039896.xlsm (2 MB), 2121728001.xlsm (2 MB), 2065400370.xlsm (2 MB), 2123956233.pdf (34 KB), 2134835252.xlsm (2 MB), 2133164095.xlsm (2 MB), 2135162883.xlsm (2 MB), 2135687213.xlsm (2 MB), 2137686103.xlsm (2 MB), 2137292824.xlsm (2 MB), 2135457793.xlsm (2 MB), 2138865685.xlsm (2 MB), 2140405767.xlsm (2 MB), 2140307465.xlsm (2 MB), 2141847553.xlsm (2 MB), 2139062281.xlsm (2 MB), 2143715415.xlsm (2 MB), 2144763905.xlsm (2 MB), 2144829441.xlsm (2 MB), 2156199939.xlsm (2 MB), 2157084673.xlsm (2 MB), 2145058817.xlsm (2 MB), 2159771651.xlsm (2 MB), 2160820225.xlsm (2 MB), 2159804418.xlsm (2 MB), 2165178392.xlsm (2 MB), 2178514945.xlsm (2 MB), 2178482178.xlsm (2 MB), 2186379305.xlsm (2 MB), 2185494561.xlsm (2 MB), 2191720451.xlsm (2 MB), 2192080898.xlsm (2 MB), 2191917061 (2 MB), 2192146470.xlsm (2 MB), 2191327242.xlsm (2 MB), 2207842310.xlsm (2 MB), 2207875075.xlsm (2 MB), 2207875087.xlsm (2 MB), 2207907852.xlsm (2 MB), 2209939476.xlsm (2 MB), 2249588759.xlsm (2 MB), 2209644832.xlsm (2 MB), 2209972297.xlsm (2 MB), 2214887475.xlsm (2 MB), 2214887737.xlsm (2 MB), 2215575555.xlsm (2 MB), 2215641115.xlsm (2 MB), 2219114499.xlsm (2 MB), 2207907841.xlsm (2 MB), 2218688599.xlsm (2 MB), 2218721335.xlsm (2 MB), 2221342739.xlsm (2 MB), 2222555139.xlsm (2 MB), 2226782211.xlsm (2 MB), 2234122257.xlsm (2 MB), 2236383606.xlsm (2 MB), 2237366273.xlsm (2 MB), 2236284929.xlsm (2 MB), 2242314281.xlsm (2 MB), 2242347051.xlsm (2 MB), 2242117861.xlsm (2 MB), 2241200148.xlsm (2 MB), 2246082576.xlsm (2 MB), 2249850915.xlsm (2 MB), 2208038915.xlsm (2 MB), 2245623809.xlsm (2 MB), 2252668946.xlsm (2 MB), 2251292673.xlsm (2 MB), 2259648594.xlsm (2 MB), 2259615847.xlsm (2 MB), 2266890241.xlsm (3 MB), 2268463133.xlsm (3 MB), 2268758046.xlsm (3 MB), 2268626979.xlsm (3 MB), 2272821284.xlsm (3 MB), 2273837079.xlsm (3 MB), 2272624682.xlsm (3 MB), 2274164870.xlsm (3 MB), 2274230404.xlsm (3 MB), 2282258517.xlsm (3 MB), 2287730742.xlsm (3 MB), 2282618915.xlsm (3 MB), 2306342954.xlsm (3 MB), 2306441223.xlsm (3 MB), 2304704532.xlsm (3 MB), 2310111236.xlsm (3 MB), 2310569986.xlsm (3 MB), 2310537220.xlsm (3 MB), 2309914645.xlsm (3 MB), 2328035364.xlsm (3 MB), 2344681487.xlsm (3 MB), 2344714258.xlsm (2 MB), 2355757059.xlsm (2 MB), 2355134466.xlsm (2 MB), 2369683470.xlsm (2 MB), 2368733198.xlsm (2 MB), 2379841540.xlsm (2 MB), 2380627984.xlsm (2 MB), 2382495766.xlsm (2 MB), 2384429058.xlsm (2 MB), 2379317253.xlsm (2 MB), 2395111426.xlsm (2 MB), 2395439114.xlsm (2 MB), 2393538561.xlsm (2 MB), 2428928001.xlsm (2 MB), 2431385602.xlsm (2 MB), 2437546000.xlsm (2 MB), 2448916483.xlsm (2 MB), 2401927268.xlsm (2 MB), 2466643970.xlsm (2 MB), 2466938881.xlsm (2 MB), 2621603841.xlsm (2 MB), 2624618506.xlsm (2 MB), 2613280821.xlsm (2 MB), 2656796674.xlsm (2 MB), 2725052451.xlsm (2 MB), 2841051137.xlsm (7 MB), 2838986763.xlsm (7 MB), 2855305219.xlsm (7 MB), 2854354952.xlsm (7 MB), 2870018052.xlsm (8 MB), 2921431057.xlsm (6 MB), 2946695173.xlsm (7 MB), 2956230659.xlsm (7 MB), 2980773909.xlsm (7 MB), 2980773921.xlsm (6 MB), 2961375234.xlsm (6 MB), 3018326089.xlsm (6 MB), 3017572396.xlsm (6 MB), 3036086322.xlsm (6 MB), 3054567462.xlsm (7 MB), 3056795678.xlsm (6 MB), 3055910998.xlsm (6 MB), 3067969555.xlsm (6 MB), 3069444142.xlsm (7 MB), 3064823817.xlsm (7 MB), 3088154636.xlsm (7 MB), 3088187408.xlsm (6 MB), 3087663119.xlsm (6 MB), 3090186242.xlsm (7 MB), 3088678994.xlsm (6 MB), 3096608778.xlsm (7 MB), 3096608800.xlsm (7 MB), 3096543264.xlsm (7 MB), 3096674305.xlsm (6 MB), 3109683218.xlsm (6 MB), 3140190210.xlsm (10 MB), 3139534865.xlsm (7 MB), 3139534852.xlsm (7 MB), 3159490576.xlsm (6 MB), 3192487937.xlsm (6 MB), 3191308290.xlsm (6 MB), 3209592833.xlsm (6 MB), 3208675347.xlsm (6 MB), 3209166850.xlsm (7 MB), 3212509185.xlsm (6 MB), 3211755522.xlsm (7 MB), 3214737420.xlsm (7 MB), 3216277506.xlsm (7 MB), 3214671875.xlsm (7 MB), 3222208517.xlsm (7 MB), 3223191554.xlsm (7 MB), 3222175758.xlsm (7 MB), 3230629892.xlsm (7 MB), 3229679617.xlsm (7 MB), 3267690503.xlsm (7 MB), 3269197825.xlsm (7 MB), 3269656577.xlsm (9 MB), 3270246413.xlsm (7 MB), 3272736773.xlsm (7 MB), 3268476932.xlsm (7 MB), 3283386369.xlsm (7 MB), 3289874433.xlsm (7 MB), 3289546753.xlsm (7 MB), 3294298115.xlsm (7 MB), 3294756866.xlsm (7 MB), 3294232579.xlsm (7 MB), 3321331713.xlsm (7 MB), 3320414209.xlsm (7 MB), 3342172161.xlsm (9 MB), 3358621704.xlsm (9 MB), 3363897347.xlsm (6 MB), 3378937857.xlsm (7 MB), 3378741249.xlsm (7 MB), 3378708481.xlsm (7 MB), 3382542338.xlsm (6 MB), 3428843521.xlsm (6 MB), 3474685957.xlsm (7 MB), 3474620419.xlsm (5 MB), 3469115393.xlsm (5 MB), 3510730756.xlsm (7 MB), 3517644801.xlsm (6 MB), 3534258178.xlsm (7 MB), 3534422017.xlsm (7 MB), 3565518854.xlsm (7 MB), 3578953737.xlsm (7 MB), 3567058946.xlsm (7 MB), 3585343490.xlsm (8 MB), 3586228225.xlsm (8 MB), 3586326529.xlsm (7 MB), 3586293763.xlsm (7 MB), 3585179652.xlsm (7 MB), 3585212417.xlsm (7 MB), 3611820033.xlsm (6 MB), 3610312705.xlsm (6 MB), 3621388296.xlsm (7 MB), 3634429953.xlsm (6 MB), 3632562180.xlsm (6 MB), 3635806209.xlsm (6 MB), 3635707907.xlsm (6 MB), 3635478529.xlsm (6 MB), 3647012865.xlsm (7 MB), 3646521345.xlsm (7 MB), 3656777734.xlsm (6 MB), 3717365762.xlsm (7 MB), 3721986050.xlsm (7 MB), 3722149889.xlsm (7 MB), 3717300225.xlsm (7 MB), 3726442497.xlsm (7 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