**Version: 202601**

# Get data analysis by SKU

**POST** `/openapi/2026-01/data-analysis/sku`

Provides merchants with detailed insights into sales data, enabling data-driven decision-making by analyzing products by SKU.

## Request

**application/json**

**Body | Example**

**Body (required)**

- `begin_time` string (required)

  Start time, a Unix timestamp in seconds passed as a string, e.g. "1748736000"
- `end_time` string (required)

  End time, a Unix timestamp in seconds passed as a string, e.g. "1781481600". Should be greater than begin\_time
- `cursor` string

  Cursor for pagination
- `page_size` int32

  Page size for pagination

  **Possible values:** `>= 1` and `<= 500`

  **Default value:** `10`
- `page` int32

  Page number (1-based). Mutually exclusive with cursor
- `sort_by` string

  Field to sort by. Supported values:

  *   `variant_op_updated_at`: Last updated time of the variant
  *   `views_count`: Number of page views
  *   `add_to_cart_count`: Number of add-to-cart actions
  *   `order_count`: Number of orders
  *   `sales_total`: Total sales amount
  *   `net_sales_total`: Net sales amount
  *   `add_to_cart_rate`: Add-to-cart rate
  *   `add_to_cart_conversion_rate`: Add-to-cart conversion rate
  *   `sales_count`: Number of items sold
  *   `views_rate`: Page view rate
- `time_zone` int32

  Notice: Values outside the range -12 to 14 might lead to unexpected results in time-based calculations. Time zone offset (in hours) used for analysis. Recommended range: -12 to 14
- `sort_direction` string

  Sort order: asc (ascending), desc (descending)
- `collection_id` string

  Filter by collection ID
- `sales_platform` string

  Sales channel filter. Supported values:

  *   `shopping_action`: Google Shopping Action
  *   `shoplazza`: Online store
  *   `mocart`: Mocart
- `keyword` string

  Keyword fuzzy search: title, ID, brief, SKU, SPU, tags, note
- `search_model` string

  Filtering mode: base (default) or advanced. When set to advanced, the additional filter fields below take effect
- `collection_name` string

  Filter by collection name
- `title` string

  Filter by product title
- `tag_list` string

  Filter by product tags
- `category` string

  Filter by product category
- `sub_category` boolean

  Whether to include all sub-category levels in the search
- `cost_price_min` string

  Minimum cost price, e.g. "1.99"
- `cost_price_max` string

  Maximum cost price, e.g. "8.99"
- `product_note` string

  Filter by product note / remark
- `vendor` string

  Filter by vendor / supplier name
- `created_at_min_at` string

  Filter products created at or after this time, e.g. "2026-04-01 00:00:00"
- `created_at_max_at` string

  Filter products created at or before this time, e.g. "2026-04-04 00:00:00"
- `filter_crawler_type` string

  Crawler-filtering policy that controls whether bot/crawler traffic is excluded from the statistics. Values:

  *   `no_filter_crawler`: do not filter; count all traffic (default)
  *   `official_crawler`: exclude known crawlers/bots

```json
{
  "begin_time": "string",
  "end_time": "string",
  "cursor": "string",
  "page_size": 10,
  "page": 0,
  "sort_by": "string",
  "time_zone": 0,
  "sort_direction": "string",
  "collection_id": "string",
  "sales_platform": "string",
  "keyword": "string",
  "search_model": "string",
  "collection_name": "string",
  "title": "string",
  "tag_list": "string",
  "category": "string",
  "sub_category": true,
  "cost_price_min": "string",
  "cost_price_max": "string",
  "product_note": "string",
  "vendor": "string",
  "created_at_min_at": "string",
  "created_at_max_at": "string",
  "filter_crawler_type": "string"
}
```

## Responses

**200**

OK

**application/json**

**Schema | Example**

**Schema**

- `code` string

  error code
- `message` string

  error message
