Companies

Holds company profiles for B2B operations, including names, contact data, and relationship details.

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.
ExternalId supports the '=, !=' comparison operators.
Name supports the '=, !=' comparison operators.
CustomerSince supports the '=, <, >, >=, <=' comparison operators.
CreatedAt supports the '=, <, >, >=, <=' comparison operators.
UpdatedAt supports the '=, <, >, >=, <=' comparison operators.

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

  SELECT * FROM Companies WHERE Id = 'Val1'
  SELECT * FROM Companies WHERE ExternalId = 'Val1'
  SELECT * FROM Companies WHERE Name = 'Val1'
  SELECT * FROM Companies WHERE CustomerSince = '2023-01-01 11:10:00'
  SELECT * FROM Companies WHERE CreatedAt = '2023-01-01 11:10:00'
  SELECT * FROM Companies WHERE UpdatedAt = '2023-01-01 11:10:00'

Insert

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

ExternalId, Name, Note, CustomerSince

Update

The following columns can be updated:

ExternalId, Name, Note, MainContactId

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 company record within Shopify.
ExternalId	String	False		An externally provided identifier used to link the company to external systems or third-party integrations.
Name	String	False		The official name of the company as entered by the merchant.
Note	String	False		A merchant-authored note containing additional information or context about the company.
ContactsCount	Int	True		The total number of contact records associated with this company.
ContactsCountPrecision	String	True		Indicates whether the contacts count value is exact or estimated.
CustomerSince	Datetime	True		The date and time when the company was first recorded as a customer in Shopify.
DefaultCursor	String	True		A cursor value used to return the next record in ascending order by company ID during pagination.
LifetimeDuration	String	True		The length of time the company has been a customer, expressed in readable duration format such as '2 days', '3 months', or '1 year'.
LocationsCount	Int	True		The number of physical or operational locations associated with the company.
LocationsCountPrecision	String	True		Indicates whether the locations count value is exact or approximate.
OrdersCount	Int	True		The total number of orders placed by the company across all its associated locations.
OrdersCountPrecision	String	True		Indicates whether the order count value is exact or estimated.
HasTimelineComment	Bool	True		Indicates whether the merchant has added any timeline comments to this company record.
CreatedAt	Datetime	True		The timestamp marking when the company record was created in Shopify.
UpdatedAt	Datetime	True		The timestamp marking the most recent modification of the company record.
DefaultRoleId	String	True		The unique identifier of the default role assigned to contacts within this company.
DefaultRoleName	String	True		The name of the default role assigned to company contacts, such as 'Admin' or 'Buyer'.
DefaultRoleNote	String	True		A descriptive note or internal reference related to the default role configuration for the company.
MainContactId	String	True		The unique identifier of the company's designated main contact person.
TotalSpentAmount	Decimal	True		The total monetary amount spent by the company across all orders.
TotalSpentCurrencyCode	String	True		The three-letter ISO currency code representing the currency of the total amount spent.