Can I export all addresses associated with a customer in Shopify?
Yes, our EZ Exporter app supports exporting all Shopify customer addresses.
To export these addresses, simply select the field addresses when creating a Data Settings for Customer data. This will export a list of addresses in JSON format in one column.
If you'd like to export the data in a more readable format, you can use this formula in the Calculated Fields section:
"\n\n".join(["\n".join([v for v in [i.name or "", i.company or "", i.address1 or "", i.address2 or "", f"{i.city or ''} {i.province or ''} {i.zip or ''}".strip(), i.country or ""] if v]) for i in load_json_data({{ addresses }}) if i.name])
This will export each address in this format separated by 2 line breaks:
Full Name Company Name Address1 Address2 City State/Province Zip Country
App: EZ Exporter
Tags: customer addresses