- `data` object

  - `count` int32

    Total number of matching records
  - `last_updated_at` string

    Latest statistics update time, e.g. "2026-03-26 00:00:00"
  - `cursor` string

    Cursor for pagination
  - `has_more` boolean

    Whether there are more records
  - `data` object[]

    List of variant-level sales data items

    *   Array \[

    - `product_id` string

      Product ID
    - `variant_id` string

      Variant ID (SKU level)
    - `title` string

      Product title
    - `brief` string

      Product subtitle / brief description
    - `variant_title` string

      Variant title, e.g. size or color combination
    - `sku` string

      Stock keeping unit code
    - `spu` string

      Standard product unit code
    - `image` string

      Product image filename
    - `seo_url` string

      SEO-friendly product URL path including variant parameter
    - `price` float

      Variant price in shop currency
    - `variant_op_updated_at` string

      Last operation update time of the variant, in ISO-8601 format
    - `sales_count` int32

      Number of items sold
    - `sales_total` float

      Total sales amount
    - `net_sales_total` float

      Net sales amount after deducting refunds
    - `order_count` int32

      Number of orders containing this variant
    - `refund_count` int32

      Number of refund transactions
    - `views_count_original` int32

      Product detail page view count, numeric value
    - `view_client_count` int32

      Number of unique visitors to the product detail page
    - `add_to_cart_count_original` int32

      Add-to-cart event count, numeric value
    - `add_cart_client_count` int32

      Number of unique users who added this variant to cart
    - `transform_rate_original` float

      Conversion rate from visit to order, numeric value, e.g. 100 (represents 100%)
    - `add_to_cart_conversion_rate_original` float

      Conversion rate from add-to-cart to order, numeric value, e.g. 100 (represents 100%)
    - `published_at` string

      First publish time of the product, in ISO-8601 format
    - `refund_quantity` int32

      Total number of refunded items
    - `add_to_cart_rate_original` float

      Add-to-cart rate as a percentage of product page views, numeric value
    - `views_rate_original` float

      Share of this variant's views among all product views, numeric value
    - `opened_orders` int32

      Number of open / pending orders
    - `refund_orders` int32

      Number of orders that have been fully refunded
    - `transform_rate` string

      Conversion rate from visit to order, formatted string, e.g. "100.00%"
    - `add_to_cart_conversion_rate` string

      Conversion rate from add-to-cart to order, formatted string, e.g. "100.00%"
    - `add_to_cart_rate` string

      Add-to-cart rate, formatted string, e.g. "100.00%"
    - `views_rate` string

      Share of total product views, formatted string, e.g. "100.00%"
    - `views_count` string

      Product detail page views, formatted string, e.g. "1"
    - `add_to_cart_count` string

      Add-to-cart count, formatted string, e.g. "1"
    *   \]

```json
{
  "code": "string",
  "message": "string",
  "data": {
    "count": 0,
    "last_updated_at": "string",
    "cursor": "string",
    "has_more": true,
    "data": [
      {
        "product_id": "string",
        "variant_id": "string",
        "title": "string",
        "brief": "string",
        "variant_title": "string",
        "sku": "string",
        "spu": "string",
        "image": "string",
        "seo_url": "string",
        "price": 0,
        "variant_op_updated_at": "string",
        "sales_count": 0,
        "sales_total": 0,
        "net_sales_total": 0,
        "order_count": 0,
        "refund_count": 0,
        "views_count_original": 0,
        "view_client_count": 0,
        "add_to_cart_count_original": 0,
        "add_cart_client_count": 0,
        "transform_rate_original": 0,
        "add_to_cart_conversion_rate_original": 0,
        "published_at": "string",
        "refund_quantity": 0,
        "add_to_cart_rate_original": 0,
        "views_rate_original": 0,
        "opened_orders": 0,
        "refund_orders": 0,
        "transform_rate": "string",
        "add_to_cart_conversion_rate": "string",
        "add_to_cart_rate": "string",
        "views_rate": "string",
        "views_count": "string",
        "add_to_cart_count": "string"
      }
    ]
  }
}
```