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 '=,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 = 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:

Id

Columns