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 Power BI Connector for Shopify Views


Name	Description
AbandonedCheckoutCustomAttributes	Retrieves custom attributes linked to an abandoned checkout, providing additional metadata for recovery workflows.
AbandonedCheckoutLineItems	Lists line items included in an abandoned checkout, including product, quantity, and pricing details.
AbandonedCheckouts	Displays all checkouts that customers started but didn't complete, supporting cart recovery analytics and remarketing.
AbandonedCheckoutTaxLines	Shows individual tax components applied to abandoned checkouts for reporting and calculation consistency.
Abandonment	Tracks abandonment sessions that capture customer behavior during incomplete checkouts.
AbandonmentProductsAddedToCart	Lists products added to a cart during an abandoned shopping session, helping merchants understand customer intent.
AbandonmentProductsViewed	Lists products viewed by a customer during an abandoned visit, providing insight into browsing interest.
AppCredits	Retrieves app credit records issued to merchants for future app billing or adjustments.
ArticleCommentEvents	Displays events related to article comments, such as creation, approval, or deletion actions.
ArticleEvents	Lists activity events associated with blog articles, including publishing, updates, or deletions.
AssignedFulfillmentOrders	Retrieves all fulfillment orders assigned to the shop's locations or fulfillment services managed by the app.
BlogEvents	Displays event logs tied to blog actions such as creation, publication, and content edits.
BusinessEntities	Lists legal or business entities associated with a shop, used for tax or corporate reporting.
CollectionProducts	Lists all products contained within a specific collection, including display order and availability.
CompanyContactRoles	Lists available role definitions for company contacts, including role names and associated privileges.
CompanyEvents	Displays activity events tied to company records, such as creation, updates, and contact modifications.
CustomerAddresses	Lists addresses linked to customer accounts, including default shipping and billing details.
CustomerEvents	Shows customer-related activity events, such as account creation, updates, or login attempts.
CustomerSegmentMembers	Displays members belonging to defined customer segments, supporting segmentation and targeting analysis.
CustomerStoreCreditAccounts	Shows store credit account balances and transactions linked to individual customers.
DeliveryProfileLocationGroupCountries	Lists countries assigned to location groups within a specific delivery profile.
DeliveryProfileLocationGroupCountryProvinces	Displays provinces or regions associated with selected countries in delivery profiles.
DeliveryProfileLocationGroups	Lists location groups that belong to a delivery profile, including group identifiers and configuration data.
DeliveryProfileLocationGroupZones	Shows shipping zones defined for a given location group within a delivery profile.
DeliveryProfileUnassignedLocations	Lists store locations not yet assigned to any location group within a delivery profile, useful for setup and auditing.
DiscountEvents	Lists events related to discount creation, modification, or deletion, providing an audit trail for discount activities.
DiscountsCodeFreeShipping	Displays free-shipping discount code data, including minimum purchase requirements and applicable regions.
Disputes	Shows payment dispute cases raised by customers, including dispute type, amount, and resolution status.
DraftOrderCustomAttributes	Lists custom fields and metadata attached to draft orders for workflow or integration purposes.
DraftOrderEvents	Tracks events associated with draft orders, such as creation, edits, and completion.
DraftOrderLineItemCustomAttributes	Displays custom key–value attributes attached to draft order line items.
DraftOrderLineItems	Lists products, variants, and quantities included in draft orders, including applied discounts.
DraftOrderLineItemTaxLines	Shows tax line details applied to individual draft order line items.
DraftOrderTaxLines	Lists tax components applied to draft orders, including rate and tax jurisdiction.
Events	Retrieves general event logs related to store activities such as updates, creation, or deletions across entities.
FulfillmentLineItems	Lists line items included within fulfillment records, including quantities, SKUs, and location data.
FulfillmentLineItemTaxLines	Displays tax lines applied to fulfillment line items for accurate accounting.
FulfillmentOrderLineItems	Retrieves detailed product line information associated with fulfillment orders.
FulfillmentOrderLocationForMoveAvailableLineItems	Lists items that can be reassigned to a new fulfillment location during inventory relocation.
FulfillmentOrderLocationForMoveUnavailableLineItems	Lists items that cannot be moved to a new fulfillment location, often due to stock or policy restrictions.
FulfillmentOrderLocationsForMove	Displays eligible locations to which fulfillment orders can be reassigned.
InventoryAdjustmentGroupChanges	Shows sets of changes to inventory quantities that occurred within inventory adjustment events.
InventoryAdjustmentGroups	Displays groups of related inventory adjustments created as part of larger inventory operations.
InventoryItemCountryHarmonizedSystemCodes	Lists harmonized system codes for inventory items by country, supporting customs and import documentation.
InventoryItemInventoryLevelQuantities	Reports current inventory quantities for items across store locations.
InventoryItemInventoryLevelScheduledChanges	Displays future or pending adjustments to inventory levels that are scheduled to take effect later.
Jobs	Displays job records used to track the status of asynchronous operations such as imports, exports, or bulk edits.
LocalizationCountries	Lists countries enabled for localized storefront experiences, including language and currency settings.
MarketingEvents	Lists marketing activities and campaigns created by apps, including type, channel, and performance status.
MetafieldDefinitionConstraintValues	Lists constraint values that restrict how metafields can be applied to specific object types or contexts.
MetafieldDefinitionStandardTemplates	Provides prebuilt metafield templates that define standard configurations for common use cases.
MetafieldDefinitionTypes	Lists supported metafield data types, including validation and display properties.
MetaobjectDefinitions	Defines the structure of metaobjects, specifying which metafields and types they include.
MetaObjects	Displays all metaobject instances created for the shop, each representing a reusable structured content record.
OrderAdditionalFees	Lists additional fees applied to an order, such as environmental surcharges or custom service fees.
OrderAgreementAdditionalFeeSales	Shows sales data associated with agreements that include additional fee items.
OrderAgreementAdjustmentSales	Displays order adjustment sales linked to agreements, such as price corrections or discounts.
OrderAgreementDutySales	Shows sales data related to duty charges captured under agreement-based orders.
OrderAgreementGiftCardSales	Lists gift card-related sales that are part of an order agreement.
OrderAgreementProductSales	Shows product-level sales connected to contractual agreements or subscription orders.
OrderAgreements	Displays active order agreements, including terms, conditions, and associated sales data.
OrderAgreementShippingLineSales	Shows sales data for shipping lines tied to order agreements.
OrderAgreementTipSales	Displays tip-related sales that are part of an agreement, such as service-based transactions.
OrderAgreementUnknownSales	Contains unclassified or miscellaneous sales entries linked to an order agreement.
OrderCustomAttributes	Lists custom fields and key–value pairs defined at the order level for tracking and analytics.
OrderDiscountApplications	Shows all discounts applied to an order, excluding refunds and order edits, including type and allocation data.
OrderEditAgreementAdditionalFeeSales	Displays adjusted additional fee sales linked to edited orders.
OrderEditAgreementAdjustmentSales	Shows edited order adjustment sales tied to agreements.
OrderEditAgreementDutySales	Lists edited duty-related sales data associated with order agreements.
OrderEditAgreementGiftCardSales	Shows gift card sales data that changed during an order edit under an agreement.
OrderEditAgreementProductSales	Displays product sales adjustments resulting from order edits connected to agreements.
OrderEditAgreements	Lists agreements governing edited orders, including revision details and associated transactions.
OrderEditAgreementShippingLineSales	Shows edited shipping line sales related to agreements, reflecting updated shipping costs or routes.
OrderEditAgreementTipSales	Displays updated tip-related sales resulting from order edits under agreements.
OrderEditAgreementUnknownSales	Captures unclassified edited sales entries tied to order agreements.
OrderEvents	Logs order lifecycle events such as creation, payment, fulfillment, and cancellation.
OrderLineItemCustomAttributes	Lists custom key–value pairs assigned to order line items for personalization or metadata tracking.
OrderLineItemDiscountAllocations	Shows how discount amounts are distributed among individual order line items.
OrderLineItemDuties	Displays duty charges applied to order line items for customs or import purposes.
OrderLineItems	Provides detailed product-level information for all line items included in orders.
OrderLineItemTaxLines	Displays tax line information applied to specific order items.
OrderNonFulfillableLineItemDuties	Shows duty charges on items that cannot be fulfilled due to restrictions or inventory issues.
OrderNonFulfillableLineItems	Lists order line items that are not eligible for fulfillment, typically due to stockouts or fulfillment exceptions.
OrderRefundAgreementAdditionalFeeSales	Shows refund-related sales adjustments for agreements involving additional fees.
OrderRefundAgreementAdjustmentSales	Displays refund adjustments tied to agreements that modify the order's financials.
OrderRefundAgreementDutySales	Shows refunded duty sales data linked to order agreements.
OrderRefundAgreementGiftCardSales	Lists refunded gift card sales tied to agreements.
OrderRefundAgreementProductSales	Displays product-level refund sales associated with order agreements.
OrderRefundAgreements	Shows agreements governing refunded orders, including refund rules and financial references.
OrderRefundAgreementShippingLineSales	Shows refunded shipping line sales under order agreements.
OrderRefundAgreementTipSales	Displays refunded tip sales tied to order agreements.
OrderRefundAgreementUnknownSales	Captures miscellaneous refund transactions associated with order agreements.
OrderShippingLines	Lists shipping lines attached to orders, including carrier, rate, and destination data.
OrderTaxLines	Displays applied tax lines for orders, detailing title, rate, and tax amount.
PageEvents	Tracks events related to page creation, updates, and deletions in the online store.
PriceListPrices	Lists pricing entries tied to a specific price list, including product, variant, and region-specific prices.
ProductBundleComponentOptionSelections	Links component options to their selected parent options within product bundles.
ProductBundleComponents	Lists components that make up product bundles, including associated product and quantity details.
ProductEvents	Logs product-related events such as creation, price changes, and publication updates.
ProductOperations	Tracks background operations performed on products, such as imports or bulk edits.
ProductVariantEvents	Logs lifecycle events for product variants, such as creation, updates, and inventory changes.
PublicationCollections	Lists collections published to specific sales channels or publications.
PublicationProducts	Lists products published to specific channels or publications.
RefundDuties	Displays refunded duty amounts associated with international orders.
RefundLineItemDuties	Shows refunded duty charges applied to individual order line items.
RefundLineItems	Lists refunded line items from an order, including product, quantity, and refund amount details.
RefundOrderAdjustments	Displays order-level adjustments included in refunds, such as discounts or shipping refunds.
RefundShippingLines	Lists refunded shipping lines, including refunded shipping cost and related carrier information.
RefundTransactionFees	Displays transaction fees refunded to merchants for Shopify Payments transactions.
RefundTransactions	Shows transactions created as part of refunds, including payment gateway data and refund amounts.
ReturnExchangeLineItems	Lists exchange line items associated with a return, including replacement products, quantities, and values.
ReturnLineItems	Displays the line items included in a return request, including refund amounts and restock eligibility.
ReturnLineItemsUnverified	Shows return line items pending verification, often awaiting condition or receipt confirmation.
ReverseFulfillmentOrderDeliveries	Tracks packages sent from buyers back to merchants as part of reverse fulfillment operations.
ReverseFulfillmentOrderDeliveryLineItems	Lists individual items included in reverse deliveries, such as returns or exchanges.
ReverseFulfillmentOrderLineItems	Shows detailed item data tied to reverse fulfillment orders, including quantities and statuses.
ReverseFulfillmentOrders	Lists fulfillment orders representing inbound return shipments processed by fulfillment services.
SegmentFilterParameters	Displays parameters used in defining event-based segment filters, such as field names and conditions.
SegmentFilters	Lists available filters applied to customer or event segments.
SellingPlanGroupSellingPlans	Lists selling plans associated with a selling plan group, including frequency and pricing options.
Shop	Displays overall shop metadata, such as store name, plan type, contact info, and settings.
ShopifyPaymentsAccount	Shows Shopify Payments account information, including account ID, currency, and payout configuration.
ShopifyPaymentsAccountBalance	Lists current balances in each supported currency for a Shopify Payments account.
ShopifyPaymentsAccountBalanceTransactionAdjustmentsOrders	Links payout balance transaction adjustments back to the originating orders for reconciliation.
ShopifyPaymentsAccountBalanceTransactions	Displays all balance transactions for a Shopify Payments account, including payouts and adjustments.
ShopifyPaymentsAccountBankAccounts	Lists connected bank accounts used for Shopify Payments deposits and withdrawals.
ShopifyPaymentsAccountDisputes	Displays dispute records tied to a Shopify Payments account, including resolution outcomes and evidence links.
ShopifyPaymentsAccountPayouts	Lists all payouts issued from Shopify Payments to linked bank accounts, with dates and statuses.
ShopifyPaymentsAccountVerifications	Displays account verification requirements and their current statuses for Shopify Payments compliance.
StaffMembers	Lists staff accounts with access to the shop, including roles and permissions. Available only for Shopify Plus stores.
StoreCreditAccountDebitRevertTransactions	Displays debit reversal transactions created when a debit entry is voided or corrected.
StoreCreditAccountExpirationTransactions	Lists store credit expiration events when unused balances expire after a set duration.
TenderTransactions	Lists payment tender transactions processed in the shop, including amounts, payment methods, and timestamps.