---
title: "How to edit the timezone for a Shopify query"
slug: "how-to-edit-the-timezone-for-a-shopify-query"
description: "Adjust Shopify query timezones in Supermetrics for accurate data. Learn how to modify timezones in your reporting tools."
updated: 2026-05-06T12:12:56Z
published: 2026-05-06T13:25:57Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to edit the timezone for a Shopify query

Supermetrics isn’t able to convert data that matches dynamic time ranges for specific timezones in your data destination.If this impacts your Shopify queries — for instance, if you get different results for a different day when you set “Yesterday” or “Today” as a query’s date range — you can edit the query’s timezone manually.

This can be especially helpful if you're seeing [Shopify data discrepancies when working with data across different timezones](/v1/docs/about-timezone-setting-discrepancies-in-shopify-data).

## Instructions

****Google Sheets****

1. Open the Supermetrics sidebar.
2. Select the Shopify query you'd like to modify.
3. Scroll down and click the **Options** dropdown.
4. Under **Reporting timezone**, choose the timezone for the query.

****Data Studio****

1. Click any report element from your query in Data Studio to open the Supermetrics pane.
2. Click the **Edit icon** next to Shopify to open the configuration page.
3. Click **Edit connection**.
4. Scroll down to **Reporting timezone**.
5. Select the timezone that matches your Shopify's store timezone.

While you’re in this view, we recommend checking the box next to **Allow “Reporting timezone” to be modified in reports**. With this enabled, you can adjust the timezone only for selected data objects on your dashboard that are using the dynamic date range of “Today” or “Yesterday”.

****Excel****

1. Open the Supermetrics sidebar.
2. Select a Shopify query and click **Modify**.
3. Go to **Options**.
4. Under **Reporting timezone**, choose the timezone for the query.

****Power BI****

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **Power BI** under **Analyze**.
2. Select the Shopify query to modify.
3. Select the connection to use.
4. Go to **Options**.
5. Under **Reporting timezone**, choose the timezone for the query.

****The Supermetrics API****

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **API queries** under **Manage**.
2. Select the Shopify data source and the query to modify.
3. In the sidebar, go to **Options**.
4. Under **Reporting timezone**, choose the timezone for the query.
5. Click **Run** to run the query.

****Data warehouse****

[When setting up your data transfer](/v1/docs/how-to-create-a-transfer), navigate to **General settings** and select the timezone settings to use.