website logo
Navigate through spaces
⌘K
OVERVIEW
ORDER MANAGEMENT (OMS)
CONTENT MANAGEMENT (CMS)
DATA
CUSTOMER LIFETIME REVENUE
Customer Lifetime Revenue Explanation
Customer Lifetime Revenue and Purchase Likelihood
Recency Frequency and Monetary
CLR and RFM Data Table Glossary
RFM and CLR in the Hub
LOOKER
Modifying a Dashboard
Timestamp differences between Looker, OMS and Shopify
How to create custom calculations in Looker
Looker and Shopify data models
Custom fields
How to 'Save and Schedule' reports
Creating Custom Reports or Look
Looks vs Dashboards
Login Looker FAQ
Looker Glossary
SEGMENT EVENT TRACKING
What are event tracking
Adding Tracking
What is the Tracking Plan?
The Chord Tracking Plan
The Shopify Tracking Plan
Event Tracking FAQ
EVENT UPDATES PAGE
Email Subscription Payment Event Update
Product Feed Setup
Getting Segment to Production
Consent Management
Installing in Next.js
Installing in Gatsby
Integrations
👩‍💻Developer Tools
Using Chord with Shopify
Docs powered by
Archbee
LOOKER

Timestamp differences between Looker, OMS and Shopify

3min



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?
PREVIOUS
Modifying a Dashboard
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?
Docs powered by
Archbee