Sales by product (cursor)

Developing

GET

/sales/by-product

Scrollable table of product-level sales metrics for a period. search matches SKU and name.

Request

Authorization

JWT Bearer

Add the parameter

Authorization

to Headers

Example:

Authorization: ********************

API Key

Add parameter in cookie

access_token

Example:

access_token: ********************

Query Params

Request Code Samples

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location 'https://mock.apidog.com/m1/1052146-0-default/sales/by-product?cursor=undefined&limit=undefined&search=undefined&sortKey=undefined&sortDir=undefined&categories=undefined&item=undefined&store=undefined&location=undefined&date_from=undefined&date_to=undefined&status=undefined&units_sold_min=undefined&units_sold_max=undefined&asp_min=undefined&asp_max=undefined&netsales_min=undefined&netsales_max=undefined&cogs_min=undefined&cogs_max=undefined&gp_min=undefined&gp_max=undefined&margin_min=undefined&margin_max=undefined&soh_min=undefined&soh_max=undefined' \
--header 'Authorization: Bearer <token>'

Responses

🟢200OK

application/json

Bodyapplication/json

Example

{
    "success": true,
    "code": "LOGIN_OK",
    "message": "Authenticated",
    "data": {
        "rows": [
            {
                "id": "string",
                "sku": "SKU-000123",
                "name": "Basmati Rice 5kg",
                "category": "Groceries",
                "unit": "Pack",
                "unitsSold": 340,
                "avgSellingPrice": 6500,
                "netSales": 2080000,
                "cogs": 1496000,
                "grossProfit": 584000,
                "marginPercent": 0.28,
                "stockOnHand": 120,
                "lastSoldAt": "2025-09-30T20:06:30.000Z"
            }
        ],
        "nextCursor": "string",
        "hasNext": true
    },
    "meta": {
        "page": 1,
        "perPage": 50,
        "total": 1
    }
}

🟠400Bad Request

🟠401Unauthorized

Modified at 2025-10-06 16:06:43

Get sales summary

Sales by product summary (totals)