Create, update, delete, and query customer addresses.

Table-Specific Information

Select

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

• CustomerId supports the '=,IN' comparison.
• CustomerUpdatedAt supports the '<,>,<=,>=' comparison.

For example, the following queries are processed server-side:

SELECT * FROM CustomerAddresses WHERE CustomerId = '123'

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

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

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	Bool	True		Indicates whether this address is the default address for the customer.