website logo
Navigate through spaces
Chord Commerce
⌘K
Getting Started
CMS
Data
OMS
Integrations
👩‍💻Developer Tools
Shopify
Docs powered by archbee 
3min

Timestamp differences between Looker, OMS and Shopify



Introduction

The default timezone in Looker for OMS timestamps is UTC, whereas the OMS UI displays EST.

Within Looker, we've added additional timezone options for some of our timestamps but not for Order Approved Date. Custom time zones can be created with a custom field and can be submitted as a feature request.



Shopify uses the last edited_at timestamp in reporting if the order was edited whereas Chord's models use the timestamp of order fulfillment.



This means edited orders show in February in Shopify because it was edited in February but the order was *placed *in January.



Yet, *unedited orders placed *in January, not edited, and not fulfilled until February, so Looker shows this in February but Shopify shows.



What counts as an edited order in Shopify?

Shopify Analytics If you edit an order after the day the order was placed, then the edit appears as a separate order in your reports. The reports display the edit as if it is a new order, even though a new order hasn't been created.



What reports in Looker will be impacted by this discrepancy?

Orders over time, Sales over time, Average order value over time.



if you have any questions or need help, please reach out to us at help@chord.co



Updated 03 Mar 2023
Did this page help you?
Yes
No
UP NEXT
How to create custom calculations in Looker
Docs powered by archbee 
TABLE OF CONTENTS
Introduction
What counts as an edited order in Shopify?
What reports in Looker will be impacted by this discrepancy?