01. Overview

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

Originally written by John Hardwick, last updated Nov 01, 2023, on the Swan Retail knowledge base (FRS).

Part of: Product Creator - v1207


General guide and tips re the features available within the spreadsheet.

Spreadsheet Operation

The product creator spreadsheet consists of several tabs, each tab detailing a different aspect of the product structure.

The spreadsheet checks data entered and will produce warnings if the data entered a cell is not valid.

When hovered over the green help cells provide useful information relating to the spreadsheet or cell associated with the help message.

There are help messages in most column headings throughout the spreadsheet (indicated by a small red triangle in the top right of the cell, or by a green square with a question mark in it. Hovering will show the message as indicated below.

The spreadsheet hides columns once the Preview Create Catalogue Data button is selected.

Certain fields offer the user advice when the cell is selected.

Many tabs offer a series of icons, displayed in the header section of the page.

These icons perform specific tasks and are detailed below.

Icon

Purpose

Certain tabs offer the operator the option to sort the data. Clicking this icon instructs the program to sort the table contents.

Sorting enables pick lists to be presented in alphabetical order.

Clicking this icon instructs the program to remove the row from the table.

Prior to clicking ensure you have clicked in the row to be deleted. The is no undo option for this process.

This option is also available by holding the control key and pressing D

Tip – To remove multiple rows, click in the first row to be deleted, hold the mouse key down and drag down to the last row and then press CTRL-D – this will delete the selected rows.

Clicking this icon instructs the program to add a new row immediately ABOVE the current cursor position within the table.

This option is also available by holding the control key and pressing I

It is possible to set the default number of rows to insert in a single action (range 1 to 100) – note the large the number the longer the time it takes to process.

When inserting click into the row you wish to have new rows added below and click the icon or press CTRL-I, the following window will appear asking how many rows to insert.

The window will prompt with the default row setting however this can be changed. Invalid entries will be ignored, and the default rows value used.

The program is designed to ignore blank rows in the tabs – it is not necessary to remove blank lines before generating the output file for the Product XML import.

Clicking this icon instructs the program to clear the database of ALL ROWS.

The spreadsheet presents the following window ensuring the button was not clicked by mistake.

There are no undo options for the process.

Where visible, it is possible to toggle the data in ‘word wrap’ mode.

Word wrap shows all contents of a cell within the cell as several lines or will show a single line of narrative which max extend over the end of the cell.

This feature is useful if working with numbers, thus reducing the column height, where large descriptions are not as important.

There is no loss to data integrity toggling between these display modes.

Within the Items tab, this feature allows you to search and replace text.

Highlight the cells to be searched, then click this icon.

The program will ask for the text to be replaced and then what it will be replaced with.

All text matching the ‘replace’ text within the highlighted cells will be replaced with the characters entered in the ‘replace with’ entry field.

Where visible this icon, instructs the page to toggle the case of selected cells.

The toggle will cycle through all lower case, sentence (capital first letter), uppercase variants.

This icon unlocks protected cells on the Range, Options and Choices tabs, subject to the entry of a valid password.

These locked cells are to protect the data already loaded in SwanFRS.

For example, if you change an option choice from Red to Blue then all the history relating to that choice changes.

This button acts as a toggle locking and unlocking specific cells.

Unlocking allows typo’s to be corrected, for example, it should not be used to change the name, answer – always create a new and discontinue the old in these circumstances.

The password for this feature will be provided during training or by raising a support call.

This button is only available on the Items and Choices tabs and generates a data dump of the tab without cell controls or conditions and may be used as desired.

The data file is a separate spreadsheet..

This icon on the Choices and Items tabs, toggles between highing and showing rows with either the Exclude from XML control set or a discontinued date set.

Wherever this icon is displayed, there is a video guide available.

Video’s are played in a browser via YouTube and require internet access.

This icon only displays in the PG X Ref tab.

When selected it pulls all the unmatched product groups within the Items tab adding them to the PG X Ref list ready for mapping to SwanFRS product groups.

This icon appears on the Blocked and Defaults tab and is designed to allow the rapid creation of blocked and default options associated with SKUs.

By default, tabs have been protected. This means several cells are locked off and therefore are not accessible or amendable. This is to make the process of creating data easier.

Locked tabs preserve formulas and conditional checks on the cells, and therefore it is strongly recommended that tabs remain locked.

Please contact Swan if there is a something the spreadsheet is blocking you doing as we can often make a change or advise of an alternative way of achieving the requirement.

When pasting into the spreadsheets always use the PASTE VALUES options. This ensures the source contents are copied into the spreadsheet without the formatting of the source.

Certain features available for unlocked tabs are restricted however alternatives are usually available. If you are experiencing difficulties populating the spreadsheet, please contact your Swan representative.

Right Clicking

Spreadsheet specific options have been added to the ‘right click’ options list. To use, once you’ve selected the desired cell, right click on the mouse. The following menu will display.

There are 4 special options

The spreadsheet must be configured to show images, and the cursor must be positioned in an image field to view the image. These are page specific - options only appear where the feature is applicable to the tab.

All but the clear filters require the cursor to be focussed in the appropriate cell to operator and will produce a warning if not.

Clear All Column Filters

Click to clear all column filtering on this and all other tabs within the spreadsheet.

Show Image

Select to show the image defined within the selected cell.

Add Image

Click to select an image held in a ‘local’ folder.

This can also be achieved by double clicking in the image cell.

SKU Finder

When focussed in an ‘SKU’ column, clicking opens a SKU finder window to help select the desired SKU.

Clear Amended Dates

Within the Choices and Items tabs, clicking clears the amended since date.

This option is irreversible however it is not destructive to the item data.

Toggle Amended Date View

Within the Choices and Items tabs, clicking this option shows / hides rows that have been amended since the last ‘save to file’ XML export was generated for the products, prices and options export.

These features are tab specific and will only show where applicable.

Table Filtering

It is possible to filter the data displayed in the table by pressing the grey down arrow shown to the bottom right of the header block.

Clicking offers the operator the ability to filter the contents of the table. There are pick lists for specific data, keyword selections and advanced options for data filtering.

Once chosen, specific data rows may disappear and the triangle icon is replaced with a funnel icon.

This is of particular use in the items, choices, and refresh tabs where it can be used to restrict the scope of the price changes applied via the formula buttons.

It is important to note that leaving a filter on a tab may cause processes such as the importing of data / generating XMLs to fail.

Please ensure you reset the filtering once completed. I.e., make sure there are no filtered columns in the tab. There is a short cut to achieve this – to remove filtering from all tabs simply hold the control key down and press the y (lower case) key on the keyboard.

Selecting Clear All Column Filters from the right click menu clears filters on ALL tabs within the spreadsheet.

Show Images

Images with a full path (http URLS for example) cannot be displayed.

Where an image can be found, a pop-up window shows the image, click the cross or the yellow close button to close the window and return to spreadsheet operation.

Add Images

Double clicking an image URL cell or selecting from the right click menu, opens a ‘file explorer’ window which can be used to ‘find’ ‘select’ the image to be used for the range / choice or item.

If the image path has been set in the Admin tab, the explorer window will open showing the contents of this folder.

Having made a selection the path to the folder (as set in the Admin tab) will be removed this leaving only the local folder and the filename thus removing the need to edit the path.

it is possible to manually enter, paste in the image path which includes URLs

Opening the explorer window and closing is not destrictive and will not clear any contents previously set in the ‘active cell’.

SKU Finder

Clicking this option when focussed in a SKU column, generates the following pop up.

The page is split into two sections, either enter a serise of letters and press return to instruct the routine to ‘find’ the text within the items description or Supplier’s model number, or double click on the desired SKU from the full list of SKUs pulled from the Items tab.

selecting a SKU overwrites popultes the SKU cell the cursoe was positioned in prior to selecting the SKU Finder.

Alerts

Several tabs present an Alert column, this is designed to advise if there is an issue with the data on that row.

If one or more rows have an ‘red’ alert a yellow warning is displayed (as shown below) in the header row to advise the operator there are issues with the data set.

  • Text on a yellow or salmon background indicate a non-critical warning – these can be ignored from the perspective of generating XML. The message advises of the issue, the operator may elect to change the data thus removing the alert or proceed.

  • White text on a red background indicates a data inconsistency that will stop the successful loading of data into SwanFRS. These alerts should NOT be ignored and corrected. The routine will not allow you to save the XML data if there are data inconsistencies within the spreadsheet.

The GenerateXML button will not operate if one or more of the Range, Options, Choices or Items tab is presenting the CHECK ALERTS message.

Wait Screen

When processing data the spreadsheet may present the following page.

During this time screen updating within Excel is turned off and the program may appear to have frozen. Please allow the process to complete all features will become available once the process has finished.

Performance Note

Processes which may take time to complete, such as importing data, will show the status of the processes.

It is also important to note that when processing larger data volumes, it may take the program some time to complete its task. During this time other Microsoft Office products such as Outlook may freeze or run slowly.

It is recommended that prior to processing a large data set, ensure your PC / laptop is running on mains power and all other ‘programs’ are turned off or paused. Doing so will improve performance.

Performance issues have been experienced on older machines, perhaps running on 32 bit or older processes. The data crunching aspect of the spreadsheet does consume resource therefore is performance is an issue it is suggested that other programs are closed or perhaps a more powerful PC is used for this process.

The spreadsheet will advise the operator should a large data set be selected for processing.

Home Tab

There are some dos and do nots re operating this spreadsheet.

Please ensure you are aware of the ramifications of making changes to the spreadsheet once data has been loaded into SwanFRS.

For example, changing the ID of a range or option item will change all trading histories of that product – Always discontinue the old and create new.

There are also a series of useful shortcuts which will make processing a little easier.

Control Key Shortcuts

There are a number of control key shortcuts which will improve productivity.

Note these controls are lowercase keys

To operate hold the <control> key down and press the appropriate key having positioned the cursor in the correct cell first.

<Control> &

Action

d

Deletes the selected row(s)

y

Clear any filters set on ALL tabs

i

Inserts one or more lines from the current cursor position

v

Pastes the contents on the clipboard into the selected cell

e

Shows the last exported value of the cell the cursor is currently in.

This option applies only to the Items Tab.

<space>

selects all items in the coloumn the cursor is currently positioned.

t

Moves the cursor to first cell in the table (usually C6)

h

Moves the cursor to the first active column in the table, for the cursors current row.

z

Moves the cursor to the last active column in the table, for the cursors current row.

Spreadsheet Column Headers Colour Scheme

Each column in the spreadsheet with a column header will have one of the following colours.

Items with the blue background are mandatory

Items with the light blue background are optional

System populated columns are pink

Locked cells will also present with a pink background.

Cost / selling columns - These columns can be used to generate margin information and work in partnership with the dark blue cost control columns in the page header

These are optional cost columns, holding ancillary costs or work zone prices

Green column headings indicate ‘web’ related columns.

Row Visibility

Where the data table, due to the number of rows, exceeds the width of a ‘standard’ screen, the spreadsheet will highlight the selected row with a light blue background, which allows the operator to reference the specific line without losing focus when horizontal scrolling.

The active cell is shown with a darker blue background.

Files from the Confluence page

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