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


Name	Description
AbandonedCheckoutCustomAttributes	Retrieves custom attributes captured on an abandoned checkout, such as personalization fields or internal flags.
AbandonedCheckoutLineItems	Lists the products, variants, and quantities that were in the cart when the checkout was abandoned.
AbandonedCheckouts	Returns abandoned checkout sessions with customer, cart, and timing details for recovery.
AbandonedCheckoutTaxLines	Shows the tax lines calculated for an abandoned checkout by jurisdiction and rate.
Abandonment	Summarizes visit-level abandonment metrics and context for unfinished checkouts.
AbandonmentProductsAddedToCart	Lists products customers added to cart during sessions that ended in abandonment.
AbandonmentProductsViewed	Returns products viewed during sessions that later resulted in an abandoned checkout.
AppCredits	Lists credits that merchants can apply toward future app charges.
ArticleCommentEvents	Retrieves events tied to article comments, such as creation, approval, or deletion.
ArticleEvents	Returns event history for articles, including publication, updates, and deletions.
AssignedFulfillmentOrders	Retrieves fulfillment orders assigned to app-managed locations (requires read_assigned_fulfillment_orders). CLOSED orders are excluded by default.
BlogEvents	Retrieves activity events related to blogs, such as creation or deletion.
BusinessEntities	Lists business entities associated with the shop for organizational context.
CollectionProducts	Lists products contained within a specified collection.
CompanyContactRoles	Lists available roles that can be assigned to company contacts.
CompanyEvents	Retrieves event history associated with company records.
CustomerEvents	Retrieves event history for customer records (creation, updates, tags).
CustomerSegmentMembers	Lists members (for example, customers) associated with a specific customer segment.
CustomerStoreCreditAccounts	Lists customers' store credit accounts with balances and status.
DeliveryProfileLocationGroupCountries	Lists countries already selected in any zone for the specified location group.
DeliveryProfileLocationGroupCountryProvinces	Lists regions/provinces associated with the specified country in a location group.
DeliveryProfileLocationGroups	Lists location groups configured under a delivery profile.
DeliveryProfileLocationGroupZones	Lists shipping zones associated with the specified location group.
DeliveryProfileUnassignedLocations	Lists locations not yet assigned to any location group for this profile.
DiscountEvents	Retrieves event history for discounts, including publishing and edits.
DiscountsCodeFreeShipping	Lists free-shipping discounts available via discount codes.
Disputes	Lists chargeback and dispute cases related to the shop.
DraftOrderCustomAttributes	Lists custom attributes attached to draft orders for internal or personalization data.
DraftOrderEvents	Retrieves event history for draft orders, such as creation or completion.
DraftOrderLineItemCustomAttributes	Lists custom attributes attached to draft order line items.
DraftOrderLineItems	Lists the line items included in a draft order with quantities and prices.
DraftOrderLineItemTaxLines	Shows tax lines applied to individual draft order items.
DraftOrderTaxLines	Shows tax lines applied at the draft order level.
Events	Lists shop-wide events for auditing and troubleshooting.
FulfillmentLineItems	Lists order line items included in fulfillments for picking and packing.
FulfillmentLineItemTaxLines	Shows tax lines on fulfillment line items where applicable.
FulfillmentOrderLineItems	Lists the line items grouped under a fulfillment order.
FulfillmentOrderLocationForMoveAvailableLineItems	Lists fulfillment order line items available to move to a new location.
FulfillmentOrderLocationForMoveUnavailableLineItems	Lists fulfillment order line items that cannot be moved to a new location.
FulfillmentOrderLocationsForMove	Lists candidate locations to which a fulfillment order can be moved.
InventoryAdjustmentGroupChanges	Lists sets of quantity changes that occurred within inventory events.
InventoryAdjustmentGroups	Lists groups of adjustments applied during inventory operations.
InventoryItemCountryHarmonizedSystemCodes	Lists country-specific Harmonized System (HS) codes assigned to inventory items.
InventoryItemInventoryLevelQuantities	Lists on-hand, committed, and available quantities by location for an inventory item.
InventoryItemInventoryLevelScheduledChanges	Lists scheduled future changes to inventory levels.
Jobs	Returns job status by Id for asynchronous operations and internal tasks.
LocalizationCountries	Lists countries with localized storefront experiences enabled.
MarketingEvents	Lists marketing events associated with the marketing application and their metrics.
MetafieldDefinitionConstraintValues	Lists constraint subtype values supported by a metafield definition.
MetafieldDefinitionStandardTemplates	Lists standard metafield templates that provide ready-made definition presets.
MetafieldDefinitionTypes	Lists core metafield types and validations available for definitions.
MetaobjectDefinitions	Lists definitions for metaobjects, which are structured, reusable content modeled via metafields.
MetaObjects	Lists all metaobjects created for the shop.
OrderAdditionalFees	Lists additional fees applied to an order (for example, handling, or service).
OrderAgreementAdditionalFeeSales	Lists sales attributed to agreement-based additional fees.
OrderAgreementAdjustmentSales	Lists sales attributed to agreement-based adjustments.
OrderAgreementDutySales	Lists sales attributed to agreement-based duties.
OrderAgreementGiftCardSales	Lists sales attributed to agreement-based gift card usage.
OrderAgreementProductSales	Lists sales attributed to agreement-based product charges.
OrderAgreements	Lists sales agreements associated with orders.
OrderAgreementShippingLineSales	Lists sales attributed to agreement-based shipping lines.
OrderAgreementTipSales	Lists sales attributed to agreement-based tips.
OrderAgreementUnknownSales	Lists agreement-based sales that fall into an unknown category.
OrderCustomAttributes	Lists custom attributes attached to orders for internal or personalization data.
OrderDiscountApplications	Lists discount applications that affected an order, excluding edits and refunds.
OrderEditAgreementAdditionalFeeSales	Lists agreement-based additional fee sales within order edits.
OrderEditAgreementAdjustmentSales	Lists agreement-based adjustment sales within order edits.
OrderEditAgreementDutySales	Lists agreement-based duty sales within order edits.
OrderEditAgreementGiftCardSales	Lists agreement-based gift card sales within order edits.
OrderEditAgreementProductSales	Lists agreement-based product sales within order edits.
OrderEditAgreements	Lists sales agreements that apply to order edits.
OrderEditAgreementShippingLineSales	Lists agreement-based shipping line sales within order edits.
OrderEditAgreementTipSales	Lists agreement-based tip sales within order edits.
OrderEditAgreementUnknownSales	Lists uncategorized agreement-based sales within order edits.
OrderEvents	Retrieves event history for orders (creation, updates, fulfillment changes).
OrderLineItemCustomAttributes	Lists custom attributes attached to order line items.
OrderLineItemDiscountAllocations	Shows discount allocations applied to a line item, excluding edits and refunds.
OrderLineItemDuties	Lists duties allocated to order line items.
OrderLineItems	Lists line items on orders, including variants, quantities, and pricing.
OrderLineItemTaxLines	Shows tax lines calculated for an order line item.
OrderNonFulfillableLineItemDuties	Lists duties on line items that cannot be fulfilled.
OrderNonFulfillableLineItems	Lists order line items that are not fulfillable and related context.
OrderRefundAgreementAdditionalFeeSales	Lists refund sales associated with agreement-based additional fees.
OrderRefundAgreementAdjustmentSales	Lists refund sales associated with agreement-based adjustments.
OrderRefundAgreementDutySales	Lists refund sales associated with agreement-based duties.
OrderRefundAgreementGiftCardSales	Lists refund sales associated with agreement-based gift card usage.
OrderRefundAgreementProductSales	Lists refund sales associated with agreement-based product charges.
OrderRefundAgreements	Lists sales agreements tied to refunds.
OrderRefundAgreementShippingLineSales	Lists refund sales associated with agreement-based shipping lines.
OrderRefundAgreementTipSales	Lists refund sales associated with agreement-based tips.
OrderRefundAgreementUnknownSales	Lists uncategorized agreement-based refund sales.
OrderShippingLines	Lists shipping lines attached to orders, including rates and titles.
OrderTaxLines	Shows taxes calculated for an order at the order level.
PageEvents	Retrieves event history for pages (creation, publishing, edits).
PriceListPrices	Lists prices attached to a specific price list by currency and adjustment rules.
ProductBundleComponentOptionSelections	Lists mappings between component options and selected parent bundle options.
ProductBundleComponents	Lists component products that make up a bundle and their constraints.
ProductEvents	Retrieves event history for products (creation, publication, updates).
ProductOperations	Inspects details of asynchronous operations performed on products.
ProductVariantEvents	Retrieves event history for product variants.
PublicationCollections	Lists collections published to a specific publication (channel).
PublicationProducts	Lists products published to a specific publication (channel).
RefundDuties	Lists duties refunded as part of a refund.
RefundLineItemDuties	Lists duties attached to refunded line items.
RefundLineItems	Lists refund line item records that specify quantities and amounts refunded.
RefundOrderAdjustments	Lists order-level adjustments included on a refund.
RefundShippingLines	Lists shipping lines included in a refund.
RefundTransactionFees	Lists transaction fees applied to the original order transaction (Shopify Payments only).
RefundTransactions	Lists payment transactions generated as part of a refund.
ReturnExchangeLineItems	Lists line items created for exchanges within a return.
ReturnLineItems	Lists return line items attached to the return.
ReturnLineItemsUnverified	Lists unverified return line items pending inspection or validation.
ReverseFulfillmentOrderDeliveries	Lists reverse deliveries where buyers send packages back to the merchant.
ReverseFulfillmentOrderDeliveryLineItems	Lists line items included in reverse deliveries.
ReverseFulfillmentOrderLineItems	Lists line items managed under reverse fulfillment orders.
ReverseFulfillmentOrders	Lists items within returns to be processed by a fulfillment service.
SegmentFilterParameters	Lists available parameters used to construct event-based segment filters.
SegmentFilters	Lists reusable segment filters available for building segments.
SellingPlanGroupSellingPlans	Lists selling plans associated with a selling plan group.
Shop	Returns the shop resource for the current token, including business and management settings.
ShopifyPaymentsAccount	Returns Shopify Payments account details, including balances, disputes, and payouts.
ShopifyPaymentsAccountBalance	Returns current balances across all currencies for the account.
ShopifyPaymentsAccountBalanceTransactionAdjustmentsOrders	Lists adjustment orders linked to a specific balance transaction.
ShopifyPaymentsAccountBalanceTransactions	Lists balance transactions associated with the account's balances.
ShopifyPaymentsAccountBankAccounts	Lists bank accounts configured for the Shopify Payments account.
ShopifyPaymentsAccountDisputes	Lists disputes associated with the Shopify Payments account.
ShopifyPaymentsAccountPayouts	Lists past and current payouts between the account and the bank (available only in supported countries).
ShopifyPaymentsAccountVerifications	Lists verification steps and statuses required for the account.
StaffMembers	Lists staff members for the shop with pagination (Shopify Plus only).
StoreCreditAccountDebitRevertTransactions	Lists debit-revert transactions created when a debit is reversed on a store credit account.
StoreCreditAccountExpirationTransactions	Lists expiration transactions created when credit expires on a store credit account.
TenderTransactions	Lists tender (payment method) transactions recorded by the shop.