Shopify

overview chord ingests raw data directly from shopify and then transforms this data through a data modeling layer to clean and enrich for more efficient, enriched, and meaningful analyses chord's data models can differ from what users see directly in the shopify platform variations between chord's data models and the shopify platform order state chord provides two views of orders orders placed regardless of fulfillment status or cancellation completed orders, a subset of all orders defined as an order that has a closed at timestamp and has been fully fulfilled 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 date shopify includes any orders placed regardless of fulfillment status or cancellation the "orders" dataset displays all orders, whereas the "sales" dataset includes completed orders only to get to a view closer to shopify, use the “orders” explore to view all orders and use the "order created at" date field instead of "order completed at " timestamps chord's models provides options for both order created at and order completed at , or closed at , timestamps shopify uses the last edited at timestamp in reporting if the order was edited, and if not edited, the order created at timestamp for example, if an order were placed in january and edited in shopify in february, it would show in february orders yet, unedited orders placed in january would show in january orders within chord, these orders would show either when placed in january or when closed timezones chord provides various timezones for both the "order created at" and "order completed at" fields so you can customize them to your timezone chord's default timezone is utc and provides the following additional timezone options pacific, mountain, central, and eastern in shopify, the timezone can be configured in settings, so you can check the timezone of your account to then use the same timezone within chord if you have any questions or need help, please reach out to us at mailto\ help\@chord co