Product Extract

Created by Migration Bot, Modified on Fri, 23 Oct at 2:30 PM by Migration Bot

Originally written by John Hardwick, last updated Apr 30, 2026, on the Swan Retail knowledge base (FRS).

Part of: Management Reports


Report required for extraction of data to the 1211.4.8 (or later) version of the product creator spreadsheet.

This report generates a data output file which can be used to populating the SwanFRS Product Creator Spreadsheet.

Crystal report name New Product Extract 6

The report’s output is designed for use within an Excel spreadsheet, and therefore will appear merged on screen.

The output is an amalgam of product related data, which is only useful for the import option on the Catalogue tab within the SwanFRS Product Generator Spreadsheet version 1211.

It is important to ensure the correct version of product extract is used when sending data to SwanFRS. If in doubt please contact Swan Support.

From SwanFRS release 1207 the report name will replicate the version of the spreadsheet it feeds.

The literature relating to the product creator spreadsheet is broken into sections and can be accessed via the following link Product Creator - v1214 (1211 onwards)

Selection Criteria

Run time choices, user selectable.

  • Supplier

  • Promotion

  • Manually set Group_Product field

    • Yes / No

Print Sequence

As indicated by blue numbered squares in the report example.

  • Not Applicable

Report Totals

As indicated by yellow numbered squares in the report example.

  • There are none.

Printed Fields

This report contains all the information relating to a specific SKU in several sections.

The information is not produced for external use and no column headings are included.

Effectively the audit is a list of fields generated in a specific sequence which is used by the SwanFRS Product Creator spreadsheet to populate the spreadsheet for onwards processing.

This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)

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