Shopify

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.

Order State

Chord provides two views of orders:

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.