Shopify connection for LinkyFlow

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

Resources

Read requests

Write actions

Documented fields

73660

Workflows you can move into Excel

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

B2B

Company

Companies data in Shopify.

Read

List Companies

Fetch companies from Shopify.

Route: GET /companies

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list by the given key. Values: CREATED_AT, ID, NAME, ORDER_COUNT, SINCE_DATE
`query.active_customers_count`	number	No	-

+9 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`contactCount` default	number	-
`contactRoles.nodes.id` default	id	-
`contactRoles.nodes.name` default	string	-
`contactRoles.nodes.note` default	string	-
`contacts.nodes.createdAt` default	date	-
`contacts.nodes.id` default	id	-
`contacts.nodes.isMainContact` default	boolean	-
`contacts.nodes.lifetimeDuration` default	string	-
`contacts.nodes.locale` default	string	-
`contacts.nodes.title` default	string	-

+196 more fields available in this connection

Company Location

Company Locations data in Shopify.

Read

List Company Locations

Fetch company locations from Shopify.

Route: GET /companyLocations

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list by the given key. Values: COMPANY_AND_LOCATION_NAME, COMPANY_ID, CREATED_AT, ID, NAME
`query.company_id`	id	No	-

+8 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`billingAddress.address1` default	string	-
`billingAddress.address2` default	string	-
`billingAddress.city` default	string	-
`billingAddress.companyName` default	string	-
`billingAddress.country` default	string	-
`billingAddress.countryCode` default	enum	-
`billingAddress.createdAt` default	date	-
`billingAddress.firstName` default	string	-
`billingAddress.formattedArea` default	string	-
`billingAddress.id` default	id	-

+229 more fields available in this connection

Catalog

Catalogs data in Shopify.

Read

List Catalogs

Fetch catalogs from Shopify.

Route: GET /catalogs

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

Inputs you can set

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

+9 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`apps.nodes.apiKey` default	string	-
`apps.nodes.appStoreAppUrl` default	string	-
`apps.nodes.appStoreDeveloperUrl` default	string	-
`apps.nodes.description` default	string	-
`apps.nodes.developerName` default	string	-
`apps.nodes.developerType` default	enum	-
`apps.nodes.developerUrl` default	string	-
`apps.nodes.embedded` default	boolean	-
`apps.nodes.features` default	string[]	-
`apps.nodes.handle` default	string	-

+29 more fields available in this connection

Edit

Delete Catalog

Delete an existing catalog in Shopify.

Route: DELETE /catalogs/{id}

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Collection

Collections data in Shopify.

Read

List Collections

Fetch collections from Shopify.

Route: GET /collections

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

Inputs you can set

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

+11 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`availablePublicationsCount.count` default	number	-
`availablePublicationsCount.precision` default	enum	-
`descriptionHtml` default	string	-
`events.nodes.action` default	string	-
`events.nodes.additionalContent` default	string	-
`events.nodes.additionalData` default	string	-
`events.nodes.appTitle` default	string	-
`events.nodes.arguments` default	string	-
`events.nodes.attributeToApp` default	boolean	-
`events.nodes.attributeToUser` default	boolean	-

+111 more fields available in this connection

Create

Create Collection

Create a new collection in Shopify.

Route: POST /collections

Inputs you can set

Name	Type	Required	Description
`input.descriptionHtml`	string	No	-
`input.handle`	string	No	-
`input.id`	string	No	-
`input.image.altText`	string	No	-
`input.image.id`	string	No	-
`input.image.src`	string	No	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-

+15 more inputs available in this connection

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Collection

Update an existing collection in Shopify.

Route: PATCH /collections/{id}

Inputs you can set

Name	Type	Required	Description
`input.descriptionHtml`	string	No	-
`input.handle`	string	No	-
`input.id`	string	No	-
`input.image.altText`	string	No	-
`input.image.id`	string	No	-
`input.image.src`	string	No	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-

+15 more inputs available in this connection

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Collection

Delete an existing collection in Shopify.

Route: DELETE /collections/{id}

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Price List

Price Lists data in Shopify.

