You can select the field shipping_address.validation_result_summary (Shipping Address Validation Status) in the Order Data Settings to determine whether the shipping address of an order has potential errors.

shipping_address.validation_result_summary

Shipping Address Validation Status (type: text). The validation status that is leveraged by the address validation feature in the Shopify Admin. Valid values: ERROR: Indicates that the address has been validated and is very likely to contain invalid information. NO_ISSUES: Indicates that the address has been validated and no issues were found. WARNING: Indicates that the address has been validated and might contain invalid information. Note that this field may also be null/blank if the address is not validated.

To exclude orders with an ERROR shipping address validation status from your order exports, you can add the following filter under the Custom Filters section:

Data must match: all conditions

• Shipping Address Validation Status is not equal to ERROR

To exclude orders with ERROR and WARNING status:

• Shipping Address Validation Status is not equal to any ERROR,WARNING

Note that if the address is not validated at all, it will have a blank/empty value.