QuickBooks

Multiple Ship To Address Importer Guide

This utility is used to Add and Update Ship To Addresses for existing customers in QuickBooks®

See our Multiple Ship To Address Importer application page for pricing and purchase information.

This product has been designed to work with a currently open QuickBooks® file so prior to launching this application make sure you have your QuickBooks® file open.

The first time the program is run you will be prompted for a Product Key. You must enter a valid Product Key for the application to continue. Your Product Key will be provided when you purchase the product. Our Product Keys are generated for the computer the application is being run on. If you are planning on running the application on multiple computers you will be provided a Product Key for each system. Make sure that you are entering the correct Product Key for the system you are on.

Once you have successfully entered your Product Key you will see the main screen of the program. The Company Name of the Open QuickBooks® file will be displayed at the top of the screen, helping to ensure you are logged into the correct file, for those that may have more than one.

The first step in running the application is to select the type of import you want to do.

There are 2 options:

  1. Add new / Keep existing – Addresses in your spreadsheet will be compared to any current addresses in the file, if the address in the spreadsheet is new it will be added and if the address name already exists the address in the spreadsheet will be ignored.
  2. Add new / Update existing – Addresses in your spreadsheet will be compared to any current addresses in the file, if the address in the spreadsheet is new it will be added, if the address name already exists the address will be updated with the information in the spreadsheet.

MultiShipToStart

Type of Import

Once you have selected your option the Select Spreadsheet button will be activated and you can now select the spreadsheet you wish to import.

After selecting the spreadsheet you will be able to select the sheet within the Excel workbook that contains your address information.

MultiShipToSheetSelectWith the proper sheet selected click the Validate Spreadsheet button. If there are problems with the data in the spreadsheet, for example the Customer does not exist in QuickBooks® or you have duplicate address names in the spreadsheet, a list of errors will appear in the lower part of the application window.

MultiShipToErrorAt this point you can print the list of errors and warnings, correct the issues in the spreadsheet and re-select the spreadsheet; or you can import what passed validation and then take care of the errors.

Once the import is complete you will receive a message indicating the application is done, once you click the okay button the application will reset so you can do another file or you can exit the program.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s