Read

List Price Lists

Fetch price lists from Shopify.

Route: GET /priceLists

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

Inputs you can set

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

Data returned in Excel

Field	Type	Description
`catalog.id` default	id	-
`catalog.status` default	enum	-
`catalog.title` default	string	-
`currency` default	enum	-
`fixedPricesCount` default	number	-
`id` default	id	-
`name` default	string	-
`prices.nodes.originType` default	enum	-
`quantityRules.nodes.increment` default	number	-
`quantityRules.nodes.isDefault` default	boolean	-

+3 more fields available in this connection

Create

Create Price List

Create a new price list in Shopify.

Route: POST /priceLists

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Price List

Update an existing price list in Shopify.

Route: PATCH /priceLists/{id}

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Price List

Delete an existing price list in Shopify.

Route: DELETE /priceLists/{id}

Inputs you can set

Name	Type	Required	Description
`id`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product

Products in Shopify catalog.

Read

List Products

Fetch products from Shopify.

Route: GET /products

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

Inputs you can set

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

+36 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`availablePublicationsCount.count` default	number	-
`availablePublicationsCount.precision` default	enum	-
`bodyHtml` default	string	-
`bundleComponents.nodes.quantity` default	number	-
`bundleConsolidatedOptions.name` default	string	-
`category.ancestorIds` default	string[]	-
`category.childrenIds` default	string[]	-
`category.fullName` default	string	-
`category.id` default	id	-
`category.isArchived` default	boolean	-

+226 more fields available in this connection

Create

Create Product

Create a new product in Shopify.

Route: POST /products

Inputs you can set

Name	Type	Required	Description
`media.alt`	string	No	-
`media.mediaContentType`	enum	Yes	Values: VIDEO, EXTERNAL_VIDEO, MODEL_3D, IMAGE
`media.originalSource`	string	Yes	-
`product.category`	string	No	-
`product.claimOwnership.bundles`	boolean	No	-
`product.collectionsToJoin`	string[]	No	-
`product.combinedListingRole`	enum	No	Values: PARENT, CHILD
`product.descriptionHtml`	string	No	-

+24 more inputs available in this connection

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Product

Update an existing product in Shopify.

Route: PATCH /products/{id}

Inputs you can set

Name	Type	Required	Description
`media.alt`	string	No	-
`media.mediaContentType`	enum	Yes	Values: VIDEO, EXTERNAL_VIDEO, MODEL_3D, IMAGE
`media.originalSource`	string	Yes	-
`product.category`	string	No	-
`product.collectionsToJoin`	string[]	No	-
`product.collectionsToLeave`	string[]	No	-
`product.deleteConflictingConstrainedMetafields`	boolean	No	-
`product.descriptionHtml`	string	No	-

+18 more inputs available in this connection

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Product

Delete an existing product in Shopify.

Route: DELETE /products/{id}

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product Option

Product Options data in Shopify.

Create

Create Product Option

Create a new product option in Shopify.

Route: POST /productOptions

Inputs you can set

Name	Type	Required	Description
`options.linkedMetafield.key`	string	Yes	-
`options.linkedMetafield.namespace`	string	Yes	-
`options.linkedMetafield.values`	string[]	No	-
`options.name`	string	No	-
`options.position`	number	No	-
`options.values.linkedMetafieldValue`	string	No	-
`options.values.name`	string	No	-
`productId`	string	Yes	-

+1 more inputs available in this connection

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product Set

Products managed through Shopify productSet mutation.

Create

Create Product Set

Create a new product set in Shopify.

Route: POST /productSets

Inputs you can set

Name	Type	Required	Description
`identifier.customId.key`	string	Yes	-
`identifier.customId.namespace`	string	No	-
`identifier.customId.value`	string	Yes	-
`identifier.handle`	string	No	-
`identifier.id`	string	No	-
`input.category`	string	No	-
`input.claimOwnership.bundles`	boolean	No	-
`input.collections`	string[]	No	-

+81 more inputs available in this connection

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product Variant

Product Variants data in Shopify.

Read

List Product Variants

