15. Items Tab

Created by Migration Bot, Modified on Fri, 23 Oct at 2:30 PM 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


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.

  • Cost Uplift using Formula – this is primarily to calculating a cost price using one of the formula choices.

  • Margin – use the margin formula to calculate the result

  • Charm only – do not apply a formula – just charm the destination column.

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,

  • Any value in the range 100 to 109 will be reduced by 10 this changing 100 to 90, 101 becomes 91 etc.

  • Values in the range 1210 to 1219 would be reduced by 20, 1210 would become 1190, 1211 would become 1191 etc.

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

  • N – No (exclude this row form the XML export (GenerateXML tab).

When using the SheetMapping process this column will indicate if the row has been changed by the import process. The warnings are –

  • OLD - This row was present in the Items tab prior to importing hte new data.

  • NEW - This row was created as part of the import process.

  • DISC - This original row was not mapped to a new data import tow and therefore has been Discontinued.

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.

  • UPD - This row has been updated as a result of the import. i.e. the mapped index was already ‘known' and therefore the original data has been updated with the new imported data.

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.

  • SKU if the SKU hasn’t been set

  • DESCx if any of the descriptions exceeds 80 characters. (x indicates the description number).

  • Qx – if there is an invalid description set (x represents the Question number)

  • GROUP – if the product group is incorrectly set

  • CLASS – if the class isn’t set

  • RANGE – if the collection / range isn’t mapped correctly.

  • PROD-GRP – if the product group isn’t mapped correctly.

  • DAYS – if the lead time is incorrect.

  • DEFAULT – shown is the range matches the default range set in the Catalogue tab.

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
(Cost x + uplift)

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 –

  • N – do not reorder (default if not set).

  • Y – Reorderable.

B2B PO

Specify if the item can be special ordered –

  • N – This item can be special ordered – back-to-back ordering allowed. (Default if not set).

  • Y – This item needs supervisory permission to special order. This restriction does not apply to internal ordering.

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?

  • N – Goods must be shipped to the retailer’s premises.

  • Y – Goods can be shipped directly to the customer home.

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.

  • N – Stock labels are not required.

  • Y – Produce the label for the manufacturer and include with the PDF sent to them when ordering.

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.

  • N – Do not use the system setting margin control

  • Y – Spiff margin % commission control is to be used for this SKU.

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.

  • N – No (default if not set).

  • Y – This 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?

  • N – No (default if not set).

  • Y – This item is a part and therefore requires special permission to order.

Serial Number

Does this part have a manufacturer’s serial number?

  • N – No (default if not set).

  • Y – These items have serial numbers which must be captured before the goods can be ‘delivery confirmed’.

Allocation on Despatch

Can this SKU have stock allocated just before despatching to the customer.

  • N – No (default if not set) - allocate stock at time or order.

  • Y – Leave the item on ‘demand’ until just before delivery (for example underlay which is allocated at time of collection prior to fitting).

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

  • N – Item not availabel within the till.

  • Y – This item needs to be sent to the till for EPOS operation.

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

  • All SKUs within the roll up should have the same first image which will be used as the main feature image on the product page when it first loads.

  • The second image on each SKU will replace the main featured image, but only when the corresponding options are selected to match the SKU.

  • Any additional images will be shown as thumbnails underneath the main featured image, but only when the corresponding options are selected.

If not using Web Features

  • The first image becomes the main featured image on the product page.

  • Any additional images will be shown as thumbnails underneath the main featured image.

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).

  • N – No do not show a web price

  • Y – show prices on the web (default if not set).

Web orders

Specify if the item can be sold via the web site –

  • N – This item is not visible on a linked website (default if not set).

  • Y – this item is to be sent to the website.

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

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