How long does it take to download my data?
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.
Why is my data source’s “Stored data” interval is complete even though I’m missing data?
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.
Temporary delays in data imports
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.
At what frequency will my Shopify data update?
Funnel will download Shopify data at the following frequencies:
Sales transaction report
Data younger than 2 days will be refreshed every 4 hours.
Data younger than 3 days will be refreshed every 24 hours.
Inventory report
Data is downloaded once every 4 hours.
Why can't I see my historical data in the inventory report?
When connecting a Shopify inventory report, data is downloaded and stored in snapshots, starting from the date you connect your data source. Data is then downloaded once every 4 hours. The field "Date" in Funnel shows the date data was downloaded. This means that historical data prior to the date you connected your data source is not included.
Understanding Referrer Source dimensions
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:
How do I group my sales data by First-time/Returning customers?
The easiest way to group your data by First-time and Returning customers is to use the Customer Sale Type dimension.
Related Shopify guides