I am trying to pull customer data all address fields, but for some reason when I try and pull it, under the 'billing address' data, there is no street address field available. Same for 'shipping address'. I know this data exists at the line item level, and maybe not at the order level. Any idea how to get to the street address info?
If you want a customer list, you can use the Customers list and export to csv. If you want other reports to include the address or see them all on screen, I don't believe it is possible.
You can do this in our free app Report Toaster. We have over 60 pre-built reports and all of them can include any of the customer addresses. Or you can create your own custom reports. Please feel free to take. look and let me know if you have any questions. Thanks!
I am John from Report Pundit app.
It is possible with Report Pundit to get the complete street address for Billing and shipping address.
In few clicks, you can export the report you are looking for. Additionally, we can create custom sales level reports with all the shipping and product variant details.
The report can be exported to Excel, CSV, PDF, or Private URL Google sheet, Google drive, and BigQuery.
We have a 14-day free trial to test the reports. Our support team can set up any type of custom report unique to your store. Report setup is always free. You can reach us at email@example.com or contact our live chat support team.