TDV Adapter for Shopify

Build 24.0.9060

Tables

The adapter models the data in Shopify as a list of tables in a relational database that can be queried using standard SQL statements.

Shopify Adapter 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060