Home
Home
  1. TrueGradient
  • BizeeBuy API Introduction
  • V1
    • Authentication
      • Generate Access Token
      • Refresh Access Token
    • Masters
      • Get Warehouse List
      • Finished Goods List
      • Material List
    • Purchase
    • GRN
    • Inventory
      • FG Stock Status
      • Material Stock Status
    • Production
      • Batch List
      • Material Consumption
    • Sales
      • Sales Order Dispatch
      • Sales Order Status
      • Turnover & Gross Margin Report
      • FG Demand Status Report
      • Get Sales
      • Get Sales Invoices
    • TrueGradient
      • Item Master - FG
        POST
      • Sales Order Status
        POST
      • FG Inventory-Batchwise
        POST
      • Open Purchase Orders
        POST
      • Item Master - Materials
        POST
      • FG BoM
        POST
  1. TrueGradient

Sales Order Status

POST
https://api.bizeebuy.com/v1/sales/order-status
This API offers the details around the Sales Orders and their status in terms of Items Ordered vs Dispatched vs pendencies at an SKU level. It also provides the financial information related to respective Sales Orders such as rates, tax values etc.
There are are following two versions of this data set available for access through this API:
Sales order data Inclusive of All the Returned Orders ie. Report type =WR ie "With Return".
Sales order data Exclusive of the Returned Orders ie. Report type =R .

Request

Header Params
Authorization
string 
required
Example:
Bearer 3e4b6e748d872a95aa39483ca54b27cb49eb464f
Body Params application/json
version
string 
required
With Return or Without Return
from_date
string 
required
From Date IST - 2024-12-01
to_date
string 
required
To date IST - 2024-12-31
Example
{
    "version":"WR",
    "from_date":"2024-01-01",
    "to_date":"2025-01-31"
}

{
    "version":"R",
    "from_date":"2024-01-01",
    "to_date":"2025-01-31"
}

Responses

