ShopifyQL query support, store credit accounts, payment payout updates

9/11/2025, 12:00:19 AM

The unstable schema adds a new query, shopifyqlQuery, that returns a ShopifyqlQueryResponse containing parseErrors and tabular tableData with detailed column metadata (ShopifyqlTableData, ShopifyqlTableDataColumn) and a new ColumnDataType enum covering many data kinds. The CompanyLocation type now exposes a paginated storeCreditAccounts field with filtering by currency_code and id. Typical error enums receive new values: InventoryShipmentRemoveItemsUserErrorCode gains LOCATION_NOT_ACTIVE, and ProductSetUserErrorCode gets INVENTORY_QUANTITIES_LIMIT_EXCEEDED and VARIANT_METAFIELDS_LIMIT_EXCEEDED. The ShopifyPaymentsPayoutSummary type is expanded with required MoneyV2 fields capitalRemittanceAmount and creditRemittanceAmount. The ShopifyPaymentsTransactionType enum has had four platform adjustment values removed. CartTransforms query and related mutations (create/delete) retain their original behavior but have updated verbose descriptions for clarity. No existing query or mutation is deprecated or removed, preserving backward compatibility while providing these new capabilities.

Query Changes

βž• Added Queries (1)

shopifyqlQuery

Returns the results of a ShopifyQL query.

πŸ”„ Modified Queries (1)

cartTransforms

Retrieves all cart transform functions currently deployed by your app within the merchant's store. This query provides comprehensive access to your active cart modification logic, enabling management and monitoring of bundling and merchandising features.

The query returns paginated results with full cart transform details, including function IDs, configuration settings, and operational status.

Cart Transform ownership is scoped to your API client, ensuring you only see and manage functions deployed by your specific app. This isolation prevents conflicts between different apps while maintaining security boundaries for sensitive merchandising logic.

Learn more about managing cart transforms.

Mutation Changes

πŸ”„ Modified Mutations (2)

cartTransformCreate

Creates a cart transform function that lets merchants customize how products are bundled and presented during checkout. This gives merchants powerful control over their merchandising strategy by allowing apps to modify cart line items programmatically, supporting advanced approaches like dynamic bundles or personalized product recommendations.

For example, a bundle app might create a cart transform that automatically groups related products (like a camera, lens, and case) into a single bundle line item when customers add them to their cart, complete with bundle pricing and unified presentation.

Use CartTransformCreate to:

  • Deploy custom bundling logic to merchant stores
  • Enable dynamic product grouping during checkout
  • Implement personalized product recommendations
  • Create conditional offers based on cart contents
  • Support complex pricing strategies for product combinations

The mutation processes synchronously and returns the created cart transform along with any validation errors. Once created, the cart transform function becomes active for the shop and will process cart modifications according to your defined logic. Cart transforms integrate with Shopify Functions to provide powerful customization capabilities while maintaining checkout performance.

Cart Transform functions can be configured to block checkout on failure or allow graceful degradation, giving you control over how errors are handled in the customer experience.

Learn more about customized bundles.

cartTransformDelete

Removes an existing cart transform function from the merchant's store, disabling any customized bundle or cart modification logic it provided. This mutation persistently deletes the transform configuration and stops all associated cart processing.

For example, when discontinuing a bundle app or removing specific merchandising features, you would delete the corresponding cart transform to ensure customers no longer see the bundled products or modified cart behavior.

Use CartTransformDelete to:

  • Deactivate customized bundle logic when removing app features
  • Clean up unused transform functions
  • Disable cart modifications during app uninstallation
  • Remove outdated merchandising strategies
  • Restore default cart behavior for merchants

The deletion processes immediately and returns the ID of the removed cart transform for confirmation. Once deleted, the transform function stops processing new cart operations, though existing cart sessions may retain their current state until refresh. This ensures a clean transition without disrupting active customer sessions.

Consider the timing of deletions carefully, as removing transforms during peak shopping periods could affect customer experience if they have active carts with transformed items.

Learn more about managing cart transforms.

Type Changes

βž• Added Types (4)

πŸ“‹ColumnDataTypeβž• AddedENUM

The data type of a column.

Values: UNSPECIFIED, MONEY, PERCENT, INTEGER, FLOAT, DECIMAL, STRING, BOOLEAN ... +20 more
πŸ—οΈShopifyqlQueryResponseβž• AddedOBJECT

A response to a ShopifyQL query.

Fields: parseErrors, tableData
πŸ—οΈShopifyqlTableDataβž• AddedOBJECT

The result of a ShopifyQL query.

Fields: columns, rows
πŸ—οΈShopifyqlTableDataColumnβž• AddedOBJECT

Represents a column in a ShopifyQL query response.

Fields: dataType, displayName, name, subType

πŸ”„ Modified Types (5)

πŸ—οΈCompanyLocationπŸ”„ Modified
βž• Field added: storeCreditAccounts

Returns a list of store credit accounts that belong to the owner resource.
A store credit account owner can hold multiple accounts each with a different currency.

πŸ—οΈInventoryShipmentRemoveItemsUserErrorCodeπŸ”„ Modified
βž• Enum value added: LOCATION_NOT_ACTIVE
πŸ—οΈProductSetUserErrorCodeπŸ”„ Modified
βž• Enum value added: INVENTORY_QUANTITIES_LIMIT_EXCEEDED
βž• Enum value added: VARIANT_METAFIELDS_LIMIT_EXCEEDED
πŸ—οΈShopifyPaymentsPayoutSummaryπŸ”„ Modified
βž• Field added: capitalRemittanceAmount

Total amount for all lending capital remittance balance adjustments.

βž• Field added: creditRemittanceAmount

Total amount for all lending credit remittance balance adjustments.

πŸ—οΈShopifyPaymentsTransactionTypeπŸ”„ Modified
βž– Enum value removed: MANAGED_MARKETS_DUTIES_AND_TAXES_ADJUSTMENT_PLATFORM_DEBIT
βž– Enum value removed: MANAGED_MARKETS_DUTIES_AND_TAXES_ADJUSTMENT_PLATFORM_CREDIT
βž– Enum value removed: MANAGED_MARKETS_DUTIES_AND_TAXES_ADJUSTMENT_PLATFORM_DEBIT_REVERSAL
βž– Enum value removed: MANAGED_MARKETS_DUTIES_AND_TAXES_ADJUSTMENT_PLATFORM_CREDIT_REVERSAL