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 Power BI Connector for Shopify Tables
| Name | Description |
| ApplicationCharges | Stores one-time billing charges created by an app, including charge amounts, currency, and payment status. |
| ApplicationCredit | Tracks credits applied toward app charges, including reference amounts and associated applications. |
| Articles | Contains blog article data, allowing creation, update, retrieval, and deletion of article content. |
| Assets | Represents theme assets such as templates, images, and scripts. Note: Create, update, and delete operations are not accessible for public apps. |
| Blogs | Manages blog metadata including titles, handles, and publishing status. |
| CarrierServices | Contains information about carrier-provided shipping services, including service names and integration identifiers. |
| CollectionListings | Provides visibility into collections published to the storefront, allowing retrieval or deletion of listings. |
| Collects | Maps products to custom collections, supporting queries and deletion of product-collection relationships. |
| Comments | Stores blog comment records, including author, content, status, and moderation details. |
| CustomCollections | Defines merchant-created product collections and supports creation, updates, and deletions. |
| CustomerAddresses | Holds customer address data including shipping and billing addresses, supporting full CRUD operations. |
| Customers | Stores customer profiles including contact details, marketing preferences, and order associations. |
| DiscountCodes | Manages discount codes tied to price rules, including creation, activation, and redemption information. |
| DraftOrders | Contains information on draft orders created prior to checkout, including customer, billing, and fulfillment details. |
| FulfillmentEvents | Tracks events related to the lifecycle of fulfillments, including creation, shipment, and delivery updates. |
| Fulfillments | Contains shipment data for orders, including tracking numbers, carriers, and fulfillment status. |
| FulfillmentServices | Manages third-party fulfillment service configurations and metadata for merchant stores. |
| GiftCards | Stores digital or physical gift card records, including balance, currency, and issuance details. |
| MarketingEvents | Stores marketing campaign events and metadata, such as channel, UTM parameters, and performance timestamps. |
| Metafields | Holds custom key–value data attached to Shopify resources, including namespace, key, value, and type. |
| Orders | Stores order headers with customer, payment, fulfillment, pricing, and tax information across the order lifecycle. |
| OrderTransactions | Tracks financial transactions for orders, such as authorizations, captures, refunds, and payment gateway responses. |
| Pages | Contains static page content for the storefront, including title, body HTML, SEO fields, and publish state. |
| PriceRules | Defines discount conditions and benefits (fixed amount, percentage, or free shipping) that generate discount codes or automatic discounts. |
| RecurringApplicationCharges | Stores subscription billing records for apps, including plan details, trial periods, status, and recurring amounts. |
| Redirects | Manages URL redirects for the storefront, mapping old paths to new destinations to preserve SEO and navigation. |
| Refunds | Holds refund headers for orders, including totals, currency, refund reasons, and associated transactions. |
| ResourceFeedbacks | Captures feedback about shop resources from apps, including issues and suggested actions for merchants. |
| ScriptTags | Stores client-side script tag registrations that inject JavaScript into storefront pages, with source URL and scope. |
| SmartCollections | Defines rule-based product collections that update automatically based on product conditions. |
| Themes | Contains theme packages installed on the shop, including roles (main, unpublished) and asset references. |
| UsageCharges | Records metered usage charges billed against a recurring application charge, with amount, currency, and billing period. |