CustomerAddresses

Create, update, delete, and query customer addresses.

Table-Specific Information

Select

The adapter uses the Shopify API to process WHERE clause conditions built with the following column and operator. The adapter processes other filters client-side within the adapter.

CustomerId supports the '=,IN' comparison.
CustomerUpdatedAt supports the '=' comparison.
FirstName supports the '=' comparison.
LastName supports the '=' comparison.
Company supports the '=' comparison.
Address1 supports the '=' comparison.
Address2 supports the '=' comparison.
City supports the '=' comparison.
Province supports the '=' comparison.
Country supports the '=' comparison.
Phone supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CustomerAddresses

SELECT * FROM CustomerAddresses WHERE CustomerId='123'

SELECT * FROM CustomerAddresses WHERE CustomerId IN ('123','456')

SELECT * FROM CustomerAddresses WHERE CustomerUpdatedAt = '2018-05-04'

SELECT * FROM CustomerAddresses WHERE FirstName='abc'

SELECT * FROM CustomerAddresses WHERE LastName='xyz'

SELECT * FROM CustomerAddresses WHERE Company='cdata'

SELECT * FROM CustomerAddresses WHERE Address1='Electronic city'

SELECT * FROM CustomerAddresses WHERE City='Bangalore'

SELECT * FROM CustomerAddresses WHERE Country='India'

SELECT * FROM CustomerAddresses WHERE Phone='9769879890'

Insert

You must specify the customer Id to create an address.

INSERT INTO CustomerAddresses(CustomerId, Address1, City, Company) VALUES('123', '1 Rue des Carrieres', 'Suite 1234', 'Montreal')

Update

You must specify the customer Id and the Id of the customer address to update an address.

UPDATE CustomerAddresses SET Zip='90210' WHERE CustomerId='123' AND Id='456'

Delete

You must specify the customer Id and the Id of the customer address to delete an address. You cannot delete a customer's default address.

DELETE FROM CustomerAddresses WHERE CustomerId='183467180055' AND Id='292265787415'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the address.
CustomerId [KEY]	Long	False	Customers.Id	A unique numeric identifier for the customer.
CustomerUpdatedAt	Datetime	True		The date and time when the customer information was last updated.
Name	String	False		The customer's name.
FirstName	String	False		The customer's first name.
LastName	String	False		The customer's last name.
Company	String	False		The customer's company.
Address1	String	False		The customer's mailing address.
Address2	String	False		An additional field for the customer's mailing address.
City	String	False		The customer's city.
Province	String	False		The customer's province or state name.
Country	String	False		The customer's country.
Zip	String	False		The customer's zip or postal code.
Phone	String	False		The customer's phone number for this mailing address.
ProvinceCode	String	False		The two-letter pcode for the customer's province or state.
CountryCode	String	False		The two-letter country code corresponding to the customer's country.
CountryName	String	False		The customer's normalized country name.
Default	Boolean	True		Indicates whether this address is the default address for the customer.