How do I install the Order Analytics skill?

Run npx skillmds@latest add wix/order-analytics in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

What does the Order Analytics skill do?

Order Analytics - Wix Orders API It is listed under Data & Analytics on SkillMD.

Is Order Analytics safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Order Analytics?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Order Analytics free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Order Analytics?

wix (@wix) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Order Analytics by wix — Agent Skill

Name: Order Analytics
Author: wix

Order Analytics - Wix Orders API

Overview

Complete order querying, revenue calculation, trend analysis, and cohort analysis using direct Wix REST API calls.

Configuration

App ID: df7c18eb-009b-4868-9891-15e19dddbe67
API Key: ${API_KEY}
Site ID: ${SITE_ID}

Query Orders

Basic Order Query

Endpoint: POST https://www.wixapis.com/stores/v2/orders/query

API Call:

curl -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "paging": {
      "limit": 50,
      "offset": 0
    }
  }
}'

Response:

{
  "orders": [
    {
      "id": "order-123",
      "number": "1001",
      "dateCreated": "2026-02-21T10:30:00.000Z",
      "paymentStatus": "PAID",
      "fulfillmentStatus": "FULFILLED",
      "priceSummary": {
        "subtotal": "100.00",
        "shipping": "10.00",
        "tax": "8.50",
        "discount": "15.00",
        "total": "103.50"
      },
      "buyerInfo": {
        "email": "customer@example.com",
        "contactId": "contact-abc123"
      },
      "lineItems": [
        {
          "productName": "Product A",
          "quantity": 2,
          "price": "50.00"
        }
      ]
    }
  ],
  "metadata": {
    "count": 50,
    "offset": 0,
    "total": 450
  }
}

Query Orders by Date Range

curl -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"dateCreated\": {\"$gte\": \"2026-02-01T00:00:00.000Z\", \"$lte\": \"2026-02-28T23:59:59.000Z\"}}",
    "sort": "{\"dateCreated\": \"desc\"}",
    "paging": {"limit": 100}
  }
}'

Query Paid Orders Only

curl -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"paymentStatus\": \"PAID\"}",
    "sort": "{\"dateCreated\": \"desc\"}",
    "paging": {"limit": 100}
  }
}'

Query Orders by Fulfillment Status

curl -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"fulfillmentStatus\": \"NOT_FULFILLED\", \"paymentStatus\": \"PAID\"}",
    "sort": "{\"dateCreated\": \"asc\"}",
    "paging": {"limit": 50}
  }
}'

Query High-Value Orders

curl -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"priceSummary.total\": {\"$gte\": \"200.00\"}, \"paymentStatus\": \"PAID\"}",
    "sort": "{\"priceSummary.total\": \"desc\"}",
    "paging": {"limit": 50}
  }
}'

Get Single Order

Endpoint: GET https://www.wixapis.com/stores/v2/orders/{orderId}

API Call:

curl -X GET "https://www.wixapis.com/stores/v2/orders/${ORDER_ID}" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Accept: application/json"

Response:

{
  "order": {
    "id": "order-123",
    "number": "1001",
    "dateCreated": "2026-02-21T10:30:00.000Z",
    "paymentStatus": "PAID",
    "fulfillmentStatus": "FULFILLED",
    "priceSummary": {
      "subtotal": "100.00",
      "shipping": "10.00",
      "tax": "8.50",
      "discount": "15.00",
      "total": "103.50"
    },
    "buyerInfo": {
      "email": "customer@example.com",
      "contactId": "contact-abc123",
      "firstName": "John",
      "lastName": "Doe"
    },
    "shippingInfo": {
      "logistics": {
        "shippingDestination": {
          "address": {
            "addressLine": "123 Main St",
            "city": "San Francisco",
            "subdivision": "CA",
            "postalCode": "94105",
            "country": "US"
          }
        }
      }
    },
    "lineItems": [
      {
        "id": "lineitem-001",
        "productName": "Product A",
        "quantity": 2,
        "price": "50.00",
        "lineItemPrice": "100.00",
        "productId": "product-abc"
      }
    ]
  }
}

Revenue Calculations

Calculate Total Revenue (Last 30 Days)

#!/bin/bash

# Get orders from last 30 days
START_DATE=$(date -u -v-30d +"%Y-%m-%dT00:00:00.000Z")
END_DATE=$(date -u +"%Y-%m-%dT23:59:59.999Z")

orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d "{
  \"query\": {
    \"filter\": \"{\\\"dateCreated\\\": {\\\"\\$gte\\\": \\\"$START_DATE\\\", \\\"\\$lte\\\": \\\"$END_DATE\\\"}, \\\"paymentStatus\\\": \\\"PAID\\\"}\",
    \"paging\": {\"limit\": 1000}
  }
}")