Fetch product variants from Shopify.

Route: GET /productVariants

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

Inputs you can set

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

+30 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`availableForSale` default	boolean	-
`barcode` default	string	-
`compareAtPrice` default	string	-
`createdAt` default	date	-
`deliveryProfile.activeMethodDefinitionsCount` default	number	-
`deliveryProfile.default` default	boolean	-
`deliveryProfile.id` default	id	-
`deliveryProfile.legacyMode` default	boolean	-
`deliveryProfile.locationsWithoutRatesCount` default	number	-
`deliveryProfile.name` default	string	-

+180 more fields available in this connection

Create

Create Product Variant

Create a new product variant in Shopify.

Route: POST /productVariants

Inputs you can set

Name	Type	Required	Description
`media.alt`	string	No	-
`media.mediaContentType`	enum	Yes	Values: VIDEO, EXTERNAL_VIDEO, MODEL_3D, IMAGE
`media.originalSource`	string	Yes	-
`productId`	string	Yes	-
`strategy`	enum	No	Values: DEFAULT, REMOVE_STANDALONE_VARIANT, PRESERVE_STANDALONE_VARIANT
`variants.barcode`	string	No	-
`variants.compareAtPrice`	string	No	-
`variants.id`	string	No	-

+39 more inputs available in this connection

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Publication

Publications data in Shopify.

Read

List Publications

Fetch publications from Shopify.

Route: GET /publications

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

Inputs you can set

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

Data returned in Excel

Field	Type	Description
`app.apiKey` default	string	-
`app.appStoreAppUrl` default	string	-
`app.appStoreDeveloperUrl` default	string	-
`app.description` default	string	-
`app.developerName` default	string	-
`app.developerType` default	enum	-
`app.developerUrl` default	string	-
`app.embedded` default	boolean	-
`app.features` default	string[]	-
`app.handle` default	string	-

+97 more fields available in this connection

Selling Plan Group

Selling Plan Groups data in Shopify.

Read

List Selling Plan Groups

Fetch selling plan groups from Shopify.

Route: GET /sellingPlanGroups

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

Inputs you can set

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

+7 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`appId` default	string	-
`createdAt` default	date	-
`description` default	string	-
`id` default	id	-
`merchantCode` default	string	-
`name` default	string	-
`options` default	string[]	-
`position` default	number	-
`products.nodes.bodyHtml` default	string	-
`products.nodes.combinedListingRole` default	enum	-

+64 more fields available in this connection

Customers

Segment

Segments data in Shopify.

Read

List Segments

Fetch segments from Shopify.

Route: GET /segments

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

Inputs you can set

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

+2 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`creationDate` default	date	-
`id` default	id	-
`lastEditDate` default	date	-
`name` default	string	-
`query` default	string	-

Inventory

Inventory Item

Inventory Items data in Shopify.

Read

List Inventory Items

Fetch inventory items from Shopify.

Route: GET /inventoryItems

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

Inputs you can set

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

+2 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`countryCodeOfOrigin` default	enum	-
`countryHarmonizedSystemCodes.nodes.countryCode` default	enum	-
`countryHarmonizedSystemCodes.nodes.harmonizedSystemCode` default	string	-
`createdAt` default	date	-
`duplicateSkuCount` default	number	-
`harmonizedSystemCode` default	string	-
`id` default	id	-
`inventoryHistoryUrl` default	string	-
`inventoryLevel.canDeactivate` default	boolean	-
`inventoryLevel.createdAt` default	date	-

+60 more fields available in this connection

Location

Locations data in Shopify.

Read

List Locations

Fetch locations from Shopify.

Route: GET /locations

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

Inputs you can set

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

+16 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`activatable` default	boolean	-
`address.address1` default	string	-
`address.address2` default	string	-
`address.city` default	string	-
`address.country` default	string	-
`address.countryCode` default	string	-
`address.formatted` default	string[]	-
`address.latitude` default	number	-
`address.longitude` default	number	-
`address.phone` default	string	-

+80 more fields available in this connection

Logistics

Delivery Customization

