United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Henk DeJong
Level 1
posted
‎July 01, 2021 08:12 PM
last updated ‎July 01, 2021 5:12 PM

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.
Reply Join the conversation
3 Comments 3
Fiat Lux - ASIA
Level 15
‎July 02, 2021 04:58 AM

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

 

Reply Join the conversation
Henk DeJong
Level 1
‎July 02, 2021 05:57 AM

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.

Reply Join the conversation
JamesM4
QuickBooks Team
QuickBooks Team
‎July 02, 2021 03:51 PM

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. 

Reply Join the conversation
Featured
Update billing, subscription and firm info in QuickBooks Online Accountant
Looking to update billing, subscription, and firm information in QuickBooks...
Read more
New ROE submission process in QuickBooks Payroll
To learn more about the new record of employment submission process in Quic...
Read more
View and print your T4s and RL-1s in QuickBooks Workforce
Learn how you can view and print your own T4s/Relevé1s online or through th...
Read more

Need to get in touch?

Contact us