Knowledge base

Getting your data

![Shopify](https://www.synchub.io/i/logos/shopify.png) Looking to free your Shopify data? Good, you’ve come to the right place. ## Getting connected 1. Select **Connections** from the main menu 2. Click the **New** button 3. Select **Shopify** 4. Give it a name (this is especially useful if you’re creating multiple Shopify connections) 5. Authorise the connection by following the prompts to sign in to your Shopify account 6. Done. Now watch as SyncHub begins retrieving your historical data. To connect multiple Shopify accounts, simply follow the steps above for each one. Just make sure to check that your SyncHub plan allows for multiple API connections. ## Available endpoints SyncHub works by regularly querying each endpoint in the Shopify API, checking for new and modified data. For each endpoint SyncHub produces a corresponding data table in your reporting tool. These are the endpoints currently available: - Abandoned checkout - Collection - Collection product - Customer - Customer address - Fulfillment - Inventory item - Inventory level - Location - Shop meta field - Order - Order line item - Product - Product image - Refund - Shop - Smart collection - Smart collection product - Tender transaction - Abandoned checkout note attribute - Abandoned checkout shipping line - Abandoned checkout line item - Abandoned checkout tax line - Collection meta field - Customer meta field - Customer tag - Fulfillment line item - Location meta field - Order discount code - Order tax line - Order meta field - Order tag - Order line discount allocation - Order line item tax line - Product variant - Product tag - Product option - Product meta field - Refund line item - Refund order adjustment - Smart collection meta field - Abandoned checkout shipping line tax line - Product variant meta field - Product option value Need more data? No problem, please [let us know](https://www.synchub.io/contact) and we'll see if we can add it. Or if you're a data nerd like us, feel free to check out the Shopify API documentation to see what’s available. ### What data does SyncHub take from Shopify? SyncHub extracts the endpoints above from Shopify, and stores it in your data warehouse. ### What data does SyncHub create or modify in Shopify? Nothing. SyncHub is read-only and never sends data back to Shopify. ## Building your reports SyncHub stores data in a relational database optimized for reporting. This means that reporting from your favourite reporting tool is as easy as using their standard _database connector_. We have detailed walkthroughs for the most popular reporting tools here: - [Power BI](/kb/powerbi?api=shopify) - [Excel](/kb/excel?api=shopify) - [Tableau](/kb/tableau?api=shopify)