REST Data Model
The CData Excel Add-In for Shopify models the Shopify API as relational tables, views, and stored procedures.
To use the REST Data Model, simply set Schema to REST.
Note: As of October 1, 2024, Shopify has designated the REST API as legacy.
Tables
The テーブル section, which details standard SQL tables, and the ビュー section, which lists read-only SQL tables, contain samples of what you might have access to in your Shopify account.
Common tables include:
| Table | Description |
| Shop | Contains general settings and information about the shop. |
| Customers | Create, update, delete, and query customers. |
| CustomerAddresses | Create, update, delete, and query customer addresses. |
| Orders | Create, update, delete, and query orders. |
| OrdersItems | Query order items. |
| OrderTransactions | Create, update, delete, and query transactions. |
| Refunds | Create, update, delete, and query refunds. |
| RefundsItems | Get data on OrdersItems that have been refunded. |
| Redirects | Create, update, delete, and query redirects. |
| Collects | Query, insert, or delete information regarding different collects. |
| DiscountCodes | Create, select, update, and delete information regarding discount codes. |
| PriceRules | Create, update, delete, and query price rules. |
| DraftOrders | Create, update, delete, and query draft orders. |
| DraftOrderItems | Query draft order items. |
| Fulfillments | Create, update, and query fulfillments. |
| FulfillmentOrders | Query fulfillment orders. |
| FulfillmentEvents | Create, delete, and query information regarding fulfillment events. |
| Locations | Retrieve information regarding store locations. |
| TaxItems | Query order taxes. |
| Users | Query Users. |
Stored Procedures
ストアドプロシージャ are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including managing order cancellations and fulfillments, sending invoices, and handling authentication flows.