Tables
The connector models the data in Shopify as a list of tables in a relational database that can be queried using standard SQL statements.
CData Python Connector for Shopify Tables
| Name | Description |
| AppFeedbacks | Captures feedback and diagnostic information from apps, surfacing issues or setup steps in Shopify admin. |
| AppSubscriptionLineItems | Contains details of app subscription line items, including plan names, billing intervals, and pricing. |
| AppSubscriptions | Lists all active and past app subscriptions for a shop, including status and renewal details. |
| ArticleComments | Stores comments posted on blog articles, including author, content, and moderation status. |
| Articles | Contains article content for the shop's blogs, including titles, handles, authors, and publication details. |
| Blogs | Stores blog metadata and publishing configuration for each blog in the shop. |
| CarrierServices | Details third-party or custom carrier services available to the shop, including integration identifiers and supported locations. |
| Catalogs | Represents product catalogs available to the shop, often used for B2B or channel-specific listings. |
| Collections | Stores metadata for all collections in the shop, both manual and automated, including titles and publication status. |
| Companies | Holds company profiles for B2B operations, including names, contact data, and relationship details. |
| CompanyContactRoleAssignments | Maps company contacts to specific roles, defining permissions and access within a B2B company account. |
| CompanyContacts | Stores individual contact records for companies, including names, emails, roles, and assigned company identifiers. |
| CompanyLocations | Contains company location data, including address, region, and association with parent companies. |
| CompanyLocationStaffMemberAssignments | Lists staff members assigned to specific company locations. Available only for Shopify Plus stores. |
| Customers | Contains customer profile data including contact info, marketing preferences, and order history. |
| DeliveryProfiles | Stores delivery profile configurations, defining how products are grouped and shipped from different locations. |
| DiscountsAutomaticApp | Contains automatic discounts created by apps, including qualifying conditions and applied benefits. |
| DiscountsAutomaticBasic | Stores basic automatic discount rules applied at checkout without the use of discount codes. |
| DiscountsAutomaticBxgy | Represents 'Buy X Get Y' automatic discount configurations and their qualifying item relationships. |
| DiscountsCodeApp | Tracks app-generated discount codes, including associated price rules and redemption limits. |
| DiscountsCodeBasic | Contains standard discount code data, including percentage or fixed-value discounts and usage metrics. |
| DiscountsCodeBxgy | Holds 'Buy X Get Y' discount code configurations tied to specific product eligibility conditions. |
| DraftOrders | Stores draft order records created by merchants, allowing manual invoice creation and checkout completion. |
| Files | Contains metadata for media files uploaded to Shopify, including file name, MIME type, and storage URL. |
| FulfillmentEvents | Records events tied to fulfillments such as shipment creation, in-transit updates, and delivery confirmation. |
| FulfillmentOrders | Contains records of fulfillment orders, representing groupings of items to be shipped from a specific location. |
| Fulfillments | Stores shipment data for orders, including tracking details, carrier information, and shipment timestamps. |
| FulfillmentServices | Defines fulfillment services integrated with the shop, including their endpoints and managed locations. |
| FulfillmentTrackingInfo | Provides tracking details for fulfillments such as carrier name, tracking numbers, and tracking URLs. |
| GiftCards | Contains issued gift card records, including balances, codes, and issuance dates. Available only for Shopify Plus stores. |
| GiftCardTransactionsCredit | Logs credit transactions that increase gift card balances, typically due to issuance or adjustment. Available only for Shopify Plus. |
| GiftCardTransactionsDebit | Logs debit transactions that reduce gift card balances, such as redemptions or refunds. Available only for Shopify Plus. |
| InventoryItemInventoryLevels | Shows overall inventory level details for each item and its stocking locations. |
| InventoryItems | Contains records for individual inventory items, including SKU, cost, and tracking settings. |
| Locations | Stores information about physical locations, including address, fulfillment role, and inventory management settings. |
| Menus | Contains navigation menu structures for the storefront, including menu items, hierarchy, and target URLs. |
| MetafieldDefinitions | Defines metadata field templates that describe allowed namespaces, keys, and data types for metafields. |
| Metafields | Stores custom key–value data attached to Shopify resources, enabling extensibility across entities such as products or orders. |
| OrderRiskAssessments | Contains fraud risk assessment results for orders, including scores, triggers, and recommendations. |
| Orders | Stores comprehensive order data including totals, customer info, fulfillment, payment, and channel sources. |
| OrderTransactions | Stores payment transaction records for orders, including authorizations, captures, and refunds. |
| Pages | Stores static page content for the shop, such as About or FAQ pages, including titles and publication settings. |
| PriceLists | Stores all price lists defined for the shop, including currency, context, and applicable customer groups. |
| ProductMediaImages | Stores image media records tied to products, including URLs, alt text, and ordering. |
| ProductOptions | Defines option sets for products, such as Size or Color, along with position ordering. |
| ProductOptionValues | Lists possible values for each product option, including those not currently assigned to variants. |
| ProductResourceFeedbacks | Captures product-level feedback or issues reported by apps, used to notify merchants about setup or data concerns. |
| Products | Contains product catalog data including title, description, price, vendor, and publishing details. |
| ProductVariants | Stores variant-level data for products, including SKU, option values, price, and inventory management fields. |
| Publications | Defines publication targets, representing sales channels or marketplaces where products and collections are visible. |
| Refunds | Represents refund records, including refund reason, associated order, total amounts, and refund transactions. |
| Returns | Stores records of product returns, including reason codes, refund references, and associated order data. |
| ScriptTags | Contains storefront script tag definitions for embedding custom JavaScript from approved sources. |
| Segments | Stores definitions for customer segments, including filter logic and dynamic grouping criteria. |
| SellingPlanGroups | Defines selling plan groups that bundle multiple subscription or payment plan options for products. |
| StoreCreditAccountCreditTransactions | Logs credit transactions that increase store credit account balances, such as issued refunds or promotions. |
| StoreCreditAccountDebitTransactions | Records debit transactions that decrease store credit balances, such as purchases or redemptions. |
| StorefrontAccessTokens | Stores API access tokens for private storefront applications, used to authenticate client-side requests with defined scopes. |
| Themes | Contains theme metadata, including theme names, roles (main, unpublished), and publication details for storefront design management. |
| UrlRedirects | Defines URL redirects for the shop, mapping legacy or custom URLs to new destinations to maintain navigation and SEO integrity. |