cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Henk DeJong
Level 1

When importing customers from a CSV file, the Name is a required field. What if I only want to use the Company field? Many clients don't have a specific contact name.

Leaving the Name field blank results in an import error.
3 Comments 3
Fiat Lux - ASIA
Level 15

When importing customers from a CSV file, the Name is a required field. What if I only want to use the Company field? Many clients don't have a specific contact name.

Prepare the Cusomer List data with the following template

TitleCompanyFirstNameMiddleNameLastNameSuffixDisplayNamePrintOnCheckNameBillingAddressLine1BillingAddressLine2BillingAddressLine3BillingAddressLine4BillingAddressCityBillingAddressStateBillingAddressPostalCodeBillingAddressCountryShippingAddressLine1ShippingAddressLine2ShippingAddressLine3ShippingAddressLine4ShippingAddressCityShippingAddressStateShippingAddressPostalCodeShippingAddressCountryPhoneNumberMobileNumberFaxNumberOtherNumberWebSiteEmailCustomerTypeSalesTermDefaultTaxCodeTaxExemptionReasonResaleNumberPaymentMethodPreferredDeliveryMethodBillWithParentCurrencyNotes
Mr.Abacus IndustriesJanice Johnson Janice Johnson 110 Main StreetSuite 2000  DallasTX99875 400 East Street   DallasTX99875 (603) 555-2000(603) 555-2001(603) 555-2002(603) 555-2003 [email address removed]ResidentialNet 30  12345678CheckPrintY  
Mr.Walker AssociatesLeonard Walker Leonard Walker 9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345 (603) 555-3000(603) 555-3001(603) 555-3002(603) 555-3003 [email address removed]CommercialNet 30   CheckEmail   
Mr.Pinnacle PartnersLisa Smith Lisa Smith 19 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256 (603) 555-4000(603) 555-4001(603) 555-4002(603) 555-4003 [email address removed] Net 30   CheckNone   

 

DisplayName should be the one and only mandatory field

https://transactionpro.grsm.io/qbo

 

Henk DeJong
Level 1

When importing customers from a CSV file, the Name is a required field. What if I only want to use the Company field? Many clients don't have a specific contact name.

Thanks for your reply! Unfortunately I don't have the luxury of using TransactionPro. Unless I'm missing something, QBO appears to require the Name field, which eventually ends up in First Name ... Last Name. See attached screen capture.

JamesM4
QuickBooks Team

When importing customers from a CSV file, the Name is a required field. What if I only want to use the Company field? Many clients don't have a specific contact name.

Hi there. I can see the need for having the flexibility to not include the Name filed. Since this feature isn't available, I encourage you to send feedback to our product developers. You can do this by clicking the Gear icon and looking for Feedback. New product ideas and improvements are largely based on the valuable feedback we get from users like you. I'll be one message away in case you have other questions. 

Need to get in touch?

Contact us