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 |
| ApplicationCharges | Create or view Application Charges for Billing. |
| ApplicationCredit | Create or view Application Credit for Billing. |
| Articles | Create, read, update or delete articles |
| Assets | Create, read, update or delete assets. CUD support is no longer accessible for public apps. |
| Blogs | Create, read, update or delete blogs |
| CarrierServices | Returns a list of resource feedback objects.. |
| CollectionListings | Query and delete information regarding different collects. |
| Collects | Query, insert, or delete information regarding different collects. |
| Comments | Create, read, update and delete the comments. |
| Countries | Create, select, update, and delete information regarding countries. |
| CustomCollections | Query, insert, update, or delete information regarding different custom collections. |
| CustomerAddresses | Create, update, delete, and query customer addresses. |
| Customers | Create, update, delete, and query customers. |
| DiscountCodes | Create, select, update, and delete information regarding discount codes. |
| DraftOrders | Create, update, delete, and query draft orders. |
| FulfillmentEvents | Create, delete, and query information regarding fulfillment events. |
| Fulfillments | Create, update, and query fulfillments. |
| FulfillmentServices | Query, create, update, and delete information regarding different fulfillment services. |
| GiftCards | Create, update, delete, and query gift cards. |
| InventoryItems | Query and update information regarding different inventory items. |
| InventoryLevels | Query, create, and update information regarding different inventory levels. |
| MarketingEvents | Create, update, delete, and query marketing events. |
| Metafields | Retrieves a list of metafields that belong to a resource. |
| OrderRisks | Create, update, delete, and query order risks. |
| Orders | Create, update, delete, and query orders. |
| OrderTransactions | Create and query transactions. |
| Pages | Create, read, update or delete pages |
| PriceRules | Create, update, delete, and query price rules. |
| ProductImages | Query, Update and Delete Product Images |
| ProductListings | Query and delete product listings. |
| ProductOptions | Query product options. |
| ProductResourceFeedbacks | Returns a list of resource feedback objects.. |
| Products | List of products. |
| ProductVariants | List of the product variants. |
| Provinces | Query and update information regarding different provinces. |
| RecurringApplicationCharges | Create, update, delete, and query Recurring Application Charges. |
| Redirects | Create, read, update or delete redirects. |
| Refunds | Create and query refunds. |
| ResourceFeedbacks | Returns a list of resource feedback objects.. |
| ScriptTags | Create, read, update or delete script tags. |
| SmartCollections | Query, insert, update, or delete information regarding different smart collections. |
| Themes | Create, read, update or delete themes |
| UsageCharges | Create or view Usage Charges for Recurring Application Charges. |