When you connect a Shopify Sales Transaction data source, transactions from the two most recent days will be downloaded first. This is to ensure that you have some data to work with while Funnel works on getting your entire history downloaded.

After loading your two most recent days, your Shopify data will be downloaded in chronological order, starting from the date when the shop’s first order was created. How long this takes completely depends on the number of orders your Shopify store has, scaling from around one hour to several days.

Due to limitations in the Shopify API, the "Stored data" interval cannot be used as an accurate indicator of what data has been successfully downloaded. The interval only reflects the first date containing data and the most recent date (usually the current day), but this may not represent all the data in between.

This behaviour is only relevant when you first connect a Shopify data source. Upon connection, transactions from the two most recent days are downloaded first to ensure you have some data to work with while Funnel continues downloading the full historical data in chronological order, starting from your shop’s first order. The time required to complete this process depends on the volume of orders, and can range from an hour to several days.

Any data mismatches during this period are usually because the download is still in progress, so please allow more time for the download to finish.
​To check if your data source is completely backfilled, we recommend checking your Data explorer for dates that are between 4-7 days in the past.

We're also actively working on improving the accuracy of the "Stored data" status.

The Sales Transaction report replaces the previous report types offered by Funnel:

The most common reason for delays when downloading Shopify data is when you have connected more than one Shopify source with the same API credentials/app in Funnel. Only one data source at a time can download data per Shopify app. If you have connected more than one data source to the same Shopify app, the data sources will compete with each other and cause delays. Therefore, it is strongly recommended that you create a new app in your shop for each data source in Funnel.

Funnel will download Shopify data at the following frequencies:

Our connector has a couple of different Referrer source dimensions, they all come in two versions, e.g. First Visit Source and Last Visit Source.

One thing that may not be obvious about them is that if an order was made on the first visit, it will have no value on the last visit source. It will only be attributed to the first visit source.

You can make your own custom dimension to solve this problem, here is a quick example of how that may look:

The easiest way to group your data by First-time and Returning customers is to use the Customer Sale Type dimension.