03. Catalogue 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


The catalogue tab holds data pertaining to a specific supplier. It is possible to show / hide tabs as necessary.

Swan recommend using a separate spreadsheet for each and every supplier and to introduce a grand-father / father / son type sytem to protect against spreadsheet corruptions.

The Catalogue tab also allows the importing of extracted data from SwanFRS therefore if the spreadsheet has an issue it is possible to rebuild from the application.

This tab also offers a complete data tab clearing process ideal for begining to map a new supplier and to import data from an earlier version of the spreadsheet thus availing of new functionality.

Catalogue Version

The catalogue version can be found in cell O2 on the Catalogue tab and is used in partnership with the published date which is shown in cell O19.

To view new features in this version click the video icon in cell Q15.

Control Fields

Field

Comments

Catalogue Header Information

Supplier (Vendor) Catalogue ID

This is a numeric field and must be linked to the supplier / vendor within prior to attempting to import the catalogue.

It is very important that the correct catalogue ID is set, importing data with the wrong catalogue ID will push the products into the wrong supplier which may ‘corrupt’ existing data. If unsure, please check via the CATALOGUE ID button within SET UP SUPPLIERS to make sure you have the correct ID before proceeding.

Access to this field is locked when in pricing only mode.

Catalogue Name

Optional catalogue name.

Version

Optional version number.

Tab Visibility Control

A yellow background indicates there is data in the tab which will be used when generating the XML output whether or not the tab is visible.

Sets

The Sets tab enables the construction of group codes, whereby if you sell a master code in SwanFRS, it will autoatically expand it into is component parts.

Tick to show the sets tab.

Untick to Hide.

Default Options

This page control the base or default options presented when ordering a product within swanFRS.

Tick to show the defaults tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

Web Feature

This feature is used as a ‘roll-up’ when linking to an e-commerce website

Tick to show the web features tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

Relationships

This feature instructs SwanFRS to recommnd the seling of linked products when raising a sales order.

Tick to show the contents of the relationship tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

Block Options

This tab allows specific option choices to be omitted from pick lists when ordering product.

Tick to show the contents of the blocked tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

Matrix Tickets

This tab allows the creation of a series of ticket patterns where each of the x and y axis intersections (cells) holds a SKU which can be used to produce a matrix or grid ticket display ticket.

Tick to show the contents of the Matrix Tickets tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

Product Groups

This tab holds a copy of the product groups used in SwanFRS

Tick to show the contents of the product groups tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

Data held in this tab is NOT sent back to SwanFRS and therefore any changes applied must be manually updated within SwanFRS.

This tab forms part of the ‘reference’ tabs within the spreadsheet and is therefore colour coded dark blue.

Price Points

This tab enables the setting of a series of price ranges and a ‘golden price’ or price point that values within the range will be ‘charmed’ or charged.

Tick to show the contents of the price points tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

This tab forms part of the ‘reference’ tabs within the spreadsheet and is therefore colour coded dark blue.

Product Group X Ref

This tab is used in partnership with importing data and where set provides a cross reference between the ‘source’ product group and SwanFRS product groups.

Tick to show the contents of the product cross reference tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

This tab forms part of the ‘reference’ tabs within the spreadsheet and is therefore colour coded dark blue.

Sales Departments

This tab holds a copy of the sales departments used within SwanFRS.

Tick to show the contents of the sales departments tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

Amendments to this tab are prohibited in Pricing mode or when data is directly imported from SwanFRS.

It is possible to send data back to SwanFRS however this is via a separate csv output. Changes are not applied via the XML output structure.

This tab forms part of the ‘reference’ tabs within the spreadsheet and is therefore colour coded dark blue.

Price Refresh

This tab offers the ability to change prices without providing access to any other data element of teh product itself. It does not offer option price control.

Tick to show the contents of the price refresh tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

Prices changed in this tab remain separate to those held in the Items tab and therefore are not sent to SwanFRS unless the data is copied (via an action button) into the Items tab first.

