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 ODBC Driver for Shopify Views


Name	Description
AbandonedCheckoutLineItems	Retrieves a list of line items in the associated resource.
Abandonment	Returns abandonment.
AbandonmentProductsAddedToCart	Returns the products added to the cart during the customer abandoned visit.
AbandonmentProductsViewed	Returns the products viewed during the customer abandoned visit.
AppCredits	Lists credits that can be used towards future app purchases.
ArticleComments	Returns a list of comments posted on an article.
Articles	Returns a list of the shop's visible articles.
AssignedFulfillmentOrders	Retrieves a paginated list of fulfillment orders assigned to the shop locations owned by the app. Assigned fulfillment orders are fulfillment orders that are set to be fulfilled from locations managed by fulfillment services that are registered by the app. One app (api_client) can host multiple fulfillment services on a shop. Each fulfillment service manages a dedicated location on a shop. Assigned fulfillment orders can have associated, or might currently not be requested to be fulfilled. The app must have 'read_assigned_fulfillment_orders' to be able to retrieve fulfillment orders assigned to its locations. All assigned fulfillment orders (except those with the 'CLOSED' status) will be returned by default.
Blogs	Retrieves a list of the shop's blogs.
CarrierServices	Returns a list of activated carrier services and associated shop locations that support them.
CollectionProducts	Retrieves a list of the products inside of a collection.
CompanyEvents	Retrieves a paginated list of events associated with the host subject.
CustomerEvents	Retrieves a paginated list of events associated with the host subject.
CustomerSegmentMembers	The list of members, such as customers, that's associated with individual segments.
DeliveryProfileLocationGroupCountries	Lists countries already selected in any zone for the specified location group.
DeliveryProfileLocationGroupCountryProvinces	Returns the list of regions associated with this country.
DeliveryProfileLocationGroups	Lists the location groups using this profile.
DeliveryProfileLocationGroupZones	Lists the applicable zones associated to the specified location group.
DeliveryProfileUnassignedLocations	Lists the locations that have not been assigned to a location group for this profile.
DiscountEvents	Retrieves a paginated list of events associated with the host subject.
DiscountsCodeFreeShipping	Returns a list of discounts.
DraftOrderCustomAttributes	Retrieves custom attributes associated with the resource.
DraftOrderEvents	Retrieves a paginated list of events associated with the host subject.
DraftOrderLineItemCustomAttributes	Retrieves custom attributes associated with the resource.
DraftOrderLineItems	Returns a list of the line items in the draft order.
DraftOrderLineItemTaxLines	Represents a single tax applied to the associated resource.
DraftOrderTaxLines	Represents a single tax applied to the associated resource.
FulfillmentOrderLineItems	A list of the fulfillment order's line items.
FulfillmentOrderLocationForMoveAvailableLineItems	A list of the fulfillment order's line items.
FulfillmentOrderLocationForMoveUnavailableLineItems	A list of the fulfillment order's line items.
FulfillmentOrderLocationsForMove	A list of locations that the fulfillment order can potentially move to.
InventoryItemCountryHarmonizedSystemCodes	Returns a list of country specific harmonized system codes.
InventoryItemInventoryLevels	Returns a list of the inventory item's quantities for each location that the inventory item can be stocked at.
Jobs	Returns a Job resource by ID. Used to check the status of internal jobs and any applicable changes.
MarketingEvents	Returns a list of marketing events associated with the marketing app.
MetaobjectDefinitions	Provides the definition of a generic object structure composed of metafields.
MetaObjects	All metaobjects for the shop.
OrderAdditionalFees	A list of additional fees applied to the order.
OrderAgreementAdditionalFeeSales	Retrieves a list of sales associated with agreements.
OrderAgreementAdjustmentSales	Retrieves a list of sales associated with agreements.
OrderAgreementDutySales	Retrieves a list of sales associated with agreements.
OrderAgreementGiftCardSales	Retrieves a list of sales associated with agreements.
OrderAgreementProductSales	Retrieves a list of sales associated with agreements.
OrderAgreements	Retrieves a list of sales agreements associated with orders.
OrderAgreementShippingLineSales	Retrieves a list of sales associated with agreements.
OrderAgreementTipSales	Retrieves a list of sales associated with agreements.
OrderAgreementUnknownSales	Retrieves a list of sales associated with agreements.
OrderCustomAttributes	Retrieves custom attributes associated with the resource.
OrderDiscountApplications	Returns a list of discounts that are applied to the order, not including order edits and refunds.
OrderEditAgreementAdditionalFeeSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementAdjustmentSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementDutySales	Retrieves a list of sales associated with agreements.
OrderEditAgreementGiftCardSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementProductSales	Retrieves a list of sales associated with agreements.
OrderEditAgreements	Retrieves a list of sales agreements associated with orders.
OrderEditAgreementShippingLineSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementTipSales	Retrieves a list of sales associated with agreements.
OrderEditAgreementUnknownSales	Retrieves a list of sales associated with agreements.
OrderEvents	Retrieves a paginated list of events associated with the host subject.
OrderLineItemCustomAttributes	Retrieves custom attributes associated with the resource.
OrderLineItemDiscountAllocations	Retrieves the discounts that have been allocated onto the line item by discount applications, not including order edits and refunds.
OrderLineItemDuties	Lists the duties associated with the line items.
OrderLineItems	Retrieves a list of line items in the associated resource.
OrderNonFulfillableLineItemDuties	Lists the duties associated with the line items.
OrderNonFulfillableLineItems	Retrieves a list of line items in the associated resource.
OrderRefundAgreementAdditionalFeeSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementAdjustmentSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementDutySales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementGiftCardSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementProductSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreements	Retrieves a list of sales agreements associated with orders.
OrderRefundAgreementShippingLineSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementTipSales	Retrieves a list of sales associated with agreements.
OrderRefundAgreementUnknownSales	Retrieves a list of sales associated with agreements.
OrderRisks	Lists the order risks associated with this order.
OrderTaxLines	Represents a single tax applied to the associated resource.
Pages	Returns a list of the shop's pages.
PriceListPrices	A list of prices associated with a price list.
ProductOptions	Returns a list of product options. The limit is specified by Shop.resourceLimits.maxProductOptions.
PublicationCollections	Returns a list of collections published to the publication.
PublicationProducts	Returns the list of publication for products.
RefundDuties	Lists the refunded duties as part of this refund.
RefundLineItemDuties	Lists the duties associated with the line items.
RefundLineItems	Retrieves the 'RefundLineItem' resources attached to the refund.
RefundTransactionFees	Returns the transaction fees charged on the order transaction. Only present for Shopify Payments transactions.
RefundTransactions	Retrieves the transactions associated with the resource.
ReturnLineItems	Retrieves the return line items attached to the return.
SegmentFilterParameters	The parameters for event segment filters.
SegmentFilters	A list of filters.
SellingPlanGroupSellingPlans	Retrieves selling plans associated to the selling plan group.
Shop	Returns the Shop resource corresponding to the access token used in the request. The Shop resource contains business and store management settings for the shop.
ShopifyPaymentsAccount	Returns Shopify Payments account information, including balances and payouts.
ShopifyPaymentsAccountBalance	Returns current balances in all currencies for the account.
ShopifyPaymentsAccountBalanceTransactionAdjustmentsOrders	The adjustment orders associated to the transaction.
ShopifyPaymentsAccountBalanceTransactions	A list of balance transactions associated with a Shopify Payments account balance.
ShopifyPaymentsAccountBankAccounts	Lists all bank accounts configured for the Shopify Payments account.
ShopifyPaymentsAccountDisputes	Lists all disputes related to the Shopify Payments account.
ShopifyPaymentsAccountPayouts	Returns all current and previous payouts made between the account and the bank account. Its avaible only in a few certain countries.
ShopifyPaymentsAccountPermittedVerificationDocuments	Retrieves the permitted documents for identity verification.
ShopifyPaymentsAccountVerifications	Returns the verifications necessary for this account.
StaffMembers	Retrieves a paginated list of the shop's staff members.(This table is available only with a ShopifyPlus subscription)
TenderTransactions	Returns a list of TenderTransactions associated with the shop.