Note: This export differs from the one available on CRM as it includes all customers/contacts, even those that have been deleted.
Step Action
1. Select {Settings} and then select {Import/Export} under Customer.
2. Select {Export} on the right-hand side of screen to auto scroll to Export
section.
3. Select {Export} and then select Customers or Contacts from drop-down.
Note: You may need to confirm the file to be opened/saved before
proceeding, depending on your web browser. The file will be open or be
saved to your computer depending on your web browser.
Customer export will include:
Id Name Number External Identifier Phone Number Fax Number Email Address Website Sales Rep CSR Graphic Artist Tags Ship Type Invoice Payment Terms Customer Since Last Order Date | Tax Type Tax Exempt Number Discount Percentage Credit Limit Accounts Payable Contact Requires Purchase Order Deleted Commission Contacts Commission Percentages Automatically Grant Contacts Product Access Portals Roles Budgets Default Order Statuses Default Item Statuses Default Order Tags | Default Item Tags Billing Id Billing Name Billing Address Billing City Billing Region Billing Country Billing Zip/Postal Shipping Id Shipping Name Shipping Address Shipping City Shipping Region Shipping Country Shipping Zip/Postal |
Contact export will include:
Id Name Title Security Role Username Password Customer Number Customer Name Phone Number Fax Number | Email Address Is Deleted Tags Portals Budgets Billing Id Billing Name Billing Address Billing City Billing Region | Billing Country Billing Zip/Postal Shipping Id Shipping Name Shipping Address Shipping City Shipping Region Shipping Country Shipping Zip/Postal |