Along with importing customers, we are also able to update any field that you are able to import. For updating customers, please scroll down to the bottom of the article.
Importing New Customers into AmberPOS
1.Download the Excel template file HERE.
2. Open the Excel file to view the example template.
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)
Group: Add the same group name to multiple customers to group them for AR Payments.
SubGroup: Add the same subgroup name to multiple customers to group them for AR Payments.
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.
4. Open AmberPOS and Login.
5. Access the Customers Menu, then select Import Customers after selecting the More>>> option. (Scroll to the bottom of this article if you are looking to update existing customers).
6. Select Import Customers.
7. Select CustomerImportTemplate
8. Overview:
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.
10. If you want to roll back the changes made, access the customer menu again and select Roll Back Last Import.
Updating Existing Customers in AmberPOS
You can do this by having the Member ID OR Customer ID of the existing customer in one column and the customer information populating the relevant fields in the others. When you are going to update AmberPOS will use the Member ID/Cusomter ID to reference which customers to update.
We recommend you try this first in Training Mode, then double check the changes before implementing them on the live database.
1. Open AmberPOS and Login.
2. Access the Customers Menu, then select Update Customers after selecting the More>>> option.
3. Select Update Customers.
4. Select your saved excel document.
5. Overview:
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.
6. A prompt will appear notifying you of a successful import.
Article written with AmberPOS version 4.14.05.05
0 Comments