Locations

Stores information about physical locations, including address, fulfillment role, and inventory management settings.

Table-Specific Information

Select

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

Id supports the '=, IN' comparison operators.
Name supports the '=, !=' comparison operators.
IsActive supports the '=, !=' comparison operators.
AddressAddress1 supports the '=, !=' comparison operators.
AddressAddress2 supports the '=, !=' comparison operators.
AddressCity supports the '=, !=' comparison operators.
AddressCountry supports the '!=' comparison operator.
AddressProvince supports the '=, !=' comparison operators.
AddressZip supports the '=, !=' comparison operators.
IncludeInactive supports the '=' comparison operator.
IncludeLegacy supports the '=' comparison operator.

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

  SELECT * FROM Locations WHERE Id = 'Val1'
  SELECT * FROM Locations WHERE Name = 'Val1'
  SELECT * FROM Locations WHERE IsActive = true
  SELECT * FROM Locations WHERE AddressAddress1 = 'Val1'
  SELECT * FROM Locations WHERE AddressAddress2 = 'Val1'
  SELECT * FROM Locations WHERE AddressCity = 'Val1'
  SELECT * FROM Locations WHERE AddressCountry != 'Val1'
  SELECT * FROM Locations WHERE AddressProvince = 'Val1'
  SELECT * FROM Locations WHERE AddressZip = 'Val1'
  SELECT * FROM Locations WHERE IncludeInactive = true
  SELECT * FROM Locations WHERE IncludeLegacy = true

Insert

The following columns can be used to create a new record:

Name, FulfillsOnlineOrders, AddressAddress1, AddressAddress2, AddressCity, AddressPhone, AddressZip, AddressCountryCode, AddressProvinceCode

Update

The following columns can be updated:

Name, IsActive, FulfillsOnlineOrders, AddressAddress1, AddressAddress2, AddressCity, AddressPhone, AddressZip, AddressCountryCode, AddressProvinceCode

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A unique identifier for the location record.
LegacyResourceId	String	True		The identifier of the corresponding location resource in the Shopify REST Admin API, used for backward compatibility.
Name	String	False		The display name of the location, such as a warehouse, store, or fulfillment center.
Activatable	Bool	True		Indicates whether the location can be reactivated after being deactivated.
Deactivatable	Bool	True		Indicates whether the location can currently be deactivated within the system.
Deletable	Bool	True		Indicates whether the location record can be permanently deleted.
AddressVerified	Bool	True		Specifies whether the location's address has been validated for accuracy.
DeactivatedAt	String	True		The date and time when the location was deactivated, represented in ISO 8601 format (for example, '2019-09-07T15:50:00Z').
IsActive	Bool	False		Indicates whether the location is currently active and available for operations.
ShipsInventory	Bool	True		Determines whether this location is included in shipping rate calculations. This setting is ignored in multi-origin shipping mode.
IsFulfillmentService	Bool	True		Indicates whether this location is managed by a fulfillment service.
FulfillsOnlineOrders	Bool	False		Specifies whether this location can fulfill online orders.
HasActiveInventory	Bool	True		Indicates whether this location currently has any active inventory items assigned to it.
HasUnfulfilledOrders	Bool	True		Indicates whether this location has pending or unfulfilled orders requiring fulfillment.
CreatedAt	Datetime	True		The date and time when the location record was created in Shopify.
UpdatedAt	Datetime	True		The date and time when the location record was last updated.
AddressAddress1	String	False		The first line of the street address for the location.
AddressAddress2	String	False		The second line of the street address for the location, such as suite or unit number.
AddressCity	String	False		The city where the location is situated.
AddressCountry	String	True		The country where the location is situated.
AddressFormatted	String	True		A formatted version of the full address for display or export.
AddressLatitude	Double	True		The latitude coordinate of the location for mapping or routing purposes.
AddressLongitude	Double	True		The longitude coordinate of the location for mapping or routing purposes.
AddressPhone	String	False		The primary phone number associated with the location.
AddressProvince	String	True		The province, state, or region where the location is situated.
AddressZip	String	False		The postal or ZIP code for the location.
AddressCountryCode	String	False		The two-letter ISO 3166-1 alpha-2 country code of the location. The allowed values are AC, AD, AE, AF, AG, AI, AL, AM, AN, AO, AR, AT, AU, AW, AX, AZ, BA, BB, BD, BE, BF, BG, BH, BI, BJ, BL, BM, BN, BO, BQ, BR, BS, BT, BV, BW, BY, BZ, CA, CC, CD, CF, CG, CH, CI, CK, CL, CM, CN, CO, CR, CU, CV, CW, CX, CY, CZ, DE, DJ, DK, DM, DO, DZ, EC, EE, EG, EH, ER, ES, ET, FI, FJ, FK, FO, FR, GA, GB, GD, GE, GF, GG, GH, GI, GL, GM, GN, GP, GQ, GR, GS, GT, GW, GY, HK, HM, HN, HR, HT, HU, ID, IE, IL, IM, IN, IO, IQ, IR, IS, IT, JE, JM, JO, JP, KE, KG, KH, KI, KM, KN, KP, KR, KW, KY, KZ, LA, LB, LC, LI, LK, LR, LS, LT, LU, LV, LY, MA, MC, MD, ME, MF, MG, MK, ML, MM, MN, MO, MQ, MR, MS, MT, MU, MV, MW, MX, MY, MZ, NA, NC, NE, NF, NG, NI, NL, NO, NP, NR, NU, NZ, OM, PA, PE, PF, PG, PH, PK, PL, PM, PN, PS, PT, PY, QA, RE, RO, RS, RU, RW, SA, SB, SC, SD, SE, SG, SH, SI, SJ, SK, SL, SM, SN, SO, SR, SS, ST, SV, SX, SY, SZ, TA, TC, TD, TF, TG, TH, TJ, TK, TL, TM, TN, TO, TR, TT, TV, TW, TZ, UA, UG, UM, US, UY, UZ, VA, VC, VE, VG, VN, VU, WF, WS, XK, YE, YT, ZA, ZM, ZW, ZZ.
AddressProvinceCode	String	False		The two-letter ISO 3166-2 province, state, or district code for the location.
FulfillmentServiceId	String	True		The unique identifier of the fulfillment service associated with the location, if applicable.
LocalPickupSettingsV2Instructions	String	True		Any additional notes or instructions displayed to customers selecting local pickup from this location.
LocalPickupSettingsV2PickupTime	String	True		The estimated pickup time shown to customers during checkout for local pickup orders.
IncludeInactive	Bool	True		If true, includes deactivated locations in the query or operation results.
IncludeLegacy	Bool	True		If true, includes legacy locations associated with fulfillment services.