Originally written by John Hardwick, last updated Nov 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Product Creator - v1207
This tab is designed for use by the local system's administrator, allowing the setting of various parameters controlling how the spreadsheet works.
This tab is password protected and is designed to allow a systems administrator to control how the spreadsheet is to be used.
The concept is that the systems administrator creates a ‘base’ spreadsheet which is then used by the buying / merchandising team to ensure consistency of operation.
Settings applied in this tab restrict features used elsewhere within the spreadsheet, access should only be enabled for operators empowered to make such changes.
Clicking the Admin tab presents a password screen and will continue to present it until a valid password is entered. The password is then not requested whilst the spreadsheet is open. Closing and re-opening requires the password to be re-entered.
The password is provided during training or can be obtained from Swan Support by raising a ticket.
Check boxes on the Admin and Catalogue tab show with a light purple background when unchecked to aid identification.
Control Fields
|
Field |
Comments |
|
Spreadsheet Administrator Controls |
|
|
SwanFRS Version |
Choose from
Features introduced in 1206 will not be exported when sending data to SwanFRS version 1205.
The XML output will only include Sales Departments and Is Till Product fields (Items Tab) in this mode.
Compatible with 1206 - no changes to XML format. It will not be possible to extract data from FRS1206 and import into the 1207 spreadsheet. Product Extracting requires the major versions of both systems to match. |
|
SKU Format |
This field is changed via the TOGGLE button and alternates between
(If the supplier ref is blank, the line ID will be used) |
|
Mode |
This field is changed via the TOGGLE button and alternates between
|
|
Web Defaults |
This field is changed via the TOGGLE button and alternates between
|
|
Tick to Warn on Row Delete |
This option allows you to turn off the ‘are you sure’ question when the delete row icon is selected. |
|
Default # Of Insert Rows |
Set the default number of rows the system will insert in any one action. Range 1 to 200. The larger the number, the longer the program will take to complete the task. |
|
Tick to Include Prices in the XML |
Specify if the XML generated is to include prices.
When generating new SKUs, the import will be rejected if costs are excluded. |
|
Tax Rate |
This field is used to calculate the margin of the item. The margin is calculated as Selling – Tax – Cost / Selling – Tax expressed as a percentage. If operating with tax-exempt (US model) set this field to zero, otherwise set to the current prevailing tax rate for this supplier/catalogue. |
|
Exchange Rate |
Specify the exchange rate to be used when converting the currency cost to a base cost within the Item tab. |
|
Tick to Overwrite Prices |
Define how to calculate prices button in the items tab works.
|
|
Tick to Include Lead Time |
Define if the XML export is to include lead times.
|
|
Ideal Margin |
Specify the ideal margin percentage you wish to obtain when generating selling prices. (Range 0 to 100.00) This field can be updated from either the Choices, Items or Refresh tabs, subject to Locking the Margin. |
|
Landed Cost Instead of |
This field should only be used if you wish to use the landed cost as calculated within the spreadsheet as the item purchase cost but do not wish to send individual ancillary costs to SwanFRS. This field is changed via the TOGGLE button and alternates between
When set to Cost 1 or Cost 2 importing data back into the spreadsheet from SwanFRS will cause all ancillary costs to be lost. |
|
Tick to Show Picture Previews |
This field is changed via the TOGGLE button and alternates between
It is not possible to change the Image Folder path when turned ON. It is not possible to turn on if the folder path isn’t set. |
|
Tick to Turn on Single User Mode |
This field is changed via the TOGGLE button and alternates between
It is not possible to change the Auto Load SwanFRS Folder path when turned ON. It is not possible to turn on if the folder path isn’t set. This progress uses the FilesInUse subfolder held in the SwanFRS output Folder Location (C28). To work this folder must be visible to both SwanFRS and all users editing the spreadsheet. When in use, the following message will display when the spreadsheet opens. If the spreadsheet is ‘locked’ by another, a message will display the username of the person editing the document, along with the option to enter a password to bypass the lock. Details of the password will be provided during training or by contacting Swan Support. Untick to turn this feature off. |
|
Tick to Lock Margin |
Tick to stop operators from changing the margin via the Choice, Item and Pricing tabs. Untick to allow unrestricted change to the margin target value. |
|
Auto SwanFRS Linked Refresh |
Use the TOGGLE button to change this setting. ON prohibits the manual creation and alteration of Product Groups, Attributes, Relationships and Sales Departments within this spreadsheet and to import them directly from SwanFRS. SwanFRS issues updates of these data sets periodically, however manual refreshes can be requested. OFF enables the creation and amendment of this reference data within the spreadsheet. Note product groups, attributes and relationships are not sent to SwanFRS and therefore any changes need to be manually replicated in SwanFRS. When operational, the SwanFRS reference data is automatically reloaded each time the spreadsheet is opened. The REFRESH NOW button can be used to refresh the reference data whilst the spreadsheet is open. Please raise a ticket with Support should you wish to begin using this feature as changes to the configuration of SwanFRS are required. |
|
Tick to View Change Log |
Ticking Opens the Change Log tab for reference only. Unticking hides this tab. |
|
Tick to Lock Formulas |
Ticking stops the operator from changing the formula price charming controls on the Catalogue Tab. Unticking Allows general changes to the 5 formulas. |
|
Create Back Up on Open |
Use the TOGGLE button to change this setting. ON instructs the spreadsheet to create a ‘back up# copy of the spreadsheet when opened. The file is saved in a BackUp folder within the output folder path set in field C28 on this tab. This folder will be automatically created on first use. A warning will be produced on opening the spreadsheet when the size of this folder exceeds 1/2 GB. There are no automatic housekeeping routines and therefore management of this folder needs be allocated to a suitable person. OFF disables the spreadsheet back up process but does not purge any back up files already in the back up folder. |
|
Title for Cost prices (1 to 2) |
Specify the name to be shown above the Cost 1 or 2 columns as a reminder to its content / purpose. |
|
Title For Ancillary Cost (1 to 5) |
Specify the name to show above the Ancillary cost column on the Choices, Refresh, Pricing and Items tabs. |
|
Title for Sell prices (1 to 3) |
Specify the name to be shown above the Sell 1, 2 or 3 columns as a reminder to its content / purpose. |
|
Title for Workzone (1 to 3) |
Specify the name to be shown above the Workzone 1, 2 or 3 columns as a reminder to its content / purpose. |
|
Network Paths |
|
|
Image Folder Location |
This field is changed via the SET button or cleared by the CLEAR button when the Show Pictures control (C16) is set to OFF. Clicking set opens a file explorer window from which a folder can be selected. It is not possible to change the Image Folder path when cell C16 is set to ON. The folder path should ideally be the image folder path used by SwanFRS to store SKU and option thumbnails and part of a file share. All PCs using this spreadsheet need access with the same path to make use of this feature. If the spreadsheet cannot establish the folder path or image filename, no thumbnail will be presented. Http image file paths will not display the image. To view the image, right click in the appropriate cell and select Show Image. No Images are saved within the spreadsheet. |
|
SwanFRS output Folder Path |
This field is changed via the SET button or cleared by the CLEAR button when the Multi-User (C17) and Autoload (C19) are set to OFF. Clicking set opens a file explorer window from which a folder can be selected. It is not possible to change the Auto Load SwanFRS Folder path when turned ON. The folder path should ideally be the part of the folder share system used by SwanFRS part of a file share. All PCs using this spreadsheet need access with the same path to make use of this feature. When using the auto update process SwanFRS requires configuring to send updates to this folder. This folder is used for access control and autoload of SwanFRS data and contains the FRSData and FilesInUse subfolders. The folder therefore has to be visible to SwanFRS (if uploading reference data) and ALL operators using the spreadsheet (when using the single user lock functionality). SwanFRS pushes data exports of the product group, attributes and sales departments to a subfolder within this path for the spreadsheet to refresh its ‘reference copy’ automatically when opened. If the file does not exist in the folder, no upload will occur. |
|
CHANGE TAB ZOOM LEVEL |
This button changes the default zoom setting on ALL Tabs within the spreadsheet. The zoom setting will accept a value in the range 1 to 386 with the default being 100. The spreadsheet takes a little while to change zoom settings, please be patient. Changing the zoom settings remains avaialble per tab via the slider bar in the lower right of the display. |
|
Untick to hide columns in the Items tab |
|
|
Various |
Control where the column is to display within the Items tab. Y – displays the identified column. N – hides the column Please note hiding the column simply removes it from the display however if you paste multiple columns into a single row, with one of the columns hidden, the hidden cell will be included in the copy. I.e., pasting 3 cells into A, B, C with B hidden will populate B. When generating XML, hidden columns with content will be used in the output. Hiding does not remove content or stop its use. |
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