Get Sales

This API provides Sales Channel wise data for SKUs sold during a date range along with the Total sales volumes and the Total Amount of the sales done.

Request

Header Params

Authorization

string

required

Example:

Bearer 3e4b6e748d872a95aa39483ca54b27cb49eb464f

BB-Warehouse

string

optional

Example:

5489566654b27cb49eb464f

Body Params application/json

method

string

required

sku, month

from_date

string

required

From date

to_date

string

required

To Date

Example

{
    "method":"month",
    "from_date":"2024-01-01",
    "to_date":"2025-01-31"
}

Responses

🟢200Success

application/json

Body

order_no

string

required

po_no

string

required

order_date

string

required

month

string

required

order_type

string

required

channel_id

integer

required

warehouse

string

required

buyer_name

string

required

product_sku

string

required

product_name

string

required

total_sales

number

required

total_amount

number

required

Example

{
    "data": [
        {
            "order_no": "ORD/00000036",
            "po_no": "",
            "order_date": "2024-03-05",
            "week_no": "03-2024",
            "order_type": "B2B/Retail",
            "channel_id": null,
            "warehouse": "Centtral Warehouse",
            "buyer_name": "Amazon Sales",
            "product_sku": "FG/ABC/0012",
            "product_name": "My New Product",
            "total_sales": "70.0000000000",
            "total_amount": "1864.00"
        },
        {
            "order_no": "ORD/00000039",
            "po_no": "",
            "order_date": "2024-04-26",
            "week_no": "04-2024",
            "order_type": "B2B/Retail",
            "channel_id": null,
            "warehouse": "Centtral Warehouse",
            "buyer_name": "Amazon Sales",
            "product_sku": "FG-WHEA-001",
            "product_name": "New Wheat",
            "total_sales": "10.0000000000",
            "total_amount": "1000.05"
        },
        {
            "order_no": "ORD/00000039",
            "po_no": "",
            "order_date": "2024-04-26",
            "week_no": "04-2024",
            "order_type": "B2B/Retail",
            "channel_id": null,
            "warehouse": "Centtral Warehouse",
            "buyer_name": "Amazon Sales",
            "product_sku": "FG/ABC/0012",
            "product_name": "My New Product",
            "total_sales": "10.0000000000",
            "total_amount": "1180.00"
        },
        {
            "order_no": "ORD/00000040",
            "po_no": "",
            "order_date": "2024-05-08",
            "week_no": "05-2024",
            "order_type": "B2B/Retail",
            "channel_id": null,
            "warehouse": "Centtral Warehouse",
            "buyer_name": "ABC Distributer",
            "product_sku": "FG-WHEA-001",
            "product_name": "New Wheat",
            "total_sales": "250.0000000000",
            "total_amount": "32125.50"
        },
        {
            "order_no": "ORD/00000043",
            "po_no": "samppoo",
            "order_date": "2024-07-01",
            "week_no": "07-2024",
            "order_type": "Online",
            "channel_id": null,
            "warehouse": "Centtral Warehouse",
            "buyer_name": "Amazon Sales",
            "product_sku": "FG/ABC/0012",
            "product_name": "My New Product",
            "total_sales": "100.0000000000",
            "total_amount": "11800.00"
        },
        {
            "order_no": "ORD/00000044",
            "po_no": "",
            "order_date": "2024-10-01",
            "week_no": "10-2024",
            "order_type": "B2B/Retail",
            "channel_id": "1",
            "warehouse": "Centtral Warehouse",
            "buyer_name": "Amazon Sales",
            "product_sku": "FG-WHEA-001",
            "product_name": "New Wheat",
            "total_sales": "1500.0000000000",
            "total_amount": "150007.50"
        },
        {
            "order_no": "ORD/00000045",
            "po_no": "",
            "order_date": "2024-11-06",
            "week_no": "11-2024",
            "order_type": "B2B/Retail",
            "channel_id": "5",
            "warehouse": "Centtral Warehouse",
            "buyer_name": "ABC Distributer",
            "product_sku": "FG/001/001",
            "product_name": "MI FG 001",
            "total_sales": "1500.0000000000",
            "total_amount": "2655000.00"
        },
        {
            "order_no": "ORD/00000046",
            "po_no": "",
            "order_date": "2024-11-12",
            "week_no": "11-2024",
            "order_type": "B2B/Retail",
            "channel_id": "5",
            "warehouse": "Centtral Warehouse",
            "buyer_name": "ABC Distributer",
            "product_sku": "SFG/01/001",
            "product_name": "DSDSFSFS",
            "total_sales": "100.0000000000",
            "total_amount": "177000.00"
        },
        {
            "order_no": "ORD/00000047",
            "po_no": "MYPONO0001",
            "order_date": "2024-12-20",
            "week_no": "12-2024",
            "order_type": "B2B/Retail",
            "channel_id": "1",
            "warehouse": "Centtral Warehouse",
            "buyer_name": "NYKAA",
            "product_sku": "ANEW_COMBO",
            "product_name": "Physical Combo Test one",
            "total_sales": "1000.0000000000",
            "total_amount": "177000.00"
        },
        {
            "order_no": "ORD/00000047",
            "po_no": "MYPONO0001",
            "order_date": "2024-12-20",
            "week_no": "12-2024",
            "order_type": "B2B/Retail",
            "channel_id": "1",
            "warehouse": "Centtral Warehouse",
            "buyer_name": "NYKAA",
            "product_sku": "FG-COMBO-001",
            "product_name": "Physical Combo 01",
            "total_sales": "1000.0000000000",
            "total_amount": "171100.00"
        }
    ],
    "_links": {
        "self": {
            "href": "http://localhost/bizeebuy/rest/web/v1/sales?page=1"
        },
        "first": {
            "href": "http://localhost/bizeebuy/rest/web/v1/sales?page=1"
        },
        "last": {
            "href": "http://localhost/bizeebuy/rest/web/v1/sales?page=2"
        },
        "next": {
            "href": "http://localhost/bizeebuy/rest/web/v1/sales?page=2"
        }
    },
    "_meta": {
        "totalCount": 12,
        "pageCount": 2,
        "currentPage": 1,
        "perPage": 10
    }
}