Shopify connection for LinkyFlow

LinkyFlow brings Shopify ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.

Resources

Read requests

Write actions

Documented fields

73660

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

B2B

Company

Companies data in Shopify.

Used as filter by

List Catalogs · query.company_id

List Company Locations · query.company_id

Read

List Companies

Fetch companies from Shopify.

Route: GET /companies

Excel formula: =LF.shopify.companies("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list by the given key. Values: CREATED_AT, ID, NAME, ORDER_COUNT, SINCE_DATE
`query.active_customers_count`	number	No	-
`query.created_at`	date	No	-
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.external_id`	id	No	-
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.metafields.{namespace}.{key}`	string	No	Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about [querying by metafield value](https:/...
`query.name`	string	No	-
`query.ordering_status`	string	No	-
`query.since_date`	date	No	-
`query.updated_at`	date	No	-

Data returned in Excel

Field	Type	Relations	Description
`contactCount` default	number	—	-
`id` default	id	—	-
`name` default	string	—	-
`note` default	string	—	-
`createdAt` default	date	—	-
`id` default	id	—	-
`isMainContact` default	boolean	—	-
`lifetimeDuration` default	string	—	-
`locale` default	string	—	-
`title` default	string	—	-
`updatedAt` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`createdAt` default	date	—	-
`customerSince` default	date	—	-
`id` default	id	—	-
`name` default	string	—	-
`note` default	string	—	-
`acceptAutomaticDiscounts` default	boolean	—	-
`allowDiscountCodesInCheckout` default	boolean	—	-
`allVariantPricesOverridden` default	boolean	—	-
`anyVariantPricesOverridden` default	boolean	—	-
`billingAddressMatchesShippingAddress` default	boolean	—	-
`completedAt` default	date	—	-
`createdAt` default	date	—	-
`currencyCode` default	enum	—	-
`discountCodes` default	string[]	—	-
`email` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ draftOrders	-
`invoiceEmailTemplateSubject` default	string	—	-
`invoiceSentAt` default	date	—	-
`invoiceUrl` default	string	—	-
`marketName` default	string	—	-
`marketRegionCountryCode` default	enum	—	-
`name` default	string	—	-
`note2` default	string	—	-
`phone` default	string	—	-
`poNumber` default	string	—	-
`presentmentCurrencyCode` default	enum	—	-
`ready` default	boolean	—	-
`reserveInventoryUntil` default	date	—	-
`status` default	enum	—	-
`subtotalPrice` default	string	—	-
`tags` default	string[]	—	-
`taxesIncluded` default	boolean	—	-
`taxExempt` default	boolean	—	-
`totalPrice` default	string	—	-
`totalQuantityOfLineItems` default	number	—	-
`totalShippingPrice` default	string	—	-
`totalTax` default	string	—	-
`totalWeight` default	string	—	-
`transformerFingerprint` default	string	—	-
`updatedAt` default	date	—	-
`visibleToCustomer` default	boolean	—	-
`action` default	string	—	-
`additionalContent` default	string	—	-
`additionalData` default	string	—	-
`appTitle` default	string	—	-
`arguments` default	string	—	-
`attributeToApp` default	boolean	—	-
`attributeToUser` default	boolean	—	-
`author` default	string	—	-
`createdAt` default	date	—	-
`criticalAlert` default	boolean	—	-
`hasAdditionalContent` default	boolean	—	-
`id` default	id	—	-
`message` default	string	—	-
`secondaryMessage` default	string	—	-
`subjectId` default	string	—	-
`subjectType` default	enum	—	-
`externalId` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ companies	-
`lifetimeDuration` default	string	—	-
`createdAt` default	date	—	-
`currency` default	enum	—	-
`externalId` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ companyLocations	-
`locale` default	string	—	-
`name` default	string	—	-
`note` default	string	—	-
`orderCount` default	number	—	-
`phone` default	string	—	-
`taxExemptions` default	string	—	-
`taxRegistrationId` default	string	—	-
`updatedAt` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`createdAt` default	date	—	-
`id` default	id	—	-
`isMainContact` default	boolean	—	-
`lifetimeDuration` default	string	—	-
`locale` default	string	—	-
`title` default	string	—	-
`updatedAt` default	date	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`description` default	string	—	-
`id` default	id	—	-
`key` default	string	—	-
`name` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`pinnedPosition` default	number	—	-
`useAsCollectionCondition` default	boolean	—	-
`validationStatus` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`name` default	string	—	-
`note` default	string	—	-
`billingAddressMatchesShippingAddress` default	boolean	—	-
`cancelledAt` default	date	—	-
`cancelReason` default	enum	—	-
`canMarkAsPaid` default	boolean	—	-
`canNotifyCustomer` default	boolean	—	-
`capturable` default	boolean	—	-
`cartDiscountAmount` default	string	—	-
`clientIp` default	string	—	-
`closed` default	boolean	—	-
`closedAt` default	date	—	-
`confirmationNumber` default	string	—	-
`confirmed` default	boolean	—	-
`createdAt` default	date	—	-
`currencyCode` default	enum	—	-
`currentSubtotalLineItemsQuantity` default	number	—	-
`currentTotalWeight` default	string	—	-
`customerAcceptsMarketing` default	boolean	—	-
`customerLocale` default	string	—	-
`discountCode` default	string	—	-
`discountCodes` default	string[]	—	-
`displayFinancialStatus` default	enum	—	-
`displayFulfillmentStatus` default	enum	—	-
`dutiesIncluded` default	boolean	—	-
`edited` default	boolean	—	-
`email` default	string	—	-
`estimatedTaxes` default	boolean	—	-
`fulfillable` default	boolean	—	-
`fullyPaid` default	boolean	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ orders	-
`landingPageDisplayText` default	string	—	-
`landingPageUrl` default	string	—	-
`merchantEditable` default	boolean	—	-
`merchantEditableErrors` default	string[]	—	-
`name` default	string	—	-
`netPayment` default	string	—	-
`note` default	string	—	-
`number` default	number	—	-
`paymentGatewayNames` default	string[]	—	-
`phone` default	string	—	-
`poNumber` default	string	—	-
`presentmentCurrencyCode` default	enum	—	-
`processedAt` default	date	—	-
`productNetwork` default	boolean	—	-
`referralCode` default	string	—	-
`referrerDisplayText` default	string	—	-
`referrerUrl` default	string	—	-
`refundable` default	boolean	—	-
`registeredSourceUrl` default	string	—	-
`requiresShipping` default	boolean	—	-
`restockable` default	boolean	—	-
`returnStatus` default	enum	—	-
`riskLevel` default	enum	—	-
`sourceIdentifier` default	string	—	-
`sourceName` default	string	—	-
`subtotalLineItemsQuantity` default	number	—	-
`subtotalPrice` default	string	—	-
`tags` default	string[]	—	-
`taxesIncluded` default	boolean	—	-
`taxExempt` default	boolean	—	-
`test` default	boolean	—	-
`totalCapturable` default	string	—	-
`totalDiscounts` default	string	—	-
`totalPrice` default	string	—	-
`totalReceived` default	string	—	-
`totalRefunded` default	string	—	-
`totalShippingPrice` default	string	—	-
`totalTax` default	string	—	-
`totalWeight` default	string	—	-
`unpaid` default	boolean	—	-
`updatedAt` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`amount` default	number	—	-
`currencyCode` default	enum	—	-
`updatedAt` default	date	—	-

Company Location

Company Locations data in Shopify.

Used as filter by

List Catalogs · query.company_location_id

Read

List Company Locations

Fetch company locations from Shopify.

Route: GET /companyLocations

Excel formula: =LF.shopify.companyLocations("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list by the given key. Values: COMPANY_AND_LOCATION_NAME, COMPANY_ID, CREATED_AT, ID, NAME
`query.company_id`	id	No	-
`query.created_at`	date	No	-
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.external_id`	string	No	-
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.ids`	string	No	-
`query.metafields.{namespace}.{key}`	string	No	Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about [querying by metafield value](https:/...
`query.name`	string	No	-
`query.updated_at`	date	No	-

Data returned in Excel

Field	Type	Relations	Description
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`companyName` default	string	—	-
`country` default	string	—	-
`countryCode` default	enum	—	-
`createdAt` default	date	—	-
`firstName` default	string	—	-
`formattedArea` default	string	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`recipient` default	string	—	-
`updatedAt` default	date	—	-
`zip` default	string	—	-
`zoneCode` default	string	—	-
`checkoutToDraft` default	boolean	—	-
`editableShippingAddress` default	boolean	—	-
`payNowOnly` default	boolean	—	-
`id` default	id	→ catalogs	-
`status` default	enum	—	-
`title` default	string	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`contactCount` default	number	—	-
`createdAt` default	date	—	-
`customerSince` default	date	—	-
`externalId` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ companies	-
`lifetimeDuration` default	string	—	-
`name` default	string	—	-
`note` default	string	—	-
`updatedAt` default	date	—	-
`createdAt` default	date	—	-
`currency` default	enum	—	-
`acceptAutomaticDiscounts` default	boolean	—	-
`allowDiscountCodesInCheckout` default	boolean	—	-
`allVariantPricesOverridden` default	boolean	—	-
`anyVariantPricesOverridden` default	boolean	—	-
`billingAddressMatchesShippingAddress` default	boolean	—	-
`completedAt` default	date	—	-
`createdAt` default	date	—	-
`currencyCode` default	enum	—	-
`discountCodes` default	string[]	—	-
`email` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ draftOrders	-
`invoiceEmailTemplateSubject` default	string	—	-
`invoiceSentAt` default	date	—	-
`invoiceUrl` default	string	—	-
`marketName` default	string	—	-
`marketRegionCountryCode` default	enum	—	-
`name` default	string	—	-
`note2` default	string	—	-
`phone` default	string	—	-
`poNumber` default	string	—	-
`presentmentCurrencyCode` default	enum	—	-
`ready` default	boolean	—	-
`reserveInventoryUntil` default	date	—	-
`status` default	enum	—	-
`subtotalPrice` default	string	—	-
`tags` default	string[]	—	-
`taxesIncluded` default	boolean	—	-
`taxExempt` default	boolean	—	-
`totalPrice` default	string	—	-
`totalQuantityOfLineItems` default	number	—	-
`totalShippingPrice` default	string	—	-
`totalTax` default	string	—	-
`totalWeight` default	string	—	-
`transformerFingerprint` default	string	—	-
`updatedAt` default	date	—	-
`visibleToCustomer` default	boolean	—	-
`action` default	string	—	-
`additionalContent` default	string	—	-
`additionalData` default	string	—	-
`appTitle` default	string	—	-
`arguments` default	string	—	-
`attributeToApp` default	boolean	—	-
`attributeToUser` default	boolean	—	-
`author` default	string	—	-
`createdAt` default	date	—	-
`criticalAlert` default	boolean	—	-
`hasAdditionalContent` default	boolean	—	-
`id` default	id	—	-
`message` default	string	—	-
`secondaryMessage` default	string	—	-
`subjectId` default	string	—	-
`subjectType` default	enum	—	-
`externalId` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ companyLocations	-
`locale` default	string	—	-
`enabled` default	boolean	—	-
`handle` default	string	—	-
`id` default	id	→ markets	-
`name` default	string	—	-
`primary` default	boolean	—	-
`status` default	enum	—	-
`type` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`description` default	string	—	-
`id` default	id	—	-
`key` default	string	—	-
`name` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`pinnedPosition` default	number	—	-
`useAsCollectionCondition` default	boolean	—	-
`validationStatus` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`name` default	string	—	-
`note` default	string	—	-
`orderCount` default	number	—	-
`billingAddressMatchesShippingAddress` default	boolean	—	-
`cancelledAt` default	date	—	-
`cancelReason` default	enum	—	-
`canMarkAsPaid` default	boolean	—	-
`canNotifyCustomer` default	boolean	—	-
`capturable` default	boolean	—	-
`cartDiscountAmount` default	string	—	-
`clientIp` default	string	—	-
`closed` default	boolean	—	-
`closedAt` default	date	—	-
`confirmationNumber` default	string	—	-
`confirmed` default	boolean	—	-
`createdAt` default	date	—	-
`currencyCode` default	enum	—	-
`currentSubtotalLineItemsQuantity` default	number	—	-
`currentTotalWeight` default	string	—	-
`customerAcceptsMarketing` default	boolean	—	-
`customerLocale` default	string	—	-
`discountCode` default	string	—	-
`discountCodes` default	string[]	—	-
`displayFinancialStatus` default	enum	—	-
`displayFulfillmentStatus` default	enum	—	-
`dutiesIncluded` default	boolean	—	-
`edited` default	boolean	—	-
`email` default	string	—	-
`estimatedTaxes` default	boolean	—	-
`fulfillable` default	boolean	—	-
`fullyPaid` default	boolean	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ orders	-
`landingPageDisplayText` default	string	—	-
`landingPageUrl` default	string	—	-
`merchantEditable` default	boolean	—	-
`merchantEditableErrors` default	string[]	—	-
`name` default	string	—	-
`netPayment` default	string	—	-
`note` default	string	—	-
`number` default	number	—	-
`paymentGatewayNames` default	string[]	—	-
`phone` default	string	—	-
`poNumber` default	string	—	-
`presentmentCurrencyCode` default	enum	—	-
`processedAt` default	date	—	-
`productNetwork` default	boolean	—	-
`referralCode` default	string	—	-
`referrerDisplayText` default	string	—	-
`referrerUrl` default	string	—	-
`refundable` default	boolean	—	-
`registeredSourceUrl` default	string	—	-
`requiresShipping` default	boolean	—	-
`restockable` default	boolean	—	-
`returnStatus` default	enum	—	-
`riskLevel` default	enum	—	-
`sourceIdentifier` default	string	—	-
`sourceName` default	string	—	-
`subtotalLineItemsQuantity` default	number	—	-
`subtotalPrice` default	string	—	-
`tags` default	string[]	—	-
`taxesIncluded` default	boolean	—	-
`taxExempt` default	boolean	—	-
`test` default	boolean	—	-
`totalCapturable` default	string	—	-
`totalDiscounts` default	string	—	-
`totalPrice` default	string	—	-
`totalReceived` default	string	—	-
`totalRefunded` default	string	—	-
`totalShippingPrice` default	string	—	-
`totalTax` default	string	—	-
`totalWeight` default	string	—	-
`unpaid` default	boolean	—	-
`updatedAt` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`phone` default	string	—	-
`createdAt` default	date	—	-
`id` default	id	—	-
`updatedAt` default	date	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`companyName` default	string	—	-
`country` default	string	—	-
`countryCode` default	enum	—	-
`createdAt` default	date	—	-
`firstName` default	string	—	-
`formattedArea` default	string	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`recipient` default	string	—	-
`updatedAt` default	date	—	-
`zip` default	string	—	-
`zoneCode` default	string	—	-
`id` default	id	—	-
`id` default	id	—	-
`taxExemptions` default	string	—	-
`taxRegistrationId` default	string	—	-
`taxExempt` default	boolean	—	-
`taxExemptions` default	string	—	-
`taxRegistrationId` default	string	—	-
`amount` default	number	—	-
`currencyCode` default	enum	—	-
`updatedAt` default	date	—	-

Catalog

Catalogs data in Shopify.

Read

List Catalogs

Fetch catalogs from Shopify.

Route: GET /catalogs

Excel formula: =LF.shopify.catalogs("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`type`	enum	No	The type of the catalogs to be returned. Values: NONE, APP, COMPANY_LOCATION, MARKET
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, RELEVANCE, TITLE, TYPE
`query.app_id`	id	No	-
`query.company_id`	id	No	-
`query.company_location_id`	id	No	-
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.managed_country_id`	id	No	-
`query.market_id`	id	No	-
`query.status`	string	No	-
`query.title`	string	No	-

Data returned in Excel

Field	Type	Relations	Description
`apiKey` default	string	—	-
`appStoreAppUrl` default	string	—	-
`appStoreDeveloperUrl` default	string	—	-
`description` default	string	—	-
`developerName` default	string	—	-
`developerType` default	enum	—	-
`developerUrl` default	string	—	-
`embedded` default	boolean	—	-
`features` default	string[]	—	-
`handle` default	string	—	-
`id` default	id	—	-
`installUrl` default	string	—	-
`isPostPurchaseAppInUse` default	boolean	—	-
`launchUrl` default	string	—	-
`previouslyInstalled` default	boolean	—	-
`pricingDetails` default	string	—	-
`pricingDetailsSummary` default	string	—	-
`privacyPolicyUrl` default	string	—	-
`publicCategory` default	enum	—	-
`published` default	boolean	—	-
`shopifyDeveloped` default	boolean	—	-
`title` default	string	—	-
`uninstallMessage` default	string	—	-
`uninstallUrl` default	string	—	-
`webhookApiVersion` default	string	—	-
`id` default	id	→ catalogs	-
`id` default	id	—	-
`processedRowCount` default	number	—	-
`status` default	enum	—	-
`currency` default	enum	—	-
`fixedPricesCount` default	number	—	-
`id` default	id	—	-
`name` default	string	—	-
`autoPublish` default	boolean	—	-
`id` default	id	—	-
`name` default	string	—	-
`supportsFuturePublishing` default	boolean	—	-
`status` default	enum	—	-
`title` default	string	—	-

Edit

Delete Catalog

Delete an existing catalog in Shopify.

Route: DELETE /catalogs/{id}

Inputs you can set

Name	Type	Required	Description
`deleteDependentResources`	boolean	No	-
`id`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Collection

Collections data in Shopify.

Used as filter by

List Product Variants · query.collection

List Products · query.collection_id

Read

List Collections

Fetch collections from Shopify.

Route: GET /collections

Excel formula: =LF.shopify.collections("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, RELEVANCE, TITLE, UPDATED_AT
`query.collection_type`	enum	No	Values: custom, smart
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.handle`	string	No	-
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.product_id`	id	No	Filter by collections containing a product by its ID.
`query.product_publication_status`	enum	No	Filter by channel approval process status of the resource on a channel, such as the online store. The value is a composite of the [channel ... Values: * {channel_app_id}-approved, * {channel_app_id}-rejected, * {channel_app_id}-needs_action, * {channel_app_id}-awaiting_review, * {channel_app_id}-published
`query.publishable_status`	enum	No	Deprecated: This parameter is deprecated as of 2025-12 and will be removed in a future API version. Use [published_status](https://shopi... Values: * {channel_app_id}-unset, * {channel_app_id}-pending, * {channel_app_id}-approved, * {channel_app_id}-not_approved
`query.published_at`	date	No	Filter by the date and time when the collection was published to the Online Store.
`query.published_status`	enum	No	Filter resources by their visibility and publication state on a channel. Online store channel filtering: - online_store_channel: Returns a... Values: online_store_channel, published, visible, unpublished, * {channel_id_or_handle}-published
`query.title`	string	No	-
`query.updated_at`	date	No	-
`savedSearchId`	string	No	The ID of a saved search. The search’s query string is used as...

Data returned in Excel

Field	Type	Relations	Description
`count` default	number	—	-
`precision` default	enum	—	-
`descriptionHtml` default	string	—	-
`action` default	string	—	-
`additionalContent` default	string	—	-
`additionalData` default	string	—	-
`appTitle` default	string	—	-
`arguments` default	string	—	-
`attributeToApp` default	boolean	—	-
`attributeToUser` default	boolean	—	-
`author` default	string	—	-
`createdAt` default	date	—	-
`criticalAlert` default	boolean	—	-
`hasAdditionalContent` default	boolean	—	-
`id` default	id	—	-
`message` default	string	—	-
`secondaryMessage` default	string	—	-
`subjectId` default	string	—	-
`subjectType` default	enum	—	-
`summary` default	string	—	-
`handle` default	string	—	-
`id` default	id	→ collections	-
`altText` default	string	—	-
`height` default	number	—	-
`id` default	id	—	-
`originalSrc` default	string	—	-
`src` default	string	—	-
`thumbhash` default	string	—	-
`width` default	number	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`description` default	string	—	-
`id` default	id	—	-
`key` default	string	—	-
`name` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`pinnedPosition` default	number	—	-
`useAsCollectionCondition` default	boolean	—	-
`validationStatus` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`bodyHtml` default	string	—	-
`combinedListingRole` default	enum	—	-
`createdAt` default	date	—	-
`customProductType` default	string	—	-
`descriptionHtml` default	string	—	-
`descriptionPlainSummary` default	string	—	-
`giftCardTemplateSuffix` default	string	—	-
`handle` default	string	—	-
`hasOnlyDefaultVariant` default	boolean	—	-
`hasOutOfStockVariants` default	boolean	—	-
`hasVariantsThatRequiresComponents` default	boolean	—	-
`id` default	id	→ products	-
`isGiftCard` default	boolean	—	-
`onlineStorePreviewUrl` default	string	—	-
`onlineStoreUrl` default	string	—	-
`productType` default	string	—	-
`publishedAt` default	date	—	-
`requiresSellingPlan` default	boolean	—	-
`sellingPlanGroupCount` default	number	—	-
`status` default	enum	—	-
`storefrontId` default	string	—	-
`tags` default	string[]	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`totalInventory` default	number	—	-
`totalVariants` default	number	—	-
`tracksInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`vendor` default	string	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`appliedDisjunctively` default	boolean	—	-
`description` default	string	—	-
`title` default	string	—	-
`sortOrder` default	enum	—	-
`storefrontId` default	string	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`key` default	string	—	-
`locale` default	string	—	-
`outdated` default	boolean	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`handle` default	string	—	-
`id` default	id	—	-
`name` default	string	—	-
`overviewPath` default	string	—	-
`supportsFuturePublishing` default	boolean	—	-
`autoPublish` default	boolean	—	-
`id` default	id	→ publications	-
`name` default	string	—	-
`supportsFuturePublishing` default	boolean	—	-
`updatedAt` default	date	—	-

Create

Create Collection

Create a new collection in Shopify.

Route: POST /collections

Inputs you can set

Name	Type	Required	Description
`input.descriptionHtml`	string	No	-
`input.handle`	string	No	-
`input.id`	string	No	-
`input.image.altText`	string	No	-
`input.image.id`	string	No	-
`input.image.src`	string	No	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-
`input.metafields.namespace`	string	No	-
`input.metafields.type`	string	No	-
`input.metafields.value`	string	No	-
`input.products`	string[]	No	-
`input.redirectNewHandle`	boolean	No	-
`input.ruleSet.appliedDisjunctively`	boolean	Yes	-
`input.ruleSet.rules.column`	enum	Yes	Values: TAG, TITLE, TYPE, PRODUCT_TAXONOMY_NODE_ID, PRODUCT_CATEGORY_ID
`input.ruleSet.rules.condition`	string	Yes	-
`input.ruleSet.rules.conditionObjectId`	string	No	-
`input.ruleSet.rules.relation`	enum	Yes	Values: CONTAINS, ENDS_WITH, EQUALS, GREATER_THAN, IS_NOT_SET
`input.seo.description`	string	No	-
`input.seo.title`	string	No	-
`input.sortOrder`	enum	No	Values: ALPHA_ASC, ALPHA_DESC, BEST_SELLING, CREATED, CREATED_DESC
`input.templateSuffix`	string	No	-
`input.title`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Collection

Update an existing collection in Shopify.

Route: PATCH /collections/{id}

Inputs you can set

Name	Type	Required	Description
`input.descriptionHtml`	string	No	-
`input.handle`	string	No	-
`input.id`	string	No	-
`input.image.altText`	string	No	-
`input.image.id`	string	No	-
`input.image.src`	string	No	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-
`input.metafields.namespace`	string	No	-
`input.metafields.type`	string	No	-
`input.metafields.value`	string	No	-
`input.products`	string[]	No	-
`input.redirectNewHandle`	boolean	No	-
`input.ruleSet.appliedDisjunctively`	boolean	Yes	-
`input.ruleSet.rules.column`	enum	Yes	Values: TAG, TITLE, TYPE, PRODUCT_TAXONOMY_NODE_ID, PRODUCT_CATEGORY_ID
`input.ruleSet.rules.condition`	string	Yes	-
`input.ruleSet.rules.conditionObjectId`	string	No	-
`input.ruleSet.rules.relation`	enum	Yes	Values: CONTAINS, ENDS_WITH, EQUALS, GREATER_THAN, IS_NOT_SET
`input.seo.description`	string	No	-
`input.seo.title`	string	No	-
`input.sortOrder`	enum	No	Values: ALPHA_ASC, ALPHA_DESC, BEST_SELLING, CREATED, CREATED_DESC
`input.templateSuffix`	string	No	-
`input.title`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Collection

Delete an existing collection in Shopify.

Route: DELETE /collections/{id}

Inputs you can set

Name	Type	Required	Description
`input.id`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Price List

Price Lists data in Shopify.

Read

List Price Lists

Fetch price lists from Shopify.

Route: GET /priceLists

Excel formula: =LF.shopify.priceLists("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, NAME

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`status` default	enum	—	-
`title` default	string	—	-
`currency` default	enum	—	-
`fixedPricesCount` default	number	—	-
`id` default	id	→ priceLists	-
`name` default	string	—	-
`originType` default	enum	—	-
`increment` default	number	—	-
`isDefault` default	boolean	—	-
`maximum` default	number	—	-
`minimum` default	number	—	-
`originType` default	enum	—	-

Create

Create Price List

Create a new price list in Shopify.

Route: POST /priceLists

Inputs you can set

Name	Type	Required	Description
`input.catalogId`	string	No	-
`input.currency`	enum	Yes	Values: USD, EUR, GBP, CAD, AFN
`input.name`	string	Yes	-
`input.parent.adjustment.type`	enum	Yes	Values: PERCENTAGE_DECREASE, PERCENTAGE_INCREASE
`input.parent.adjustment.value`	number	Yes	-
`input.parent.settings.compareAtMode`	enum	Yes	Values: ADJUSTED, NULLIFY

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Price List

Update an existing price list in Shopify.

Route: PATCH /priceLists/{id}

Inputs you can set

Name	Type	Required	Description
`id`	string	Yes	-
`input.catalogId`	string	No	-
`input.currency`	enum	No	Values: USD, EUR, GBP, CAD, AFN
`input.name`	string	No	-
`input.parent.adjustment.type`	enum	Yes	Values: PERCENTAGE_DECREASE, PERCENTAGE_INCREASE
`input.parent.adjustment.value`	number	Yes	-
`input.parent.settings.compareAtMode`	enum	Yes	Values: ADJUSTED, NULLIFY

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Price List

Delete an existing price list in Shopify.

Route: DELETE /priceLists/{id}

Inputs you can set

Name	Type	Required	Description
`id`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product

Products in Shopify catalog.

Used as filter by

List Collections · query.product_id

List Product Variants · query.product_id

List Product Variants · query.product_ids

Read

List Products

Fetch products from Shopify.

Route: GET /products

Excel formula: =LF.shopify.products("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, ID, INVENTORY_TOTAL, PRODUCT_TYPE, PUBLISHED_AT
`query.barcode`	string	No	Filter by the product variant barcode field. Example:...
`query.bundles`	boolean	No	Filter by a product bundle. A product bundle is a set of two or more re...
`query.category_id`	string	No	Filter by the product category ID (product.category.id). A...
`query.collection_id`	id	No	Filter by the collection id field. Example: - collection_id:1...
`query.combined_listing_role`	enum	No	Filter by the role of the product in a combined listing. Example:... Values: parent, child, no_role
`query.created_at`	date	No	Filter by the date and time when the product was created. Example: - created_at:>'2020-10-21T23:39:20Z' - created_at:<now - c...
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.delivery_profile_id`	id	No	Filter by the delivery profile id field. Example: - deli...
`query.error_feedback`	string	No	Filter by products with publishing errors.
`query.gift_card`	boolean	No	Filter by the product isGiftCard field. Example: - gift_...
`query.handle`	string	No	Filter by a comma-separated list of product [handles](https://shopify.dev/api/admin-graphql/latest/queries/products#argument-query-filter-ha...
`query.has_only_composites`	boolean	No	Filter by products that have only composite variants. Example: - has_only_composites:true
`query.has_only_default_variant`	boolean	No	Filter by products that have only a default variant. A default variant is the only variant if no other variants are specified. Example: - h...
`query.has_variant_with_components`	boolean	No	Filter by products that have variants with associated components. Example: - has_variant_with_components:true
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.inventory_total`	number	No	Filter by inventory count. Example: - inventory_total:0 - inventory_total:>150 - inventory_total:>=200
`query.is_price_reduced`	boolean	No	Filter by products that have a reduced price. For more information, refer to the [CollectionRule](https://shopify.dev/api/admin-graphql/la...
`query.metafields.{namespace}.{key}`	string	No	Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about [querying by metafield value](https:/...
`query.out_of_stock_somewhere`	boolean	No	Filter by products that are out of stock in at least one location. Example: - out_of_stock_somewhere:true
`query.price`	number	No	Filter by the product variant price field. Example: - ...
`query.product_configuration_owner`	string	No	Filter by the app id field. Example: - product_configuration_owner:1...
`query.product_publication_status`	enum	No	Filter by channel approval process status of the resource on a channel, such as the online store. The value is a composite of the [channel ... Values: * {channel_app_id}-approved, * {channel_app_id}-rejected, * {channel_app_id}-needs_action, * {channel_app_id}-awaiting_review, * {channel_app_id}-published
`query.product_type`	string	No	Filter by a comma-separated list of product types. Example: - product_type...
`query.publication_ids`	string	No	Filter by a comma-separated list of publication IDs that are associated with the product. Example: - publication_ids:184111530305,184111694...
`query.publishable_status`	enum	No	Deprecated: This parameter is deprecated as of 2025-12 and will be removed in a future API version. Use [published_status](https://shopi... Values: * {channel_app_id}-unset, * {channel_app_id}-pending, * {channel_app_id}-approved, * {channel_app_id}-not_approved
`query.published_at`	date	No	Filter by the date and time when the product was published to the online store and other sales channels. Example: - published_at:>2020-10-2...
`query.published_status`	enum	No	Filter resources by their visibility and publication state on a channel. Online store channel filtering: - online_store_channel: Returns a... Values: online_store_channel, published, visible, unpublished, * {channel_id_or_handle}-published
`query.sku`	string	No	Filter by the product variant sku field. [Learn more abou...
`query.status`	enum	No	Filter by a comma-separated list of statuses. You can use statuses to manage inventory. Shopify only displays products with an ACTIVE stat... Default: active Values: active, archived, draft
`query.tag`	string	No	Filter objects by the tag field. Example: - tag:my_tag
`query.tag_not`	string	No	Filter by objects that don’t have the specified tag. Example: - tag_not:my_tag
`query.title`	string	No	Filter by the product title field. Example: - title:The Minim...
`query.updated_at`	date	No	Filter by the date and time when the product was last updated. Example: - updated_at:>'2020-10-21T23:39:20Z' - updated_at:<now ...
`query.variant_id`	id	No	Filter by the product variant id field. Example: - varian...
`query.variant_title`	string	No	Filter by the product variant title field. Example: - ...
`query.vendor`	string	No	Filter by the origin or source of the product. Learn more about [vendors and managing vendor information](https://help.shopify.com/manual/pr...
`savedSearchId`	string	No	The ID of a saved search. The search’s query string is used as...

Data returned in Excel

Field	Type	Relations	Description
`count` default	number	—	-
`precision` default	enum	—	-
`bodyHtml` default	string	—	-
`quantity` default	number	—	-
`name` default	string	—	-
`ancestorIds` default	string[]	—	-
`childrenIds` default	string[]	—	-
`fullName` default	string	—	-
`id` default	id	—	-
`isArchived` default	boolean	—	-
`isLeaf` default	boolean	—	-
`isRoot` default	boolean	—	-
`level` default	number	—	-
`name` default	string	—	-
`parentId` default	string	—	-
`descriptionHtml` default	string	—	-
`handle` default	string	—	-
`id` default	id	→ collections	-
`sortOrder` default	enum	—	-
`storefrontId` default	string	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`updatedAt` default	date	—	-
`combinedListingRole` default	enum	—	-
`fixedQuantityRulesCount` default	number	—	-
`createdAt` default	date	—	-
`customProductType` default	string	—	-
`descriptionHtml` default	string	—	-
`descriptionPlainSummary` default	string	—	-
`action` default	string	—	-
`additionalContent` default	string	—	-
`additionalData` default	string	—	-
`appTitle` default	string	—	-
`arguments` default	string	—	-
`attributeToApp` default	boolean	—	-
`attributeToUser` default	boolean	—	-
`author` default	string	—	-
`createdAt` default	date	—	-
`criticalAlert` default	boolean	—	-
`hasAdditionalContent` default	boolean	—	-
`id` default	id	—	-
`message` default	string	—	-
`secondaryMessage` default	string	—	-
`subjectId` default	string	—	-
`subjectType` default	enum	—	-
`altText` default	string	—	-
`height` default	number	—	-
`id` default	id	—	-
`originalSrc` default	string	—	-
`src` default	string	—	-
`thumbhash` default	string	—	-
`width` default	number	—	-
`alt` default	string	—	-
`createdAt` default	date	—	-
`embeddedUrl` default	string	—	-
`embedUrl` default	string	—	-
`fileStatus` default	enum	—	-
`host` default	enum	—	-
`id` default	id	—	-
`mediaContentType` default	enum	—	-
`originUrl` default	string	—	-
`status` default	enum	—	-
`updatedAt` default	date	—	-
`summary` default	string	—	-
`giftCardTemplateSuffix` default	string	—	-
`handle` default	string	—	-
`hasOnlyDefaultVariant` default	boolean	—	-
`hasOutOfStockVariants` default	boolean	—	-
`hasVariantsThatRequiresComponents` default	boolean	—	-
`id` default	id	→ products	-
`altText` default	string	—	-
`height` default	number	—	-
`id` default	id	—	-
`originalSrc` default	string	—	-
`src` default	string	—	-
`thumbhash` default	string	—	-
`width` default	number	—	-
`isGiftCard` default	boolean	—	-
`alt` default	string	—	-
`createdAt` default	date	—	-
`embeddedUrl` default	string	—	-
`embedUrl` default	string	—	-
`fileStatus` default	enum	—	-
`host` default	enum	—	-
`id` default	id	—	-
`mediaContentType` default	enum	—	-
`originUrl` default	string	—	-
`status` default	enum	—	-
`updatedAt` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`description` default	string	—	-
`id` default	id	—	-
`key` default	string	—	-
`name` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`pinnedPosition` default	number	—	-
`useAsCollectionCondition` default	boolean	—	-
`validationStatus` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`onlineStorePreviewUrl` default	string	—	-
`onlineStoreUrl` default	string	—	-
`id` default	id	→ productOptions	-
`name` default	string	—	-
`position` default	number	—	-
`values` default	string[]	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`bodyHtml` default	string	—	-
`combinedListingRole` default	enum	—	-
`createdAt` default	date	—	-
`customProductType` default	string	—	-
`descriptionHtml` default	string	—	-
`descriptionPlainSummary` default	string	—	-
`giftCardTemplateSuffix` default	string	—	-
`handle` default	string	—	-
`hasOnlyDefaultVariant` default	boolean	—	-
`hasOutOfStockVariants` default	boolean	—	-
`hasVariantsThatRequiresComponents` default	boolean	—	-
`id` default	id	→ products	-
`isGiftCard` default	boolean	—	-
`onlineStorePreviewUrl` default	string	—	-
`onlineStoreUrl` default	string	—	-
`productType` default	string	—	-
`publishedAt` default	date	—	-
`requiresSellingPlan` default	boolean	—	-
`sellingPlanGroupCount` default	number	—	-
`status` default	enum	—	-
`storefrontId` default	string	—	-
`tags` default	string[]	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`totalInventory` default	number	—	-
`totalVariants` default	number	—	-
`tracksInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`vendor` default	string	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`productType` default	string	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`publishedAt` default	date	—	-
`requiresSellingPlan` default	boolean	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`restricted` default	boolean	—	-
`restrictedReason` default	string	—	-
`sellingPlanGroupCount` default	number	—	-
`appId` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	→ sellingPlanGroups	-
`merchantCode` default	string	—	-
`name` default	string	—	-
`options` default	string[]	—	-
`position` default	number	—	-
`summary` default	string	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`description` default	string	—	-
`title` default	string	—	-
`status` default	enum	—	-
`storefrontId` default	string	—	-
`tags` default	string[]	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`totalInventory` default	number	—	-
`totalVariants` default	number	—	-
`tracksInventory` default	boolean	—	-
`key` default	string	—	-
`locale` default	string	—	-
`outdated` default	boolean	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`handle` default	string	—	-
`id` default	id	—	-
`name` default	string	—	-
`overviewPath` default	string	—	-
`supportsFuturePublishing` default	boolean	—	-
`autoPublish` default	boolean	—	-
`id` default	id	→ publications	-
`name` default	string	—	-
`supportsFuturePublishing` default	boolean	—	-
`updatedAt` default	date	—	-
`availableForSale` default	boolean	—	-
`barcode` default	string	—	-
`compareAtPrice` default	string	—	-
`createdAt` default	date	—	-
`displayName` default	string	—	-
`id` default	id	→ productVariants	-
`inventoryPolicy` default	enum	—	-
`inventoryQuantity` default	number	—	-
`position` default	number	—	-
`price` default	string	—	-
`requiresComponents` default	boolean	—	-
`sellableOnlineQuantity` default	number	—	-
`sellingPlanGroupCount` default	number	—	-
`showUnitPrice` default	boolean	—	-
`sku` default	string	—	-
`storefrontId` default	string	—	-
`taxable` default	boolean	—	-
`taxCode` default	string	—	-
`title` default	string	—	-
`updatedAt` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`vendor` default	string	—	-

Create

Create Product

Create a new product in Shopify.

Route: POST /products

Inputs you can set

Name	Type	Required	Description
`media.alt`	string	No	-
`media.mediaContentType`	enum	Yes	Values: VIDEO, EXTERNAL_VIDEO, MODEL_3D, IMAGE
`media.originalSource`	string	Yes	-
`product.category`	string	No	-
`product.claimOwnership.bundles`	boolean	No	-
`product.collectionsToJoin`	string[]	No	-
`product.combinedListingRole`	enum	No	Values: PARENT, CHILD
`product.descriptionHtml`	string	No	-
`product.giftCard`	boolean	No	-
`product.giftCardTemplateSuffix`	string	No	-
`product.handle`	string	No	-
`product.metafields.id`	string	No	-
`product.metafields.key`	string	No	-
`product.metafields.namespace`	string	No	-
`product.metafields.type`	string	No	-
`product.metafields.value`	string	No	-
`product.productOptions.linkedMetafield.key`	string	Yes	-
`product.productOptions.linkedMetafield.namespace`	string	Yes	-
`product.productOptions.linkedMetafield.values`	string[]	No	-
`product.productOptions.name`	string	No	-
`product.productOptions.position`	number	No	-
`product.productOptions.values.linkedMetafieldValue`	string	No	-
`product.productOptions.values.name`	string	No	-
`product.productType`	string	No	-
`product.requiresSellingPlan`	boolean	No	-
`product.seo.description`	string	No	-
`product.seo.title`	string	No	-
`product.status`	enum	No	Values: ACTIVE, ARCHIVED, DRAFT, UNLISTED
`product.tags`	string[]	No	-
`product.templateSuffix`	string	No	-
`product.title`	string	No	-
`product.vendor`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Product

Update an existing product in Shopify.

Route: PATCH /products/{id}

Inputs you can set

Name	Type	Required	Description
`media.alt`	string	No	-
`media.mediaContentType`	enum	Yes	Values: VIDEO, EXTERNAL_VIDEO, MODEL_3D, IMAGE
`media.originalSource`	string	Yes	-
`product.category`	string	No	-
`product.collectionsToJoin`	string[]	No	-
`product.collectionsToLeave`	string[]	No	-
`product.deleteConflictingConstrainedMetafields`	boolean	No	-
`product.descriptionHtml`	string	No	-
`product.giftCardTemplateSuffix`	string	No	-
`product.handle`	string	No	-
`product.id`	string	No	-
`product.metafields.id`	string	No	-
`product.metafields.key`	string	No	-
`product.metafields.namespace`	string	No	-
`product.metafields.type`	string	No	-
`product.metafields.value`	string	No	-
`product.productType`	string	No	-
`product.redirectNewHandle`	boolean	No	-
`product.requiresSellingPlan`	boolean	No	-
`product.seo.description`	string	No	-
`product.seo.title`	string	No	-
`product.status`	enum	No	Values: ACTIVE, ARCHIVED, DRAFT, UNLISTED
`product.tags`	string[]	No	-
`product.templateSuffix`	string	No	-
`product.title`	string	No	-
`product.vendor`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Product

Delete an existing product in Shopify.

Route: DELETE /products/{id}

Inputs you can set

Name	Type	Required	Description
`input.id`	string	Yes	-
`synchronous`	boolean	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product Option

Product Options data in Shopify.

Create

Create Product Option

Create a new product option in Shopify.

Route: POST /productOptions

Inputs you can set

Name	Type	Required	Description
`options.linkedMetafield.key`	string	Yes	-
`options.linkedMetafield.namespace`	string	Yes	-
`options.linkedMetafield.values`	string[]	No	-
`options.name`	string	No	-
`options.position`	number	No	-
`options.values.linkedMetafieldValue`	string	No	-
`options.values.name`	string	No	-
`productId`	string	Yes	-
`variantStrategy`	enum	No	Values: LEAVE_AS_IS, CREATE

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product Set

Products managed through Shopify productSet mutation.

Create

Create Product Set

Create a new product set in Shopify.

Route: POST /productSets

Inputs you can set

Name	Type	Required	Description
`identifier.customId.key`	string	Yes	-
`identifier.customId.namespace`	string	No	-
`identifier.customId.value`	string	Yes	-
`identifier.handle`	string	No	-
`identifier.id`	string	No	-
`input.category`	string	No	-
`input.claimOwnership.bundles`	boolean	No	-
`input.collections`	string[]	No	-
`input.combinedListingRole`	enum	No	Values: PARENT, CHILD
`input.descriptionHtml`	string	No	-
`input.files.alt`	string	No	-
`input.files.contentType`	enum	No	Values: IMAGE, FILE, VIDEO, EXTERNAL_VIDEO, MODEL_3D
`input.files.duplicateResolutionMode`	enum	No	Values: APPEND_UUID, RAISE_ERROR, REPLACE
`input.files.filename`	string	No	-
`input.files.id`	string	No	-
`input.files.originalSource`	string	No	-
`input.giftCard`	boolean	No	-
`input.giftCardTemplateSuffix`	string	No	-
`input.handle`	string	No	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-
`input.metafields.namespace`	string	No	-
`input.metafields.type`	string	No	-
`input.metafields.value`	string	No	-
`input.productOptions.id`	string	No	-
`input.productOptions.linkedMetafield.key`	string	Yes	-
`input.productOptions.linkedMetafield.namespace`	string	Yes	-
`input.productOptions.linkedMetafield.values`	string[]	No	-
`input.productOptions.name`	string	No	-
`input.productOptions.position`	number	No	-
`input.productOptions.values.id`	string	No	-
`input.productOptions.values.name`	string	No	-
`input.productType`	string	No	-
`input.redirectNewHandle`	boolean	No	-
`input.requiresSellingPlan`	boolean	No	-
`input.seo.description`	string	No	-
`input.seo.title`	string	No	-
`input.status`	enum	No	Values: ACTIVE, ARCHIVED, DRAFT, UNLISTED
`input.tags`	string[]	No	-
`input.templateSuffix`	string	No	-
`input.title`	string	No	-
`input.variants.barcode`	string	No	-
`input.variants.compareAtPrice`	string	No	-
`input.variants.file.alt`	string	No	-
`input.variants.file.contentType`	enum	No	Values: IMAGE, FILE, VIDEO, EXTERNAL_VIDEO, MODEL_3D
`input.variants.file.duplicateResolutionMode`	enum	No	Values: APPEND_UUID, RAISE_ERROR, REPLACE
`input.variants.file.filename`	string	No	-
`input.variants.file.id`	string	No	-
`input.variants.file.originalSource`	string	No	-
`input.variants.id`	string	No	-
`input.variants.inventoryItem.cost`	number	No	-
`input.variants.inventoryItem.countryCodeOfOrigin`	enum	No	Values: AF, AX, AL, DZ, AD
`input.variants.inventoryItem.countryHarmonizedSystemCodes.countryCode`	enum	No	Values: AF, AX, AL, DZ, AD
`input.variants.inventoryItem.countryHarmonizedSystemCodes.harmonizedSystemCode`	string	Yes	-
`input.variants.inventoryItem.harmonizedSystemCode`	string	No	-
`input.variants.inventoryItem.measurement.shippingPackageId`	string	No	-
`input.variants.inventoryItem.measurement.weight.unit`	enum	Yes	Values: KILOGRAMS, GRAMS, POUNDS, OUNCES
`input.variants.inventoryItem.measurement.weight.value`	number	Yes	-
`input.variants.inventoryItem.provinceCodeOfOrigin`	string	No	-
`input.variants.inventoryItem.requiresShipping`	boolean	No	-
`input.variants.inventoryItem.sku`	string	No	-
`input.variants.inventoryItem.tracked`	boolean	No	-
`input.variants.inventoryPolicy`	enum	No	Values: DENY, CONTINUE
`input.variants.inventoryQuantities.locationId`	string	Yes	-
`input.variants.inventoryQuantities.name`	string	Yes	-
`input.variants.inventoryQuantities.quantity`	number	Yes	-
`input.variants.metafields.id`	string	No	-
`input.variants.metafields.key`	string	No	-
`input.variants.metafields.namespace`	string	No	-
`input.variants.metafields.type`	string	No	-
`input.variants.metafields.value`	string	No	-
`input.variants.optionValues.id`	string	No	-
`input.variants.optionValues.linkedMetafieldValue`	string	No	-
`input.variants.optionValues.name`	string	No	-
`input.variants.optionValues.optionId`	string	No	-
`input.variants.optionValues.optionName`	string	No	-
`input.variants.position`	number	No	-
`input.variants.price`	string	No	-
`input.variants.requiresComponents`	boolean	No	-
`input.variants.showUnitPrice`	boolean	No	-
`input.variants.sku`	string	No	-
`input.variants.taxable`	boolean	No	-
`input.variants.taxCode`	string	No	-
`input.variants.unitPriceMeasurement.quantityUnit`	enum	No	Values: ML, CL, L, M3, FLOZ
`input.variants.unitPriceMeasurement.quantityValue`	number	No	-
`input.variants.unitPriceMeasurement.referenceUnit`	enum	No	Values: ML, CL, L, M3, FLOZ
`input.variants.unitPriceMeasurement.referenceValue`	number	No	-
`input.vendor`	string	No	-
`synchronous`	boolean	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product Variant

Product Variants data in Shopify.

Used as filter by

List Products · query.variant_id

Read

List Product Variants

Fetch product variants from Shopify.

Route: GET /productVariants

Excel formula: =LF.shopify.productVariants("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: FULL_TITLE, ID, INVENTORY_LEVELS_AVAILABLE, INVENTORY_MANAGEMENT, INVENTORY_POLICY
`query.barcode`	string	No	Filter by the product variant barcode field. Example:...
`query.collection`	string	No	Filter by the ID of the collection that the product variant belo...
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.delivery_profile_id`	id	No	Filter by the product variant [delivery profile ID](https://shopify.dev/api/admin-graphql/latest/objects/ProductVariant#field-deliveryprofil...
`query.exclude_composite`	boolean	No	Filter by product variants that aren't composites. Example: - exclude_composite:true
`query.exclude_variants_with_components`	boolean	No	Filter by whether there are components that ar...
`query.gift_card`	boolean	No	Filter by the product isGiftCard field. Example: - gift_...
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.inventory_quantity`	number	No	Filter by an aggregate of inventory across all locations where the product variant is stocked. Example: - inventory_quantity:10
`query.location_id`	id	No	Filter by the location ID for the product variant. Example: - loc...
`query.managed`	boolean	No	Filter by whether there is fulfillment service tracking associated with the product variants. Example: - managed:true
`query.managed_by`	string	No	Filter by the fulfillment service that tracks the number of items in stock for the product variant. Example: - managed_by:shopify
`query.option1`	string	No	Filter by a custom property that a shop owner uses to define product variants. Example: - option1:small
`query.option2`	string	No	Filter by a custom property that a shop owner uses to define product variants. Example: - option2:medium
`query.option3`	string	No	Filter by a custom property that a shop owner uses to define product variants. Example: - option3:large
`query.product_id`	id	No	Filter by the product id field. Example: - product_id:8474977763...
`query.product_ids`	string	No	Filter by a comma-separated list of product IDs. Example: - produc...
`query.product_publication_status`	enum	No	Filter by channel approval process status of the resource on a channel, such as the online store. The value is a composite of the [channel ... Values: * {channel_app_id}-approved, * {channel_app_id}-rejected, * {channel_app_id}-needs_action, * {channel_app_id}-awaiting_review, * {channel_app_id}-published
`query.product_status`	string	No	Filter by a comma-separated list of product statuses. Example:...
`query.product_type`	string	No	Filter by the product type that's associated with the product variants. Example: - product_type:snowboard
`query.publishable_status`	enum	No	Deprecated: This parameter is deprecated as of 2025-12 and will be removed in a future API version. Use [published_status](https://shopi... Values: * {channel_app_id}-unset, * {channel_app_id}-pending, * {channel_app_id}-approved, * {channel_app_id}-not_approved
`query.published_status`	enum	No	Filter resources by their visibility and publication state on a channel. Online store channel filtering: - online_store_channel: Returns a... Values: online_store_channel, published, visible, unpublished, * {channel_id_or_handle}-published
`query.requires_components`	boolean	No	Filter by whether the product variant can only be purchased with components. [Learn more](https://shopify.dev/apps/build/product-merchandisi...
`query.sku`	string	No	Filter by the product variant sku field. [Learn more abou...
`query.tag`	string	No	Filter objects by the tag field. Example: - tag:my_tag
`query.tag_not`	string	No	Filter by objects that don’t have the specified tag. Example: - tag_not:my_tag
`query.taxable`	boolean	No	Filter by the product variant taxable field. Example:...
`query.title`	string	No	Filter by the product variant title field. Example: - ...
`query.updated_at`	date	No	Filter by date and time when the product variant was updated. Example: - updated_at:>2020-10-21T23:39:20Z - updated_at:<now -...
`query.vendor`	string	No	Filter by the origin or source of the product variant. Learn more about [vendors and managing vendor information](https://help.shopify.com/m...
`savedSearchId`	string	No	The ID of a saved search. The search’s query string is used as...

Data returned in Excel

Field	Type	Relations	Description
`availableForSale` default	boolean	—	-
`barcode` default	string	—	-
`compareAtPrice` default	string	—	-
`createdAt` default	date	—	-
`activeMethodDefinitionsCount` default	number	—	-
`default` default	boolean	—	-
`id` default	id	—	-
`legacyMode` default	boolean	—	-
`locationsWithoutRatesCount` default	number	—	-
`name` default	string	—	-
`originLocationCount` default	number	—	-
`version` default	number	—	-
`zoneCountryCount` default	number	—	-
`displayName` default	string	—	-
`action` default	string	—	-
`additionalContent` default	string	—	-
`additionalData` default	string	—	-
`appTitle` default	string	—	-
`arguments` default	string	—	-
`attributeToApp` default	boolean	—	-
`attributeToUser` default	boolean	—	-
`author` default	string	—	-
`createdAt` default	date	—	-
`criticalAlert` default	boolean	—	-
`hasAdditionalContent` default	boolean	—	-
`id` default	id	—	-
`message` default	string	—	-
`secondaryMessage` default	string	—	-
`subjectId` default	string	—	-
`subjectType` default	enum	—	-
`id` default	id	→ productVariants	-
`altText` default	string	—	-
`height` default	number	—	-
`id` default	id	—	-
`originalSrc` default	string	—	-
`src` default	string	—	-
`thumbhash` default	string	—	-
`width` default	number	—	-
`countryCodeOfOrigin` default	enum	—	-
`createdAt` default	date	—	-
`duplicateSkuCount` default	number	—	-
`harmonizedSystemCode` default	string	—	-
`id` default	id	→ inventoryItems	-
`inventoryHistoryUrl` default	string	—	-
`provinceCodeOfOrigin` default	string	—	-
`requiresShipping` default	boolean	—	-
`sku` default	string	—	-
`tracked` default	boolean	—	-
`updatedAt` default	date	—	-
`inventoryPolicy` default	enum	—	-
`inventoryQuantity` default	number	—	-
`alt` default	string	—	-
`createdAt` default	date	—	-
`embeddedUrl` default	string	—	-
`embedUrl` default	string	—	-
`fileStatus` default	enum	—	-
`host` default	enum	—	-
`id` default	id	—	-
`mediaContentType` default	enum	—	-
`originUrl` default	string	—	-
`status` default	enum	—	-
`updatedAt` default	date	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`description` default	string	—	-
`id` default	id	—	-
`key` default	string	—	-
`name` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`pinnedPosition` default	number	—	-
`useAsCollectionCondition` default	boolean	—	-
`validationStatus` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`position` default	number	—	-
`price` default	string	—	-
`bodyHtml` default	string	—	-
`combinedListingRole` default	enum	—	-
`createdAt` default	date	—	-
`customProductType` default	string	—	-
`descriptionHtml` default	string	—	-
`descriptionPlainSummary` default	string	—	-
`giftCardTemplateSuffix` default	string	—	-
`handle` default	string	—	-
`hasOnlyDefaultVariant` default	boolean	—	-
`hasOutOfStockVariants` default	boolean	—	-
`hasVariantsThatRequiresComponents` default	boolean	—	-
`id` default	id	→ products	-
`isGiftCard` default	boolean	—	-
`onlineStorePreviewUrl` default	string	—	-
`onlineStoreUrl` default	string	—	-
`productType` default	string	—	-
`publishedAt` default	date	—	-
`requiresSellingPlan` default	boolean	—	-
`sellingPlanGroupCount` default	number	—	-
`status` default	enum	—	-
`storefrontId` default	string	—	-
`tags` default	string[]	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`totalInventory` default	number	—	-
`totalVariants` default	number	—	-
`tracksInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`vendor` default	string	—	-
`bodyHtml` default	string	—	-
`combinedListingRole` default	enum	—	-
`createdAt` default	date	—	-
`customProductType` default	string	—	-
`descriptionHtml` default	string	—	-
`descriptionPlainSummary` default	string	—	-
`giftCardTemplateSuffix` default	string	—	-
`handle` default	string	—	-
`hasOnlyDefaultVariant` default	boolean	—	-
`hasOutOfStockVariants` default	boolean	—	-
`hasVariantsThatRequiresComponents` default	boolean	—	-
`id` default	id	→ products	-
`isGiftCard` default	boolean	—	-
`onlineStorePreviewUrl` default	string	—	-
`onlineStoreUrl` default	string	—	-
`productType` default	string	—	-
`publishedAt` default	date	—	-
`requiresSellingPlan` default	boolean	—	-
`sellingPlanGroupCount` default	number	—	-
`status` default	enum	—	-
`storefrontId` default	string	—	-
`tags` default	string[]	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`totalInventory` default	number	—	-
`totalVariants` default	number	—	-
`tracksInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`vendor` default	string	—	-
`id` default	id	—	-
`quantity` default	number	—	-
`requiresComponents` default	boolean	—	-
`name` default	string	—	-
`value` default	string	—	-
`sellableOnlineQuantity` default	number	—	-
`sellingPlanGroupCount` default	number	—	-
`appId` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	→ sellingPlanGroups	-
`merchantCode` default	string	—	-
`name` default	string	—	-
`options` default	string[]	—	-
`position` default	number	—	-
`summary` default	string	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`showUnitPrice` default	boolean	—	-
`sku` default	string	—	-
`storefrontId` default	string	—	-
`taxable` default	boolean	—	-
`taxCode` default	string	—	-
`title` default	string	—	-
`key` default	string	—	-
`locale` default	string	—	-
`outdated` default	boolean	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`amount` default	number	—	-
`currencyCode` default	enum	—	-
`measuredType` default	enum	—	-
`quantityUnit` default	enum	—	-
`quantityValue` default	number	—	-
`referenceUnit` default	enum	—	-
`referenceValue` default	number	—	-
`updatedAt` default	date	—	-

Create

Create Product Variant

Create a new product variant in Shopify.

Route: POST /productVariants

Inputs you can set

Name	Type	Required	Description
`media.alt`	string	No	-
`media.mediaContentType`	enum	Yes	Values: VIDEO, EXTERNAL_VIDEO, MODEL_3D, IMAGE
`media.originalSource`	string	Yes	-
`productId`	string	Yes	-
`strategy`	enum	No	Values: DEFAULT, REMOVE_STANDALONE_VARIANT, PRESERVE_STANDALONE_VARIANT
`variants.barcode`	string	No	-
`variants.compareAtPrice`	string	No	-
`variants.id`	string	No	-
`variants.inventoryItem.cost`	number	No	-
`variants.inventoryItem.countryCodeOfOrigin`	enum	No	Values: AF, AX, AL, DZ, AD
`variants.inventoryItem.countryHarmonizedSystemCodes.countryCode`	enum	No	Values: AF, AX, AL, DZ, AD
`variants.inventoryItem.countryHarmonizedSystemCodes.harmonizedSystemCode`	string	Yes	-
`variants.inventoryItem.harmonizedSystemCode`	string	No	-
`variants.inventoryItem.measurement.shippingPackageId`	string	No	-
`variants.inventoryItem.measurement.weight.unit`	enum	Yes	Values: KILOGRAMS, GRAMS, POUNDS, OUNCES
`variants.inventoryItem.measurement.weight.value`	number	Yes	-
`variants.inventoryItem.provinceCodeOfOrigin`	string	No	-
`variants.inventoryItem.requiresShipping`	boolean	No	-
`variants.inventoryItem.sku`	string	No	-
`variants.inventoryItem.tracked`	boolean	No	-
`variants.inventoryPolicy`	enum	No	Values: DENY, CONTINUE
`variants.inventoryQuantities.availableQuantity`	number	Yes	-
`variants.inventoryQuantities.locationId`	string	Yes	-
`variants.mediaId`	string	No	-
`variants.mediaSrc`	string[]	No	-
`variants.metafields.id`	string	No	-
`variants.metafields.key`	string	No	-
`variants.metafields.namespace`	string	No	-
`variants.metafields.type`	string	No	-
`variants.metafields.value`	string	No	-
`variants.optionValues.id`	string	No	-
`variants.optionValues.linkedMetafieldValue`	string	No	-
`variants.optionValues.name`	string	No	-
`variants.optionValues.optionId`	string	No	-
`variants.optionValues.optionName`	string	No	-
`variants.price`	string	No	-
`variants.quantityAdjustments.adjustment`	number	No	-
`variants.quantityAdjustments.changeFromQuantity`	number	No	-
`variants.quantityAdjustments.locationId`	string	Yes	-
`variants.requiresComponents`	boolean	No	-
`variants.showUnitPrice`	boolean	No	-
`variants.taxable`	boolean	No	-
`variants.taxCode`	string	No	-
`variants.unitPriceMeasurement.quantityUnit`	enum	No	Values: ML, CL, L, M3, FLOZ
`variants.unitPriceMeasurement.quantityValue`	number	No	-
`variants.unitPriceMeasurement.referenceUnit`	enum	No	Values: ML, CL, L, M3, FLOZ
`variants.unitPriceMeasurement.referenceValue`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Publication

Publications data in Shopify.

Used as filter by

List Products · query.publication_ids

Read

List Publications

Fetch publications from Shopify.

Route: GET /publications

Excel formula: =LF.shopify.publications("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`catalogType`	enum	No	Filter publications by catalog type. Values: NONE, APP, COMPANY_LOCATION, MARKET
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false

Data returned in Excel

Field	Type	Relations	Description
`apiKey` default	string	—	-
`appStoreAppUrl` default	string	—	-
`appStoreDeveloperUrl` default	string	—	-
`description` default	string	—	-
`developerName` default	string	—	-
`developerType` default	enum	—	-
`developerUrl` default	string	—	-
`embedded` default	boolean	—	-
`features` default	string[]	—	-
`handle` default	string	—	-
`id` default	id	—	-
`installUrl` default	string	—	-
`isPostPurchaseAppInUse` default	boolean	—	-
`launchUrl` default	string	—	-
`previouslyInstalled` default	boolean	—	-
`pricingDetails` default	string	—	-
`pricingDetailsSummary` default	string	—	-
`privacyPolicyUrl` default	string	—	-
`publicCategory` default	enum	—	-
`published` default	boolean	—	-
`shopifyDeveloped` default	boolean	—	-
`title` default	string	—	-
`uninstallMessage` default	string	—	-
`uninstallUrl` default	string	—	-
`webhookApiVersion` default	string	—	-
`autoPublish` default	boolean	—	-
`id` default	id	—	-
`status` default	enum	—	-
`title` default	string	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`descriptionHtml` default	string	—	-
`handle` default	string	—	-
`id` default	id	→ collections	-
`sortOrder` default	enum	—	-
`storefrontId` default	string	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`updatedAt` default	date	—	-
`id` default	id	→ publications	-
`bodyHtml` default	string	—	-
`combinedListingRole` default	enum	—	-
`createdAt` default	date	—	-
`customProductType` default	string	—	-
`descriptionHtml` default	string	—	-
`descriptionPlainSummary` default	string	—	-
`giftCardTemplateSuffix` default	string	—	-
`handle` default	string	—	-
`hasOnlyDefaultVariant` default	boolean	—	-
`hasOutOfStockVariants` default	boolean	—	-
`hasVariantsThatRequiresComponents` default	boolean	—	-
`id` default	id	→ products	-
`isGiftCard` default	boolean	—	-
`onlineStorePreviewUrl` default	string	—	-
`onlineStoreUrl` default	string	—	-
`productType` default	string	—	-
`publishedAt` default	date	—	-
`requiresSellingPlan` default	boolean	—	-
`sellingPlanGroupCount` default	number	—	-
`status` default	enum	—	-
`storefrontId` default	string	—	-
`tags` default	string[]	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`totalInventory` default	number	—	-
`totalVariants` default	number	—	-
`tracksInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`vendor` default	string	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`name` default	string	—	-
`id` default	id	—	-
`processedRowCount` default	number	—	-
`status` default	enum	—	-
`isPublished` default	boolean	—	-
`publishDate` default	date	—	-
`bodyHtml` default	string	—	-
`combinedListingRole` default	enum	—	-
`createdAt` default	date	—	-
`customProductType` default	string	—	-
`descriptionHtml` default	string	—	-
`descriptionPlainSummary` default	string	—	-
`giftCardTemplateSuffix` default	string	—	-
`handle` default	string	—	-
`hasOnlyDefaultVariant` default	boolean	—	-
`hasOutOfStockVariants` default	boolean	—	-
`hasVariantsThatRequiresComponents` default	boolean	—	-
`id` default	id	→ products	-
`isGiftCard` default	boolean	—	-
`onlineStorePreviewUrl` default	string	—	-
`onlineStoreUrl` default	string	—	-
`productType` default	string	—	-
`publishedAt` default	date	—	-
`requiresSellingPlan` default	boolean	—	-
`sellingPlanGroupCount` default	number	—	-
`status` default	enum	—	-
`storefrontId` default	string	—	-
`tags` default	string[]	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`totalInventory` default	number	—	-
`totalVariants` default	number	—	-
`tracksInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`vendor` default	string	—	-
`supportsFuturePublishing` default	boolean	—	-

Selling Plan Group

Selling Plan Groups data in Shopify.

Read

List Selling Plan Groups

Fetch selling plan groups from Shopify.

Route: GET /sellingPlanGroups

Excel formula: =LF.shopify.sellingPlanGroups("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, ID, NAME, UPDATED_AT
`query.app_id`	enum	No	Default: CURRENT Values: CURRENT, ALL, * (numeric app ID)
`query.category`	enum	No	A comma-separated list of categories. Values: SUBSCRIPTION, PRE_ORDER, TRY_BEFORE_YOU_BUY, OTHER
`query.created_at`	date	No	-
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.delivery_frequency`	string	No	-
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.name`	string	No	-
`query.percentage_off`	number	No	-

Data returned in Excel

Field	Type	Relations	Description
`appId` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	→ sellingPlanGroups	-
`merchantCode` default	string	—	-
`name` default	string	—	-
`options` default	string[]	—	-
`position` default	number	—	-
`bodyHtml` default	string	—	-
`combinedListingRole` default	enum	—	-
`createdAt` default	date	—	-
`customProductType` default	string	—	-
`descriptionHtml` default	string	—	-
`descriptionPlainSummary` default	string	—	-
`giftCardTemplateSuffix` default	string	—	-
`handle` default	string	—	-
`hasOnlyDefaultVariant` default	boolean	—	-
`hasOutOfStockVariants` default	boolean	—	-
`hasVariantsThatRequiresComponents` default	boolean	—	-
`id` default	id	→ products	-
`isGiftCard` default	boolean	—	-
`onlineStorePreviewUrl` default	string	—	-
`onlineStoreUrl` default	string	—	-
`productType` default	string	—	-
`publishedAt` default	date	—	-
`requiresSellingPlan` default	boolean	—	-
`sellingPlanGroupCount` default	number	—	-
`status` default	enum	—	-
`storefrontId` default	string	—	-
`tags` default	string[]	—	-
`templateSuffix` default	string	—	-
`title` default	string	—	-
`totalInventory` default	number	—	-
`totalVariants` default	number	—	-
`tracksInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`vendor` default	string	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`availableForSale` default	boolean	—	-
`barcode` default	string	—	-
`compareAtPrice` default	string	—	-
`createdAt` default	date	—	-
`displayName` default	string	—	-
`id` default	id	→ productVariants	-
`inventoryPolicy` default	enum	—	-
`inventoryQuantity` default	number	—	-
`position` default	number	—	-
`price` default	string	—	-
`requiresComponents` default	boolean	—	-
`sellableOnlineQuantity` default	number	—	-
`sellingPlanGroupCount` default	number	—	-
`showUnitPrice` default	boolean	—	-
`sku` default	string	—	-
`storefrontId` default	string	—	-
`taxable` default	boolean	—	-
`taxCode` default	string	—	-
`title` default	string	—	-
`updatedAt` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`category` default	enum	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`name` default	string	—	-
`options` default	string[]	—	-
`position` default	number	—	-
`summary` default	string	—	-
`key` default	string	—	-
`locale` default	string	—	-
`outdated` default	boolean	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-

Customers

Segment

Segments data in Shopify.

Read

List Segments

Fetch segments from Shopify.

Route: GET /segments

Excel formula: =LF.shopify.segments("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list by the given key. Values: CREATION_DATE, ID, LAST_EDIT_DATE, RELEVANCE
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.name`	string	No	-

Data returned in Excel

Field	Type	Relations	Description
`creationDate` default	date	—	-
`id` default	id	→ segments	-
`lastEditDate` default	date	—	-
`name` default	string	—	-
`query` default	string	—	-

Inventory

Inventory Item

Inventory Items data in Shopify.

Read

List Inventory Items

Fetch inventory items from Shopify.

Route: GET /inventoryItems

Excel formula: =LF.shopify.inventoryItems("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`query.created_at`	date	No	-
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.sku`	string	No	Filter by the inventory item sku field. [Learn more a...
`query.updated_at`	date	No	-

Data returned in Excel

Field	Type	Relations	Description
`countryCodeOfOrigin` default	enum	—	-
`countryCode` default	enum	—	-
`harmonizedSystemCode` default	string	—	-
`createdAt` default	date	—	-
`duplicateSkuCount` default	number	—	-
`harmonizedSystemCode` default	string	—	-
`id` default	id	→ inventoryItems	-
`inventoryHistoryUrl` default	string	—	-
`canDeactivate` default	boolean	—	-
`createdAt` default	date	—	-
`deactivationAlert` default	string	—	-
`id` default	id	—	-
`updatedAt` default	date	—	-
`canDeactivate` default	boolean	—	-
`createdAt` default	date	—	-
`deactivationAlert` default	string	—	-
`id` default	id	—	-
`updatedAt` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`id` default	id	—	-
`provinceCodeOfOrigin` default	string	—	-
`requiresShipping` default	boolean	—	-
`sku` default	string	—	-
`tracked` default	boolean	—	-
`locked` default	boolean	—	-
`reason` default	string	—	-
`amount` default	number	—	-
`currencyCode` default	enum	—	-
`updatedAt` default	date	—	-
`availableForSale` default	boolean	—	-
`barcode` default	string	—	-
`compareAtPrice` default	string	—	-
`createdAt` default	date	—	-
`displayName` default	string	—	-
`id` default	id	→ productVariants	-
`inventoryPolicy` default	enum	—	-
`inventoryQuantity` default	number	—	-
`position` default	number	—	-
`price` default	string	—	-
`requiresComponents` default	boolean	—	-
`sellableOnlineQuantity` default	number	—	-
`sellingPlanGroupCount` default	number	—	-
`showUnitPrice` default	boolean	—	-
`sku` default	string	—	-
`storefrontId` default	string	—	-
`taxable` default	boolean	—	-
`taxCode` default	string	—	-
`title` default	string	—	-
`updatedAt` default	date	—	-
`availableForSale` default	boolean	—	-
`barcode` default	string	—	-
`compareAtPrice` default	string	—	-
`createdAt` default	date	—	-
`displayName` default	string	—	-
`id` default	id	—	-
`inventoryPolicy` default	enum	—	-
`inventoryQuantity` default	number	—	-
`position` default	number	—	-
`price` default	string	—	-
`requiresComponents` default	boolean	—	-
`sellableOnlineQuantity` default	number	—	-
`sellingPlanGroupCount` default	number	—	-
`showUnitPrice` default	boolean	—	-
`sku` default	string	—	-
`storefrontId` default	string	—	-
`taxable` default	boolean	—	-
`taxCode` default	string	—	-
`title` default	string	—	-
`updatedAt` default	date	—	-

Location

Locations data in Shopify.

Used as filter by

List Locations · query.location_id

List Orders · query.location_id

List Product Variants · query.location_id

Read

List Locations

Fetch locations from Shopify.

Route: GET /locations

Excel formula: =LF.shopify.locations("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, NAME, RELEVANCE
`query.active`	string	No	-
`query.address1`	string	No	-
`query.address2`	string	No	-
`query.city`	string	No	-
`query.country`	string	No	-
`query.created_at`	date	No	-
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.geolocated`	boolean	No	-
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.legacy`	boolean	No	-
`query.location_id`	id	No	-
`query.name`	string	No	-
`query.pickup_in_store`	enum	No	Values: enabled, disabled
`query.province`	string	No	-
`query.zip`	string	No	-
`includeLegacy`	boolean	No	Whether to include the legacy locations of fulfillment services. Default: false
`includeInactive`	boolean	No	Whether to include the locations that are deactivated. Default: false

Data returned in Excel

Field	Type	Relations	Description
`activatable` default	boolean	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`country` default	string	—	-
`countryCode` default	string	—	-
`formatted` default	string[]	—	-
`latitude` default	number	—	-
`longitude` default	number	—	-
`phone` default	string	—	-
`province` default	string	—	-
`provinceCode` default	string	—	-
`zip` default	string	—	-
`addressVerified` default	boolean	—	-
`createdAt` default	date	—	-
`deactivatable` default	boolean	—	-
`deactivatedAt` default	string	—	-
`deletable` default	boolean	—	-
`callbackUrl` default	string	—	-
`fulfillmentOrdersOptIn` default	boolean	—	-
`handle` default	string	—	-
`id` default	id	—	-
`inventoryManagement` default	boolean	—	-
`permitsSkuSharing` default	boolean	—	-
`requiresShippingMethod` default	boolean	—	-
`serviceName` default	string	—	-
`trackingSupport` default	boolean	—	-
`type` default	enum	—	-
`fulfillsOnlineOrders` default	boolean	—	-
`hasActiveInventory` default	boolean	—	-
`hasUnfulfilledOrders` default	boolean	—	-
`id` default	id	→ locations	-
`canDeactivate` default	boolean	—	-
`createdAt` default	date	—	-
`deactivationAlert` default	string	—	-
`id` default	id	—	-
`updatedAt` default	date	—	-
`canDeactivate` default	boolean	—	-
`createdAt` default	date	—	-
`deactivationAlert` default	string	—	-
`id` default	id	—	-
`updatedAt` default	date	—	-
`isActive` default	boolean	—	-
`isFulfillmentService` default	boolean	—	-
`isPrimary` default	boolean	—	-
`instructions` default	string	—	-
`pickupTime` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`description` default	string	—	-
`id` default	id	—	-
`key` default	string	—	-
`name` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`pinnedPosition` default	number	—	-
`useAsCollectionCondition` default	boolean	—	-
`validationStatus` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`name` default	string	—	-
`shipsInventory` default	boolean	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`country` default	string	—	-
`countryCode` default	enum	—	-
`formatted` default	string[]	—	-
`province` default	string	—	-
`provinceCode` default	string	—	-
`zip` default	string	—	-
`updatedAt` default	date	—	-

Logistics

Delivery Customization

Delivery Customizations data in Shopify.

Read

List Delivery Customizations

Fetch delivery customizations from Shopify.

Route: GET /deliveryCustomizations

Excel formula: =LF.shopify.deliveryCustomizations("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`query.enabled`	boolean	No	-
`query.function_id`	string	No	-
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234

Data returned in Excel

Field	Type	Relations	Description
`enabled` default	boolean	—	-
`errorsFirstOccurredAt` default	date	—	-
`firstOccurredAt` default	date	—	-
`hasBeenSharedSinceLastError` default	boolean	—	-
`hasSharedRecentErrors` default	boolean	—	-
`functionId` default	string	—	-
`id` default	id	→ deliveryCustomizations	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`description` default	string	—	-
`id` default	id	—	-
`key` default	string	—	-
`name` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`pinnedPosition` default	number	—	-
`useAsCollectionCondition` default	boolean	—	-
`validationStatus` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`apiType` default	string	—	-
`apiVersion` default	string	—	-
`appKey` default	string	—	-
`description` default	string	—	-
`handle` default	string	—	-
`id` default	id	—	-
`inputQuery` default	string	—	-
`title` default	string	—	-
`useCreationUi` default	boolean	—	-
`title` default	string	—	-

Delivery Profile

Delivery Profiles data in Shopify.

Used as filter by

List Product Variants · query.delivery_profile_id

List Products · query.delivery_profile_id

Read

List Delivery Profiles

Fetch delivery profiles from Shopify.

Route: GET /deliveryProfiles

Excel formula: =LF.shopify.deliveryProfiles("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`merchantOwnedOnly`	boolean	No	If true, returns only delivery profiles that were created by the merchant.
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false

Data returned in Excel

Field	Type	Relations	Description
`activeMethodDefinitionsCount` default	number	—	-
`default` default	boolean	—	-
`id` default	id	→ deliveryProfiles	-
`legacyMode` default	boolean	—	-
`locationsWithoutRatesCount` default	number	—	-
`name` default	string	—	-
`originLocationCount` default	number	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`capped` default	boolean	—	-
`count` default	number	—	-
`id` default	id	—	-
`appId` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	→ sellingPlanGroups	-
`merchantCode` default	string	—	-
`name` default	string	—	-
`options` default	string[]	—	-
`position` default	number	—	-
`summary` default	string	—	-
`activatable` default	boolean	—	-
`addressVerified` default	boolean	—	-
`createdAt` default	date	—	-
`deactivatable` default	boolean	—	-
`deactivatedAt` default	string	—	-
`deletable` default	boolean	—	-
`fulfillsOnlineOrders` default	boolean	—	-
`hasActiveInventory` default	boolean	—	-
`hasUnfulfilledOrders` default	boolean	—	-
`id` default	id	→ locations	-
`isActive` default	boolean	—	-
`isFulfillmentService` default	boolean	—	-
`isPrimary` default	boolean	—	-
`name` default	string	—	-
`shipsInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`activatable` default	boolean	—	-
`addressVerified` default	boolean	—	-
`createdAt` default	date	—	-
`deactivatable` default	boolean	—	-
`deactivatedAt` default	string	—	-
`deletable` default	boolean	—	-
`fulfillsOnlineOrders` default	boolean	—	-
`hasActiveInventory` default	boolean	—	-
`hasUnfulfilledOrders` default	boolean	—	-
`id` default	id	→ locations	-
`isActive` default	boolean	—	-
`isFulfillmentService` default	boolean	—	-
`isPrimary` default	boolean	—	-
`name` default	string	—	-
`shipsInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`version` default	number	—	-
`zoneCountryCount` default	number	—	-

Marketing

Marketing Activity

Marketing Activities data in Shopify.

Read

List Marketing Activities

Fetch marketing activities from Shopify.

Route: GET /marketingActivities

Excel formula: =LF.shopify.marketingActivities("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`marketingActivityIds`	string[]	No	The list of marketing activity IDs to filter by.
`remoteIds`	string[]	No	The list of remote IDs associated with marketing activities to filter by.
`utm`	string	No	The UTM parameters associated with marketing activities to filter by.
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, ID, TITLE
`query.app_id`	id	No	-
`query.app_name`	string	No	A comma-separated list of app names.
`query.created_at`	date	No	-
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.marketing_campaign_id`	id	No	-
`query.scheduled_to_end_at`	date	No	-
`query.scheduled_to_start_at`	date	No	-
`query.tactic`	string	No	-
`query.title`	string	No	-
`query.updated_at`	date	No	-
`savedSearchId`	string	No	The ID of a saved search. The search’s query string is used as...

Data returned in Excel

Field	Type	Relations	Description
`activityListUrl` default	string	—	-
`amount` default	number	—	-
`currencyCode` default	enum	—	-
`apiKey` default	string	—	-
`appStoreAppUrl` default	string	—	-
`appStoreDeveloperUrl` default	string	—	-
`description` default	string	—	-
`developerName` default	string	—	-
`developerType` default	enum	—	-
`developerUrl` default	string	—	-
`embedded` default	boolean	—	-
`features` default	string[]	—	-
`handle` default	string	—	-
`id` default	id	—	-
`installUrl` default	string	—	-
`isPostPurchaseAppInUse` default	boolean	—	-
`launchUrl` default	string	—	-
`previouslyInstalled` default	boolean	—	-
`pricingDetails` default	string	—	-
`pricingDetailsSummary` default	string	—	-
`privacyPolicyUrl` default	string	—	-
`publicCategory` default	enum	—	-
`published` default	boolean	—	-
`shopifyDeveloped` default	boolean	—	-
`title` default	string	—	-
`uninstallMessage` default	string	—	-
`uninstallUrl` default	string	—	-
`webhookApiVersion` default	string	—	-
`code` default	enum	—	-
`budgetType` default	enum	—	-
`createdAt` default	date	—	-
`formData` default	string	—	-
`hierarchyLevel` default	enum	—	-
`id` default	id	→ marketingActivities	-
`inMainWorkflowVersion` default	boolean	—	-
`isExternal` default	boolean	—	-
`marketingChannel` default	enum	—	-
`marketingChannelType` default	enum	—	-
`channel` default	enum	—	-
`channelHandle` default	string	—	-
`description` default	string	—	-
`endedAt` default	date	—	-
`id` default	id	—	-
`manageUrl` default	string	—	-
`marketingChannelType` default	enum	—	-
`previewUrl` default	string	—	-
`remoteId` default	string	—	-
`scheduledToEndAt` default	date	—	-
`sourceAndMedium` default	string	—	-
`startedAt` default	date	—	-
`targetTypeDisplayText` default	string	—	-
`type` default	enum	—	-
`utmCampaign` default	string	—	-
`utmMedium` default	string	—	-
`utmSource` default	string	—	-
`parentActivityId` default	id	—	-
`parentRemoteId` default	string	—	-
`sourceAndMedium` default	string	—	-
`status` default	enum	—	-
`statusBadgeType` default	enum	—	-
`statusBadgeTypeV2` default	enum	—	-
`statusLabel` default	string	—	-
`statusTransitionedAt` default	date	—	-
`tactic` default	enum	—	-
`targetStatus` default	enum	—	-
`title` default	string	—	-
`updatedAt` default	date	—	-
`urlParameterValue` default	string	—	-
`campaign` default	string	—	-
`content` default	string	—	-
`medium` default	string	—	-
`source` default	string	—	-
`term` default	string	—	-

Markets

Market

Markets data in Shopify.

Used as filter by

List Catalogs · query.market_id

Read

List Markets

Fetch markets from Shopify.

Route: GET /markets

Excel formula: =LF.shopify.markets("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`type`	enum	No	Filters markets by type. Values: NONE, REGION, LOCATION, COMPANY_LOCATION
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, ID, MARKET_CONDITION_TYPES, MARKET_TYPE, NAME
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.market_condition_types`	string	No	A comma-separated list of condition types.
`query.market_type`	string	No	-
`query.name`	string	No	-
`query.status`	enum	No	Values: ACTIVE, DRAFT
`query.wildcard_company_location_with_country_code`	string	No	-

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`status` default	enum	—	-
`title` default	string	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`conditionTypes` default	string	—	-
`localCurrencies` default	boolean	—	-
`roundingEnabled` default	boolean	—	-
`enabled` default	boolean	—	-
`handle` default	string	—	-
`id` default	id	→ markets	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`description` default	string	—	-
`id` default	id	—	-
`key` default	string	—	-
`name` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`pinnedPosition` default	number	—	-
`useAsCollectionCondition` default	boolean	—	-
`validationStatus` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`name` default	string	—	-
`inclusiveDutiesPricingStrategy` default	enum	—	-
`inclusiveTaxPricingStrategy` default	enum	—	-
`currency` default	enum	—	-
`fixedPricesCount` default	number	—	-
`id` default	id	—	-
`name` default	string	—	-
`primary` default	boolean	—	-
`code` default	enum	—	-
`id` default	id	—	-
`name` default	string	—	-
`status` default	enum	—	-
`type` default	enum	—	-
`id` default	id	—	-
`subfolderSuffix` default	string	—	-
`id` default	id	—	-
`subfolderSuffix` default	string	—	-

Sales

Draft Order

Draft Orders data in Shopify.

Read

List Draft Orders

Fetch draft orders from Shopify.

Route: GET /draftOrders

Excel formula: =LF.shopify.draftOrders("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CUSTOMER_NAME, ID, NUMBER, RELEVANCE, STATUS
`query.created_at`	date	No	-
`query.customer_id`	id	No	-
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.source`	string	No	-
`query.status`	string	No	-
`query.tag`	string	No	-
`query.updated_at`	date	No	-
`savedSearchId`	string	No	The ID of a saved search. The search’s query string is used as...

Data returned in Excel

Field	Type	Relations	Description
`acceptAutomaticDiscounts` default	boolean	—	-
`allowDiscountCodesInCheckout` default	boolean	—	-
`allVariantPricesOverridden` default	boolean	—	-
`anyVariantPricesOverridden` default	boolean	—	-
`amount` default	string	—	-
`description` default	string	—	-
`title` default	string	—	-
`value` default	number	—	-
`valueType` default	enum	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`company` default	string	—	-
`coordinatesValidated` default	boolean	—	-
`country` default	string	—	-
`countryCode` default	string	—	-
`countryCodeV2` default	enum	—	-
`firstName` default	string	—	-
`formattedArea` default	string	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`latitude` default	number	—	-
`longitude` default	number	—	-
`name` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`provinceCode` default	string	—	-
`timeZone` default	string	—	-
`validationResultSummary` default	enum	—	-
`zip` default	string	—	-
`billingAddressMatchesShippingAddress` default	boolean	—	-
`completedAt` default	date	—	-
`createdAt` default	date	—	-
`currencyCode` default	enum	—	-
`key` default	string	—	-
`value` default	string	—	-
`canDelete` default	boolean	—	-
`createdAt` default	date	—	-
`dataSaleOptOut` default	boolean	—	-
`displayName` default	string	—	-
`email` default	string	—	-
`firstName` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`lifetimeDuration` default	string	—	-
`locale` default	string	—	-
`multipassIdentifier` default	string	—	-
`note` default	string	—	-
`numberOfOrders` default	string	—	-
`phone` default	string	—	-
`productSubscriberStatus` default	enum	—	-
`state` default	enum	—	-
`tags` default	string[]	—	-
`taxExempt` default	boolean	—	-
`taxExemptions` default	string	—	-
`unsubscribeUrl` default	string	—	-
`updatedAt` default	date	—	-
`validEmailAddress` default	boolean	—	-
`verifiedEmail` default	boolean	—	-
`discountCodes` default	string[]	—	-
`email` default	string	—	-
`action` default	string	—	-
`additionalContent` default	string	—	-
`additionalData` default	string	—	-
`appTitle` default	string	—	-
`arguments` default	string	—	-
`attributeToApp` default	boolean	—	-
`attributeToUser` default	boolean	—	-
`author` default	string	—	-
`createdAt` default	date	—	-
`criticalAlert` default	boolean	—	-
`hasAdditionalContent` default	boolean	—	-
`id` default	id	—	-
`message` default	string	—	-
`secondaryMessage` default	string	—	-
`subjectId` default	string	—	-
`subjectType` default	enum	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ draftOrders	-
`invoiceEmailTemplateSubject` default	string	—	-
`invoiceSentAt` default	date	—	-
`invoiceUrl` default	string	—	-
`custom` default	boolean	—	-
`discountedTotal` default	string	—	-
`discountedUnitPrice` default	string	—	-
`grams` default	number	—	-
`id` default	id	—	-
`isGiftCard` default	boolean	—	-
`name` default	string	—	-
`originalTotal` default	string	—	-
`originalUnitPrice` default	string	—	-
`quantity` default	number	—	-
`requiresShipping` default	boolean	—	-
`sku` default	string	—	-
`taxable` default	boolean	—	-
`title` default	string	—	-
`totalDiscount` default	string	—	-
`uuid` default	string	—	-
`variantTitle` default	string	—	-
`vendor` default	string	—	-
`countryCode` default	enum	—	-
`key` default	enum	—	-
`purpose` default	enum	—	-
`title` default	string	—	-
`value` default	string	—	-
`countryCode` default	enum	—	-
`key` default	enum	—	-
`purpose` default	enum	—	-
`title` default	string	—	-
`value` default	string	—	-
`marketName` default	string	—	-
`marketRegionCountryCode` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`name` default	string	—	-
`note2` default	string	—	-
`billingAddressMatchesShippingAddress` default	boolean	—	-
`cancelledAt` default	date	—	-
`cancelReason` default	enum	—	-
`canMarkAsPaid` default	boolean	—	-
`canNotifyCustomer` default	boolean	—	-
`capturable` default	boolean	—	-
`cartDiscountAmount` default	string	—	-
`clientIp` default	string	—	-
`closed` default	boolean	—	-
`closedAt` default	date	—	-
`confirmationNumber` default	string	—	-
`confirmed` default	boolean	—	-
`createdAt` default	date	—	-
`currencyCode` default	enum	—	-
`currentSubtotalLineItemsQuantity` default	number	—	-
`currentTotalWeight` default	string	—	-
`customerAcceptsMarketing` default	boolean	—	-
`customerLocale` default	string	—	-
`discountCode` default	string	—	-
`discountCodes` default	string[]	—	-
`displayFinancialStatus` default	enum	—	-
`displayFulfillmentStatus` default	enum	—	-
`dutiesIncluded` default	boolean	—	-
`edited` default	boolean	—	-
`email` default	string	—	-
`estimatedTaxes` default	boolean	—	-
`fulfillable` default	boolean	—	-
`fullyPaid` default	boolean	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	—	-
`landingPageDisplayText` default	string	—	-
`landingPageUrl` default	string	—	-
`merchantEditable` default	boolean	—	-
`merchantEditableErrors` default	string[]	—	-
`name` default	string	—	-
`netPayment` default	string	—	-
`note` default	string	—	-
`number` default	number	—	-
`paymentGatewayNames` default	string[]	—	-
`phone` default	string	—	-
`poNumber` default	string	—	-
`presentmentCurrencyCode` default	enum	—	-
`processedAt` default	date	—	-
`productNetwork` default	boolean	—	-
`referralCode` default	string	—	-
`referrerDisplayText` default	string	—	-
`referrerUrl` default	string	—	-
`refundable` default	boolean	—	-
`registeredSourceUrl` default	string	—	-
`requiresShipping` default	boolean	—	-
`restockable` default	boolean	—	-
`returnStatus` default	enum	—	-
`riskLevel` default	enum	—	-
`sourceIdentifier` default	string	—	-
`sourceName` default	string	—	-
`subtotalLineItemsQuantity` default	number	—	-
`subtotalPrice` default	string	—	-
`tags` default	string[]	—	-
`taxesIncluded` default	boolean	—	-
`taxExempt` default	boolean	—	-
`test` default	boolean	—	-
`totalCapturable` default	string	—	-
`totalDiscounts` default	string	—	-
`totalPrice` default	string	—	-
`totalReceived` default	string	—	-
`totalRefunded` default	string	—	-
`totalShippingPrice` default	string	—	-
`totalTax` default	string	—	-
`totalWeight` default	string	—	-
`unpaid` default	boolean	—	-
`updatedAt` default	date	—	-
`due` default	boolean	—	-
`dueInDays` default	number	—	-
`id` default	id	—	-
`overdue` default	boolean	—	-
`paymentTermsName` default	string	—	-
`paymentTermsType` default	enum	—	-
`translatedName` default	string	—	-
`phone` default	string	—	-
`automaticDiscount` default	boolean	—	-
`bxgyDiscount` default	boolean	—	-
`code` default	string	—	-
`discountClass` default	enum	—	-
`discountClasses` default	string	—	-
`id` default	id	—	-
`presentationLevel` default	string	—	-
`shortSummary` default	string	—	-
`summary` default	string	—	-
`title` default	string	—	-
`poNumber` default	string	—	-
`presentmentCurrencyCode` default	enum	—	-
`canDelete` default	boolean	—	-
`createdAt` default	date	—	-
`dataSaleOptOut` default	boolean	—	-
`displayName` default	string	—	-
`email` default	string	—	-
`firstName` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`lifetimeDuration` default	string	—	-
`locale` default	string	—	-
`multipassIdentifier` default	string	—	-
`note` default	string	—	-
`numberOfOrders` default	string	—	-
`phone` default	string	—	-
`productSubscriberStatus` default	enum	—	-
`state` default	enum	—	-
`tags` default	string[]	—	-
`taxExempt` default	boolean	—	-
`taxExemptions` default	string	—	-
`unsubscribeUrl` default	string	—	-
`updatedAt` default	date	—	-
`validEmailAddress` default	boolean	—	-
`verifiedEmail` default	boolean	—	-
`ready` default	boolean	—	-
`reserveInventoryUntil` default	date	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`company` default	string	—	-
`coordinatesValidated` default	boolean	—	-
`country` default	string	—	-
`countryCode` default	string	—	-
`countryCodeV2` default	enum	—	-
`firstName` default	string	—	-
`formattedArea` default	string	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`latitude` default	number	—	-
`longitude` default	number	—	-
`name` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`provinceCode` default	string	—	-
`timeZone` default	string	—	-
`validationResultSummary` default	enum	—	-
`zip` default	string	—	-
`carrierIdentifier` default	string	—	-
`code` default	string	—	-
`custom` default	boolean	—	-
`deliveryCategory` default	string	—	-
`id` default	id	—	-
`isRemoved` default	boolean	—	-
`phone` default	string	—	-
`price` default	string	—	-
`shippingRateHandle` default	string	—	-
`source` default	string	—	-
`title` default	string	—	-
`status` default	enum	—	-
`subtotalPrice` default	string	—	-
`tags` default	string[]	—	-
`taxesIncluded` default	boolean	—	-
`taxExempt` default	boolean	—	-
`channelLiable` default	boolean	—	-
`price` default	string	—	-
`rate` default	number	—	-
`ratePercentage` default	number	—	-
`source` default	string	—	-
`title` default	string	—	-
`totalPrice` default	string	—	-
`totalQuantityOfLineItems` default	number	—	-
`totalShippingPrice` default	string	—	-
`totalTax` default	string	—	-
`totalWeight` default	string	—	-
`transformerFingerprint` default	string	—	-
`updatedAt` default	date	—	-
`visibleToCustomer` default	boolean	—	-
`errorCode` default	string	—	-
`field` default	string	—	-
`message` default	string	—	-

Edit

Update Draft Order

Update an existing draft order in Shopify.

Route: PATCH /draftOrders/{id}

Inputs you can set

Name	Type	Required	Description
`id`	string	Yes	-
`input.acceptAutomaticDiscounts`	boolean	No	-
`input.allowDiscountCodesInCheckout`	boolean	No	-
`input.appliedDiscount.amountWithCurrency.amount`	number	Yes	-
`input.appliedDiscount.amountWithCurrency.currencyCode`	enum	Yes	Values: USD, EUR, GBP, CAD, AFN
`input.appliedDiscount.description`	string	No	-
`input.appliedDiscount.title`	string	No	-
`input.appliedDiscount.value`	number	Yes	-
`input.appliedDiscount.valueType`	enum	Yes	Values: FIXED_AMOUNT, PERCENTAGE
`input.billingAddress.address1`	string	No	-
`input.billingAddress.address2`	string	No	-
`input.billingAddress.city`	string	No	-
`input.billingAddress.company`	string	No	-
`input.billingAddress.countryCode`	enum	No	Values: AF, AX, AL, DZ, AD
`input.billingAddress.firstName`	string	No	-
`input.billingAddress.lastName`	string	No	-
`input.billingAddress.phone`	string	No	-
`input.billingAddress.provinceCode`	string	No	-
`input.billingAddress.zip`	string	No	-
`input.customAttributes.key`	string	Yes	-
`input.customAttributes.value`	string	Yes	-
`input.discountCodes`	string[]	No	-
`input.email`	string	No	-
`input.lineItems.appliedDiscount.amountWithCurrency.amount`	number	Yes	-
`input.lineItems.appliedDiscount.amountWithCurrency.currencyCode`	enum	Yes	Values: USD, EUR, GBP, CAD, AFN
`input.lineItems.appliedDiscount.description`	string	No	-
`input.lineItems.appliedDiscount.title`	string	No	-
`input.lineItems.appliedDiscount.value`	number	Yes	-
`input.lineItems.appliedDiscount.valueType`	enum	Yes	Values: FIXED_AMOUNT, PERCENTAGE
`input.lineItems.components.quantity`	number	Yes	-
`input.lineItems.components.uuid`	string	No	-
`input.lineItems.components.variantId`	string	No	-
`input.lineItems.customAttributes.key`	string	Yes	-
`input.lineItems.customAttributes.value`	string	Yes	-
`input.lineItems.generatePriceOverride`	boolean	No	-
`input.lineItems.originalUnitPriceWithCurrency.amount`	number	Yes	-
`input.lineItems.originalUnitPriceWithCurrency.currencyCode`	enum	Yes	Values: USD, EUR, GBP, CAD, AFN
`input.lineItems.priceOverride.amount`	number	Yes	-
`input.lineItems.priceOverride.currencyCode`	enum	Yes	Values: USD, EUR, GBP, CAD, AFN
`input.lineItems.quantity`	number	Yes	-
`input.lineItems.requiresShipping`	boolean	No	-
`input.lineItems.sku`	string	No	-
`input.lineItems.taxable`	boolean	No	-
`input.lineItems.title`	string	No	-
`input.lineItems.uuid`	string	No	-
`input.lineItems.variantId`	string	No	-
`input.lineItems.weight.unit`	enum	Yes	Values: KILOGRAMS, GRAMS, POUNDS, OUNCES
`input.lineItems.weight.value`	number	Yes	-
`input.localizedFields.key`	enum	Yes	Values: TAX_CREDENTIAL_BR, SHIPPING_CREDENTIAL_BR, TAX_CREDENTIAL_CL, SHIPPING_CREDENTIAL_CL, SHIPPING_CREDENTIAL_CN
`input.localizedFields.value`	string	Yes	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-
`input.metafields.namespace`	string	No	-
`input.metafields.type`	string	No	-
`input.metafields.value`	string	No	-
`input.note`	string	No	-
`input.paymentTerms.paymentSchedules.dueAt`	date	No	-
`input.paymentTerms.paymentSchedules.issuedAt`	date	No	-
`input.paymentTerms.paymentTermsTemplateId`	string	No	-
`input.phone`	string	No	-
`input.poNumber`	string	No	-
`input.presentmentCurrencyCode`	enum	No	Values: USD, EUR, GBP, CAD, AFN
`input.purchasingEntity.customerId`	string	No	-
`input.purchasingEntity.purchasingCompany.companyContactId`	string	Yes	-
`input.purchasingEntity.purchasingCompany.companyId`	string	Yes	-
`input.purchasingEntity.purchasingCompany.companyLocationId`	string	Yes	-
`input.reserveInventoryUntil`	date	No	-
`input.sessionToken`	string	No	-
`input.shippingAddress.address1`	string	No	-
`input.shippingAddress.address2`	string	No	-
`input.shippingAddress.city`	string	No	-
`input.shippingAddress.company`	string	No	-
`input.shippingAddress.countryCode`	enum	No	Values: AF, AX, AL, DZ, AD
`input.shippingAddress.firstName`	string	No	-
`input.shippingAddress.lastName`	string	No	-
`input.shippingAddress.phone`	string	No	-
`input.shippingAddress.provinceCode`	string	No	-
`input.shippingAddress.zip`	string	No	-
`input.shippingLine.priceWithCurrency.amount`	number	Yes	-
`input.shippingLine.priceWithCurrency.currencyCode`	enum	Yes	Values: USD, EUR, GBP, CAD, AFN
`input.shippingLine.shippingRateHandle`	string	No	-
`input.shippingLine.title`	string	No	-
`input.sourceName`	string	No	-
`input.tags`	string[]	No	-
`input.taxExempt`	boolean	No	-
`input.transformerFingerprint`	string	No	-
`input.useCustomerDefaultAddress`	boolean	No	-
`input.visibleToCustomer`	boolean	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Draft Order

Delete an existing draft order in Shopify.

Route: DELETE /draftOrders/{id}

Inputs you can set

Name	Type	Required	Description
`input.id`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Fulfillment Order

Fulfillment Orders data in Shopify.

Read

List Fulfillment Orders

Fetch fulfillment orders from Shopify.

Route: GET /fulfillmentOrders

Excel formula: =LF.shopify.fulfillmentOrders("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`includeClosed`	boolean	No	Whether to include closed fulfillment orders. Default: false
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: ID, UPDATED_AT
`query.assigned_location_id`	id	No	-
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.status`	string	No	-
`query.updated_at`	date	No	-

Data returned in Excel

Field	Type	Relations	Description
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`countryCode` default	enum	—	-
`name` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`zip` default	string	—	-
`channelId` default	id	—	-
`createdAt` default	date	—	-
`id` default	id	—	-
`maxDeliveryDateTime` default	date	—	-
`methodType` default	enum	—	-
`minDeliveryDateTime` default	date	—	-
`presentedName` default	string	—	-
`serviceCode` default	string	—	-
`sourceReference` default	string	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`company` default	string	—	-
`countryCode` default	enum	—	-
`email` default	string	—	-
`firstName` default	string	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`zip` default	string	—	-
`fulfillAt` default	date	—	-
`fulfillBy` default	date	—	-
`displayReason` default	string	—	-
`handle` default	string	—	-
`heldByRequestingApp` default	boolean	—	-
`id` default	id	—	-
`reason` default	enum	—	-
`reasonNotes` default	string	—	-
`channelId` default	id	—	-
`createdAt` default	date	—	-
`fulfillAt` default	date	—	-
`fulfillBy` default	date	—	-
`id` default	id	→ fulfillmentOrders	-
`orderId` default	id	→ orders	-
`orderName` default	string	—	-
`orderProcessedAt` default	date	—	-
`requestStatus` default	enum	—	-
`status` default	enum	—	-
`updatedAt` default	date	—	-
`createdAt` default	date	—	-
`deliveredAt` default	date	—	-
`displayStatus` default	enum	—	-
`estimatedDeliveryAt` default	date	—	-
`id` default	id	—	-
`inTransitAt` default	date	—	-
`name` default	string	—	-
`requiresShipping` default	boolean	—	-
`status` default	enum	—	-
`totalQuantity` default	number	—	-
`updatedAt` default	date	—	-
`id` default	id	→ fulfillmentOrders	-
`incoterm` default	string	—	-
`id` default	id	—	-
`inventoryItemId` default	string	—	-
`productTitle` default	string	—	-
`remainingQuantity` default	number	—	-
`requiresShipping` default	boolean	—	-
`sku` default	string	—	-
`totalQuantity` default	number	—	-
`variantTitle` default	string	—	-
`vendor` default	string	—	-
`message` default	string	—	-
`movable` default	boolean	—	-
`id` default	id	—	-
`kind` default	enum	—	-
`message` default	string	—	-
`requestOptions` default	string	—	-
`responseData` default	string	—	-
`sentAt` default	date	—	-
`billingAddressMatchesShippingAddress` default	boolean	—	-
`cancelledAt` default	date	—	-
`cancelReason` default	enum	—	-
`canMarkAsPaid` default	boolean	—	-
`canNotifyCustomer` default	boolean	—	-
`capturable` default	boolean	—	-
`cartDiscountAmount` default	string	—	-
`clientIp` default	string	—	-
`closed` default	boolean	—	-
`closedAt` default	date	—	-
`confirmationNumber` default	string	—	-
`confirmed` default	boolean	—	-
`createdAt` default	date	—	-
`currencyCode` default	enum	—	-
`currentSubtotalLineItemsQuantity` default	number	—	-
`currentTotalWeight` default	string	—	-
`customerAcceptsMarketing` default	boolean	—	-
`customerLocale` default	string	—	-
`discountCode` default	string	—	-
`discountCodes` default	string[]	—	-
`displayFinancialStatus` default	enum	—	-
`displayFulfillmentStatus` default	enum	—	-
`dutiesIncluded` default	boolean	—	-
`edited` default	boolean	—	-
`email` default	string	—	-
`estimatedTaxes` default	boolean	—	-
`fulfillable` default	boolean	—	-
`fullyPaid` default	boolean	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ orders	-
`landingPageDisplayText` default	string	—	-
`landingPageUrl` default	string	—	-
`merchantEditable` default	boolean	—	-
`merchantEditableErrors` default	string[]	—	-
`name` default	string	—	-
`netPayment` default	string	—	-
`note` default	string	—	-
`number` default	number	—	-
`paymentGatewayNames` default	string[]	—	-
`phone` default	string	—	-
`poNumber` default	string	—	-
`presentmentCurrencyCode` default	enum	—	-
`processedAt` default	date	—	-
`productNetwork` default	boolean	—	-
`referralCode` default	string	—	-
`referrerDisplayText` default	string	—	-
`referrerUrl` default	string	—	-
`refundable` default	boolean	—	-
`registeredSourceUrl` default	string	—	-
`requiresShipping` default	boolean	—	-
`restockable` default	boolean	—	-
`returnStatus` default	enum	—	-
`riskLevel` default	enum	—	-
`sourceIdentifier` default	string	—	-
`sourceName` default	string	—	-
`subtotalLineItemsQuantity` default	number	—	-
`subtotalPrice` default	string	—	-
`tags` default	string[]	—	-
`taxesIncluded` default	boolean	—	-
`taxExempt` default	boolean	—	-
`test` default	boolean	—	-
`totalCapturable` default	string	—	-
`totalDiscounts` default	string	—	-
`totalPrice` default	string	—	-
`totalReceived` default	string	—	-
`totalRefunded` default	string	—	-
`totalShippingPrice` default	string	—	-
`totalTax` default	string	—	-
`totalWeight` default	string	—	-
`unpaid` default	boolean	—	-
`updatedAt` default	date	—	-
`orderId` default	id	→ orders	-
`orderName` default	string	—	-
`orderProcessedAt` default	date	—	-
`requestStatus` default	enum	—	-
`status` default	enum	—	-
`action` default	enum	—	-
`externalUrl` default	string	—	-
`updatedAt` default	date	—	-

Manual Holds Fulfillment Order

Manual Holds Fulfillment Orders data in Shopify.

Read

List Manual Holds Fulfillment Orders

Fetch manual holds fulfillment orders from Shopify.

Route: GET /manualHoldsFulfillmentOrders

Excel formula: =LF.shopify.manualHoldsFulfillmentOrders("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`query`	string	No	The query conditions used to filter fulfillment orders. Only fulfillment orders corresponding to orders matching the query will be counted....
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false

Data returned in Excel

Field	Type	Relations	Description
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`countryCode` default	enum	—	-
`name` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`zip` default	string	—	-
`channelId` default	id	—	-
`createdAt` default	date	—	-
`id` default	id	—	-
`maxDeliveryDateTime` default	date	—	-
`methodType` default	enum	—	-
`minDeliveryDateTime` default	date	—	-
`presentedName` default	string	—	-
`serviceCode` default	string	—	-
`sourceReference` default	string	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`company` default	string	—	-
`countryCode` default	enum	—	-
`email` default	string	—	-
`firstName` default	string	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`zip` default	string	—	-
`fulfillAt` default	date	—	-
`fulfillBy` default	date	—	-
`displayReason` default	string	—	-
`handle` default	string	—	-
`heldByRequestingApp` default	boolean	—	-
`id` default	id	—	-
`reason` default	enum	—	-
`reasonNotes` default	string	—	-
`channelId` default	id	—	-
`createdAt` default	date	—	-
`fulfillAt` default	date	—	-
`fulfillBy` default	date	—	-
`id` default	id	→ fulfillmentOrders	-
`orderId` default	id	→ orders	-
`orderName` default	string	—	-
`orderProcessedAt` default	date	—	-
`requestStatus` default	enum	—	-
`status` default	enum	—	-
`updatedAt` default	date	—	-
`createdAt` default	date	—	-
`deliveredAt` default	date	—	-
`displayStatus` default	enum	—	-
`estimatedDeliveryAt` default	date	—	-
`id` default	id	—	-
`inTransitAt` default	date	—	-
`name` default	string	—	-
`requiresShipping` default	boolean	—	-
`status` default	enum	—	-
`totalQuantity` default	number	—	-
`updatedAt` default	date	—	-
`id` default	id	→ fulfillmentOrders	-
`incoterm` default	string	—	-
`id` default	id	—	-
`inventoryItemId` default	string	—	-
`productTitle` default	string	—	-
`remainingQuantity` default	number	—	-
`requiresShipping` default	boolean	—	-
`sku` default	string	—	-
`totalQuantity` default	number	—	-
`variantTitle` default	string	—	-
`vendor` default	string	—	-
`message` default	string	—	-
`movable` default	boolean	—	-
`id` default	id	—	-
`kind` default	enum	—	-
`message` default	string	—	-
`requestOptions` default	string	—	-
`responseData` default	string	—	-
`sentAt` default	date	—	-
`billingAddressMatchesShippingAddress` default	boolean	—	-
`cancelledAt` default	date	—	-
`cancelReason` default	enum	—	-
`canMarkAsPaid` default	boolean	—	-
`canNotifyCustomer` default	boolean	—	-
`capturable` default	boolean	—	-
`cartDiscountAmount` default	string	—	-
`clientIp` default	string	—	-
`closed` default	boolean	—	-
`closedAt` default	date	—	-
`confirmationNumber` default	string	—	-
`confirmed` default	boolean	—	-
`createdAt` default	date	—	-
`currencyCode` default	enum	—	-
`currentSubtotalLineItemsQuantity` default	number	—	-
`currentTotalWeight` default	string	—	-
`customerAcceptsMarketing` default	boolean	—	-
`customerLocale` default	string	—	-
`discountCode` default	string	—	-
`discountCodes` default	string[]	—	-
`displayFinancialStatus` default	enum	—	-
`displayFulfillmentStatus` default	enum	—	-
`dutiesIncluded` default	boolean	—	-
`edited` default	boolean	—	-
`email` default	string	—	-
`estimatedTaxes` default	boolean	—	-
`fulfillable` default	boolean	—	-
`fullyPaid` default	boolean	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ orders	-
`landingPageDisplayText` default	string	—	-
`landingPageUrl` default	string	—	-
`merchantEditable` default	boolean	—	-
`merchantEditableErrors` default	string[]	—	-
`name` default	string	—	-
`netPayment` default	string	—	-
`note` default	string	—	-
`number` default	number	—	-
`paymentGatewayNames` default	string[]	—	-
`phone` default	string	—	-
`poNumber` default	string	—	-
`presentmentCurrencyCode` default	enum	—	-
`processedAt` default	date	—	-
`productNetwork` default	boolean	—	-
`referralCode` default	string	—	-
`referrerDisplayText` default	string	—	-
`referrerUrl` default	string	—	-
`refundable` default	boolean	—	-
`registeredSourceUrl` default	string	—	-
`requiresShipping` default	boolean	—	-
`restockable` default	boolean	—	-
`returnStatus` default	enum	—	-
`riskLevel` default	enum	—	-
`sourceIdentifier` default	string	—	-
`sourceName` default	string	—	-
`subtotalLineItemsQuantity` default	number	—	-
`subtotalPrice` default	string	—	-
`tags` default	string[]	—	-
`taxesIncluded` default	boolean	—	-
`taxExempt` default	boolean	—	-
`test` default	boolean	—	-
`totalCapturable` default	string	—	-
`totalDiscounts` default	string	—	-
`totalPrice` default	string	—	-
`totalReceived` default	string	—	-
`totalRefunded` default	string	—	-
`totalShippingPrice` default	string	—	-
`totalTax` default	string	—	-
`totalWeight` default	string	—	-
`unpaid` default	boolean	—	-
`updatedAt` default	date	—	-
`orderId` default	id	→ orders	-
`orderName` default	string	—	-
`orderProcessedAt` default	date	—	-
`requestStatus` default	enum	—	-
`status` default	enum	—	-
`action` default	enum	—	-
`externalUrl` default	string	—	-
`updatedAt` default	date	—	-

Order

Orders in Shopify checkout flow.

Read

List Orders

Fetch orders from Shopify.

Route: GET /orders

Excel formula: =LF.shopify.orders("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, CURRENT_TOTAL_PRICE, CUSTOMER_NAME, DESTINATION, FINANCIAL_STATUS
`query.cart_token`	string	No	Filter by the cart token's unique value to track abandoned cart conversions or troubleshoot checkout issues. The token references the cart t...
`query.channel`	string	No	Filter by the channel information [handle](https://shopify.dev/api/admin-graphql/latest/objects/ChannelInformation#field-ChannelInformatio...
`query.channel_id`	id	No	Filter by the channel id field. Example: - channe...
`query.chargeback_status`	enum	No	Filter by the order's chargeback status. A chargeback occurs when a customer questions the legitimacy of a charge with their financial insti... Values: accepted, charge_refunded, lost, needs_response, under_review
`query.checkout_token`	string	No	Filter by the checkout token's unique value to analyze conversion funnels or resolve payment issues. The checkout token's value references t...
`query.confirmation_number`	string	No	Filter by the randomly generated alpha-numeric identifier for an order that can be displayed to the customer instead of the sequential order...
`query.created_at`	date	No	Filter by the date and time when the order was created in Shopify's system. Example: - created_at:2020-10-21T23:39:20Z - created_at:...
`query.credit_card_last4`	string	No	Filter by the last four digits of the payment card that was used to pay for the order. This filter matches only the last four digits of the...
`query.current_total_price`	number	No	Filter by the current total price of the order in the shop currency, including any returns/refunds/removals. This filter supports both exact...
`query.customer_id`	id	No	Filter orders by the customer id field. Example:...
`query.default`	string	No	Filter by a case-insensitive search of multiple fields in a document. Example: - query=Bob Norman - query=title:green hoodie
`query.delivery_method`	enum	No	Filter by the delivery [methodType](https://shopify.dev/api/admin-graphql/2024-07/objects/DeliveryMethod#field-DeliveryMethod.fields.metho... Values: shipping, pick-up, retail, local, pickup-point
`query.discount_code`	string	No	Filter by the case-insensitive discount code that was applied to the order at checkout. Limited to the first discount code used on an order....
`query.email`	string	No	Filter by the email address that's associated with the order to provide customer support or analyze purchasing patterns. Example: - email:e...
`query.financial_status`	enum	No	Filter by the order [displayFinancialStatus](https://shopify.dev/api/admin-graphql/latest/objects/Order#field-Order.fields.displayFinancia... Values: paid, pending, authorized, partially_paid, partially_refunded
`query.fraud_protection_level`	enum	No	Filter by the level of fraud protection that's applied to the order. Use this filter to manage risk or handle disputes. Example: - fraud_pr... Values: fully_protected, partially_protected, not_protected, pending, not_eligible
`query.fulfillment_location_id`	id	No	Filter by the fulfillment location [id](https://shopify.dev/api/admin-graphql/latest/objects/Fulfillment#field-Fulfillment.fields.location...
`query.fulfillment_status`	enum	No	Filter by the [displayFulfillmentStatus](https://shopify.dev/docs/api/admin-graphql/latest/objects/Order#field-Order.fields.displayFulfill... Values: unshipped, shipped, fulfilled, partial, scheduled
`query.gateway`	string	No	Filter by the [paymentGatewayNames](https://shopify.dev/docs/api/admin-graphql/latest/objects/Order#field-Order.fields.paymentGatewayNames...
`query.id`	id	No	Filter by id range. Example: - id:1234 - id:>=1234 - id:<=1234
`query.location_id`	id	No	Filter by the location id that's associated...
`query.metafields.{namespace}.{key}`	string	No	Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about [querying by metafield value](https:/...
`query.name`	string	No	Filter by the order name field. Example: - name:1001-A
`query.payment_id`	string	No	Filter by the payment ID that's associated with the order to reconcile financial records or troubleshoot payment issues. Example: - payment...
`query.payment_provider_id`	id	No	Filter by the ID of the payment provider that's associated with the order to manage payment methods or troubleshoot transactions. Example: -...
`query.po_number`	string	No	Filter by the order poNumber field. Example: - ...
`query.processed_at`	date	No	Filter by the order processedAt field. Exampl...
`query.reference_location_id`	id	No	Filter by the ID of a location that's associated with the order, such as locations from fulfillments, refunds, or the shop's primary locatio...
`query.return_status`	enum	No	Filter by the order's returnStatus to monito... Values: return_requested, in_progress, inspection_complete, returned, return_failed
`query.risk_level`	enum	No	Filter by the order risk assessment [riskLevel](https://shopify.dev/api/admin-graphql/latest/objects/OrderRiskAssessment#field-OrderRiskAs... Values: high, medium, low, none, pending
`query.sales_channel`	string	No	Filter by the sales channel where the order was made to analyze performance or manage...
`query.sku`	string	No	Filter by the product variant sku f...
`query.source_identifier`	string	No	Filter by the ID of the order placed on the originating platform, such as a unique POS or third-party identifier. This value doesn't corresp...
`query.source_name`	string	No	Filter by the platform where the order was placed to distinguish between web orders, POS sales, draft orders, or third-party channels. Use t...
`query.status`	enum	No	Filter by the order's status to manage workflows or analyze the order lifecycle. Example: - status:open Values: open, closed, cancelled, not_closed
`query.subtotal_line_items_quantity`	string	No	Filter by the total number of items across all line items in an order. This filter supports both exact values and ranges, and is useful for...
`query.tag`	string	No	Filter objects by the tag field. Example: - tag:my_tag
`query.tag_not`	string	No	Filter by objects that don’t have the specified tag. Example: - tag_not:my_tag
`query.test`	boolean	No	Filter by test orders. Test orders are made using the [Shopify Bogus Gateway](https://help.shopify.com/manual/checkout-settings/test-orders/...
`query.total_weight`	string	No	Filter by the order weight. This filter supports both exact values and ranges, and is to be used to filter orders by the total weight of all...
`query.updated_at`	date	No	Filter by the date and time when the order was last updated in Shopify's system. Example: - updated_at:2020-10-21T23:39:20Z - update...
`savedSearchId`	string	No	The ID of a saved search. The search’s query string is used as...

Data returned in Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`happenedAt` default	date	—	-
`id` default	id	—	-
`reason` default	enum	—	-
`content` default	string	—	-
`dismissibleHandle` default	string	—	-
`icon` default	enum	—	-
`severity` default	enum	—	-
`title` default	string	—	-
`id` default	id	—	-
`name` default	string	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`company` default	string	—	-
`coordinatesValidated` default	boolean	—	-
`country` default	string	—	-
`countryCode` default	string	—	-
`countryCodeV2` default	enum	—	-
`firstName` default	string	—	-
`formattedArea` default	string	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`latitude` default	number	—	-
`longitude` default	number	—	-
`name` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`provinceCode` default	string	—	-
`timeZone` default	string	—	-
`validationResultSummary` default	enum	—	-
`zip` default	string	—	-
`billingAddressMatchesShippingAddress` default	boolean	—	-
`staffNote` default	string	—	-
`cancelledAt` default	date	—	-
`cancelReason` default	enum	—	-
`canMarkAsPaid` default	boolean	—	-
`canNotifyCustomer` default	boolean	—	-
`capturable` default	boolean	—	-
`cartDiscountAmount` default	string	—	-
`handle` default	string	—	-
`id` default	id	—	-
`name` default	string	—	-
`overviewPath` default	string	—	-
`supportsFuturePublishing` default	boolean	—	-
`channelId` default	id	—	-
`displayName` default	string	—	-
`id` default	id	—	-
`clientIp` default	string	—	-
`closed` default	boolean	—	-
`closedAt` default	date	—	-
`confirmationNumber` default	string	—	-
`confirmed` default	boolean	—	-
`createdAt` default	date	—	-
`currencyCode` default	enum	—	-
`currentSubtotalLineItemsQuantity` default	number	—	-
`channelLiable` default	boolean	—	-
`price` default	string	—	-
`rate` default	number	—	-
`ratePercentage` default	number	—	-
`source` default	string	—	-
`title` default	string	—	-
`currentTotalWeight` default	string	—	-
`key` default	string	—	-
`value` default	string	—	-
`canDelete` default	boolean	—	-
`createdAt` default	date	—	-
`dataSaleOptOut` default	boolean	—	-
`displayName` default	string	—	-
`email` default	string	—	-
`firstName` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`lifetimeDuration` default	string	—	-
`locale` default	string	—	-
`multipassIdentifier` default	string	—	-
`note` default	string	—	-
`numberOfOrders` default	string	—	-
`phone` default	string	—	-
`productSubscriberStatus` default	enum	—	-
`state` default	enum	—	-
`tags` default	string[]	—	-
`taxExempt` default	boolean	—	-
`taxExemptions` default	string	—	-
`unsubscribeUrl` default	string	—	-
`updatedAt` default	date	—	-
`validEmailAddress` default	boolean	—	-
`verifiedEmail` default	boolean	—	-
`customerAcceptsMarketing` default	boolean	—	-
`customerOrderIndex` default	number	—	-
`daysToConversion` default	number	—	-
`customerOrderIndex` default	number	—	-
`daysToConversion` default	number	—	-
`ready` default	boolean	—	-
`customerLocale` default	string	—	-
`allocationMethod` default	enum	—	-
`index` default	number	—	-
`targetSelection` default	enum	—	-
`targetType` default	enum	—	-
`title` default	string	—	-
`discountCode` default	string	—	-
`discountCodes` default	string[]	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`company` default	string	—	-
`coordinatesValidated` default	boolean	—	-
`country` default	string	—	-
`countryCode` default	string	—	-
`countryCodeV2` default	enum	—	-
`firstName` default	string	—	-
`formattedArea` default	string	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`latitude` default	number	—	-
`longitude` default	number	—	-
`name` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`provinceCode` default	string	—	-
`timeZone` default	string	—	-
`validationResultSummary` default	enum	—	-
`zip` default	string	—	-
`displayFinancialStatus` default	enum	—	-
`displayFulfillmentStatus` default	enum	—	-
`id` default	id	—	-
`initiatedAs` default	enum	—	-
`status` default	enum	—	-
`dutiesIncluded` default	boolean	—	-
`edited` default	boolean	—	-
`email` default	string	—	-
`estimatedTaxes` default	boolean	—	-
`action` default	string	—	-
`additionalContent` default	string	—	-
`additionalData` default	string	—	-
`appTitle` default	string	—	-
`arguments` default	string	—	-
`attributeToApp` default	boolean	—	-
`attributeToUser` default	boolean	—	-
`author` default	string	—	-
`createdAt` default	date	—	-
`criticalAlert` default	boolean	—	-
`hasAdditionalContent` default	boolean	—	-
`id` default	id	—	-
`message` default	string	—	-
`secondaryMessage` default	string	—	-
`subjectId` default	string	—	-
`subjectType` default	enum	—	-
`completedAt` default	date	—	-
`createdAt` default	date	—	-
`id` default	id	—	-
`mirrored` default	boolean	—	-
`note` default	string	—	-
`fulfillable` default	boolean	—	-
`channelId` default	id	—	-
`createdAt` default	date	—	-
`fulfillAt` default	date	—	-
`fulfillBy` default	date	—	-
`id` default	id	→ fulfillmentOrders	-
`orderId` default	id	→ orders	-
`orderName` default	string	—	-
`orderProcessedAt` default	date	—	-
`requestStatus` default	enum	—	-
`status` default	enum	—	-
`updatedAt` default	date	—	-
`createdAt` default	date	—	-
`deliveredAt` default	date	—	-
`displayStatus` default	enum	—	-
`estimatedDeliveryAt` default	date	—	-
`id` default	id	—	-
`inTransitAt` default	date	—	-
`name` default	string	—	-
`requiresShipping` default	boolean	—	-
`status` default	enum	—	-
`totalQuantity` default	number	—	-
`updatedAt` default	date	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`fullyPaid` default	boolean	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	→ orders	-
`landingPageDisplayText` default	string	—	-
`landingPageUrl` default	string	—	-
`canRestock` default	boolean	—	-
`currentQuantity` default	number	—	-
`discountedTotal` default	string	—	-
`discountedUnitPrice` default	string	—	-
`fulfillableQuantity` default	number	—	-
`fulfillmentStatus` default	string	—	-
`id` default	id	—	-
`isGiftCard` default	boolean	—	-
`merchantEditable` default	boolean	—	-
`name` default	string	—	-
`nonFulfillableQuantity` default	number	—	-
`originalTotal` default	string	—	-
`originalUnitPrice` default	string	—	-
`quantity` default	number	—	-
`refundableQuantity` default	number	—	-
`requiresShipping` default	boolean	—	-
`restockable` default	boolean	—	-
`sku` default	string	—	-
`taxable` default	boolean	—	-
`title` default	string	—	-
`totalDiscount` default	string	—	-
`unfulfilledDiscountedTotal` default	string	—	-
`unfulfilledOriginalTotal` default	string	—	-
`unfulfilledQuantity` default	number	—	-
`variantTitle` default	string	—	-
`vendor` default	string	—	-
`countryCode` default	enum	—	-
`key` default	enum	—	-
`purpose` default	enum	—	-
`title` default	string	—	-
`value` default	string	—	-
`countryCode` default	enum	—	-
`key` default	enum	—	-
`purpose` default	enum	—	-
`title` default	string	—	-
`value` default	string	—	-
`archived` default	boolean	—	-
`companyName` default	string	—	-
`displayName` default	string	—	-
`id` default	id	—	-
`primary` default	boolean	—	-
`merchantEditable` default	boolean	—	-
`merchantEditableErrors` default	string[]	—	-
`id` default	id	—	-
`name` default	string	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`description` default	string	—	-
`id` default	id	—	-
`key` default	string	—	-
`name` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`pinnedPosition` default	number	—	-
`useAsCollectionCondition` default	boolean	—	-
`validationStatus` default	enum	—	-
`compareDigest` default	string	—	-
`createdAt` default	date	—	-
`description` default	string	—	-
`id` default	id	—	-
`jsonValue` default	string	—	-
`key` default	string	—	-
`namespace` default	string	—	-
`ownerType` default	enum	—	-
`type` default	string	—	-
`updatedAt` default	date	—	-
`value` default	string	—	-
`name` default	string	—	-
`netPayment` default	string	—	-
`canRestock` default	boolean	—	-
`currentQuantity` default	number	—	-
`discountedTotal` default	string	—	-
`discountedUnitPrice` default	string	—	-
`fulfillableQuantity` default	number	—	-
`fulfillmentStatus` default	string	—	-
`id` default	id	—	-
`isGiftCard` default	boolean	—	-
`merchantEditable` default	boolean	—	-
`name` default	string	—	-
`nonFulfillableQuantity` default	number	—	-
`originalTotal` default	string	—	-
`originalUnitPrice` default	string	—	-
`quantity` default	number	—	-
`refundableQuantity` default	number	—	-
`requiresShipping` default	boolean	—	-
`restockable` default	boolean	—	-
`sku` default	string	—	-
`taxable` default	boolean	—	-
`title` default	string	—	-
`totalDiscount` default	string	—	-
`unfulfilledDiscountedTotal` default	string	—	-
`unfulfilledOriginalTotal` default	string	—	-
`unfulfilledQuantity` default	number	—	-
`variantTitle` default	string	—	-
`vendor` default	string	—	-
`note` default	string	—	-
`number` default	number	—	-
`additionalPaymentCollectionUrl` default	string	—	-
`paymentGatewayNames` default	string[]	—	-
`due` default	boolean	—	-
`dueInDays` default	number	—	-
`id` default	id	—	-
`overdue` default	boolean	—	-
`paymentTermsName` default	string	—	-
`paymentTermsType` default	enum	—	-
`translatedName` default	string	—	-
`phone` default	string	—	-
`activatable` default	boolean	—	-
`addressVerified` default	boolean	—	-
`createdAt` default	date	—	-
`deactivatable` default	boolean	—	-
`deactivatedAt` default	string	—	-
`deletable` default	boolean	—	-
`fulfillsOnlineOrders` default	boolean	—	-
`hasActiveInventory` default	boolean	—	-
`hasUnfulfilledOrders` default	boolean	—	-
`id` default	id	—	-
`isActive` default	boolean	—	-
`isFulfillmentService` default	boolean	—	-
`isPrimary` default	boolean	—	-
`name` default	string	—	-
`shipsInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`poNumber` default	string	—	-
`presentmentCurrencyCode` default	enum	—	-
`processedAt` default	date	—	-
`productNetwork` default	boolean	—	-
`autoPublish` default	boolean	—	-
`id` default	id	—	-
`name` default	string	—	-
`supportsFuturePublishing` default	boolean	—	-
`canDelete` default	boolean	—	-
`createdAt` default	date	—	-
`dataSaleOptOut` default	boolean	—	-
`displayName` default	string	—	-
`email` default	string	—	-
`firstName` default	string	—	-
`hasTimelineComment` default	boolean	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`lifetimeDuration` default	string	—	-
`locale` default	string	—	-
`multipassIdentifier` default	string	—	-
`note` default	string	—	-
`numberOfOrders` default	string	—	-
`phone` default	string	—	-
`productSubscriberStatus` default	enum	—	-
`state` default	enum	—	-
`tags` default	string[]	—	-
`taxExempt` default	boolean	—	-
`taxExemptions` default	string	—	-
`unsubscribeUrl` default	string	—	-
`updatedAt` default	date	—	-
`validEmailAddress` default	boolean	—	-
`verifiedEmail` default	boolean	—	-
`referralCode` default	string	—	-
`referrerDisplayText` default	string	—	-
`referrerUrl` default	string	—	-
`refundable` default	boolean	—	-
`createdAt` default	date	—	-
`id` default	id	—	-
`note` default	string	—	-
`processedAt` default	date	—	-
`updatedAt` default	date	—	-
`registeredSourceUrl` default	string	—	-
`requiresShipping` default	boolean	—	-
`restockable` default	boolean	—	-
`activatable` default	boolean	—	-
`addressVerified` default	boolean	—	-
`createdAt` default	date	—	-
`deactivatable` default	boolean	—	-
`deactivatedAt` default	string	—	-
`deletable` default	boolean	—	-
`fulfillsOnlineOrders` default	boolean	—	-
`hasActiveInventory` default	boolean	—	-
`hasUnfulfilledOrders` default	boolean	—	-
`id` default	id	—	-
`isActive` default	boolean	—	-
`isFulfillmentService` default	boolean	—	-
`isPrimary` default	boolean	—	-
`name` default	string	—	-
`shipsInventory` default	boolean	—	-
`updatedAt` default	date	—	-
`closedAt` default	date	—	-
`createdAt` default	date	—	-
`id` default	id	—	-
`name` default	string	—	-
`requestApprovedAt` default	date	—	-
`status` default	enum	—	-
`totalQuantity` default	number	—	-
`returnStatus` default	enum	—	-
`recommendation` default	enum	—	-
`riskLevel` default	enum	—	-
`display` default	boolean	—	-
`level` default	enum	—	-
`message` default	string	—	-
`address1` default	string	—	-
`address2` default	string	—	-
`city` default	string	—	-
`company` default	string	—	-
`coordinatesValidated` default	boolean	—	-
`country` default	string	—	-
`countryCode` default	string	—	-
`countryCodeV2` default	enum	—	-
`firstName` default	string	—	-
`formattedArea` default	string	—	-
`id` default	id	—	-
`lastName` default	string	—	-
`latitude` default	number	—	-
`longitude` default	number	—	-
`name` default	string	—	-
`phone` default	string	—	-
`province` default	string	—	-
`provinceCode` default	string	—	-
`timeZone` default	string	—	-
`validationResultSummary` default	enum	—	-
`zip` default	string	—	-
`carrierIdentifier` default	string	—	-
`code` default	string	—	-
`custom` default	boolean	—	-
`deliveryCategory` default	string	—	-
`id` default	id	—	-
`isRemoved` default	boolean	—	-
`phone` default	string	—	-
`price` default	string	—	-
`shippingRateHandle` default	string	—	-
`source` default	string	—	-
`title` default	string	—	-
`carrierIdentifier` default	string	—	-
`code` default	string	—	-
`custom` default	boolean	—	-
`deliveryCategory` default	string	—	-
`id` default	id	—	-
`isRemoved` default	boolean	—	-
`phone` default	string	—	-
`price` default	string	—	-
`shippingRateHandle` default	string	—	-
`source` default	string	—	-
`title` default	string	—	-
`status` default	enum	—	-
`sourceIdentifier` default	string	—	-
`sourceName` default	string	—	-
`accountType` default	enum	—	-
`active` default	boolean	—	-
`email` default	string	—	-
`exists` default	boolean	—	-
`firstName` default	string	—	-
`id` default	id	—	-
`initials` default	string[]	—	-
`isShopOwner` default	boolean	—	-
`lastName` default	string	—	-
`locale` default	string	—	-
`name` default	string	—	-
`phone` default	string	—	-
`subtotalLineItemsQuantity` default	number	—	-
`subtotalPrice` default	string	—	-
`amount` default	string	—	-
`maximumRefundable` default	string	—	-
`subtotal` default	string	—	-
`totalTaxes` default	string	—	-
`tags` default	string[]	—	-
`taxesIncluded` default	boolean	—	-
`taxExempt` default	boolean	—	-
`channelLiable` default	boolean	—	-
`price` default	string	—	-
`rate` default	number	—	-
`ratePercentage` default	number	—	-
`source` default	string	—	-
`title` default	string	—	-
`test` default	boolean	—	-
`totalCapturable` default	string	—	-
`totalDiscounts` default	string	—	-
`totalPrice` default	string	—	-
`totalReceived` default	string	—	-
`totalRefunded` default	string	—	-
`totalShippingPrice` default	string	—	-
`totalTax` default	string	—	-
`amount` default	number	—	-
`currencyCode` default	enum	—	-
`totalWeight` default	string	—	-
`accountNumber` default	string	—	-
`amount` default	string	—	-
`authorizationCode` default	string	—	-
`authorizationExpiresAt` default	date	—	-
`createdAt` default	date	—	-
`errorCode` default	enum	—	-
`formattedGateway` default	string	—	-
`gateway` default	string	—	-
`id` default	id	—	-
`kind` default	enum	—	-
`manuallyCapturable` default	boolean	—	-
`manualPaymentGateway` default	boolean	—	-
`maximumRefundable` default	string	—	-
`multiCapturable` default	boolean	—	-
`paymentId` default	string	—	-
`paymentMethod` default	enum	—	-
`processedAt` default	date	—	-
`receiptJson` default	string	—	-
`settlementCurrency` default	enum	—	-
`settlementCurrencyRate` default	number	—	-
`status` default	enum	—	-
`test` default	boolean	—	-
`totalUnsettled` default	string	—	-
`count` default	number	—	-
`precision` default	enum	—	-
`unpaid` default	boolean	—	-
`updatedAt` default	date	—	-

Edit

Update Order

Update an existing order in Shopify.

Route: PATCH /orders/{id}

Inputs you can set

Name	Type	Required	Description
`input.customAttributes.key`	string	Yes	-
`input.customAttributes.value`	string	Yes	-
`input.email`	string	No	-
`input.id`	string	Yes	-
`input.localizedFields.key`	enum	Yes	Values: TAX_CREDENTIAL_BR, SHIPPING_CREDENTIAL_BR, TAX_CREDENTIAL_CL, SHIPPING_CREDENTIAL_CL, SHIPPING_CREDENTIAL_CN
`input.localizedFields.value`	string	Yes	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-
`input.metafields.namespace`	string	No	-
`input.metafields.type`	string	No	-
`input.metafields.value`	string	No	-
`input.note`	string	No	-
`input.phone`	string	No	-
`input.poNumber`	string	No	-
`input.shippingAddress.address1`	string	No	-
`input.shippingAddress.address2`	string	No	-
`input.shippingAddress.city`	string	No	-
`input.shippingAddress.company`	string	No	-
`input.shippingAddress.countryCode`	enum	No	Values: AF, AX, AL, DZ, AD
`input.shippingAddress.firstName`	string	No	-
`input.shippingAddress.lastName`	string	No	-
`input.shippingAddress.phone`	string	No	-
`input.shippingAddress.provinceCode`	string	No	-
`input.shippingAddress.zip`	string	No	-
`input.tags`	string[]	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Order

Delete an existing order in Shopify.

Route: DELETE /orders/{id}

Inputs you can set

Name	Type	Required	Description
`orderId`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.