Tables
The driver models the data in Shopify as a list of tables in a relational database that can be queried using standard SQL statements.
CData JDBC Driver for Shopify Tables
| Name | Description |
| AppFeedbacks | The system surfaces app feedback items that notify merchants about setup requirements or issues in the Admin. |
| AppSubscriptionLineItems | Lists the plan components and recurring line items that comprise an app subscription. |
| AppSubscriptions | Lists all subscriptions created for the shop's installed app, including status and billing cycles. |
| ArticleComments | Lists comments on blog articles with author details, content, and moderation status. |
| Articles | Lists the shop's articles with titles, content, authorship, and publication state. |
| Blogs | Lists the shop's blogs with titles, handles, and metadata. |
| CarrierServices | Lists activated carrier services and the shop locations that support them for live rate calculation. |
| Catalogs | Lists product catalogs belonging to the shop for business-to-business (B2B) or channel use. |
| Collections | Returns manual and automated collections with titles, rules, and publication state. |
| Companies | Lists business-to-business (B2B) companies configured in the shop. |
| CompanyContactRoleAssignments | Lists role assignments mapping company contacts to their permissions. |
| CompanyContacts | Lists contacts for companies, including identifiers, email, and role. |
| CompanyLocations | Lists locations defined under a company, including addresses and identifiers. |
| CompanyLocationStaffMemberAssignments | Lists staff members assigned to a company location. Actions are scoped to that location (Shopify Plus only). |
| CustomerAddresses | List addresses associated with customers. |
| Customers | Lists customers with core profile data, marketing preferences, and tags. |
| DeliveryProfiles | Lists saved delivery profiles that define shipping logic by product and location. |
| DiscountsAutomaticApp | Lists automatic discounts defined and managed by apps. |
| DiscountsAutomaticBasic | Lists basic automatic discounts (for example, percentage or amount off). |
| DiscountsAutomaticBxgy | Lists automatic buy-X-get-Y discounts. |
| DiscountsCodeApp | Lists discount codes managed by apps. |
| DiscountsCodeBasic | Lists basic code discounts (fixed/percentage off, minimums). |
| DiscountsCodeBxgy | Lists buy-X-get-Y discount codes. |
| DraftOrders | Lists saved draft orders for manual checkout or invoicing workflows. |
| Files | Lists files uploaded to Shopify (images, PDFs, media) with metadata and URLs. |
| FulfillmentEvents | Lists status events (in transit, delivered) associated with fulfillments. |
| FulfillmentOrders | Lists merchant-managed and third-party fulfillment orders with statuses and assignments. |
| Fulfillments | Represents shipments created for orders, including tracking and delivery status. |
| FulfillmentServices | Lists fulfillment services that prepare and ship orders on behalf of the merchant. |
| FulfillmentTrackingInfo | Lists tracking details for fulfillments, including company, number, and tracking URL. |
| GiftCards | Lists gift cards and balances (requires read_gift_cards; available for Shopify Plus/private or custom application). |
| GiftCardTransactionsCredit | Lists credit transactions that increase a gift card balance (Shopify Plus only). |
| GiftCardTransactionsDebit | Lists debit transactions that decrease a gift card balance (Shopify Plus only). |
| InventoryItemInventoryLevels | Shows per-location inventory level summaries for an inventory item. |
| InventoryItems | Lists inventory items (SKU-level records) with tracking and cost data. |
| Locations | Lists active inventory locations used for stock, fulfillment, and pickup. |
| Menus | Lists navigation menus used on the storefront. |
| MetafieldDefinitions | Lists metafield definitions, including validation and presentation details. |
| Metafields | Lists metafields attached to one or more resource Ids. |
| OrderRiskAssessments | Lists fraud risk assessments attached to orders with scores and reasons. |
| Orders | Lists orders with customer, payment, fulfillment, duty, and tax details. |
| OrderTransactions | Lists payment transactions associated with orders (authorization, capture, refund). |
| Pages | Lists the shop's informational pages used on the storefront. |
| PriceLists | Lists price lists configured for the shop (for example, business-to-business (B2B) tiers, or markets). |
| ProductMediaImages | Lists image media attached to products with alt text and ordering. |
| ProductOptions | Lists product options (Size or Color). Limited by Shop.resourceLimits.maxProductOptions. |
| ProductOptionValues | Lists all possible option values for a given product option, even if not used by a variant. |
| ProductResourceFeedbacks | Lists product resource feedback items visible to the current application. |
| Products | Lists products with titles, status, variants, media, and publishing details. |
| ProductVariants | Lists product variants with pricing, inventory tracking, and option values. |
| Publications | Lists sales channel publications configured for the shop. |
| Refunds | Represents refunds of items or transactions on an order, with amounts and reasons. |
| Returns | Lists returns associated with orders, including statuses and dispositions. |
| ScriptTags | Lists script tags that inject JavaScript into storefront pages. |
| Segments | Lists customer segments defined in the shop. |
| SellingPlanGroups | Lists selling plan groups used for subscriptions and prepaid options. |
| StoreCreditAccountCreditTransactions | Lists transactions that credit (increase) a store credit account. |
| StoreCreditAccountDebitTransactions | Lists transactions that debit (decrease) a store credit account. |
| StorefrontAccessTokens | Lists storefront access tokens for private applications, scoped per application. |
| Themes | Lists the shop's themes with role and preview data. |
| UrlRedirects | Lists URL redirects configured for the shop to preserve search engine optimization (SEO) and navigation. |