Why Is the default_address_id Column Empty in the Shopify CUSTOMER table?
If the default_address_id column in the Shopify CUSTOMER table appears empty, it’s because we no longer populate this column due to a schema change.
Why is the default_address_id column empty?
We have removed the default_address_id column from the CUSTOMER table in January 2021. For more information, see our Shopify changelog.
Where to find default address data
Use the is_default column in the CUSTOMER_ADDRESS table to find default addresses. To backfill the historical data for this column, contact our support team.