CustomerAccountShippingAddress

CustomerAccountShippingAddress is an auto generated table. The supported operations are Querying data from this table.

Table Specific Information

Select

The add-in uses the AdobeCommerce API to filter the results by CustomerId while the rest of the filter is executed client side within the add-in.

You must specify the CustomerId column in the WHERE clause to retrieve results from CustomerAccountShippingAddress. CustomerId can be used only with the equals (=) operator. For example:

SELECT * FROM [CustomerAccountShippingAddress] WHERE CustomerId = '123'

Columns


Name	Type	Description
Id [KEY]	Int	ID
City	String	City name
Company	String	Company
CountryId	String	Country code in ISO_3166-2 format
CustomerId	Int	Customer ID
DefaultBilling	Bool	If this address is default billing address
DefaultShipping	Bool	If this address is default shipping address.
ExtensionAttributes	String	This is an auto-generated column
Fax	String	Fax number
Firstname	String	First name
Lastname	String	Last name
Middlename	String	Middle name
Postcode	String	Postcode
Prefix	String	Prefix
Region	String	This is an auto-generated column
RegionId	Int	Region ID
Street	String	Street
Suffix	String	Suffix
Telephone	String	Telephone number
VatId	String	Vat id

Excel Add-In for Adobe Commerce

CustomerAccountShippingAddress

Table Specific Information

Select

Columns