# Shopify Shopify is a leading e-commerce platform that allows businesses to create and manage online stores. It provides a comprehensive suite of tools for handling everything from product listings and inventory management to order processing, payments, and shipping. Shopify's robust reporting features offer insights into sales, customer behavior, and overall store performance. However, for advanced analysis and reporting, integrating Shopify data with other data sources is often necessary. Okay, here's a revised draft for the Shopify data source section, reflecting Uniquery's approach of retrieving "resources" rather than explicitly defining metrics and dimensions: ### **Shopify Resources in Uniquery** Instead of using the traditional "metrics" and "dimensions" terminology, Uniquery works with Shopify *resources*. A resource represents a type of data object within Shopify, such as an Order, a Product, or a Customer. Each resource has a set of associated *fields* that contain the specific data points. When you create a Shopify report in Uniquery, you select the resource you want to import. ### **Shopify Resources Supported by Uniquery** Uniquery supports importing data from the following Shopify resources: * **Orders:** Contains all information related to orders placed in your store, including order details, line items, customer information, shipping and billing addresses, payment details, refunds, and fulfillment status. * **Products:** Contains information about your products, including titles, descriptions, variants (with prices and SKUs), inventory levels (through associated Inventory Level objects), images, and more. * **Collects:** Represents the relationships between products and collections. Useful for understanding which products belong to which collections. * **Events:** Records various events that occur within your Shopify store, such as order creation, product updates, and customer account changes. * **Gift cards:** Contains data on gift cards issued by your store. * **Custom collections:** Contains information of your custom collections. * **Marketing events:** Contains marketing activities. * **Blogs** Contains blog posts ### **Filtering Shopify Data (Order Status)** For the `Orders` resource, Uniquery provides an additional filtering option: * **Order Status:** You can choose to import orders with a specific status: * **Any:** Imports all orders, regardless of status. * **Open:** Imports only orders that are currently open (not yet fulfilled or canceled). * **Closed:** Imports only orders that have been fulfilled. * **Canceled:** Imports only orders that have been canceled. This allows you to focus your reports on specific subsets of your order data. ### **Limiting the Number of Records (Limit)** The Shopify API has limits on the number of records that can be retrieved in a single request. Uniquery allows you to specify a `Limit` for your data import: * **Limit (Optional):** Enter the number of records you want to import. The default value is 50. The maximum value is 250, due to Shopify's API limitations. Uniquery automatically handles pagination, so even if you set a limit of 250, and there are more than 250 records, running the query again will retrieve the next set of records. ### **Example: Importing Order Data** To import order data into your Google Sheet: 1. **Connect to Shopify:** In the Uniquery sidebar, go to "Manage Connections" and add a connection to your Shopify store. 2. **Create a Report:** Go to the "Create Report" page. 3. **Select Resource:** Choose "Orders" from the "Choose a Shopify resource type to import" dropdown. 4. **Filter by Status (Optional):** Select the desired "Order status" (Any, Open, Closed, or Canceled). 5. **Set Limit (Optional):** Enter a value for "Limit" (maximum 250). Leave blank for the default of 50. 6. **Generate Report:** Click the button to generate the report. Uniquery will import the specified order data into your Google Sheet. The data will be presented with each field (e.g., `order_number`, `created_at`, `total_price`, `customer.email`, etc.) as a separate column. **Example: Importing product data** To import product data, select "Products" as resource, set limits, and then click the button to generate the report. All product data will be imported into the Google Sheet. By selecting different resources and using the available filtering and limiting options, you can create a wide variety of reports in Google Sheets to analyze your Shopify data and gain valuable insights into your store's performance. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://help.uniquery.io/data-sources/shopify.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.