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. Inventory can have many states (see Inventory states on Shopify's documentation site). We have multiple fields that break out this inventory:Few readers

• Reporting 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 readers

• Shopify 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 readers

• Report 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 readers

• Reporting 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

• 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 placedFew readers

• Shopify order level reporting

  When creating a report you have the option to choose which "level" to report on. Report Level Report Level: Any Level Results are not grouped Report Level: Order Results will be grouped by order, with each order on its own row. Fields that are repeated as part of an order (e.g. sales, products) will be collapsed into a single column under the order they are associated with. ExampleFew 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 forPopular

• Limit 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 readers

• Query 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 readers

• Known 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