Locations

Returns a list of active inventory locations.

Select

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

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 operators.
AddressProvince supports the '=,!=' comparison operators.
AddressZip supports the '=,!=' comparison operators.
IncludeInactive supports the '=,IN' comparison operators.
IncludeLegacy supports the '=,IN' comparison operators.

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 = 123
  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 = 123
  SELECT * FROM Locations WHERE IncludeLegacy = 123

Insert

Insert statements are mapped to the 'locationAdd' GraphQL mutation.

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

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

Update

Update statements are mapped to the 'locationEdit' GraphQL mutation.

The following columns can be updated:

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

Delete

Delete statements are mapped to the 'locationDelete' GraphQL mutation.

You can delete entries by specifying the Id

Columns