Click here to learn about Tableau, Power BI, and MS Excel templates for Shopify. WIP.
Tables
Pre-mapped ETL+ tables available. Subject to change without notice.
Important: DataSelf DFT foundation is ERP agnostic - click here to learn more.
|
Source |
Table Name |
|---|---|
|
Shopify |
Customers |
|
Shopify |
DiscountApplications |
|
Shopify |
DiscountCodes |
|
Shopify |
FulfillmentOrders |
|
Shopify |
Fulfillments |
|
Shopify |
InventoryItems |
|
Shopify |
Metafields |
|
Shopify |
OrderItemDiscountAllocations |
|
Shopify |
OrderItemProperties |
|
Shopify |
Orders |
|
Shopify |
OrderItems |
|
Shopify |
OrderTransactions |
|
Shopify |
ProductOptions |
|
Shopify |
Products |
|
Shopify |
ProductVariants |
|
Data Warehouse |
4_Today |
|
Data Warehouse |
5_Date |
|
Data Warehouse |
6_DatePeriod |
Notes:
-
Some of the above tables will only be deployed using customized SOWs or via services.
-
Currently, the Shopify tables can be extracted into the data warehouse using ODBC.
-
We only recommend extracting tables that are important for your reporting purposes.
Table Columns Example
DataSelf ETL+ templates include adjustments to table columns' data types and indexes. Click here to learn more.
The following is an example of a table and its column names, indexes, and formatting in ETL+. Column green icons indicate the data type and/or index definition have been set or changed in ETL+.
Delta Load Example
DataSelf ETL+ templates include delta load configuration for popular large tables. This dramatically reduces the time to refresh the data warehouse. ETL+ Table Load Types.
The following is an example using the Upsert feature.
Related Pages
-
ETL+ for Shopify.