7cart - User Import - Schema

	A	B
1	Column Heading	Display Name
2	username	Username of the User
3	email	Email Address of the User
4	firstname	First Name of the User
5	lastname	Last Name of the User
6	taxexempt	Whether or not the user is tax exempt. Enter either 0 or 1; 1 being tax exempt
7	shippingexempt	Whether or not the user is shipping exempt. Enter either 0 or 1; 1 being shipping exempt
8	accountnumber	Account Number of the User
9	company	Company of the User
10	comment	Any additional comments on the User
11	billingfirstname	Primary Billing Address's First Name
12	billinglastname	Primary Billing Address's Last Name
13	billingcompany	Primary Billing Address's Company
14	billingaddressline1	Primary Billing Address Line 1
15	billingaddressline2	Primary Billing Address Line 2
16	billingaddressline3	Primary Billing Address Line 3
17	billingaddresscity	Primary Billing Address City
18	billingaddressstate	Primary Billing Address State
19	billingaddresspostalcode	Primary Billing Address Zip Code
20	billingaddresscountry	Primary Billing Address Country
21	billingaddressphone	Primary Billing Address Phone Number
22	billingaddressfax	Primary Billing Address Fax Number
23	shippingfirstname	Primary Shipping Address First Name
24	shippinglastname	Primary Shipping Address Last Name
25	shippingcompany	Primary Shipping Address Company
26	shippingaddressline1	Primary Shipping Address Line 1
27	shippingaddressline2	Primary Shipping Address Line 2
28	shippingaddressline3	Primary Shipping Address line 3
29	shippingaddresscity	Primary Shipping Address City
30	shippingaddressstate	Primary Shipping Address State
31	shippingaddresspostalcode	Primary Shipping Address Zip Code
32	shippingaddresscountry	Primary Shipping Address Country
33	shippingaddressphone	Primary Shipping Address Phone Number
34	shippingaddressfax	Primary Shipping Address Fax Number
35	salesperson	Username of Salesperson. The Salesperson you type in must already exist in the system.
36	email2	BCC Email Address
37	email3	BCC Email Address
38	email4	BCC Email Address
39	pricerulename	Full Name of Price Rule. Case Sensitive.
40	managerusername	Username of Manager. Must already exist in users.
41	useraccountrole	Accepted values: "Manager" or "Purchaser"
42	useraccountapprovalmode	Accepted values: "None" or "Always"
43	accountrole	Full Name of Customer Group. Case Sensitive.
44	avalaracertificateid	Third Party Information
45	backenduserid	This is an internal tag that is used for development
46	backenddepartmentid	This is an internal tag that is used for development