Locations

Returns a list of active inventory locations.

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
  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 globally-unique ID.
LegacyResourceId	String	True		The ID of the corresponding resource in the REST Admin API.
Name	String	False		The name of the location.
Activatable	Bool	True		Whether this location can be reactivated.
Deactivatable	Bool	True		Whether this location can be deactivated.
Deletable	Bool	True		Whether this location can be deleted.
AddressVerified	Bool	True		Whether the location address has been verified.
DeactivatedAt	String	True		The date and time that the location was deactivated at. For example, 3: 30 pm on September 7, 2019 in the time zone of UTC (Universal Time Coordinated) is represented as '2019-09-07T15: 50: 00Z'.
IsActive	Bool	False		Whether the location is active.
ShipsInventory	Bool	True		Whether this location is used for calculating shipping rates. In multi-origin shipping mode, this flag is ignored.
FulfillsOnlineOrders	Bool	False		Whether this location can fulfill online orders.
HasActiveInventory	Bool	True		Whether this location has active inventory.
HasUnfulfilledOrders	Bool	True		Whether this location has orders that need to be fulfilled.
AddressAddress1	String	False		The first line of the address for the location.
AddressAddress2	String	False		The second line of the address for the location.
AddressCity	String	False		The city of the location.
AddressCountry	String	True		The country of the location.
AddressFormatted	String	True		A formatted version of the address for the location.
AddressLatitude	Double	True		The latitude coordinates of the location.
AddressLongitude	Double	True		The longitude coordinates of the location.
AddressPhone	String	False		The phone number of the location.
AddressProvince	String	True		The province of the location.
AddressZip	String	False		The ZIP code of the location.
AddressCountryCode	String	False		The 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 code for the province, state, or district of the address of the location.
FulfillmentServiceId	String	True		The ID of the fulfillment service.
LocalPickupSettingsV2Instructions	String	True		Additional instructions or information related to the local pickup.
LocalPickupSettingsV2PickupTime	String	True		The estimated pickup time to show customers at checkout.
IncludeInactive	Bool	True		If true, also include the locations that are deactivated.
IncludeLegacy	Bool	True		If true, also include the legacy locations of fulfillment services.