# Calculate total revenue
total_revenue=$(echo "$orders" | jq '[.orders[].priceSummary.total | tonumber] | add')
order_count=$(echo "$orders" | jq '.orders | length')
avg_order_value=$(echo "$orders" | jq '[.orders[].priceSummary.total | tonumber] | add / length')

echo "30-Day Revenue Report"
echo "===================="
echo "Total Orders: $order_count"
echo "Total Revenue: \$$total_revenue"
echo "Average Order Value: \$$avg_order_value"

Calculate Revenue by Product

#!/bin/bash

# Get all paid orders
orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"paymentStatus\": \"PAID\"}",
    "paging": {"limit": 1000}
  }
}')

# Extract line items and calculate revenue by product
echo "$orders" | jq -r '
  [.orders[].lineItems[]] |
  group_by(.productName) |
  map({
    product: .[0].productName,
    quantity_sold: ([.[].quantity] | add),
    revenue: ([.[].lineItemPrice | tonumber] | add)
  }) |
  sort_by(-.revenue) |
  .[] |
  "\(.product) | Qty: \(.quantity_sold) | Revenue: $\(.revenue)"
'

Calculate Discount Impact

#!/bin/bash

orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"paymentStatus\": \"PAID\"}",
    "paging": {"limit": 1000}
  }
}')

# Calculate discount metrics
total_discount=$(echo "$orders" | jq '[.orders[].priceSummary.discount | tonumber] | add')
orders_with_discount=$(echo "$orders" | jq '[.orders[] | select(.priceSummary.discount | tonumber > 0)] | length')
total_orders=$(echo "$orders" | jq '.orders | length')
discount_rate=$(echo "scale=2; $orders_with_discount / $total_orders * 100" | bc)

echo "Discount Impact Analysis"
echo "======================="
echo "Orders with discounts: $orders_with_discount / $total_orders ($discount_rate%)"
echo "Total discount given: \$$total_discount"
echo "Average discount per order: \$$(echo "scale=2; $total_discount / $total_orders" | bc)"

Trend Analysis

Daily Revenue Trend

#!/bin/bash

# Get last 30 days of orders
START_DATE=$(date -u -v-30d +"%Y-%m-%dT00:00:00.000Z")
END_DATE=$(date -u +"%Y-%m-%dT23:59:59.999Z")

orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d "{
  \"query\": {
    \"filter\": \"{\\\"dateCreated\\\": {\\\"\\$gte\\\": \\\"$START_DATE\\\", \\\"\\$lte\\\": \\\"$END_DATE\\\"}, \\\"paymentStatus\\\": \\\"PAID\\\"}\",
    \"paging\": {\"limit\": 1000}
  }
}")

# Group by date and calculate daily revenue
echo "$orders" | jq -r '
  [.orders[] | {
    date: (.dateCreated | split("T")[0]),
    revenue: (.priceSummary.total | tonumber)
  }] |
  group_by(.date) |
  map({
    date: .[0].date,
    orders: length,
    revenue: ([.[].revenue] | add)
  }) |
  sort_by(.date) |
  .[] |
  "\(.date) | Orders: \(.orders) | Revenue: $\(.revenue)"
'

Month-over-Month Growth

#!/bin/bash

# Current month
CURRENT_MONTH_START=$(date -u +"%Y-%m-01T00:00:00.000Z")
CURRENT_MONTH_END=$(date -u +"%Y-%m-%dT23:59:59.999Z")

# Previous month
PREV_MONTH_START=$(date -u -v-1m +"%Y-%m-01T00:00:00.000Z")
PREV_MONTH_END=$(date -u -v-1m +"%Y-%m-%dT23:59:59.999Z")

# Get current month orders
current=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d "{
  \"query\": {
    \"filter\": \"{\\\"dateCreated\\\": {\\\"\\$gte\\\": \\\"$CURRENT_MONTH_START\\\", \\\"\\$lte\\\": \\\"$CURRENT_MONTH_END\\\"}, \\\"paymentStatus\\\": \\\"PAID\\\"}\",
    \"paging\": {\"limit\": 1000}
  }
}")

# Get previous month orders
previous=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d "{
  \"query\": {
    \"filter\": \"{\\\"dateCreated\\\": {\\\"\\$gte\\\": \\\"$PREV_MONTH_START\\\", \\\"\\$lte\\\": \\\"$PREV_MONTH_END\\\"}, \\\"paymentStatus\\\": \\\"PAID\\\"}\",
    \"paging\": {\"limit\": 1000}
  }
}")

