Data: General Data Flow

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

  1. Locations
  2. Customers
  3. Customers
  4. Products
  5. Product Variants
  6. Orders
  7. Order Line Items
  8. Order Discount Codes
  9. Order Shipping Service
  10. Order Payments
  11. Transactions
  12. Refunds
  13. Refund Line Items
  14. Fulfillments
  15. Order Item Fulfillments
  16. Shopify Sales Report

Amazon Seller Central

  1. Locations
  2. Customers
  3. Products
  4. Product Variants
  5. Orders
  6. Order Line Items
  7. Order Payments
  8. Transactions
  9. Fulfillments
  10. Order Item Fulfillments
  11. Current Inventory Levels

Skubana (not live yet)

  1. Locations
  2. Customers
  3. Products
  4. Product Variants