Skip to main content
T
toni11_2
August 23, 2017
Solved

List for Customer with multiple Ship-To addresses

  • August 23, 2017
  • 5 replies
  • 0 views
How do I export a list to excel for one customer that includes multiple Ship-To addresses?
    Best answer by AliciaRoy

    Hi Toni, 

     

    I'd be happy to lend a hand with exporting the customer's information. 

     

    This can be done by running the Customer Contact List report. Here's how: 

     

    • Go to the Reports tab, select Customers & Receivables, and choose Customer Contact List. 
    • Click on Customize Report and check off all the ship to fields (ship to 1, ship to 2, ship to 3, etc.) under the Display tab. 
    • Under the Filters tab, go to Customers and select the customer you need to run the report for. 
    • Click OK. You should now see the contact information for the selected customer, which includes all of their shipping addresses. 
    • Navigate to the drop down arrow next to Excel, select Create New Worksheet, and click the Export button. 

     

    Please let me know if this helps, or if you have any further questions for me. 

     

    5 replies

    AliciaRoy
    AliciaRoyAnswer
    August 24, 2017

    Hi Toni, 

     

    I'd be happy to lend a hand with exporting the customer's information. 

     

    This can be done by running the Customer Contact List report. Here's how: 

     

    • Go to the Reports tab, select Customers & Receivables, and choose Customer Contact List. 
    • Click on Customize Report and check off all the ship to fields (ship to 1, ship to 2, ship to 3, etc.) under the Display tab. 
    • Under the Filters tab, go to Customers and select the customer you need to run the report for. 
    • Click OK. You should now see the contact information for the selected customer, which includes all of their shipping addresses. 
    • Navigate to the drop down arrow next to Excel, select Create New Worksheet, and click the Export button. 

     

    Please let me know if this helps, or if you have any further questions for me. 

     

      T
      toni11_2Author
      August 28, 2017

      Hello Alicia,

      Thank you for taking the time to assist.  I initially did, and once again upon your reply, did generate this report; however, QB did not list any of the Ship To addresses (300+) for this one particular customer....unless there was a default address checked in the profile, and then only that address appeared on the report.

       

      I did find a work around by generating a report under sales for that customer, then customizing to include all Ship To filter selections.  The format was not ideal, but definitely usuable.

       

      Thank you again!

       

      Toni

        C
        cstansbarger
        March 15, 2018

        Toni,

         

        If you could share with me how you created that report, I would appreciate it. I am trying to do the same thing with a lot of frustration with not being able to within quickbooks.

         

        Thank you,

        Chandra

        qbteachmt
        qbteachmt
        August 28, 2017

        For QB Desktop, unfortunately, there is No Way to export the "Ship To" adresses if you are maintaining a List of them. It is its own list.

         

        The functions of "Ship to 1, Ship to 2" etc, seen in reporting are the Individual rows from the "Ship To" address block, the same way as you see "Bill to 1, Bill to 2" are the Rows. Think of these as Address Labels, to understand they have (for US addresses) 5 rows.

         

        That isn't the same use of the words or phrase "Ship To 1" which I can Rename to be Project Location, as a Ship To Address, on the Ship To list for that name.

         

        You can likely get to this data using a custom reporting tool, such as SDK or ODBC or perhaps Crystal Reports. I recommend asking on the Developers' Forum: https://help.developer.intuit.com/s/

         

         

        To see what AliciaRoy described, please see my attachments.

         

        Shipping Notes.JPGShip To Excel 2.JPGShip To Excel.JPGShip To Exported.JPG

        T
        TomC
        November 7, 2018

        Why does this say "solved"? It is far from solved, as it is not possible to export a list of ship-to addresses for each customer. This is frustratingly not possible with Quickbooks.

          B
          BetterIdeaGroup
          April 2, 2021

          We recently published a small extension for QuickBooks  that exports all the shipto addresses. See it at:

           

          Ship to address export tool

          S
          Stu66
          January 13, 2024

          zed access alllows you to both export and import multiple ship too addresses

           

          https://support.zed-systems.com/kb/a290/import-multiple-ship-to-addresses-into-quickbooks.aspx

           

           

          B
          BetterIdeaGroup
          January 14, 2024

          Yeah but $235 is a pretty steep price for a single export. For half that price that you can get all of your  ship to addresses exported using this tool:  
          https://www.betterideagroup.com/export-ship-to.html

           

          So far, the largest export was 17,000 individual addresses.

          Terms & ConditionsAccessibility statement