🟢200Success
application/json
Body
product_sku
string 
required
product_name
string 
required
Prod_type
string 
required
SO_order_id
string 
required
order_date
string 
required
order_time
string 
required
po_no
string 
required
po_date
string 
required
party_name
string 
required
warehouse
string 
required
Order_qty
string 
required
UoM
string 
required
rate
string 
required
Order_value
string 
required
gst
string 
required
total_amount
string 
required
issued_qty
string 
required
last_issue_date
string 
required
Remaining_qty
string 
required
return_qty
string 
required
usable_qty
string 
required
unusable_qty
string 
required
Return_date
string 
required
SoStatus
string 
required
invoice_no
string 
required
invoice_date
string 
required
pincode
string 
required
Examples
{
    "data": [
        {
            "product_sku": "FG/ABC/0012",
            "product_name": "My New Product",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000036",
            "order_date": "2024-03-05",
            "order_time": "13:49:00",
            "po_no": "",
            "po_date": "2024-03-05",
            "party_name": "Amazon Sales",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "10",
            "UoM": "Nos",
            "rate": "100.00",
            "Order_value": "1000.00",
            "gst": "18.00",
            "total_amount": "1180.00",
            "issued_qty": "10",
            "last_issue_date": "2024-03-15",
            "Remaining_qty": "0",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Closed",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110011"
        },
        {
            "product_sku": "FG/ABC/0012",
            "product_name": "My New Product",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000037",
            "order_date": "2024-03-15",
            "order_time": "15:02:18",
            "po_no": "",
            "po_date": "2024-03-15",
            "party_name": "Amazon Sales",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "30",
            "UoM": "Nos",
            "rate": "10.00",
            "Order_value": "300.00",
            "gst": "10.00",
            "total_amount": "330.00",
            "issued_qty": "30",
            "last_issue_date": "2024-03-15",
            "Remaining_qty": "0",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Closed",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110011"
        },
        {
            "product_sku": "FG/ABC/0012",
            "product_name": "My New Product",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000038",
            "order_date": "2024-03-15",
            "order_time": "15:03:09",
            "po_no": "",
            "po_date": "2024-03-15",
            "party_name": "ABC Distributer",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "30",
            "UoM": "Nos",
            "rate": "10.00",
            "Order_value": "300.00",
            "gst": "18.00",
            "total_amount": "354.00",
            "issued_qty": "0",
            "last_issue_date": "Not Issued",
            "Remaining_qty": "30",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Accepted",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110001"
        },
        {
            "product_sku": "ITPRINTINK01",
            "product_name": "Printer INK",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000038",
            "order_date": "2024-03-15",
            "order_time": "15:03:09",
            "po_no": "",
            "po_date": "2024-03-15",
            "party_name": "ABC Distributer",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "10",
            "UoM": "Units",
            "rate": "0.00",
            "Order_value": "0.00",
            "gst": "0.00",
            "total_amount": "0.00",
            "issued_qty": "0",
            "last_issue_date": "Not Issued",
            "Remaining_qty": "10",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Accepted",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110001"
        },
        {
            "product_sku": "FG-WHEA-001",
            "product_name": "New Wheat",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000039",
            "order_date": "2024-04-26",
            "order_time": "12:56:23",
            "po_no": "",
            "po_date": "2024-04-26",
            "party_name": "Amazon Sales",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "10",
            "UoM": "Kg",
            "rate": "84.75",
            "Order_value": "847.50",
            "gst": "18.00",
            "total_amount": "1000.05",
            "issued_qty": "10",
            "last_issue_date": "2024-05-08",
            "Remaining_qty": "0",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Closed",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110011"
        },
        {
            "product_sku": "FG/ABC/0012",
            "product_name": "My New Product",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000039",
            "order_date": "2024-04-26",
            "order_time": "12:56:23",
            "po_no": "",
            "po_date": "2024-04-26",
            "party_name": "Amazon Sales",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "10",
            "UoM": "Nos",
            "rate": "100.00",
            "Order_value": "1000.00",
            "gst": "18.00",
            "total_amount": "1180.00",
            "issued_qty": "10",
            "last_issue_date": "2024-05-08",
            "Remaining_qty": "0",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Closed",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110011"
        },
        {
            "product_sku": "FG-WHEA-001",
            "product_name": "New Wheat",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000040",
            "order_date": "2024-05-08",
            "order_time": "16:50:08",
            "po_no": "",
            "po_date": "2024-05-08",
            "party_name": "ABC Distributer",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "150",
            "UoM": "Kg",
            "rate": "125.00",
            "Order_value": "18750.00",
            "gst": "18.00",
            "total_amount": "22125.00",
            "issued_qty": "80",
            "last_issue_date": "2024-05-08",
            "Remaining_qty": "70",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Partial Issued",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110001"
        },
        {
            "product_sku": "FG-WHEA-001",
            "product_name": "New Wheat",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000041",
            "order_date": "2024-05-13",
            "order_time": "13:19:04",
            "po_no": "",
            "po_date": "2024-05-13",
            "party_name": "Amazon Sales",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "100",
            "UoM": "Kg",
            "rate": "84.75",
            "Order_value": "8475.00",
            "gst": "18.00",
            "total_amount": "10000.50",
            "issued_qty": "0",
            "last_issue_date": "Not Issued",
            "Remaining_qty": "100",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Accepted",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110011"
        },
        {
            "product_sku": "FG/ABC/0012",
            "product_name": "My New Product",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000043",
            "order_date": "2024-07-01",
            "order_time": "10:10:59",
            "po_no": "samppoo",
            "po_date": "2024-07-01",
            "party_name": "Amazon Sales",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "100",
            "UoM": "Nos",
            "rate": "100.00",
            "Order_value": "10000.00",
            "gst": "18.00",
            "total_amount": "11800.00",
            "issued_qty": "0",
            "last_issue_date": "Not Issued",
            "Remaining_qty": "100",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Accepted",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110011"
        },
        {
            "product_sku": "FG-WHEA-001",
            "product_name": "New Wheat",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000044",
            "order_date": "2024-10-01",
            "order_time": "11:00:39",
            "po_no": "",
            "po_date": "2024-10-15",
            "party_name": "Amazon Sales",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "1500",
            "UoM": "Kg",
            "rate": "84.75",
            "Order_value": "127125.00",
            "gst": "18.00",
            "total_amount": "150007.50",
            "issued_qty": "0",
            "last_issue_date": "Not Issued",
            "Remaining_qty": "1500",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Accepted",
            "invoice_no": "SAL-00000009",
            "invoice_date": "2024-10-15 00:00:00",
            "pincode": "110011"
        },
        {
            "product_sku": "FG/001/001",
            "product_name": "MI FG 001",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000045",
            "order_date": "2024-11-06",
            "order_time": "16:07:53",
            "po_no": "",
            "po_date": "2024-11-06",
            "party_name": "ABC Distributer",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "1500",
            "UoM": "Nos",
            "rate": "1500.00",
            "Order_value": "2250000.00",
            "gst": "18.00",
            "total_amount": "2655000.00",
            "issued_qty": "140",
            "last_issue_date": "2024-11-06",
            "Remaining_qty": "1360",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Partial Issued",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110001"
        },
        {
            "product_sku": "SFG/01/001",
            "product_name": "DSDSFSFS",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000046",
            "order_date": "2024-11-12",
            "order_time": "18:59:07",
            "po_no": "",
            "po_date": "2024-11-12",
            "party_name": "ABC Distributer",
            "party_city": "Delhi",
            "warehouse": "Central",
            "Order_qty": "100",
            "UoM": "Nos",
            "rate": "1500.00",
            "Order_value": "150000.00",
            "gst": "18.00",
            "total_amount": "177000.00",
            "issued_qty": "50",
            "last_issue_date": "2024-12-20",
            "Remaining_qty": "50",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Partial Issued",
            "invoice_no": null,
            "invoice_date": null,
            "pincode": "110001"
        },
        {
            "product_sku": "ANEW_COMBO",
            "product_name": "Physical Combo Test one",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000047",
            "order_date": "2024-12-20",
            "order_time": "15:18:52",
            "po_no": "MYPONO0001",
            "po_date": "2024-12-20",
            "party_name": "NYKAA",
            "party_city": "New delhi",
            "warehouse": "Central",
            "Order_qty": "1000",
            "UoM": "Nos",
            "rate": "150.00",
            "Order_value": "150000.00",
            "gst": "18.00",
            "total_amount": "177000.00",
            "issued_qty": "1000",
            "last_issue_date": "2024-12-20",
            "Remaining_qty": "0",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Closed",
            "invoice_no": "SAL-00000010",
            "invoice_date": "2024-12-20 00:00:00",
            "pincode": "110001"
        },
        {
            "product_sku": "FG-COMBO-001",
            "product_name": "Physical Combo 01",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000047",
            "order_date": "2024-12-20",
            "order_time": "15:18:52",
            "po_no": "MYPONO0001",
            "po_date": "2024-12-20",
            "party_name": "NYKAA",
            "party_city": "New delhi",
            "warehouse": "Central",
            "Order_qty": "1000",
            "UoM": "Pack",
            "rate": "145.00",
            "Order_value": "145000.00",
            "gst": "18.00",
            "total_amount": "171100.00",
            "issued_qty": "1000",
            "last_issue_date": "2024-12-20",
            "Remaining_qty": "0",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Closed",
            "invoice_no": "SAL-00000010",
            "invoice_date": "2024-12-20 00:00:00",
            "pincode": "110001"
        },
        {
            "product_sku": "New-PROD-0001",
            "product_name": "New product post FG Allowed IN BoM",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000047",
            "order_date": "2024-12-20",
            "order_time": "15:18:52",
            "po_no": "MYPONO0001",
            "po_date": "2024-12-20",
            "party_name": "NYKAA",
            "party_city": "New delhi",
            "warehouse": "Central",
            "Order_qty": "1000",
            "UoM": "Bunches",
            "rate": "280.00",
            "Order_value": "280000.00",
            "gst": "18.00",
            "total_amount": "330400.00",
            "issued_qty": "1000",
            "last_issue_date": "2024-12-20",
            "Remaining_qty": "0",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Closed",
            "invoice_no": "SAL-00000010",
            "invoice_date": "2024-12-20 00:00:00",
            "pincode": "110001"
        },
        {
            "product_sku": "SFG/01/001",
            "product_name": "DSDSFSFS",
            "Prod_type": "Single",
            "SO_order_id": "ORD/00000047",
            "order_date": "2024-12-20",
            "order_time": "15:18:52",
            "po_no": "MYPONO0001",
            "po_date": "2024-12-20",
            "party_name": "NYKAA",
            "party_city": "New delhi",
            "warehouse": "Central",
            "Order_qty": "1000",
            "UoM": "Nos",
            "rate": "500.00",
            "Order_value": "500000.00",
            "gst": "18.00",
            "total_amount": "590000.00",
            "issued_qty": "1000",
            "last_issue_date": "2024-12-20",
            "Remaining_qty": "0",
            "return_qty": "0",
            "usable_qty": "0",
            "unusable_qty": "0",
            "Return_date": "N/A",
            "SoStatus": "Closed",
            "invoice_no": "SAL-00000010",
            "invoice_date": "2024-12-20 00:00:00",
            "pincode": "110001"
        }
    ],
    "_links": {
        "self": {
            "href": "http://localhost/bizeebuy/rest/web/v1/sales/order-status?page=1"
        },
        "first": {
            "href": "http://localhost/bizeebuy/rest/web/v1/sales/order-status?page=1"
        },
        "last": {
            "href": "http://localhost/bizeebuy/rest/web/v1/sales/order-status?page=1"
        }
    },
    "_meta": {
        "totalCount": 16,
        "pageCount": 1,
        "currentPage": 1,
        "perPage": 20
    }
}
Previous
Item Master - FG
Next
FG Inventory-Batchwise
Built with