Importing a Customer List to AmberPOS With Excel

Along with importing customers, we are also able to update any field that you are able to import.

You can do this by having the member ID of the existing customer in one column and the customer information populating the relevant fields in the others. When you are going to import AmberPOS will use the member ID to reference which customers to update.

 

1.Download the Excel template file here.

 

2. Open the Excel file to view the example template.

excel.JPG

     

 

Overview of Excel fields for Customer:

MemberID: The memberID of the customer in AmberPOS. (example: 1234567890)

Salutation: The salutation towards the particular customer. (example: Mr)

CustomerType: The type of customer to be designated as in AmberPOS. (example: Regular Customer)

FirstName: First name of the customer. (example: Mike)

LastName: Last name of the customer. (example: James)

Company: The company associated with the customer. (example: ABC inc)

Address: The address of the customer. (example: 123 Main Street)

City: The city that the customer resides in. (example: New York)

ProvState: The province or state that the customer resides in. (example: California)

PostalZip: The Postal code (Zip Code) of the customer. (example: 90210)

Country: The country that the customer resides in. (example: United States)

ShippingCity: The city associated with the customer to ship products sold to. (example: New York)

ShippingProvState: The province or state associated with the customer to ship products sold to. (example: California)

ShippingPostalZip: The Postal code (Zip Code) associated with the customer to ship products sold to. (example: 90210)

ShippingCountry: The country associated with the customer to ship products sold to. (example: United States)

Phone1: The phone number of the customer. (example: 919-012-4567)

Phone1Ext: The extension of the phone number associated with the customer. (example: 301)

Phone2: A second phone number associated with the customer. (example: 818-013-4568)

Phone2Ext: A second extension of the second phone number associated with the customer. (example: 302)

CellPhone: The cellular phone number of the customer. (example: 630-263-7345)

Fax: The fax number of the customer. (example: 639-873-8438)

Email: The email address of the customer. (example: examplecustomer@customer.com)

Notes: Any notes on the customer. (example: great customer!)

Tax1,2,3Number: The tax numbers on the customer. (example: 9643458)

StoreCredit: The store credit of the customer. (example: $250.00)

AR_Balance: The accounts receivable balance of the customer. (example: $1,253.54)

Points: The redeemable points balance that the customer for your store has accumulated. (example: 155000)

Active: Weather the customer is active or not. (example: Y or N)

MailingList: Weather the customer has subscribed to your mailing list. (example: Y or N)

EmailList: Weather the customer has subscribed to your email list. (example: Y or N)

Attribute1,2,3,4,5: Any extra attributes associated with the customer. (example: Male, 23 years, 196lb)

 

3. Go to File in the top right corner of the screen and select Save to save your excel file.

file_save_excel.JPG

 

4. Open AmberPOS and Login.

5. Access the Customers Menu, then select Import Customers after selecting the More>>> option. 

moreeee.JPG

 

6. Select Import Customers.

import_customers.JPG

 

7. Select CustomerImportTemplate

customerimporttemplate_icon.JPG

8. Overview:

customers_yeaaah.JPG

      Step 1: Ensure that the fields on the left match the fields on the right identically.

      Step 2: Select OK to proceed with the import.

 

9. A prompt will appear notifying you of a successful import.

 

customers_file_success_import.JPG

10. If you want to roll back the changes made, access the customer menu again and select Roll Back Last Import.

roll_back_last_import.JPG

 

Article written with AmberPOS version 4.14.05.05

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk