Shopify

Shopify is a cloud-based, multichannel commerce platform designed for small and medium-sized businesses. You can use Shopify to manage stores across multiple sales channels, including web, mobile, social media, and brick-and-mortar locations. The Grow/Shopify integration helps you visualize all of your data separately or combined, making it easy to monitor and expand your business.

Connecting to Shopify

Here are the steps to connect your Shopify account to Grow:

  1. Select the Data tab next to the Dashboard. This takes you to the Data Overview page.
  2. Click on the Connections button.
  3. Select the blue Connect button at the end of the Your Top Data Sources options.
  4. From the list of Connections, search and select Shopify.
  5. Click on Connect to Shopify.
  6. Enter your store's domain name and press Connect.
  7. Fill in your Shopify account credentials in the sign in window to complete the connection.
    This window only pops up if you are not already signed in to your Shopify account.

Data Warehousing

Shopify is on the Grow Data Warehouse, which we highly recommend you use. For more information about warehousing your data, visit the Data Warehouse Help Article.

Tables

The list of tables available depends on your unique Shopify project. You can expect to see one table per dataset associated with the project ID in your connection.

Suggested Tables

We pull in all the main tables from the Shopify API.

These tables include:

  • Checkouts
  • Collects
  • Custom-collections
  • Customers
  • Orders
  • Price rules
  • Products
  • Inventory Items

These Shopify API tables power 23 Derived Tables which are available in Grow.

Screen_Shot_2020-11-13_at_10.28.11_AM.png

Warehousing your Data

  1. In the Connections Overview Page, click on your Shopify connection. This opens the Connection Details page.
  2. Select the Manage Connection button inside the Connection Details section to open the warehouse table selection flow.
  3. Select the data you want stored in the Data Warehouse and click the Sync & Store button at the bottom of the Manage Connection page.
    This begins the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, sometimes up to several hours.

You may continue working within the app while your data is In Queue or Processing.

If your data source is not already connected, refer to the Connecting to a Data Source for more details.

Sync Interval

Full Sync

The default sync interval for warehouse tables is 1 week.

Incremental Sync

Incremental Sync is available for all Shopify warehouse tables. The default incremental sync interval is 1 hour.

To learn more about sync intervals and how to adjust the default settings, please visit the Sync section of the Data Warehouse help article.

Endpoints

Here is a list of the reports you can pull in from Shopify Direct Query, along with a short description of each report. All Shopify reports include a Multiple Auths version that can be used to pull data for multiple shops simultaneously.

  • Abandoned Checkouts: All order sessions abandoned mid-checkout within the selected date range, including ID, token, cart token, email, date, referring site, source details, price, discount, subtotal, taxes included, total line items price, total, tax, weight, billing and shipping information, etc.
  • Customers: All customers, including orders count, state, total amount spent, multipass identifier, and tags.
  • Items Sold: A list of all items purchased, including item name and ID, order name and ID, order date, shop name, quantity, price, weight, SKU, vendor, fulfillment status, etc.
  • Orders: All processed orders matching the selected date range, including date created, date closed, gateway, total price, subtotal, weight details, currency type, tax details, order status, cancel reason, cancel date, customer info, discount codes, financial status, fulfillment information, etc.
  • Refunds: All refunds, including refund ID, created date, processed date, refund line items, transactions, restock, notes, user ID, etc.
  • Product List: A list of all products published to the shop inventory, including product name and ID, created date, images, options, product type, tags, variants, inventory quantity, price, restock information, vendor, etc.
  • Shops Timezone: Details for the selected shop(s), including location, time zone, UTC Offset, etc.

Shopify API Docs

https://shopify.dev/docs/admin-api/rest/reference

This is for reference only. You should not need to consult this very often.

FAQs + Tips and Tricks

What does the (Report Name)- Multiple Auth's mean?

These reports allow you to combine information from multiple businesses into one metric easily. When you select this endpoint, you get an additional option to select which stores you would like to include before you pull the data into Grow.

Data Accuracy and ShopifyQL

Because of some differences between the Shopify Admin API and Shopify's internal sales reports, Grow reports often show slight differences in amounts when compared to your internal reports in your Shopify account. This does not mean that data in Grow is incorrect, simply that the internal logic that is applied to generate the numbers seen in Shopify is removed. Many clients create their own logic and view the numbers the way they want to view them while others have found success in recreating the same logic.

I'm trying to pull in data going back several months, but it's not working or it's taking a long time.

Retrieving data through Direct Query can take a long time. To avoid this delay, you can use the Warehouse feature of Grow. Refer Data Warehousing for more details.

Multiple Reports

When pulling from Shopify, it's important to only pull one report at a time. If you try to pull two different reports at the same time, it can overload the connection to Shopify and cause the app to freeze. You'll need to wait for the first report to finish loading before you click connect on the next one.

Time Zones

The time zones used by Shopify to separate days and months of data are specific to the time zone of the shop you're pulling data for. The Grow app uses Coordinated Universal Time (UTC) for its in-app transforms, so the data may look different in Grow. We've included the Shops Timezone report to make it easier to offset your local time to UTC and make sure your dates are grouping correctly.

Was this article helpful?