Connexion Shopify pour LinkyFlow

LinkyFlow connecte Excel a Shopify pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

73660

Workflows a ramener dans Excel

Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.

B2B

Company

Companies data in Shopify.

Utilise comme filtre par

List Catalogs · query.company_id

List Company Locations · query.company_id

Lecture

List Companies

Fetch companies from Shopify.

Route: GET /companies

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

Entrees configurables

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	-

Donnees retournees dans 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.

Utilise comme filtre par

List Catalogs · query.company_location_id

Lecture

List Company Locations

Fetch company locations from Shopify.

Route: GET /companyLocations

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

Entrees configurables

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	-

Donnees retournees dans 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.

Lecture

List Catalogs

Fetch catalogs from Shopify.

Route: GET /catalogs

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

Entrees configurables

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	-

Donnees retournees dans 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	—	-

Modification

Delete Catalog

Delete an existing catalog in Shopify.

Route: DELETE /catalogs/{id}

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Collection

Collections data in Shopify.

Utilise comme filtre par

List Product Variants · query.collection

List Products · query.collection_id

Lecture

List Collections

Fetch collections from Shopify.

Route: GET /collections

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

Entrees configurables

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...

Donnees retournees dans 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	—	-

Creation

Create Collection

Create a new collection in Shopify.

Route: POST /collections

Entrees configurables

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	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Collection

Update an existing collection in Shopify.

Route: PATCH /collections/{id}

Entrees configurables

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	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Collection

Delete an existing collection in Shopify.

Route: DELETE /collections/{id}

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Price List

Price Lists data in Shopify.

Lecture

List Price Lists

Fetch price lists from Shopify.

Route: GET /priceLists

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

Entrees configurables

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

Donnees retournees dans 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	—	-

Creation

Create Price List

Create a new price list in Shopify.

Route: POST /priceLists

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Price List

Update an existing price list in Shopify.

Route: PATCH /priceLists/{id}

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Price List

Delete an existing price list in Shopify.

Route: DELETE /priceLists/{id}

Entrees configurables

Name	Type	Required	Description
`id`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product

Products in Shopify catalog.

Utilise comme filtre par

List Collections · query.product_id

List Product Variants · query.product_id

List Product Variants · query.product_ids

Lecture

List Products

Fetch products from Shopify.

Route: GET /products

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

Entrees configurables

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...

Donnees retournees dans 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	—	-

Creation

Create Product

Create a new product in Shopify.

Route: POST /products

Entrees configurables

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	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Product

Update an existing product in Shopify.

Route: PATCH /products/{id}

Entrees configurables

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	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Product

Delete an existing product in Shopify.

Route: DELETE /products/{id}

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Option

Product Options data in Shopify.

Creation

Create Product Option

Create a new product option in Shopify.

Route: POST /productOptions

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Set

Products managed through Shopify productSet mutation.

Creation

Create Product Set

Create a new product set in Shopify.

Route: POST /productSets

Entrees configurables

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	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Variant

Product Variants data in Shopify.

Utilise comme filtre par

List Products · query.variant_id

Lecture

List Product Variants

Fetch product variants from Shopify.

Route: GET /productVariants

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

Entrees configurables

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...

Donnees retournees dans 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	—	-

Creation

Create Product Variant

Create a new product variant in Shopify.

Route: POST /productVariants

Entrees configurables

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	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Publication

Publications data in Shopify.

Utilise comme filtre par

List Products · query.publication_ids

Lecture

List Publications

Fetch publications from Shopify.

Route: GET /publications

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

Entrees configurables

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

Donnees retournees dans 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.

Lecture

List Selling Plan Groups

Fetch selling plan groups from Shopify.

Route: GET /sellingPlanGroups

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

Entrees configurables

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	-

Donnees retournees dans 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.

Lecture

List Segments

Fetch segments from Shopify.

Route: GET /segments

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

Entrees configurables

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	-

Donnees retournees dans 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.

Lecture

List Inventory Items

Fetch inventory items from Shopify.

Route: GET /inventoryItems

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

Entrees configurables

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	-

Donnees retournees dans 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.

Utilise comme filtre par

List Locations · query.location_id

List Orders · query.location_id

List Product Variants · query.location_id

Lecture

List Locations

Fetch locations from Shopify.

Route: GET /locations

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

Entrees configurables

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

Donnees retournees dans 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.

Lecture

List Delivery Customizations

Fetch delivery customizations from Shopify.

Route: GET /deliveryCustomizations

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

Entrees configurables

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

Donnees retournees dans 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.

Utilise comme filtre par

List Product Variants · query.delivery_profile_id

List Products · query.delivery_profile_id

Lecture

List Delivery Profiles

Fetch delivery profiles from Shopify.

Route: GET /deliveryProfiles

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

Entrees configurables

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

Donnees retournees dans 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.

Lecture

List Marketing Activities

Fetch marketing activities from Shopify.

Route: GET /marketingActivities

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

Entrees configurables

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...

Donnees retournees dans 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.

Utilise comme filtre par

List Catalogs · query.market_id

Lecture

List Markets

Fetch markets from Shopify.

Route: GET /markets

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

Entrees configurables

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	-

Donnees retournees dans 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.

Lecture

List Draft Orders

Fetch draft orders from Shopify.

Route: GET /draftOrders

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

Entrees configurables

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...

Donnees retournees dans 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	—	-

Modification

Update Draft Order

Update an existing draft order in Shopify.

Route: PATCH /draftOrders/{id}

Entrees configurables

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	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Draft Order

Delete an existing draft order in Shopify.

Route: DELETE /draftOrders/{id}

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Fulfillment Order

Fulfillment Orders data in Shopify.

Lecture

List Fulfillment Orders

Fetch fulfillment orders from Shopify.

Route: GET /fulfillmentOrders

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

Entrees configurables

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	-

Donnees retournees dans 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.

Lecture

List Manual Holds Fulfillment Orders

Fetch manual holds fulfillment orders from Shopify.

Route: GET /manualHoldsFulfillmentOrders

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

Entrees configurables

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

Donnees retournees dans 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.

Lecture

List Orders

Fetch orders from Shopify.

Route: GET /orders

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

Entrees configurables

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...

Donnees retournees dans 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	—	-

Modification

Update Order

Update an existing order in Shopify.

Route: PATCH /orders/{id}

Entrees configurables

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	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Order

Delete an existing order in Shopify.

Route: DELETE /orders/{id}

Entrees configurables

Name	Type	Required	Description
`orderId`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.