Skip to main content

Shopify node

The Shopify Data Source Node is designed to seamlessly integrate your Shopify store's data into your analysis workflows. By leveraging Shopify's robust Admin API, you can pull various data entities directly into your data engine, ready for transformation, filtering, and visualization.

Whether you're tracking sales trends, managing inventory, or understanding customer behavior, this node provides the initial connection to get your Shopify data flowing.

Use Cases​

The Shopify Data Source Node opens up a wide range of analytical possibilities:

  • E-commerce Performance Tracking: Extract order data to analyze sales trends, average order value, and conversion rates over time.
  • Product Analytics: Pull product information to understand best-sellers, inventory levels, and product variations.
  • Customer Segmentation: Extract customer data to identify valuable customer segments, analyze demographics, and personalize marketing efforts.
  • Inventory Management: Monitor stock levels by fetching product and variant data, helping you make informed reordering decisions.
  • Automated Reporting: Integrate with other nodes to build automated reports on your store's health and performance.
  • Marketing Campaign Analysis: Correlate sales data with marketing efforts to measure ROI.

How to Use the Shopify Data Source Node​

To use the Shopify Node, you'll need your Shopify store's domain and an Admin API Access Token.

1. Obtain Your Shopify Admin API Access Token​

To connect securely to your Shopify store, you need to create a Private App within your Shopify admin and obtain its Admin API Access Token.

  1. Log in to your Shopify admin panel.
  2. Navigate to Apps.
  3. Click on Develop apps (usually in the top right or within the menu).
  4. Click Create an app.
    • If you've never created a custom app before, you might see an "Allow custom app development" button first.
  5. Name your app (e.g., "My Data Engine Integration") and enter an App developer email. Then click Create app.
  6. Once the app is created, go to the Configuration tab.
  7. Under "Admin API access scopes," click Configure Admin API scopes.
  8. Crucially, grant the necessary "read" permissions for the data you intend to extract. For example:
    • To get products: Check read_products.
    • To get orders: Check read_orders.
    • To get customers: Check read_customers.
    • Only grant "read" permissions unless you specifically intend to write data (which this node does not do). Granting too many permissions is a security risk.
  9. Click Save.
  10. Go to the API credentials tab.
  11. Click Install app. Confirm by clicking "Install".
  12. Once installed, the Admin API access token will be revealed. Copy this token immediately as it will only be shown once.

2. Configure the Shopify Node​

  1. Drag and drop the Shopify Data Source Node onto your canvas.
  2. Shopify Store Domain: Enter your store's .myshopify.com domain (e.g., my-awesome-store.myshopify.com).
  3. Shopify Admin API Access Token: Paste the Admin API access token you obtained in the previous step.
  4. Click "Connect to Shopify". Once successful, the node will indicate it's connected.
  5. Shopify Resource: Select the type of data you want to extract from the dropdown (e.g., Products, Orders, Customers).
  6. API Query Parameters (Optional): Add any standard Shopify REST API query parameters to filter or paginate your data.
    • Examples:
      • limit=50: Fetch only 50 records.
      • status=any: Fetch orders of any status.
      • fields=id,title,variants: Select specific fields for products.
      • updated_at_min=2024-01-01T00:00:00-00:00: Fetch records updated after a certain date.
    • Do not include the ? at the beginning of your query parameters.
  7. Click "Execute Shopify Query".

The node will then attempt to fetch the data. If successful, the output handle will be populated with the JSON data, and the data schema (columns) will be inferred and available for subsequent nodes in your flow. Any errors or success messages will appear in the system log.

Important Considerations​

  • API Rate Limits: Shopify APIs have rate limits. Be mindful of this when fetching very large datasets or making frequent requests. For large data extraction, consider implementing pagination carefully.
  • Security: While the access token is encrypted at rest within the flow's data, for production applications handling highly sensitive data, consider implementing a secure backend proxy to manage API requests and credentials.
  • Data Structure: Shopify's REST API returns data as JSON. The structure might vary slightly between resources. This node aims to provide the primary collection of records (e.g., products array from /admin/api/products.json).