Articles on: Shopify

Filtering Shopify reports by date

SyncWith matches the behaviour of Shopify's built-in reporting interface when reporting on orders and sales. It's useful to review Shopify's terminology:

An Order is a collection of 1 or more sales
A Sale is something that causes money to change hands, for example, a user buying a product, a user exchanging a product, a merchant issuing a refund

If you specify a date range filter, your report will include all sales that happened during that date range. For example, if a user placed an order on October 30th, then returned some of the items on November 2nd, a report limited to the month of November would show that order. However, it would only report the sales activity from the refunds, not from the original purchases.

How do timezones work?

The timezone of your Google Sheet is used. Please see our article on managing timezones in the Google Sheets add-on for more information.

How does the date range filter apply for reports that only report on Customers or Products?

When reporting on things other than Orders, an entry will be returned if the item's Created at date falls within the date range specified.

Can I filter orders by their Created at date?

This is not currently possible, orders will always be filtered by whether or not any of their sales match your date range filter.

Updated on: 12/09/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!