The sequence in which data from source systems is processed is as follows.
This is driven by: https://github.com/Daasity/platform-sql-v2/blob/master/clients/_daasity_growth/daily_incremental.yml
Diagram
https://www.lucidchart.com/invitations/accept/e1d8b4b2-ac6e-4277-a906-de0b1b35bb8f
Order Sources
Shopify
- Locations
- Customers
- Customers
- Products
- Product Variants
- Orders
- Order Line Items
- Order Discount Codes
- Order Shipping Service
- Order Payments
- Transactions
- Refunds
- Refund Line Items
- Fulfillments
- Order Item Fulfillments
- Shopify Sales Report
Amazon Seller Central
- Locations
- Customers
- Products
- Product Variants
- Orders
- Order Line Items
- Order Payments
- Transactions
- Fulfillments
- Order Item Fulfillments
- Current Inventory Levels
Skubana (not live yet)
- Locations
- Customers
- Products
- Product Variants