Chord Commerce Data Platform
Data Models
Orders
3min
overview chord utilizes transactional data from the oms (chord oms, shopify, etc ) to derive the orders dataset created vs completed orders chord has two different order concepts created order when the order was first created in the oms this date will be most closely aligned with how omses report orders completed order when the order is considered complete, either when it's closed or fully fulfilled this timestamp is useful for financial reporting, such as revenue recognition for shopify, the closed at timestamp is generated for orders in shopify that are automatically archived if this feature is not enabled, the last updated closed fulfillment date is used as the completed at date for chord oms, the order is considered completed when the completed at date is not null this means that the order does not necessarily have a state = 'complete', since states can change after the order completion (for example in the case of a refund) orders vs sales explores the "orders" explore contains all orders regardless of status, whereas the "sales" explore includes only completed orders if you have any questions or need help, please reach out to us at help\@chord co mailto\ help\@chord co