current_revenue=$(echo "$current" | jq '[.orders[].priceSummary.total | tonumber] | add // 0')
previous_revenue=$(echo "$previous" | jq '[.orders[].priceSummary.total | tonumber] | add // 0')

growth=$(echo "scale=2; ($current_revenue - $previous_revenue) / $previous_revenue * 100" | bc)

echo "Month-over-Month Growth"
echo "======================"
echo "Previous month: \$$previous_revenue"
echo "Current month: \$$current_revenue"
echo "Growth: $growth%"

Top Selling Products (Last 30 Days)

#!/bin/bash

START_DATE=$(date -u -v-30d +"%Y-%m-%dT00:00:00.000Z")
END_DATE=$(date -u +"%Y-%m-%dT23:59:59.999Z")

orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d "{
  \"query\": {
    \"filter\": \"{\\\"dateCreated\\\": {\\\"\\$gte\\\": \\\"$START_DATE\\\", \\\"\\$lte\\\": \\\"$END_DATE\\\"}, \\\"paymentStatus\\\": \\\"PAID\\\"}\",
    \"paging\": {\"limit\": 1000}
  }
}")

echo "Top 10 Best Sellers (Last 30 Days)"
echo "==================================="
echo ""

echo "$orders" | jq -r '
  [.orders[].lineItems[]] |
  group_by(.productName) |
  map({
    product: .[0].productName,
    units_sold: ([.[].quantity] | add),
    revenue: ([.[].lineItemPrice | tonumber] | add)
  }) |
  sort_by(-.units_sold) |
  .[:10] |
  to_entries |
  .[] |
  "\(.key + 1). \(.value.product) - \(.value.units_sold) units - $\(.value.revenue)"
'

Cohort Analysis

First-Time vs Repeat Customers

#!/bin/bash

# Get all paid orders
orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"paymentStatus\": \"PAID\"}",
    "sort": "{\"dateCreated\": \"asc\"}",
    "paging": {"limit": 1000}
  }
}')

# Analyze customer purchase frequency
echo "$orders" | jq -r '
  [.orders[] | {email: .buyerInfo.email, date: .dateCreated, total: .priceSummary.total}] |
  group_by(.email) |
  map({
    email: .[0].email,
    order_count: length,
    first_order_date: .[0].date,
    last_order_date: .[-1].date,
    total_spent: ([.[].total | tonumber] | add)
  }) |
  group_by(if .order_count == 1 then "first_time" else "repeat" end) |
  map({
    segment: .[0] | if .order_count == 1 then "First-Time" else "Repeat" end,
    customers: length,
    total_revenue: ([.[].total_spent] | add),
    avg_revenue_per_customer: ([.[].total_spent] | add / length)
  }) |
  .[] |
  "\(.segment) Customers: \(.customers) | Revenue: $\(.total_revenue) | Avg: $\(.avg_revenue_per_customer)"
'

Customer Lifetime Value (CLV)

#!/bin/bash

orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"paymentStatus\": \"PAID\"}",
    "paging": {"limit": 1000}
  }
}')

echo "Top 20 Customers by Lifetime Value"
echo "==================================="
echo ""

echo "$orders" | jq -r '
  [.orders[] | {email: .buyerInfo.email, total: (.priceSummary.total | tonumber)}] |
  group_by(.email) |
  map({
    email: .[0].email,
    order_count: length,
    total_spent: ([.[].total] | add)
  }) |
  sort_by(-.total_spent) |
  .[:20] |
  to_entries |
  .[] |
  "\(.key + 1). \(.value.email) - \(.value.order_count) orders - $\(.value.total_spent)"
'

Purchase Frequency Distribution

#!/bin/bash

orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"paymentStatus\": \"PAID\"}",
    "paging": {"limit": 1000}
  }
}')

echo "Purchase Frequency Distribution"
echo "==============================="
echo ""

echo "$orders" | jq -r '
  [.orders[] | .buyerInfo.email] |
  group_by(.) |
  map(length) |
  group_by(.) |
  map({
    orders: .[0],
    customers: length
  }) |
  sort_by(.orders) |
  .[] |
  "\(.orders) order(s): \(.customers) customers"
'

Order Fulfillment Analysis

Fulfillment Time Analysis

#!/bin/bash

# Get fulfilled orders from last 30 days
START_DATE=$(date -u -v-30d +"%Y-%m-%dT00:00:00.000Z")

orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d "{
  \"query\": {
    \"filter\": \"{\\\"fulfillmentStatus\\\": \\\"FULFILLED\\\", \\\"dateCreated\\\": {\\\"\\$gte\\\": \\\"$START_DATE\\\"}}\",
    \"paging\": {\"limit\": 1000}
  }
}")