Delivery Customizations data in Shopify.

Read

List Delivery Customizations

Fetch delivery customizations from Shopify.

Route: GET /deliveryCustomizations

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

Inputs you can set

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

+1 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`enabled` default	boolean	-
`errorHistory.errorsFirstOccurredAt` default	date	-
`errorHistory.firstOccurredAt` default	date	-
`errorHistory.hasBeenSharedSinceLastError` default	boolean	-
`errorHistory.hasSharedRecentErrors` default	boolean	-
`functionId` default	string	-
`id` default	id	-
`metafield.compareDigest` default	string	-
`metafield.createdAt` default	date	-
`metafield.description` default	string	-

+38 more fields available in this connection

Delivery Profile

Delivery Profiles data in Shopify.

Read

List Delivery Profiles

Fetch delivery profiles from Shopify.

Route: GET /deliveryProfiles

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

Inputs you can set

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

Data returned in Excel

Field	Type	Description
`activeMethodDefinitionsCount` default	number	-
`default` default	boolean	-
`id` default	id	-
`legacyMode` default	boolean	-
`locationsWithoutRatesCount` default	number	-
`name` default	string	-
`originLocationCount` default	number	-
`productVariantsCount.count` default	number	-
`productVariantsCount.precision` default	enum	-
`productVariantsCountV2.capped` default	boolean	-

+45 more fields available in this connection

Marketing

Marketing Activity

Marketing Activities data in Shopify.

Read

List Marketing Activities

Fetch marketing activities from Shopify.

Route: GET /marketingActivities

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`marketingActivityIds`	string[]	No	The list of marketing activity IDs to filter by.
`remoteIds`	string[]	No	The list of remote IDs associated with marketing activities to filter by.
`utm`	string	No	The UTM parameters associated with marketing activities to filter by.
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.

+14 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`activityListUrl` default	string	-
`adSpend.amount` default	number	-
`adSpend.currencyCode` default	enum	-
`app.apiKey` default	string	-
`app.appStoreAppUrl` default	string	-
`app.appStoreDeveloperUrl` default	string	-
`app.description` default	string	-
`app.developerName` default	string	-
`app.developerType` default	enum	-
`app.developerUrl` default	string	-

+63 more fields available in this connection

Markets

Market

Markets data in Shopify.

Read

List Markets

Fetch markets from Shopify.

Route: GET /markets

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

Inputs you can set

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

+7 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`catalogs.nodes.id` default	id	-
`catalogs.nodes.status` default	enum	-
`catalogs.nodes.title` default	string	-
`catalogsCount.count` default	number	-
`catalogsCount.precision` default	enum	-
`conditions.conditionTypes` default	string	-
`currencySettings.localCurrencies` default	boolean	-
`currencySettings.roundingEnabled` default	boolean	-
`enabled` default	boolean	-
`handle` default	string	-

+49 more fields available in this connection

Sales

Draft Order

Draft Orders data in Shopify.

Read

List Draft Orders

Fetch draft orders from Shopify.

Route: GET /draftOrders

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

Inputs you can set

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

+8 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`acceptAutomaticDiscounts` default	boolean	-
`allowDiscountCodesInCheckout` default	boolean	-
`allVariantPricesOverridden` default	boolean	-
`anyVariantPricesOverridden` default	boolean	-
`appliedDiscount.amount` default	string	-
`appliedDiscount.description` default	string	-
`appliedDiscount.title` default	string	-
`appliedDiscount.value` default	number	-
`appliedDiscount.valueType` default	enum	-
`billingAddress.address1` default	string	-

+298 more fields available in this connection

Edit

Update Draft Order

Update an existing draft order in Shopify.

Route: PATCH /draftOrders/{id}

Inputs you can set

Name	Type	Required	Description
`id`	string	Yes	-
`input.acceptAutomaticDiscounts`	boolean	No	-
`input.allowDiscountCodesInCheckout`	boolean	No	-
`input.appliedDiscount.amountWithCurrency.amount`	number	Yes	-
`input.appliedDiscount.amountWithCurrency.currencyCode`	enum	Yes	Values: USD, EUR, GBP, CAD, AFN
`input.appliedDiscount.description`	string	No	-
`input.appliedDiscount.title`	string	No	-
`input.appliedDiscount.value`	number	Yes	-

