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 |
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 |
Comments
0 comments
Please sign in to leave a comment.