Originally written by John Hardwick, last updated Oct 25, 2023, on the Swan Retail knowledge base (FRS).
Part of: Product Creator - v1207
The import process allows raw data provided by a third party to be imported into the spreadsheet using a mapping tool.
This feature turned on via the ‘Sheet Mapping in Use’ option within the Catalogue Tab.
Setting this option to ticked displays the SheetMapping and ImportData tabs, unticked hides these tabs.
When using the import feature, it is necessary to set a default product group (from a pick list of data obtained from the Prod Group tab) and a default lead time in days.
If either of these control fields are not set, the import process will cease.
These fields will only be used if the mapped data does not contain lead time or product group information.
Import Data
This tab has no controls or formatting and is designed to allow the pasting of data directly from the supplier’s catalogue in any format.
The only stipulation for this tab is to ensure there are no ‘merged’ columns in the source data as this will cause the import process to fail.
It is important to ensure your data is pasted into the top left cell (A1) otherwise the import will fail.
It is recommended that this tab be populated to allow the data mapping to occur.
Data Mapping
This tab is designed to allow the operator to map columns in the ImportData tab to columns in the spreadsheet.
-
Green indicates the column has been found in the ‘Import Data’ or that a mapping has been created for that data column.
-
Yellow indicates the mapped column has not been found in the ‘Import Data.’
This tab is designed to allow data held in the ImportData tab to be ‘mapped’ to columns in Prod Group, Range, and Items tabs.
There is an option to clear all data from previous runs, therefore no need to clear all tabs before processing.
There are four mapping, two are preloaded with specific formats mapping to standard output formats.
-
Free format
-
‘Wondersign’ pre-set (but amendable)
-
‘AIS’ Format-B pre-set (but amendable)
-
Unix pre-set (but amendable)
Table Columns
|
Field |
Comments |
|
Import Data Column |
This column contains a list of column IDs (as used by Excel) to identify a column. |
|
Import Data Header |
This field is autopopulated by the ‘header’ row (row 1) of the ImportData Sheet. |
|
Misc Mapping |
This column allows the mapping of a specific column in the ImportData sheet to a field used in the Items tab. Where set the cell turns green, yellow if not used (no mapping – ignore the column). |
|
Wondersign Columns |
This is a pre-set list of columns issued by ‘Wondersign’ in their data extract. It is possible to add mapping columns at the bottom of the pre-set list. |
|
Wondersign Map |
Although prebuilt, it is possible to ‘tweak’ the settings as required. This mapping will be used during the import, where the import button is used. |
|
AIS (Format-B) Column |
This is a pre-set list of columns issued by ‘AIS (Format B) in their data extract. It is possible to add mapping columns at the bottom of the pre-set list. |
|
AIS Map |
Although prebuilt, it is possible to ‘tweak’ the settings as required. This mapping will be used during the import, where the import button is used. |
|
UNIX Column |
This is a pre-set list of columns issued by ‘FRS-UNIX’) in their data extract. It is possible to add mapping columns at the bottom of the pre-set list. |
|
UNIX Map |
Although prebuilt, it is possible to ‘tweak’ the settings as required. This mapping will be used during the import, where the import button is used. |
Note, colours and options are not imported.
Once the mapping has been completed and the source data has been copied into the ImportData tab clicking the PROCESS MAPPED DATA button begins the process of populating the spreadsheet with the data held in the load file.
Processing the Mapped Data
Clicking the PROCESS MAPPED DATA button produces the following window.
There are two tabs, select the appropriate tab for the data set being imported.
Miscellaneous Mapping
Pre-Set Mapping
This tab should be used for importing Wondersign, AIS and Unix data sets.
Specify the data controls for importing data (some mapping types do not require all fields to be set – the process will not be allowed to continue until all appropriate fields have been selected.
Preset processing is designed to append to existing data, therefore if you are wishing to restart with, i.e., starting a new import ensure you clear the tabs via the red clear button on the Catalogue Tab before importing.
Note: If you wish to begin with empty data tables, select the Red ‘Empty Data tabs (Restart) button on the Catalogue tab, as this process adds to existing data in the ranges and items tabs.
All but the last Action Required option merge new data rows with original advising of the change.
The Update Existing - Ignore New option can be used as a quick form of price update - specify the index mapping in 1 column, supplier's model number for example, then list the change columns - cost price, MRP for example, importing effectively replaces the cost with the new cost. Note: This process overwrites existing rows and IGNORES new data.
Having instructed the system how to act on the data, a final screen confirms the choices made prior to processing the data.
Once process the sequence will …
-
Create new ranges will be added to the Range Tab, whilst retaining those already set.
-
Create new Items will be added to the Items tab and marked accordingly
-
Update current items.
-
Where set mark, original items are not present in the new load file as discontinued.
This process may take some time to complete.
Once completed, the Include column on the Items tab may display one of the following identifiers (Include Column).
|
OLD |
This row was present in the Items tab before the import mapped data process was processed. |
|
|
NEW |
This is a newly created row, generated as part of the import of mapped data. |
|
|
DISC |
This is an original row not present in the import mapped data and has been discontinued. Remember, discontinued lines need importing once into SwanFRS to ‘discontinue’ them in SwanFRS, after this they can be deleted from the spreadsheet. |
|
|
UPD |
This row has been updated because of the import. i.e., the mapped index was in the items tab before the import and present in the import data. The original row has been ‘replaced’ with the new data. N UPD indicates a row marked not to be sent to SwanFRS which has been updated via the Update Existing - Ignore new feature. |
These indicators cannot be set by the user, however they can be cleared via the CLEAR button in the header row.
When process Wondersign® data, any data marked as a ‘fixed’ or ‘bundle’ will be converted into a set with the Sets tab being populated with the relevant data.
The process will automatically generate missing ‘components’ used in the set, this data will not have cost or selling prices and holds the minimum data required to process a set order in SwanFRS.
If this situation arises, please contact your Wondersign® agent and advise them of the data inconsistency in the vendor data.
It is possible to continue processing and to order goods with the ‘component’ codes within SwanFRS.
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