Import My Customers

Contents of this Topic: Show

Overview

Customer information can be imported from a file or from a web store, if the shopping cart supports that feature. Refer to the Shopping Cart Matrix and Shopping Cart Functions screen for more information about the latter.

This topic discusses importing customer information from a text file, which can be either a tab-delimited or comma-delimited text file.

When importing data from a text file and the data contains commas, the file should be saved as a tab-delimited file, not as a .csv file.

Quotes should not be present in text files, regardless of whether it is a csv or tab-delimited file, or you will encounter errors.

To import customer information from a text file, go to Main Menu>Manage My Customers>Import My Customers - File

Best Practice

Before importing data into the store file, make a backup copy in case you need to back out the changes.

Description of the Screens

Select File to Import tab

Import

File to import from

Folder

Start Over

Next

Import Options tab

Field Delimiter

Comma
Tab
Other

First Row Contains Field Names

Match on Customer ID

Create New Customers

Data in Text File

Start Over

Back

Next

Customer Fields tab

 

 

Customer ID Company Country

Price Level

Full Name Email

Phone 1

Discount %
Name Prefix Address 1 Fax Cost Plus %
First Name Address 2 Don't Ship Web ID
Middle Name City Don't Mail Web Login
Last Name State Tax Exempt Password
Name Suffix Zipcode Tax ID  

 

Data in Text File

Start Over

Back

Next

Custom Fields tab 1

 

Data in Text File

Start Over

Back

Next

Custom Fields tab 2

 

Data in Text File

Start Over

Back

Next

Finish and Import Tab

Test Data

Begin Import

Start Over

Back

Additional information

Configuring Custom Fields

Customers

 

Created: 6/15/12

Revised: 8/10/15

Published: 08/19/15