+80 more inputs available in this connection

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Draft Order

Delete an existing draft order in Shopify.

Route: DELETE /draftOrders/{id}

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Fulfillment Order

Fulfillment Orders data in Shopify.

Read

List Fulfillment Orders

Fetch fulfillment orders from Shopify.

Route: GET /fulfillmentOrders

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

Inputs you can set

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

+5 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`assignedLocation.address1` default	string	-
`assignedLocation.address2` default	string	-
`assignedLocation.city` default	string	-
`assignedLocation.countryCode` default	enum	-
`assignedLocation.name` default	string	-
`assignedLocation.phone` default	string	-
`assignedLocation.province` default	string	-
`assignedLocation.zip` default	string	-
`channelId` default	id	-
`createdAt` default	date	-

+147 more fields available in this connection

Manual Holds Fulfillment Order

Manual Holds Fulfillment Orders data in Shopify.

Read

List Manual Holds Fulfillment Orders

Fetch manual holds fulfillment orders from Shopify.

Route: GET /manualHoldsFulfillmentOrders

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

Inputs you can set

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

Data returned in Excel

Field	Type	Description
`assignedLocation.address1` default	string	-
`assignedLocation.address2` default	string	-
`assignedLocation.city` default	string	-
`assignedLocation.countryCode` default	enum	-
`assignedLocation.name` default	string	-
`assignedLocation.phone` default	string	-
`assignedLocation.province` default	string	-
`assignedLocation.zip` default	string	-
`channelId` default	id	-
`createdAt` default	date	-

+147 more fields available in this connection

Order

Orders in Shopify checkout flow.

Read

List Orders

Fetch orders from Shopify.

Route: GET /orders

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`first`	number	No	The first n elements from the paginated list. Default: 250
`after`	string	No	The elements that come after the specified cursor.
`last`	number	No	The last n elements from the paginated list.
`before`	string	No	The elements that come before the specified cursor.
`reverse`	boolean	No	Reverse the order of the underlying list. Default: false
`sortKey`	enum	No	Sort the underlying list using a key. If your query is slow or returns an error, then [try specifying a sort key that matches the field used... Values: CREATED_AT, CURRENT_TOTAL_PRICE, CUSTOMER_NAME, DESTINATION, FINANCIAL_STATUS
`query.cart_token`	string	No	Filter by the cart token's unique value to track abandoned cart conversions or troubleshoot checkout issues. The token references the cart t...

+41 more inputs available in this connection

Data returned in Excel

Field	Type	Description
`additionalFees.id` default	id	-
`additionalFees.name` default	string	-
`agreements.nodes.happenedAt` default	date	-
`agreements.nodes.id` default	id	-
`agreements.nodes.reason` default	enum	-
`alerts.content` default	string	-
`alerts.dismissibleHandle` default	string	-
`alerts.icon` default	enum	-
`alerts.severity` default	enum	-
`alerts.title` default	string	-

+491 more fields available in this connection

Edit

Update Order

Update an existing order in Shopify.

Route: PATCH /orders/{id}

Inputs you can set

Name	Type	Required	Description
`input.customAttributes.key`	string	Yes	-
`input.customAttributes.value`	string	Yes	-
`input.email`	string	No	-
`input.id`	string	Yes	-
`input.localizedFields.key`	enum	Yes	Values: TAX_CREDENTIAL_BR, SHIPPING_CREDENTIAL_BR, TAX_CREDENTIAL_CL, SHIPPING_CREDENTIAL_CL, SHIPPING_CREDENTIAL_CN
`input.localizedFields.value`	string	Yes	-
`input.metafields.id`	string	No	-
`input.metafields.key`	string	No	-

+17 more inputs available in this connection

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Order

Delete an existing order in Shopify.

Route: DELETE /orders/{id}

Inputs you can set

Name	Type	Required	Description
`orderId`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.