Excel Add-In for Shopify

Build 24.0.9060

DraftOrderItemProperties

Query order item properties.

View-Specific Information

Select

The add-in uses the Shopify API to process search criteria that refer to the DraftOrderId column. The supported SQL operators are '=' for DraftOrderId. The add-in processes other filters client-side within the add-in.

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

SELECT * FROM DraftOrderItemProperties WHERE DraftOrderId = '123'

Columns

Name Type References Description
ItemId Long

DraftOrderItems.ItemId

The id of the order item.
DraftOrderId Long

DraftOrders.Id

The id of the draft.
Name String The name of the item property.
Value String The value of the item property.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060