Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Python Connector for Shopify Views


Name	Description
AbandonedCheckouts	Retrieves information on customer checkouts that were started but not completed, useful for tracking cart abandonment and follow-up marketing.
AbandonedCheckoutsItems	Provides item-level details from abandoned checkouts, including product, quantity, and price data.
AssignedFulfillmentOrders	Lists fulfillment orders currently assigned to a given app or fulfillment service within a store.
DiscountApplications	Displays discount applications applied to an order or draft order, including type and allocation details.
DraftOrderItemProperties	Lists custom property key-value pairs attached to draft order line items.
DraftOrderItems	Shows line items included in draft orders, with product, quantity, and pricing details.
DraftOrderItemTaxLines	Displays tax breakdowns applied to individual draft order line items.
Events	Retrieves store event logs such as updates, deletions, and order activities for audit or monitoring.
FulfillmentOrderLineItems	Provides details about line items tied to fulfillment orders, including quantities and SKUs.
FulfillmentOrders	Retrieves fulfillment order records, representing items to be shipped from a specific location.
Locations	Retrieves store locations used for inventory and fulfillment, including address, active status, and assignment capabilities.
NoteAttributes	Exposes custom note attributes linked to orders or draft orders as key–value pairs for workflow and reporting.
OrderDiscountCodes	Lists discount codes applied to orders, including the code, source price rule, and allocation details.
OrderItemDiscountAllocations	Breaks down how discounts are allocated to individual line items, including amounts and discount application references.
OrderItemProperties	Shows custom properties (options) attached to order line items, useful for personalization and configuration.
OrdersItems	Provides item-level order details, including variant, quantity, pricing, discounts, and fulfillment status.
Payouts	Lists Shopify Payments payouts with amounts, currencies, statuses, and payout dates for reconciliation.
PayoutTransactions	Shows balance transactions within each payout, ordered by processing time for accounting drilldowns.
PayoutTransactionsAdjustmentOrderTransactions	Links balance adjustments in payouts back to the originating order transactions for traceability.
RefundAdjustments	Details non-item refund adjustments, such as shipping or custom amounts, applied during a refund.
RefundsItems	Lists refunded line items with quantities, amounts, duties, and restock instructions.
RefundTransactions	Displays transactions generated by refunds, including gateway messages and net amounts.
ShippingItemDiscountAllocations	Breaks out discount amounts allocated to shipping lines on orders.
ShippingItems	Provides per-order shipping line details, including title, price, discounts, and requested delivery info.
ShippingZones	Lists shipping zones with associated countries, provinces, and shipping rate groupings.
Shop	Exposes shop-level settings and identifiers, such as domain, currency, locale, and plan information.
TaxItems	Displays tax lines applied to orders or line items, including rate, title, and calculated tax amounts.
Users	Retrieves information about store users, including names, contact details, and account permissions.