Tables

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

CData Excel Add-In 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.