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
      • Purchase Orders List
    • 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
      • Sales Orders List
    • TrueGradient
      • Item Master - FG
        POST
      • Sales Order Status
        POST
      • FG Inventory-Batchwise
        POST
      • Open Purchase Orders
        POST
      • Item Master - Materials
        POST
      • FG BoM
        POST
Home
Home
  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

Body Params application/json

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

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