Originally written by John Hardwick, last updated Oct 25, 2023, on the Swan Retail knowledge base (FRS).
Part of: Product Creator - v1207
When using the mapping tool, the third party may provide a product group or genre type, this is unlikely to map to the SwanFRS product group. This tab allows a cross-reference to be constructed which will map a product genre to a SwanFRS Product group.
When turned on, via the Catalogue Tab, this page allows the definition of alternative codes for product groups and is of particular use if importing data from a third-party spreadsheet.
PG X Ref is a cross-reference facility allowing you to link the third party’s product group with one used in SwanFRS.
This tab allows the creation of a list of product groups and the replacement code, which is applied to the Items tab when via a ‘process’ button.
This allows the mass changing of product groups from X to Y as defined within the Items Tab.
Note: This process does not check the class of the product group, therefore it is possible within the spreadsheet to change PG 1 which is an accessory classed group to PG 2 which is a measured classed group. The spreadsheet will allow the change however when importing into SwanFRS, SwanFRS will reject the load advising that changing product group classes is not possible.
This tab is of particular use when using the SheetMapping process, allowing the operator to move the vendors' product groups to the retailers’ groups. This process is run as part of the import data process, however on first processing the cross-reference will require manual population.
|
Field |
Comments |
|
From PG |
Specify the product group to be changed. For example, in the source data the manufacturer has used code ‘Bedroom Cabinets’ – this code does not exist in SwanFRS and therefore needs to be replaced. |
|
To PG |
Specify the product to be change to (as set within the Product Group tab) Using the example above ‘Bedroom Cabinets’ is ‘B011- Lockers’ in SwanFRS therefore the relationship between the two codes is formed. Once formed, any future imports of ‘Bedroom Cabinets’ will be automatically converted into ‘B011 – Lockers’ |
|
ID Check |
Shows the SwanFRS product group of the To PG Code and acts as a warning should the code previously used in the Prod Groups tab no longer exist. |
|
This icon appears only in this tab and optionally allows the extraction of ‘mismatched’ product groups set within the Items tab to be pulled into the PG X Ref tab and then for duplicates to be removed, thus making the process of mapping 3rd party (or old product groups) to those currently used in SwanFRS. |
Clicking APPLY PG REMAPPING works down the list of conversions, applying them to the Items tab.
Remapping product groups within the Items tab is not reversible, and therefore it is important to ensure the mapping is correct before ‘applying’
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