Uploading Customers – AB Commerce Online Help

CSV File Naming Standards

The following is the CSV file that you can export:

CSV File
All Customers	customers_YYYYMMDDHHMMSS.csv	Sent every 15 minutes

Mandatory Fields

The following are the mandatory fields that must be included in the files:

AccountCode

Text(50)

The unique code for this customer

Optional Fields

The following are the optional fields that can be included in the files:

FirstName	Text(100)	The customer's first name
LastName	Text(100)	Their last name
CompanyName	Text(150)	Their company name
Email	Text(100)	Their email address
TaxNumber	Text(50)	e.g. EU Vat Number
CurrencyCode	Text(3)	Their default currency e.g. EUR, GBP, USD, etc
EnablePayOnAccount	True / False	If TRUE, they can select pay on account during checkout
DoNotChargeTax	True / False	If TRUE, they are not charged tax
FreeShippingOnAllOrders	True / False	If TRUE, they are not charged shipping
POMandatory	True / False	If TRUE, they must enter a PO number during checkout
DiscountPercentage_OrderItems	0 - 100	If not zero, the customer is given a discount on all products - excluding DISCOUNTS DISALLOWED products and disallowed primary categories
PricePlan_BaseCode	Text(50)	Optional base price plan code
PricePlan_SpecialCode	Text(50)	Optional special price plan code
OnlyShowCustomProducts	True / False	If TRUE, the customer will only see the products in their special price plan

Related articles