# Note: This requires fulfillment timestamp data
echo "Fulfillment Performance"
echo "======================"
echo "Total fulfilled orders: $(echo "$orders" | jq '.orders | length')"

Pending Fulfillment Report

#!/bin/bash

pending=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"fulfillmentStatus\": \"NOT_FULFILLED\", \"paymentStatus\": \"PAID\"}",
    "sort": "{\"dateCreated\": \"asc\"}",
    "paging": {"limit": 100}
  }
}')

count=$(echo "$pending" | jq '.orders | length')

echo "⚠️  PENDING FULFILLMENT: $count orders"
echo ""
echo "$pending" | jq -r '.orders[] | "Order #\(.number) - \(.dateCreated | split("T")[0]) - $\(.priceSummary.total)"'

Average Order Value (AOV) Segmentation

AOV by Customer Segment

#!/bin/bash

orders=$(curl -s -X POST "https://www.wixapis.com/stores/v2/orders/query" \
  -H "Authorization: ${API_KEY}" \
  -H "wix-site-id: ${SITE_ID}" \
  -H "Content-Type: application/json" \
  -d '{
  "query": {
    "filter": "{\"paymentStatus\": \"PAID\"}",
    "paging": {"limit": 1000}
  }
}')

echo "AOV by Customer Type"
echo "===================="
echo ""

echo "$orders" | jq -r '
  [.orders[] | {email: .buyerInfo.email, total: (.priceSummary.total | tonumber)}] |
  group_by(.email) |
  map({
    email: .[0].email,
    order_count: length,
    total_spent: ([.[].total] | add),
    avg_order_value: ([.[].total] | add / length),
    segment: (if length == 1 then "First-Time" elif length <= 3 then "Occasional" else "Loyal" end)
  }) |
  group_by(.segment) |
  map({
    segment: .[0].segment,
    customers: length,
    avg_order_value: ([.[].avg_order_value] | add / length)
  }) |
  .[] |
  "\(.segment): \(.customers) customers | AOV: $\(.avg_order_value)"
'

Documentation References

Orders API Overview: https://dev.wix.com/docs/rest/business-solutions/stores/orders/introduction
Query Orders: https://dev.wix.com/docs/rest/api-reference/wix-stores/orders/query-orders
Get Order: https://dev.wix.com/docs/rest/api-reference/wix-stores/orders/get-order
Order Object: https://dev.wix.com/docs/rest/business-solutions/stores/orders/the-order-object
Payment Status Values: https://dev.wix.com/docs/rest/business-solutions/stores/orders/order-payment-status
Fulfillment Status Values: https://dev.wix.com/docs/rest/business-solutions/stores/orders/order-fulfillment-status

Order Analytics

File contents

Order Analytics - Wix Orders API

Overview

Configuration

Query Orders

Basic Order Query

Query Orders by Date Range

Query Paid Orders Only

Query Orders by Fulfillment Status

Query High-Value Orders

Get Single Order

Revenue Calculations

Calculate Total Revenue (Last 30 Days)

Calculate Revenue by Product

Calculate Discount Impact

Trend Analysis

Daily Revenue Trend

Month-over-Month Growth

Top Selling Products (Last 30 Days)

Cohort Analysis

First-Time vs Repeat Customers

Customer Lifetime Value (CLV)

Purchase Frequency Distribution

Order Fulfillment Analysis

Fulfillment Time Analysis

Pending Fulfillment Report

Average Order Value (AOV) Segmentation

AOV by Customer Segment

Documentation References

Frequently asked questions

Order Analytics

File contents

Order Analytics - Wix Orders API

Overview

Configuration

Query Orders

Basic Order Query

Query Orders by Date Range

Query Paid Orders Only

Query Orders by Fulfillment Status

Query High-Value Orders

Get Single Order

Revenue Calculations

Calculate Total Revenue (Last 30 Days)

Calculate Revenue by Product

Calculate Discount Impact

Trend Analysis

Daily Revenue Trend

Month-over-Month Growth

Top Selling Products (Last 30 Days)

Cohort Analysis

First-Time vs Repeat Customers

Customer Lifetime Value (CLV)

Purchase Frequency Distribution

Order Fulfillment Analysis

Fulfillment Time Analysis

Pending Fulfillment Report

Average Order Value (AOV) Segmentation

AOV by Customer Segment

Documentation References

Related skills

Frequently asked questions

How do I install the Order Analytics skill?

What does the Order Analytics skill do?

Is Order Analytics safe to use?

Which AI agents work with Order Analytics?

Is Order Analytics free to use?

Who published Order Analytics?