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 ODBC Driver for Shopify Tables


Name	Description
AppFeedbacks	Reports the status of shops and their resources and displays this information within Shopify admin. AppFeedback is used to notify merchants about steps they need to take to set up an application on their store.
AppSubscriptionLineItems	Returns the plans attached to the app subscription.
AppSubscriptions	Lists all subscriptions created for a shop on the installed application.
Catalogs	The catalogs belonging to the shop.
Collections	Returns a list of collections.
Companies	Returns the list of companies in the shop.
CompanyLocations	Returns a list of locations in the company.
Customers	Retrieves a list of customers.
DeliveryProfiles	Returns a list of saved delivery profiles.
DiscountsAutomaticApp	Returns a list of discounts.
DiscountsAutomaticBasic	Returns a list of discounts.
DiscountsAutomaticBxgy	Returns a list of discounts.
DiscountsCodeApp	Returns a list of discounts.
DiscountsCodeBasic	Returns a list of discounts.
DiscountsCodeBxgy	Returns a list of discounts.
DraftOrders	Returns a list of saved draft orders.
FulfillmentEvents	Retrieves the history of events associated with one or many fulfillments.
FulfillmentOrders	Retrieves a paginated list of merchant-managed and third-party fulfillment orders.
Fulfillments	Fulfillment represents a shipment of one or more items in an order.
FulfillmentServices	Lists fulfillmentServices which Represents service that prepares and ships orders on behalf of the store owner.
FulfillmentTrackingInfo	Lists tracking information associated with the fulfillment, such as the tracking company, tracking number, and tracking URL.
GiftCards	Returns a list of gift cards. Requires read_gift_cards access scope. Also, note that the API client must be a private or custom application installed on a Shopify Plus or Shopify Plus Partner Sandbox store.(This table is available only with a ShopifyPlus subscription)
InventoryItems	Returns a list of inventory items.
Locations	Returns a list of active inventory locations.
Metafields	Retrieves a list of metafields that belong to one or many resource IDs.
Orders	Retrieves a list of orders.
OrderTransactions	Retrieves the transactions associated with the resource.
PriceLists	All price lists for a shop.
ProductImages	Returns the media images associated with the product.
ProductResourceFeedbacks	Returns the product resource feedback for the currently authenticated app.
Products	Returns a list of products.
ProductVariants	Returns a list of the product variants.
Publications	Returns the list of publications.
Refunds	Represents a refund of items or transactions in an order.
Returns	Retrieves a list of returns for the order.
ScriptTags	Returns a list of script tags.
Segments	A list of a shop's segments.
SellingPlanGroups	Returns a list Selling Plan Groups.
StorefrontAccessTokens	Retrieves the storefront access token of a private application. These are scoped per-application.
UrlRedirects	Returns a list of redirects for a shop.