26. Price Refresh Tab

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

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.

  • Green backgrounds indicate a price reduction

  • Red indicates a price increase

  • Yellow will show for no price changes.

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.

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

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

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