Originally written by John Hardwick, last updated Oct 25, 2023, on the Swan Retail knowledge base (FRS).
Part of: Product Creator - v1207
This tab is specifically designed to assist with the process of price management. It allows the pasting of a ‘reference' and cost value which is then mapped to SKU data showing the movement in cost price, which can then be used to generate revised selling prices prior to sending them to the Items tab and onwards exporting to SwanFRS.
This tab is turned on via the ‘Assisted Cost Refresh in Use’ option within Tab Usage.
Setting this option to ticked displays the Refresh tab, unticked hides the tab.
This tab is designed to allow the entry of a series of ‘model numbers and revised prices in the left-hand side blue headed columns.
Once ready, clicking the RELOAD GRID FROM ITEM TAB button processes the data showing the movement of products and prices, cross-referencing the model numbers specified with those in the Items tab.
Table 1 Columns
|
Field |
Comments |
|
Mapping Control |
This field allows the entry of the supplier’s reference data and is used to match codes already present in the Items tab. Click the CHANGE MAPPING button to change the mapping. Select from … Changing the mapping resorts the right-hand side table presenting data in the chosen mapping column sequence and relinks codes where possible. To preserve cost mapped, ensure these are Locked before re-sorting |
|
Suppliers New Cost |
Specify the new selling price for this item. |
|
Found it? |
This column will show the word ‘Matched’ with a green background if the mapped control data element has been matched to a SKU present on the Items tab. A red ‘No Match’ informs the operator that a match hasn’t been found, and therefore the item is potentially a new offering from the supplier. |
Table 2 Columns
This table is replicating the pricing functionality within the Items tab.
|
Field |
Comments |
|
New Price? |
This column will show a green ‘Matched’ if the mapped control data element has been matched to a SKU present on the Items tab. The red ‘No Match’ informs the operator that a match hasn’t been found, and therefore the item is potentially a discontinued item. |
|
Mapped Field |
The reference held on the Items tab. The contents of this field are controlled via the CHANGE MAPPING button in the Mapping Control column. The tab header also indicates which field is the ‘mapping field’ and will change as the mapping is altered. |
|
Range / Collection Description |
This field shows the concatenated description (1,2 & 3) from the Items tab. |
|
SKU |
The Item SKU number. |
|
New Cost |
This is the cost specified for matched items in table 1. Matched costs are highlighted in yellow to highlight mapped rows. If the cost changes are to be adopted and used for price manipulation, the REPLACE COSTS button should be clicked. This produces a cost replacement window, whereby it is possible to specify which cost column is to be REPLACED by the values in the New Cost column. Note: There is no ‘undo’ feature. Click the LOCK COSTS button to lock the mapped costs. This allows you to enter different mapping criteria in the left-hand column whilst preserving the new cost process for onwards processing in the right-hand table. Select from … Once locked rows appear with an orange background, the mapping in the left-hand column can now change without clearing costs. Prices are now locked even if a new map is specified, the locked price will not change unless unlocked first. |
|
Change |
This is the movement in cost from that held in the Items tab.
Cell P2 – controls whether Cost 1, Cost 2, or Cost + Uplift column is to be used as the comparison. |
|
Cost 1 |
Specify the base cost (retailer's 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 |
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. |
|
Cost + uplift |
This is the ‘active’ cost column (as defined in the 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. |
|
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. |
Any values changed in table 2 are NOT replicated onto the Items tab until the UPDATE ITEMS TAB WITH NEW PRICES button is selected.
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,
|
Sending Data to the Items Tab
Once any price changes are finalized, and if these prices are to be ‘saved’ / to be imported into SwanFRS, they need copying to the Items tab.
Clicking the UPDATE ITEMS TAB WITH NEW PRICES button offers the ability to send items with ‘mapped’ costs only, or to refresh the entire table.
If refreshing the entire table, the process will ask if ‘non-matched’ items are to be discontinued.
If non-mapped items are to be discontinued, specify the date the item can no longer be ‘ordered.’
If the item has already been discontinued, the discontinue date will not be changed.
Leaving this date empty will continue to update the prices linked to the unmapped item, but will not mark it as discontinued.
Prior to copying prices to the Items tab, the prompt below will detail the actions.
-
Clicking NO aborts, the process.
-
Clicking YES copies prices from Table 2 to the items tab.
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