This tab is displayed with the pink-red background.

Extended Item Attributes

It is possible to set a maximum of 10 attributes per product within the items tab, if this is inusfficient additional (unlimited) attributes can be set via this tab.

Tick to show the contents of the extended item attributes tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

This tab is optional and threfore is displayed with the light blue background.

Extended Item Options

It is possible to set a maximum of 20 first level questions per product within the items tab, if this is inusfficient additional (unlimited) options (questions) can be set via this tab.

Tick to show the contents of the extended item options tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

This tab is optional and threfore is displayed with the light blue background.

Extended Item Images

It is possible to set a maximum of 10 images per product within the items tab, if this is inusfficient additional (unlimited) images can be set via this tab.

Tick to show the contents of the extended item images tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

This tab is optional and threfore is displayed with the light blue background.

Extended Choice Links

It is possible to set a maximum of 5 linked questions per answer on the Chocies tab, if this is inusfficient additional (unlimited) number of next level questions can be set via this tab.

Tick to show the contents of the extended choice links tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

This tab is optional and threfore is displayed with the light blue background.

Notes

This notes pad is for operator only and is designed to allow the collection of thoughts and actions for future reference.

Tick to show the contents of the notes tab.

Untick to Hide.

Data held in this tab remains event if the tab his hidden.

This tab is not used in data export and as such is coloured red.

Help & Tips

This tab contains help, tips and advice as to what to do and not do with data including a number of control-key shorcuts.

Tick to show the contents of the help tab.

Untick to Hide.

Data Mapping

Data mappping allows raw electronic data to be ingested into the spreadsheet thus creating or updating existing records and removes the need to copy and paste multiple columns.

Default Product Group

This field must be set to use the data import mapping process.

Once the Prod Group tab has been populated, select the default product group from the pick list which will be used if this column is empty when importing mapped data.

Lead Time

This field must be set (none-zero) to use the data import mapping process.

Set to the number of days it takes to get a product from point of issuing the purchase order to receipt at the ‘warehouse’ door.

Sheet Mapping in Use

Is the quick data population method required?

  • Tick to show the contents of the notes tab

  • Untick to Hide

