Originally written by John Hardwick, last updated Nov 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Product Creator - v1207
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.
It is possible to add options to the product such as colour however it is recommended that the item be defined to a main price break / feature or spec to allow the salesperson to find the item quickly and advise of price rather than having to answer a series of questions before they can present a price to the potential customer.
It is possible to create a ‘header’ row in the table by leaving the line number blank (this shows as a red cell) – The preview tab will skip over header rows. This feature makes it easier to retain the format of the data thus matching that of the suppliers.
Control Cells
This tab has three control cells identified by white text on dark blue backgrounds. These cells control the content of the XML and the auto calculated fields in this tab.
See Change Margin for directions for changing the margin percentage used.
|
Field |
Comments |
|
Cost |
This field tells the program which cost should be used when showing the Landed Cost value. The selected cost plus the sum of the ancillary columns is shown in the Landed Cost column. |
|
Cost |
This field tells the program which cost to use when calculating the Achieved Margin and Selling Price to Achieve Margin columns. |
|
Sell |
This field tells the program which of the selling columns is active. The active selling is used to populate the Achieved Margin column. |
Include – Column C
The CLEAR button in the Include column, clears all settings within the column and is of particular use when viewing the results of an ‘Import mapped data’ action.
Alert – Column D
The VIEW button in the Alert column changes the display to maximize the space available. Clicking generates the following window
The page displays the type of view selected in yellow text in teh dark blue page header.
Select one of the following to change the screen display.
|
Choice |
Action |
|
Consolidated |
This choice hides the active range and description columns, consolidating them into a single column thus making space for more ‘active’ columns to be viewed on the right-hand side of the page. This mode is particularly useful with the products have been identified and you’re populating the dimensions and control elements of the SKU |
|
SKU Maintenance |
This choice displays the SKU definitions and allows modification. This mode consumes almost all the screen and therefore there is little space for additional control columns. This mode is of particular use when changing descriptions / setting up the SKUs from scratch. |
Line # - Column AI
The AUTO # button in the Line # column auto populates all rows in the table with an incremental order line number starting with the next number from the largest number already defined. This process is non-destructive only setting blank line numbers.
Line numbers will not be set for rows with missing product ranges.
Grid Seq – Column AM
The AUTO # button in the Grid Seq. column auto populates all rows in the table with an incremental order line replacing any line sequences already set.
This option, when used in partnership with the SKU display control in SwanFRS ensures the list of SKUs presented in SwanFRS’s Catalogue Search program matches the sequence in the spreadsheet.
Convert – Column AY
The CONVERT button in the Currency Cost. column may be used to convert the values in this column to a specified cost column applying the conversion rate set in C11 of the Admin tab, effectively conerting foriegn currency costs into base currencies for onwards manipulation.
Once the APPLY button is selected a counter in the grey box advises of progress,
Margin – Column BH
The MARGIN % button, when not locked, allows the desired margin percentage to be changed.
Changing the margin recalculates Selling Price to Achieve Margin (BI) column.
Change – Column BJ
The CHANGE button allows mass changes to the lead time.
Choose from addition, subtraction, mulitiplcation or replacement of the values in the lead time column.
Once the APPLY button is selected a counter in the grey box advises of progress,
Auto # – Column CG
Clicking the AUTO # button ripples down the CG column setting the net sequential number in blank cells thus producing a menu ticket sequence.
Set From Range + D1 – Column EL
The SET FROM RANGE + D1 button populates the Web Description (name used on the web) with the range description and the contents of description 1.The
Note where the range is debranded, the debranded range name is used.
Convert – Columns EP
The CONVERT button automatically converts any numbers held in the Webshop Up Sell column which correspond to actual row numbers within the table to the row’s SKU.
For example, if a field contained 8,9,10 where the SKUs held on those rows are 10-1-2,10-1-3 and 10-4-56 the 8,9,10 would be converted to 10-1-2, 10-1-3, 10-4-56.
Row numbers must be separated with commas, any narrative which is not matched to a row number in the table will be left unchanged.
Previous Exported Data Check
Once data has been exported (saved as XML) via the GenerateXML tab, the spreadsheet generates a reference copy of the Items tab.
It is then possible to use the Control plus the ‘e’ key to ‘see’ the exported value of that cell and optionally reset it back to the exported state.
To use click in the appropriate cell in the items tab, the system will then show the previously exported value.
The window shows the cells current value, previously exported value and offers the option to revert to the previously exported value.
To reset select the YES option, to close and continue select NO .
This feature ONLY works of accessible cells within the Items Tab.
Update Ancillary Costs
This feature has now been incorporated in the UPDATE PRICES button in the header row, which is now located above the Currency / Retail Price columns.
Update Prices
This button allows a range of calculations to be performed on ‘price’ columns, clicking presents a two tabbed window offering basic and advanced adjustment calculations.
Basic Pricing
This tab offers a simple approach to price changes offering a series of arithmetic options.
|
Field |
Comments |
|
Source Column |
Click to highlight the source column to be used when applying the calculation. |
|
Destination Column |
Click to highlight the destination column, the column in which the results of the calculation are to be stored. |
|
Calculation |
Choose the type of calculation to be performed |
|
Value |
Specify the value the source column is to be adjusted by. This field requires a decimal value to be entered. |
Advanced Pricing
This tab offers a series of formula options to calculate (primarily) selling prices.
|
Field |
Comments |
|
Source Column |
Click to highlight the source column to be used when applying the calculation. |
|
Destination Column |
Click to highlight the destination column, the column in which the results of the calculation are to be stored. |
|
Formula |
Choose one of the formula options specified in the Catalogue tab to be used in partnership with the Calculation and / or charming choices relating to ‘formula’. Where set the screen will use the name given to the formula. |
|
Calculation |
Choose one of the calculation methods.
|
|
Charming |
Choose how the calculated value (in the destination column) should be ‘rounded’ |
|
Charming 0 & 1s |
Where ticked the charmed price will be further adjusted if the value is X0Y or X1Y where X and Y are numbers. X0Y will have 10 taken from the value, X1Y will be reduced by a value of 20. This applied to values over 99. For example,
|
Table Columns
It is important to remember that if you empty a cell, particularly when it previously held a Y, or an N will cause the exclusion of the field from the import process. If you want to change a cell from a setting back to its default ensure you set the field, rather than making it blank. i.e., if column X has a default of Y and previously imported with an N, you must set the column to N and import it to change the setting in SwanFRS.
|
Field |
Comments |
|
Include |
Include in export
When using the SheetMapping process this column will indicate if the row has been changed by the import process. The warnings are –
Remember discontinued lines need importing into SwanFRS to inform SwanFRS they are no longer purchase-able, once imported they can be removed from the spreadsheet however it is recommended they are retained to ensure the SKU isn’t reused for another product.
These indicators cannot be set by the user however they can be cleared via the CLEAR button in the header row. It is possible to use the filter option to focus in on specific items. If the range has been set to exclude, changing the contents of this column has no impact on the output status. Rows with excluded ranges or set to N will not be included in the XML output. |
|
Alert |
This field will produce a warning if one or more of the cells in the row would cause a problem when loaded into SwanFRS.
If there is one or more alert the header row will show the Check Alerts notification, useful if the issue relates to a row not currently displayed on screen. |
|
SKU |
This will be automatically built from the Catalogue ID, Range ID, and Line #. This cell will display with a green background which indicates an element on the row has been changed in some way since the last time the product XML was ‘saved to file’ via the Generate XML tab. The amend status of all rows can be cleared by selecting ‘Clear Amended Dates' from the right-click menu or hidden/displayed via the ‘Toggle Amended Date View’ again on the right click menu. Clearing Amended dates does not affect the data in the items tab but is irreversible. |
|
Range / Collection Description |
The drop-down pick list allows the operator to choose a range / collection the item is linked to – this field must be set for the item to be loaded into SwanFRS.. Cells in this column may be locked if imported from or sent to SwanFRS. To unlock click the red disk witht the pad-lock and enter the password. This will unlock the pink cells. The password is provided during training or can be obtained by logging a support ticket. To re-lock repeat this process. |
|
Line # |
Specify a line number for the stock item. This field is used for the last element of the SKU. This field must be set for the item to be loaded into SwanFRS – a blank indicates a header row which is ignored by the Preview tab – blank fields will show a red background.. Cells in this column may be locked if imported from or sent to SwanFRS. To unlock click the red disk witht the pad-lock and enter the password. This will unlock the pink cells. The password is provided during training or can be obtained by logging a support ticket. To re-lock repeat this process. |
|
Retailer description 1 |
Specify a description defining the item. Description field will show an amber background if a ‘restricted’ character is used – the load process will fail if the &, “ or | symbol is used. When linking to a Swan website and using the Group_Product option this field should contain the item purpose/design placing ancillary data in the Description 2 and 3 columns. This field acts as a collation point for the web to group like product – E.g., If you have a 3-seater sofa which comes in 4 grades – description 1 should contain the ‘3-Seater Sofa’ with Description 2 and / or 3 holding the grade and other information about the product. |
|
Retailer description 2 |
Additional description |
|
Retailer description 3 |
Additional description |
|
Grid Seq. |
Optionally set a sequence number which will be used by SwanFRS to force the order in which matching items are displayed in the Search Catalogue results table. |
|
Legacy System Code |
This is an optional field. This field may be used to hold a legacy system code thus allowing searching by the pre-SwanFRS reference. This code is unique and cannot be used on any other SKU (system wide). An error will be produced at time of import if this code has been used against a variant SKU. sending legacy codes requires a separate export XML. After importing the products XML, generate the legacy XML and import. The legacy XML should only be sent after a change of legacy code or SKU the code is linked to. |
|
Supplier’s / Vendor’s Model Number |
Specify the code used by the supplier / vendor to identify this item. This code will be used when raising purchase orders for this item with the supplier / vendor. |
|
Barcode |
Where available specify the barcode used by the supplier / vendor to identify the item. |
|
Cost 1 |
Specify the base cost (retailers cost) of the item. For new items this column must be set for the SKU to import – Do not set the Include Prices to N if creating new SKUs |
|
Cost 2 (Alt Cost) |
Optionally specify a second cost |
|
Ancillary Cost x (1 to 5) |
Optionally specify ancillary costs associated with the SKU. These costs will be added to the ‘active cost’ thus forming the Cost + Uplifts value. The row header for each ancillary cost is shown as set within the Catalogue Tab. |
|
Landed Cost |
This is the ‘active’ cost column (as defined in yellow cell header above the Cost 1 column. The value is the chosen cost * ancillary cost percentage set in the Catalogue Tab plus either the tariff uplift value or tariff uplift percentage on cost dependent upon settings in the Catalogue tab. This field is used when ‘calculating’ selling prices but is NOT sent to SwanFRS unless directed by the setting on the Catalgoue tab. |
|
Currency Cost |
For currency suppliers / vendors where the supplier’s / vendor’s cost is fixed specify the cost price in the supplier’s / vendor’s currency. When raising purchase orders, the system will calculate the base currency cost by dividing the currency cost by the current exchange rate. For base currency suppliers / vendors leave this field blank. |
|
Retail |
Specify the RRSP / RSP / high price for the item. This price is NEVER charged by SwanFRS and only used to show the client what the price may have been. |
|
Sell 1 |
Specify the selling price 1 of the item. It is suggested to set this as the standard or establishment price. |
|
Sell 2 |
Specify the selling price 2 of the item. It is suggested this price be the ‘in sale’ price. |
|
Sell 3 |
Specify the selling price 3 of the item It is suggested this is the special event price. |
|
Web Price |
Specify the web selling price of the item |
|
Workzone X (1 to 3) |
These columns are provided to ‘what if’ scenarios and do not form part of the data sent to SwanFRS. |
|
Achieved Margin |
This field shows the margin of the item if sold at the prices specified – the margin show relates to the ‘active selling price’ chosen in the blue control cell. Tax is calculated using the Tax Rate values set in the Catalogue tab. |
|
Selling Price to Achieve Margin |
This column shows the ideal margin using the tax rate set in the Catalogue tab and the preferred margin percentage control cell. This value is the raw (uncharmed) selling price required to meet the margin threshold specified. |
|
Lead time |
Specify the number of days it takes from point of notifying the supplier / vendor to receipt into the warehouse. |
|
Product group |
Select the product group for this item from the pick list |
|
Question X (1 to 20) |
If this item has a choice or question related to it select the question from the pick list – this list is populated from the Options Tab. The spreadsheet has been constructed with a maximum of 20 questions per item – if you need more, please contact Swan support to have the range extended. |
|
Ticket Size |
Setting this field generates an Attribute of Ticket_Size which can be used in reporting as a filter to ensure the correct size label is produced for the SKU. The ticket / display ‘report’ must be specifically designed to use this feature |
|
Ticket Seq |
Used in partnersgip with Ticket Size this option generates a Ticket_Size_Seq attribute linked to the SKU and is used to control the sequence in which SKUs are printed within the specifically designed ticket generator. |
|
Reorderable |
Specify if the item is to form part of the reordering algorithm –
|
|
B2B PO |
Specify if the item can be special ordered –
|
|
Minimum stock level |
Optionally specify the minimum stock level for reordering. |
|
Maximum stock level |
Optionally specify the maximum stock level for reordering. |
|
Reorder quantity |
Optionally specify the number of units to reorder at any one time. (Pack size). |
|
Home delivery |
Can this item be shipped directly from the supplier / vendor to the customer?
|
|
Number of pieces |
How many pieces is the item shipped in. |
|
Unpackaged Width |
How wide is the item? |
|
Unpackaged Height |
How high is the item? |
|
Unpackaged Depth |
How deep / tall is the item. |
|
Unpackaged Weight |
How much does the item weight? |
|
Packaged Cubic |
What is the cubic space consumed by this item when packaged? (Outer box cubic). |
|
# Of seats |
Like cubics this field holds the number of seats used by some suppliers when building containers / may be used to calculate the number of ‘warranty’ units each item incurs. |
|
Commodity Code |
Used to hold the commodity code for an item when importing / exporting goods to / from Europe. |
|
PO_Label |
Indicate if the purchase order is to generate a stock tracking label for the supplier to attach to their goods prior to shipping to the retailer.
This field auto generates an PO_Label Attribute which is held against the SKU instructing the ‘Banner PO’ print to include a stock label in the output. |
|
Commission group |
Specify the commission group for this item. Product groups used are held in the Set Up Commission Groups routine in SwanFRS |
|
Spiff Margin Controlled |
This feature is a custom column, not in general use and can be ignored. Where set, and used it tells the commission system to pay a ‘spiff’ commission against a specific SKU if the margin of sale meets the target set within the system settings.
|
|
Spiff Payment Value |
This feature is only used with the commission export to file routines (Export Salesperson Commission and Export Branch Statistics) Specify the value of spiff payment for this SKU which is paid subject to the spiff system control settings when generating salesperson and branch specific commission exports via the accounts menu. |
|
Uplift Percentage |
This feature is only used with the commission export to file routines (Export Salesperson Commission and Export Branch Statistics) Specify the uplift percentage to be applied to the items cost price when calculating a margin. For example 50 would double the cost price. |
|
TV indicator |
Specify if the item is a TV.
|
|
Spare 1 |
Not Currently used by the Generate XML process. |
|
Spare 2 |
Not Currently used by the Generate XML process. |
|
Spare 3 |
Not Currently used by the Generate XML process. |
|
Mask separator |
Specify character used as a separator when generating supplier / vendor model references that change with the selection of options. SwanFRS-UNIX use only. |
|
Hierarchy x (1 to 6) |
Specify the product hierarchy group for this item. Product groups used are held in the Set Up Product Hierarchy routine in SwanFRS |
|
Part |
Is this item a part rather than a full retail item?
|
|
Serial Number |
Does this part have a manufacturer’s serial number?
|
|
Allocation on Despatch |
Can this SKU have stock allocated just before despatching to the customer.
|
|
Disc Date |
Specify the date this item became discontinued or will become discontinued. i.e., not able to order new items. |
|
Pack Size |
This relates to the number of units in the supplier’s / vendor’s standard purchase pack. E.g., 4 indicates the supplier / vendor sells the items in packs of 4. |
|
Pack Description |
This field holds the purchase pack description (singular). To be imported to SwanFRS both the Pack Size and Pack Description must be set. |
|
Is Till Product |
Specify if this product is to be sent to an EPOS till
|
|
Sales Department X (1 to 3) |
Optionally specify the item specific sales department for this item. If not set sales departments will be taken from the product group and if not set at this level, a default of ‘not set’ will be used in SwanFRS report. |
|
Image X (1 to 10) |
Optionally specify the file name or full URL path of any images linked to the SKU. The spreadsheet has been constructed with a maximum of 10 questions per item – if you need more, please contact Swan support to have the range extended. The optimum size for images is 540 across by 460 pixels depth. If the image is to be located within a sub folder use the / to indicate the folder – E.g., Pictures/image.jpg Embedded spaces in the image filename / path will cause the load to fail. When using images on a website avoid using PNG and BMP images – JPG / JPEG are the preferred image formats for web. When linking to a Swan website with Web Features
If not using Web Features
Where configured the spreadsheet will present a thumbnail image of the locally held URL. Right clicking, with the cursor sat in the desred Image URL cell and selecting the Show Image option. Double Clicking, or right clicking and selecting Add Image from the menu with the cursor focused in an image cell opens a file explorer from which it is possible to choose the image file. |
|
Brand (web) |
Specify if the item is to have a brand attribute created. Select from – N – Do not create a brand attribute. Y – Create a brand attribute The brand attribute is used for groupings within the Swan linked website and is essential for the effective operation of a website. (This field is set to the Vendor name set within the Catalog Tab). Any existing Attributes linked to the SKU will be removed and new ones added if one or more Attribute code is set. |
|
Group_Product (web) |
Specify if the item is to have a Group_Product attribute created. Select from N – Do not create a group product attribute. Y – Create a group product attribute The group product attribute is used in partnership with Web Features to provide a way of grouping SKUs in to pick lists. (This field is set to the Range/Collection suffixed by the Retailer Description 1 field). If the length of these two fields exceeds 100 characters issues can be experienced when viewing the detail on the web. An error will be produced if this occurs – in this instance it is suggested that you reduce the number of characters in these fields perhaps moving characters from Description 1 into Description 2. Any existing Attributes linked to the SKU will be removed and new ones added if one or more Attribute code is set. |
|
Show Prices on Web |
When linked to a web system is the item to show a selling price (on the web).
|
|
Web orders |
Specify if the item can be sold via the web site –
|
|
Webshop Search Engine Optimisation |
Optionally specify a list of SEO words used for web systems to allow searching. |
|
Webshop Description |
Optionally specify an alternative name for this item when shown on the web. |
|
Webshop Start Date |
Optionally specify the first date this SKU will display on the web. |
|
Webshop End Date |
Optionally specify the last date this item is visible on the web. |
|
Web Shipping Class |
Setting this field, when used in partnership with a linked website advises the site how the product is ‘shipped’ to the customer. Please ensure codes used are recognised by your web provider. When used do not use the Shipping_Class attribute elsewhere in the spreadsheet. |
|
Web Upsells |
This field is designed to hold a list of SKUs which are auto suggested by a linked website as potential accompaniments to the item being viewed /purchased. SKUs should be separated by commas. As the SKU column cannot be copied. Enter the row number of the SKU to be added, separated by a comma then press the CONVERT button, this action will convert the row number (of the table as seen in the left-hand column) to a SKU. When used do not use the Product_Upsell attribute. |
|
Attribute X code (1 to 10) |
Optionally choose an attribute group name. Any existing Attributes linked to the SKU will be removed and new ones added if one or more Attribute code is set |
|
Attribute X value (1 to 10) |
Optionally specify a value for the selected attribute. |
|
Long Description |
This field holds an extended description of the product and may contain HTML formatting controls. |
f the application parameter CATALOGUE_PICTURES is set to ImageURL, SwanFRS will display image # 1 as the thumbnail within the Catalogue Search program.
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