Customer Interactions Export

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

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

Part of: Sales Reports


This report produces a customer export data file (similar to Customer Export) with the addition of saved customer interactions.

The output of this report is designed to feed into other systems and therefore may not display accurately within the browser

Crystal Report name Customer Interactions Export 1

The example has the header row included.

Selection Criteria

Run time choices, user selectable.

  • Customer Interaction(s)

  • Show Separate Title, Initials and Surname

    • Yes / No

  • Restricted Location(s)

  • Include Header Row

    • Yes / No

  • Include Customers with Mail Flag set

    • Yes / No

  • Include Customers with Email Flag set

    • Yes / No

  • Include Customers with Accept Phone Calls Flag set

    • Yes / No

  • Consolidate Customers

    • Yes / No

Print Sequence

As indicated by blue numbered squares in the report example.

1 Sales Order Date

2 Sales Order Number

Report Totals

As indicated by yellow numbered squares in the report example.

  • There are none.

Printed Fields

Fields printed on the report.

  • Customer

    • ID

    • Title

    • Initials

    • Surname (or Title, Initials and Surname printed as a single field if selected)

    • Address lines 1 to 5

    • Postcode (zip code / Eircode)

    • Last Location to take an Order

    • Main Telephone

    • Mobile / Cell Phone

    • Daytime Phone Number

    • Email Address

    • Email Preference Indicator

    • Post Preference Indicator

    • Phone Call Preference Indicator

  • Interactions Description

The output may replicate customers showing the customer repeated for each purchase location, or when consolidated the customer is listed once irrespective of how many locations they may have purchased from historically (the most recent purchase location is used in this mode).

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