Skip to main content
The Get Report node lets you fetch performance data from your connected Shopify store using specified metrics, dimensions, and filters. This is an AI-powered node that can understand natural language instructions.

​
When to Use It

Use this node to:
  • Generate automated sales and performance reports
  • Track order metrics and customer behavior over time
  • Create data-driven insights for business decisions
  • Export data for further analysis in external tools
  • Monitor inventory levels and product performance

​
Setup Requirements

Before using this node, you need to connect your Shopify store to Markifact. Follow our step-by-step guide:

How to Connect Your Shopify Store

Complete setup guide with screenshots

​
Inputs

FieldTypeRequiredDescription
Date RangeDate range pickerYesSelect date range for the report
MetricsMulti-selectYesSelect metrics to include in the report
DimensionsMulti-selectNoSelect dimensions to segment your data
FiltersRule-based filtersNoAdd filters to refine your data
Order BySort configurationNoSet the order of results
LimitNumberNoMaximum number of rows to return
OptionsReport optionsNoAdditional options for the report

​
Filters

Filters allow you to refine your data by applying conditions to specific dimensions or metrics. Multiple filters use AND logic - all conditions must be met for a row to be included in the results.

​
Available Filter Operators

OperatorDescriptionExample Use Case
EQUALSExact matchProduct type equals “Electronics”
NOT_EQUALSDoes not match exactlyOrder status not equals “cancelled”
CONTAINSContains substringProduct title contains “iPhone”
NOT_CONTAINSDoes not contain substringProduct title doesn’t contain “test”
IN_LISTMatches any value in listOrder status in [“fulfilled”, “paid”]
NOT_IN_LISTDoesn’t match any value in listPayment status not in [“pending”]
REGEXP_MATCHMatches regular expressionProduct title matches ”.(phone|tablet).”
NOT_REGEXP_MATCHDoesn’t match regexProduct title doesn’t match “test.*“
GREATER_THANNumeric greater thanOrder value > 100
LESS_THANNumeric less thanQuantity < 10
IS_NULLField has no valueDiscount code is null
IS_NOT_NULLField has a valueDiscount code is not null

​
Filter Examples

Example 1: High-value fulfilled orders 
- Order value > 50 (GREATER_THAN)
- Order status = "fulfilled" (EQUALS)
- Payment status = "paid" (EQUALS)
Example 2: Electronics products using regex (OR logic) 
- Product type matches ".*(phone|tablet|laptop).*" (REGEXP_MATCH)
Example 3: Exclude test orders 
- Customer email does not contain "test" (NOT_CONTAINS)
- Order total > 0 (GREATER_THAN)

​
OR Logic with Filters

Since multiple filters use AND logic, use these approaches for OR conditions:
  1. IN_LIST operator: Order status IN ["fulfilled", "shipped", "delivered"]
  2. REGEXP_MATCH operator: Product type REGEXP_MATCH ".*(electronics|accessories|gadgets).*"
  3. Run separate queries: Create different workflows for different conditions

​
Options Reference

These optional settings let you format the output from Shopify before passing it to other nodes.
OptionDescription
Pretty Column NamesConverts column headers to Title Case (e.g. orderValue becomes Order Value)
Add Percent Sign to RatiosAppends % to ratio metrics like Conversion Rate
Display Currency SymbolAdds $ or local currency symbol to monetary metrics
Compact NumbersConverts large numbers to short format (e.g. 10K instead of 10,000)
Pivot Dimensions as ColumnsTransforms dimension values into separate columns for easier comparison

​
Output

The node returns a structured dataset with performance metrics and dimensions. The exact format depends on your configuration and the data returned from Shopify. Typical Output Structure:
  • Data Rows: Performance metrics and dimensions
  • Metadata: Store information, date ranges, and query details
  • Summary Statistics: Total records, data freshness, execution time
Can be passed to:
  • AI nodes like Analyze Data or Structured Output
  • Export nodes (e.g., Google Sheets)
  • Email or Slides nodes

​
Credit Cost

  • Cost per run: 1 credit (per successful execution)

​
Example Setup

Scheduler (Daily 9 AM) →
Shopify Get Report →
AI Analysis →
Google Slides Report →
Email Report
Configuration Example:
  • Date Range: Last 30 days
  • Metrics: Total Sales, Order Count, New Customers, Average Order Value
  • Dimensions: Date, Product Type
  • Filters: Order Status = “fulfilled”
  • Limit: 1000 rows

​
FAQs

Multiple filters always use AND logic (all conditions must be true). For OR logic, use:Option 1: IN_LIST operator
Order status IN ["fulfilled", "shipped", "delivered"]
Option 2: REGEXP_MATCH operator
Product type REGEXP_MATCH ".*(electronics|accessories|gadgets).*"
Option 3: Run separate workflows Create different Get Report nodes for different conditions, then combine the data downstream.
  • CONTAINS: Simple substring search. Product title CONTAINS "iPhone" finds any product with “iPhone” anywhere in the title
  • REGEXP_MATCH: Advanced pattern matching. Product title REGEXP_MATCH "^iPhone.*" finds products that START with “iPhone”
Use CONTAINS for simple text searches, REGEXP_MATCH for complex patterns or OR conditions.
Common filter issues:
  • Case sensitivity: “Electronics” ≠ “electronics”. Use CONTAINS or regex for flexible matching
  • Data type mismatch: Don’t use text operators on numeric fields like order value
  • Field availability: Not all dimensions/metrics support all filter operators
  • Syntax errors: Check regex patterns for proper escaping
Shopify connections are store-specific - each connection represents one Shopify store. You don’t need to select accounts because the node automatically uses your connected store’s data.
Each Shopify store requires a separate connection in Markifact. You’ll need to:
  • Use different Get Report nodes for each store’s data
  • Create individual connections with each store’s credentials
Common causes of empty results:
  • Date range: The selected period may have no orders or activity
  • Filters: Your filters may be too restrictive
  • Store status: Your store may be in development mode or have no sales
  • Permissions: Check that your access token has the required permissions
  • Connection: Verify your Shopify connection is still active
Data discrepancies can occur due to:
  • Order statuses: Different filters applied (e.g., including/excluding refunds)
  • Data freshness: Reports may take time to sync
  • Calculation methods: Different aggregation methods between Shopify admin and API
If your API token fails:
  • Token visibility: API tokens are only shown once when created
  • Permissions: Ensure you selected the required scopes (read_orders, read_customers, read_inventory)
  • App status: Verify your custom app is installed and active
  • Token expiry: Check if you need to regenerate the token
  • Store ID: Confirm you’re using the correct store ID from your admin URL
Your Store ID is in your Shopify admin URL:
  1. Log in to your Shopify admin dashboard
  2. Look at the URL in your browser
  3. Find the text after /store/ in the URL
  4. Example: In https://admin.shopify.com/store/my-store, your Store ID is my-store
If your Shopify connection fails:
  • Check if your custom app is still installed in Shopify
  • Verify the access token hasn’t been revoked
  • Ensure your Shopify store is active and accessible
  • Try reconnecting with a new access token
  • Contact support if issues persist
⌘I