--- title: Customer File Import description: "A customer file contains information about a customer in OMS. Customers are typically companies with whom your company does business with.  A sample template of the import is provided here: Customer I" --- [Skip to content](https://support.mastersystem.com/onboarding/data-conversion/customer-file-import#main-content) English Show submenu for translations ![pavo\_oms\_no\_shadow.png\]](https://support.mastersystem.com/hs-fs/hubfs/pavo_oms_no_shadow.png?height=45&name=pavo_oms_no_shadow.png) Open main navigation Close main navigation - English Show submenu for translations - [Go to mastersystem.com](https://www.mastersystem.com/) [Go to mastersystem.com](https://www.mastersystem.com/) Get Support with OMS/Pavo - There are no suggestions because the search field is empty. 1. [OMS/Pavo Support](https://support.mastersystem.com/?hsLang=en) 2. [Onboarding](https://support.mastersystem.com/onboarding?hsLang=en) 3. [Data Conversion](https://support.mastersystem.com/onboarding?hsLang=en#data-conversion) # Customer File Import A customer file contains information about a customer in OMS. Customers are typically companies with whom your company does business with.  A sample template of the import is provided here: [Customer Import Template](https://support.mastersystem.com/hubfs/Import_Customer.csv?hsLang=en) ### Supported Customer Fields For Import The customer import supports the import of the following fields: | **Column Name** | **Required** | **Type** | **Note** | | --- | --- | --- | --- | | Customer ID | Yes | String | Maximum Length 10 | | Customer Name | Yes | String |   | | Phone#1 | Yes | Integer | Maximum Length 10 | | Phone#2 | No | Integer | Maximum Length 10 | | Fax# | No | Integer | Maximum Length 10 | | Status | Yes | String | "Active", "Inactive", "Credit Hold", "Potential" | | Bus.Type | No | Integer | Valid values are 1, 2, 3, 4 or 5. This is the business type assigned to this Customer. If this column is not provided, the value provided will be 1. | | Billing\_Address1 | No | String | Maximum Length 60 | | Billing\_Address2 | No | String | Maximum Length 60 | | Billing\_City | No | String | Maximum Length 40 | | Billing\_State | No | String | We recommend using two digits ("CA"). Maximum Length 12 | | Billing\_Zip | No | String | Maximum Length 10 | | Billing\_Country | No | String | We recommend using two digits ("US"). Maximum Length 30 | | Ship\_Address1 | No | String | Maximum Length 60 | | Ship\_Address2 | No | String | Maximum Length 60 | | Ship\_City | No | String | Maximum Length 40 | | Ship\_State | No | String | We recommend using two digits ("CA"). Maximum Length 12 | | Ship\_Zip | No | String | Maximum Length 10 | | Ship\_Country | No | String | We recommend using two digits ("US"). Maximum Length 30 | | Ship Via | No | String | Maximum Length 40 | | Attn1 | No | String | Attention Field, or Contact Person. Maximum length 30 | | Title | No | String | Maximum length 10 | | Sales1# | No | String | 2 character sales rep code | | Sales2# | No | String | 2 character sales rep code | | Business Start Date | No | String | Date in format "MM/DD/YYYY" | | Email | No | String |   | | Website | No | String | Maximum length 40 | | Terms | No | String |   | | Term Days | No | Integer |   | | Credit Limit | No | Decimal | Up to $99,999,999 | | Tax Rate % | No | Decimal | Example: Input "10" for 10% tax rate | | Discount % | No | Decimal | Example: Input "10" for 10% discount | | Resale# | No | String | Maximum length 20 | | Source | No | String | Maximum length 8 | | Invoice Type | No  | String | Maximum length 2 | | Dept | No | String | Maximum length 4 | | Zone | No | String | Maximum length 3 |   - [Onboarding](https://support.mastersystem.com/onboarding?hsLang=en#main-content) - [Data Conversion](https://support.mastersystem.com/onboarding?hsLang=en#data-conversion) - [OMS (On-Premise)](https://support.mastersystem.com/onboarding?hsLang=en#oms-on-premise) - [Pavo](https://support.mastersystem.com/onboarding?hsLang=en#pavo) - [Archived](https://support.mastersystem.com/onboarding?hsLang=en#archived) - [OMS ERP](https://support.mastersystem.com/oms-erp?hsLang=en#main-content) - [System Administration](https://support.mastersystem.com/oms-erp?hsLang=en#system-administration) - [Installation & Updates](https://support.mastersystem.com/oms-erp?hsLang=en#installation-updates) - [OMS Cloud](https://support.mastersystem.com/oms-cloud?hsLang=en#main-content) - [Onboarding](https://support.mastersystem.com/oms-cloud?hsLang=en#onboarding) - [General Usage](https://support.mastersystem.com/oms-cloud?hsLang=en#general-usage) - [Archived](https://support.mastersystem.com/oms-cloud?hsLang=en#archived) - [OMS Cloud & Pavo Add-Ons](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#main-content) - [Email Module](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#email-module) - [Credit Card Module](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#credit-card-module) - [Shipping](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#shipping) - [PavoConnect](https://support.mastersystem.com/oms-cloud-pavo-add-ons-1?hsLang=en#pavoconnect) - [Pavo Integrations](https://support.mastersystem.com/pavo-integrations?hsLang=en#main-content) - [Overview](https://support.mastersystem.com/pavo-integrations?hsLang=en#overview) - [Rithum (CommerceHub)](https://support.mastersystem.com/pavo-integrations?hsLang=en#rithum-commercehub) - [NuORDER](https://support.mastersystem.com/pavo-integrations?hsLang=en#nuorder) - [WooCommerce](https://support.mastersystem.com/pavo-integrations?hsLang=en#woocommerce) - [BigCommerce](https://support.mastersystem.com/pavo-integrations?hsLang=en#bigcommerce) - [Pavo Admin](https://support.mastersystem.com/pavo-admin?hsLang=en#main-content) - [Payments](https://support.mastersystem.com/pavo-admin?hsLang=en#payments) - [Shipping](https://support.mastersystem.com/pavo-admin?hsLang=en#shipping) - [Clarion Server](https://support.mastersystem.com/pavo-admin?hsLang=en#clarion-server) - [Email](https://support.mastersystem.com/pavo-admin?hsLang=en#email) - [Pavo Websites (B2B & Sales Rep)](https://support.mastersystem.com/pavo-websites-b2b-sales-rep?hsLang=en#main-content) - [Domain & URLs](https://support.mastersystem.com/pavo-websites-b2b-sales-rep?hsLang=en#domain-urls) - [Using your site](https://support.mastersystem.com/pavo-websites-b2b-sales-rep?hsLang=en#using-your-site) [![Chill listening crop-3](https://support.mastersystem.com/hs-fs/hubfs/pavo_oms_no_shadow.png?width=85&height=24&name=pavo_oms_no_shadow.png "Chill listening crop-3")](https://support.mastersystem.com?hsLang=en) OMS/Pavo Support Copyright © 2026, Master System, Inc.