02. Admin Tab

Created by Migration Bot, Modified on Fri, 23 Oct at 11:20 AM by Migration Bot

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

  • 1205

Features introduced in 1206 will not be exported when sending data to SwanFRS version 1205.

  • 1206

The XML output will only include Sales Departments and Is Till Product fields (Items Tab) in this mode.

  • 1207

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

  • Line ID (default) – The SKU will be the CatalogueID-RangeID-LineNumber

  • SupplierRef – The SKU will be CatalogueID-RangeID-SupplierRef

(If the supplier ref is blank, the line ID will be used)

Mode

This field is changed via the TOGGLE button and alternates between

  • Full – allow access to all fields within the Items tab.

  • Price Only – all except price related cells are locked.

Web Defaults

This field is changed via the TOGGLE button and alternates between

  • Y - Turns on web defaults

  • N - Turns off web defaults

  • Not Set - no defaults in use.

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.

  • Tick – Costs and selling prices are to be included within the XML Catalogue used to populate SwanFRS with items.

  • Unticked - excludes cost and selling prices when sending data to SwanFRS.

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.

  • Ticked - New prices will replace any existing values in the destination column.

  • Unticked – Only set prices for empty cells in the destination column.

Tick to Include Lead Time

Define if the XML export is to include lead times.

  • Ticked - Include lead times in the export (For new SKUs, this is essential).

  • Unticked – Exclude 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

  • Not Set - Send costs and ancillary costs to SwanFRS.

  • Cost 1 - Send the ‘landed cost’ as Cost 1 when exporting XML product data, omitting all ancillary costs from the export.

  • Cost 2 - Send the ‘landed cost’ as Cost 2 when exporting XML product data, omitting all ancillary costs from the export.

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

  • ON - Turns on the ability to view images within the spreadsheet.

  • Off - The image display feature is turned off.

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

  • ON - Turns restricts the spreadsheet, allowing only one person at once to edit the document.

  • Off - This feature is not required.

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

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