The import data tabs (SheetMapping and ImportData are coloured green to aid identification.

Default Range

Optionally specify a product range range to be used when the import process cannot identify a range.

Price Charming (formula 1 to 5)

Multiplier

Specify a value to multiply the ‘source’ column by to generate a base ‘selling’ price. E.g. 3.5 would increase the source price by a factor of 3.5.

Round to

Specify a value the calculated selling price (from field 1) is to be ‘moved to’.

E.g., 50 would change a selling price of 123 to 100. 10 would change a the 123 to 120.

If you do not want to use this feature set to 0.01

The calculated value is always rounded down.

Take off

Specify a value to be taken off the calculated price. E.g., 0.01 would cause all prices to end in 0.99. .25 would result in prices ending in 0.75 (both assuming a whole number was specified in field 2)

Set to 0 if you do not want to use this feature.

Name

Optionally specify a name for the specific formula calculation.

This makes selection of the appropriate formula easier when applying price charming within the Choices and Items tabs.

New Catalogue Linking

When creating a new suppliers catalogue it is essential to have a link point between SwanFRS and the Product Creator spreasheet. This is acheived via the Catalogue ID.

Menu Location: System Admin > Purchasing > Set Up Suppliers (Vendors)

Create the supplier / vendor ensuring and then click teh CATALOG ID button shown in the top level supplier listing.

Clicking the Catalog IDs button produces a screen like that shown below

Field

Comments

Catalogue ID

This unique number must match with the Supplier / Vendor Catalogue ID in the Catalogue Tab of the product creator spreadsheet.

Name

Specify the name of the catalogue used when communicating with the supplier / vendor.

Debrand

Specify the name of the catalogue which is used when conversing with customers.

Leave blank if the range / collection is not to be debranded.

Active

Tick to allow stock to be ordered, processed etc.

Data Type

This field must be set to XML if using the product creator as the sole means of product creation and maintenance.

If, once loaded, SwanFRS will be used to maintain items this field should be set to XML, Internal. This gives access to Set Up Product Pricing.

Managed Catalogue Product Group

Used when importing catalogues from third party generation systems and is used to force the product group for new items where not set in the import file.

Selling Price Format

For use where the catalog being imported does not have a selling price.

Choose from

  • None – do not use the auto calculate selling formula.

  • Calculate using a margin / mark up (set in the data entry text box at the foot of the column)

  • Percentage – uplift by a percentage of cost

  • Multiply – multiply the cost by a specified value.

Choose the price charming method from

  • None

  • Round down

  • 9 &5’s

  • Golden price rounding up within tolerance (set in the type in field)

  • Golden price rounding down

Ensure the Catalogue ID set here matches the catalogue ID set witin the spredsheet.

If these fields do not match product may be uploaded into the wrong suppliers porfolio within SwanFRS.

Upgrading from Previous Versions

It is possible to import data from earlier versions of the spreadsheet to do so it is necessary to open the original ‘old’ version of the spreadsheet and V7 at the same time.

From the Catalogue tab click the Import from Earlier Version button

Clicking produces the following window where the name of the ‘source’ data file (spreadsheet).

The filename keyed must match the name of the ‘old’ open spreadsheet. (Without the .xlsm suffix)

This routine will then ask if you wish to retain the ‘static data' (dark blue tabs) or import ALL data from the source spreadsheet.

It is not possible to proceed with the import until one of the import reference data choices has been selected.

Clicking IMPORT DATA begins the process of pulling data from the source spreadsheet to the destination.

This version of the spreadsheet will only import version 7.x spreadsheets. If you are using an older version of the spreadsheet (Version 6 for example) you will need to import to version 7.3.2 and then import into this version.

Once the process has completed. Please ensure the data has been imported correctly prior to proceeding.

This feature will overwrite any data already present in the version 7 spreadsheet leaving the original unchanged.

Exporting from SwanFRS

It is possible to import data from SwanFRS for importing into the spreadsheet.

The process begins with a Crystal Report in SwanFRS – Product Export requires the selection of a supplier and a promotion and generates an export file.

Please ensure you’re running PRODUCT EXTRACT 8 (or later) which is designed specifically for this version of the product creator.

Once the output has been displayed on screen click the export button and then choose ‘export to excel workbook.

This will offer a series of export formats

Tip - choose the optoin containing the work ‘workbook'

The export file needs to be exported to xlsx.

Ensure you select the Microsoft Excel Workbook Data-Only option

With the export data file open, open the Product Creator Spreadsheet and click the Import from SwanFRS button.

Clicking produces the following window where the name of the ‘source’ data file (spreadsheet).

The filename keyed must match the name of the ‘export data file’ open spreadsheet. (Without the .xlsx suffix)

Clicking OK begins the process of pulling in the data from the source spreadsheet into the version 7 data format.

The program will advise once the process has completed. Please ensure the data has been imported correctly prior to proceeding.

All existing data tabs are cleared during this process.

Clearing Data

It is possible to clear the spreadsheet of product data using a single button.

From the Catalogue tab click the Empty Data Tabs (Restart) button

Clicking produces the following warning

Field

Comments

Clear Product Data Only

This choice clears the range, options, choices, items and related tabs. Effectively prodcut specific data is cleared leaving the reference data (dark blue tabs) data.

Clear Product & Reference

This choice clears all data tabs including the reference data tabs.

Clear All Settings

This option clears all data tabs and resets the controls in the Admin and Catalogue Tabs.

There is no ‘undo’ feature for this process therefore it is strongly recommended that you take a copy of your existing spreadsheet before clearing data.

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