Go to Bottom

Customer Export Setup Screen

In this Topic: Show

Overview

The Order Manager is able to export customer information to a text file for various purposes, such as using the file as input to a bulk email campaign, or to transfer that information to another application.

This screen is basically a filter that is used to limit the data that is exported by specifying the desired order source, payment status, a date range of when the orders were placed, etc. When all of that information has been selected, click the [Begin Export] button to start the process.

To access this feature, go to the Maintenance Menu, Import/Export tab and select Export Customer Data & Bulk Email To Customers from the list of activities.

Click the Show link next to "In This Topic" at the top of this page to see a series of links in outline form, which can be used to quickly jump to that section of the topic.

In addition, major topics may provide a brief synopsis of a field's purpose or direct the reader to the appropriate section of the topic by scrolling over the image. To return to the previous location within the same page, right-click the mouse and select [Back].

If clicking a field directs the reader to a different Knowledge Base topic, it will open in a new tab or window, leaving the currently viewed topic open. The browser's settings determine whether a new tab or window is opened.

Description of the Customer Export Setup Screen - Filter Mode

Figure 1: Customer Export Setup screen

Fields and Controls on the Customer Export Setup Screen - Filter Mode

From: Column

Thru: Column

Order # Field

Web Order # Field

Order Date Field

Customer ID Field

Source of Initial Order Field

Payment Status Field

Most recent order was: Field

Date: Field

City Field

State Field

Zip Field

Country Field

Add to Email List Field

Begin Export Button

Cancel Button Field

Items Purchased Tab 

Orders that: Radio Buttons and Check Boxes

Select items here to build the list

Select by Radio Buttons

Add to List Button

Any of the following list of Items:

Delete Button

Custom Fields Tab

Figure 2: Custom Fields tab of Customer Export Setup Screen - Filter Mode

Frequency and Value Tab

Figure 3: Frequency & Value tab of the Customer Export Setup Screen - Filter Mode

Description of the Customer Export Setup Screen - Export Mode

Click the Show link next to "In This Topic" at the top of this page to see a series of links in outline form, which can be used to quickly jump to that section of the topic.

In addition, major topics may provide a brief synopsis of a field's purpose or direct the reader to the appropriate section of the topic by scrolling over the image. To return to the previous location within the same page, right-click the mouse and select [Back].

If clicking a field directs the reader to a different Knowledge Base topic, it will open in a new tab or window, leaving the currently viewed topic open. The browser's settings determine whether a new tab or window is opened.

Figure 4: Customer Export Setup screen - Export Mode

File Type Section

The fields and controls in this section of the screen only apply to the customer export process, not to the process of sending bulk email to selected customers.

Comma Delimited (CSV) Radio Button

Tab Delimited Radio Button

Include Field Names Check Box

Export Button

Close Button

Export to text file: select fields to include in file Section

Choose one or more fields in this section to determine the kinds of information that will be written to the text file. The fields and controls in this section of the screen only apply to the customer export process, not to the process of sending bulk email to selected customers.

Full Name Field

Name Prefix Field

First Name Field

Middle Name Field

Last Name Field

Name Suffix

Company Field

Address1 Field

Address2 Field

City Field

State Field

Zip Field

Email Field

Fax Field

Phone Field

Customer ID Field

Original Source Field      

Country Field

Recency Field

Frequency Field

Monetary Value Field

First Order Date Field

Start/End Date Fields

Calendar Button

Select All Button

Clear All Button

Bulk Email Section

The fields and buttons in this section only apply to sending bulk email to selected customers; they are not part of the customer record export process.

Email Template to Send to Customers Drop-Down list

Edit Template Button

Preview Button

Send Email Button

Note to add to Customer records Field

Sample Data Section          

The data displayed in this section of the screen represents the list of customer records that will be affected by exporting customer data to a text file or by the sending of bulk email messages to selected customers.

The fields that are displayed for each customer record depend on which fields are checked in the Export to text file: select fields to include in file section of the screen. If sending bulk email to customers, it is fine to [Clear All] of the default field selections to make the list of customer records less cluttered, although leaving them checked will have no bearing on the sending of bulk email.

 

Related Topics

Created: 1/19/11

Modified: 9/22/11

Go to Top