Reporting
Report on current product inventory from Shopify
SyncWith can report on your product inventory in Shopify. The quantities shown are the current stock levels. Set your time range to All Time to report on all products, regardless of when they were first added to your store. If you are reporting at the product level, use the Product total inventory metric. This reports on available stock (i.e., it excludes damaged and committed stock). If you are reporting at the variant level, or need to break out by warehouse location, use thFew readersReporting on Shopify Analytics
SyncWith can report on a wide array of data at Shopify, including sales, and inventory, but Shopify doesn't make what they call "Analytics" data available outside of Shopify (as far as we can tell!) This generally includes things that happen on your Shopify store before an order is placed. SyncWith can still report on all sorts of things about orders, products, sales, iFew readersShopify sales reporting
SyncWith can easily report on your sales for Shopify, whether by time period (by day, week, month, etc) or by product, and much more. When reporting on sales Shopify has a few key metrics that are important to understand:Few readersReport privacy and sharing settings
SyncWith offers three Shopify integrations: Google Sheets, Looker Studio and an embedded application in the Shopify admin UI. In all three integrations, your reports are private to you unless explicitly shared. If you want to share your report, the process varies based on the integration: Google Sheets: To share a report in Google Sheets, use the Google Sheets sharing settings in the upper right corner. Share a Google Sheet (https://storage.crisp.chat/users/helpdesk/website/ae068b3706aaFew readersReporting on Shopify Metafields
SyncWith can report on your store's custom metafields. Only product and order metafields are supported, however we're limited to 25 metafields per object type. Custom fields, which are similar to metafields but less structured, are not supported by SyncWith.Few readers
Troubleshooting
Connect your Shopify store
This document explains how to connect your Shopify store to SyncWith using our Shopify Google Sheets integration or our Shopify Looker Studio connector. Shopify requires us to send you to their app store to install our app. This can make things a little tricky forPopularLimit on number of concurrent Shopify reports
SyncWith uses a special bulk data endpoint. This allows us to report on large datasets spanning long period of times. However, Shopify limits the number of such reports that can be run simultaneously: only one report can run at a time. SyncWith will try to hide this complexity when handling your scheduled reports, but you may encounter it when creating and editing reports. If you see an error related to it, please try your report again. When two Shopify reports for the same store attempt to ruFew readersQuery gid://shopify/BulkOperation/1234 was canceled
If you receive an error like Query gid://shopify/BulkOperation/1234 was canceled or A bulk query operation for this app and shop is already in progress: gid://shopify/BulkOperation/4581579817270 when running a Shopify report using SyncWith, this is because SyncWith's integration with Shopify is currently limited to running 1 report per store currently. If multiple reports attempt to run at the same time, either on a schedule, or when you refresh them manually, or even when creating a newFew readersKnown issue - Internal server error running query
If you receive an error like Internal server error running query gid://shopify/BulkOperation/3422257807473 when running a report against Shopify, the best bet is to try to shorten your date range or somehow reduce the number of rows being requested. When you run a Shopify report using SyncWith, SyncWith then runs a query at Shopify to pull the data needed for the report, and we've seen that occasionally Shopify will fail to return the necessary data with this error. We're investigating to seFew readers