1. Select {Settings} and then select {Import/Export} under Customer.
2. Select {Choose File}.
3. Locate file on computer to be imported and select {Open}. The name of the file to
be imported will appear next to {Choose File} button.
4. Select {Import}. A Customers and Contacts option will appear.
Tips for Formatting Customer .CSV for Import
The following guidelines should be noted when creating your Customer .CSV file for import:
Notes:
Column header names must follow the exact same naming scheme as provided or the import upload will fail.
Blank rows are considered empty and skipped by the importer.
It is possible to successfully upload 0 rows of information, as long as all required columns are present, the importer will still “succeed”.
Overwrites will be performed on any data that has been changed between exporting/importing.
Field | Is Field Required? | Additional Details | Field Value Format | Max Characters/Values |
Id | Leave Blank |
|
|
|
Name | Yes |
|
| 120 |
Number | Leave Blank |
|
|
|
External Identifier | No |
|
|
|
Phone Number | No | |||
Fax Number | No | |||
Email Address | No | |||
Website | No | |||
Sales Rep | No |
|
|
|
CSR | Leave Blank |
|
|
|
Graphic Artist | Leave Blank |
|
|
|
Tags | No |
|
| 200 |
Ship Type | No |
|
|
|
Invoice | No |
|
| 30 |
Payment Terms | No | |||
Customer Since | No | |||
Last Order Date | No | |||
Tax Type | No |
Example: Ontario - HST or Alberta-GST or Manitoba-GST+PST
|
| 50 |
Tax Exempt Number | No | |||
Discount Percentage | No |
|
| |
Credit Limit | No |
|
|
|
Accounts Payable Contact | Leave Blank | |||
Requires Purchase Order | No | |||
Deleted | Yes |
|
|
|
Commission Contacts | Leave Blank |
|
|
|
Commission Percentages | Leave Blank |
|
|
|
Automatically Grant Contacts Product Access | Yes |
|
|
|
Portals | Leave Blank |
|
|
|
Roles | Leave Blank |
|
| 200 |
Budgets | No |
|
|
|
Default Order Statuses |
|
|
|
|
Default Item Statuses |
|
|
|
|
Default Order Tags |
|
|
|
|
Default Item Tags |
|
|
|
|
Billing Id | Leave Blank |
|
|
|
Billing Name | No |
|
| 255 |
Billing Address | No |
| ||
Billing City | No |
|
|
|
Billing Region | No |
|
|
|
Billing Country | No |
|
|
|
Billing Zip/Postal | No |
| ||
Shipping Id | Leave Blank |
|
| |
Shipping Name |
|
|
| 255 |
Shipping Address | No |
| ||
Shipping City | No |
| ||
Shipping Region | No |
|
|
|
Shipping Country | No |
|
|
|
Shipping Zip/Postal | No |
|
|
|
Tips for Formatting Contacts .CSV for Import
The following guidelines should be noted when creating your Contacts .CSV file for import:
Notes:
Column header names must follow the exact same naming scheme as provided or the import upload will fail.
Currently this importer is not working, functionality should be as described below:
Blank rows are considered empty and skipped by the importer.
It is possible to successfully upload 0 rows of information, as long as all required columns are present, the importer will still “succeed”.
Overwrites will be performed on any data that has been changed between exporting/importing.
Field | Is Field Required? | Additional Details | Field Value Format | Max Characters/Values |
Id | Leave Blank |
|
| |
Name | Yes |
|
|
|
Title | No |
| 100 | |
Security Role | Leave Blank |
Example: Rush;Delivery
|
| 200 |
Username | Leave Blank |
|
|
|
Password | Leave Blank |
|
|
|
Customer Number | Yes |
|
|
|
Customer Name | No |
|
| 120 |
Phone Number | No |
| 50 | |
Fax Number | No |
| 50 | |
Email Address | No |
| 150 | |
Is Deleted | Yes |
|
| |
Tags | No |
|
| 200 |
Portals | Leave Blank |
|
|
|
Budgets | No |
|
| |
Billing Id | Leave Blank |
|
| |
Billing Name | No |
|
| 255 |
Billing Address | No |
|
| 500 |
Billing City | No |
|
| 50 |
Billing Region | No |
|
| 255 |
Billing Country | No |
|
| 255 |
Billing Zip/Postal | No |
|
| 20 |
Shipping Id | Leave Blank |
|
| |
Shipping Name | No |
|
| 255 |
Shipping Address | No |
|
| 500 |
Shipping City | No |
| 50 | |
Shipping Region | No |
|
| 255 |
Shipping Country | No |
|
| 255 |
Shipping Zip/Postal | No |
|
| 20 |