Import multiple Ship to addresses into QuickBooks

With Zed Axis you can import multiple Ship To addresses into a customer record in QuickBooks (up to a maximum of 50 per customer) from a text or Excel file. You will need your ship to addresses in a flat file with the customers name as it appears in QuickBooks and a column for the name of the ship to address eg. LA Residence.  
 
Here is a sample of how the ship to addresses import file should be laid out. 
 
 
Then using the Customer import type map your data to the Name (Customer Name) and a combination of the fields described below, for more on the mapping options importing address click here 
 
Add Ship address
 
QuickBooks fieldFormat Description 
NameStr 41MANDATORY The name of the customer
Ship To NameStr 41MANDATORY Name of the ship to address
Ship To Addr1Str 41The first line of an address block
Ship To Addr2Str 41The second line of an address block 
Ship To Addr3Str 41The third line of an address block 
Ship To Addr4Str 41The fourth line of an address block
Ship To Addr5Str 41The fifth line of an address block
Ship To CityStr 31The City line of an address
Ship To StateStr 21The State line of an address
Ship To Postal CodeStr 13The zip/post code of an address
Ship To CountryStr 31The country of an address
Ship To NoteStr 41A note that may appear at the bottom of an address block
Default Ship ToBoolWhether the ship to address is the default (true or false)

Add Feedback