Import multiple Ship to addresses into QuickBooks

With Zed Axis you can import multiple Ship To addresses into a customer record in QuickBooks 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 field Format  Description 
Name Str 41 MANDATORY The name of the customer
ShipToName Str 41 MANDATORY Name of the ship to address
ShipToAddr1 Str 41 The first line of an address block
ShipToAddr2 Str 41 The second line of an address block 
ShipToAddr3 Str 41 The third line of an address block 
ShipToAddr4 Str 41 The fourth line of an address block
ShipToAddr5 Str 41 The fifth line of an address block
ShipToCity Str 31 The City line of an address
ShipToState Str 21 The State line of an address
ShipToPostalCode Str 13 The zip/post code of an address
ShipToCountry Str 31 The country of an address
ShipToNote Str 41 A note that may appear at the bottom of an address block

Add Feedback