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

FG Inventory-Batchwise

POST
https://api.bizeebuy.com/v1/truegrad/invetory-snapshot
This API provides an exhaustive data set related to Inventory snapshot for ALL the SKUs[Finished Goods] marked as "Active" in BizeeBuy.

Request

Header Params
Authorization
string 
required
Example:
Bearer 3e4b6e748d872a95aa39483ca54b27cb49eb464f
Warehouse
string 
optional
Example:
cfcd208495d565ef66e7dff9f98764da
Body Params application/json
limit
number 
required
date
string 
required
Example
{
    "date":"2025-01-31",
    "limit":"500"
}

Responses

🟢200Success
application/json
Body
product_name
string 
required
product_sku
string 
required
product_category
string 
required
primary_category
string 
required
batch_no
string 
required
inventory_date
string 
required
expiry_date
string 
required
mfg_date
string 
required
Receipt_qty
integer 
required
Debit_qty
integer 
required
Available_qty
integer 
required
rec_source
string 
required
Examples
{
    "data": [
        {
            "primary_category": "Oil",
            "product_category": "Beard Oil",
            "product_name": "Peanut Butter Cookie 16g Sticker",
            "product_sku": "10",
            "batch_no": "SAVDEMO0001",
            "inventory_date": "2023-05-01",
            "expiry_date": "2030-05-31",
            "mfg_date": "NA",
            "Receipt_qty": "400.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "400.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Oil",
            "product_category": "Beard Oil",
            "product_name": "Peanut Butter Cookie 16g Sticker",
            "product_sku": "10",
            "batch_no": "",
            "inventory_date": "2022-07-12",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "100.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "100.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Raw Material",
            "product_category": "Printed Items",
            "product_name": "Tender Coconut Ice Cream 450 Ml Lid Sticker",
            "product_sku": "33",
            "batch_no": "ASAS343599905",
            "inventory_date": "2023-03-21",
            "expiry_date": "2025-03-07",
            "mfg_date": "NA",
            "Receipt_qty": "6038.0000000000",
            "Debit_qty": "841.0000000000",
            "Available_qty": "5197.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Raw Material",
            "product_category": "Printed Items",
            "product_name": "Tender Coconut Ice Cream 450 Ml Lid Sticker",
            "product_sku": "33",
            "batch_no": "NEW80BATCH",
            "inventory_date": "2022-07-12",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "80.0000000000",
            "Debit_qty": "5.0000000000",
            "Available_qty": "75.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Sample Cat",
            "product_category": "Test Product Cat",
            "product_name": "YB - 14159 - 10g Protein Bar - Dispenser Pack ( Blueberry Blast + Choco chip) (PROMO)",
            "product_sku": "ABCDE00012133132",
            "batch_no": "AVCDFDF001231",
            "inventory_date": "2022-05-12",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "100.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "100.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Sample Cat",
            "product_category": "Test Product Cat",
            "product_name": "Chips 100GM",
            "product_sku": "CHIPS110MG",
            "batch_no": "",
            "inventory_date": "2022-06-01",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "1550.0000000000",
            "Debit_qty": "25.0000000000",
            "Available_qty": "1525.0000000000",
            "rec_source": "N/A"
        },
        {
            "primary_category": "Hair Care",
            "product_category": "Hair Oil",
            "product_name": "Intermideatory Product 01",
            "product_sku": "DEMO00101",
            "batch_no": "3000ABCDE001",
            "inventory_date": "2023-03-21",
            "expiry_date": "2025-03-31",
            "mfg_date": "NA",
            "Receipt_qty": "5.0000000000",
            "Debit_qty": "4.5000000000",
            "Available_qty": "0.5000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "FG",
            "product_category": "Wheats",
            "product_name": "New Wheat",
            "product_sku": "FG-WHEA-001",
            "batch_no": "FGWHEA001",
            "inventory_date": "2023-12-06",
            "expiry_date": "2023-12-31",
            "mfg_date": "2023-12-06",
            "Receipt_qty": "100.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "100.0000000000",
            "rec_source": "Procured"
        },
        {
            "primary_category": "FG",
            "product_category": "Wheats",
            "product_name": "New Wheat",
            "product_sku": "FG-WHEA-001",
            "batch_no": "10SALES-001-001",
            "inventory_date": "2023-07-29",
            "expiry_date": "2023-10-31",
            "mfg_date": "NA",
            "Receipt_qty": "1010.0000000000",
            "Debit_qty": "875.0000000000",
            "Available_qty": "135.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "FG",
            "product_category": "Wheats",
            "product_name": "MI FG 001",
            "product_sku": "FG/001/001",
            "batch_no": "ABDE-01201",
            "inventory_date": "2023-06-30",
            "expiry_date": "2023-10-28",
            "mfg_date": "NA",
            "Receipt_qty": "1000.0000000000",
            "Debit_qty": "899.0000000000",
            "Available_qty": "101.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Hair Care",
            "product_category": "Hair Oil",
            "product_name": "My New Product",
            "product_sku": "FG/ABC/0012",
            "batch_no": "5962320",
            "inventory_date": "2023-09-18",
            "expiry_date": "2025-09-03",
            "mfg_date": "NA",
            "Receipt_qty": "250.0000000000",
            "Debit_qty": "227.0000000000",
            "Available_qty": "23.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "FG",
            "product_category": "Wheats",
            "product_name": "Fully Flavored Wheat",
            "product_sku": "FGWHT0001",
            "batch_no": "24325efsB121",
            "inventory_date": "2023-06-07",
            "expiry_date": "2024-06-29",
            "mfg_date": "NA",
            "Receipt_qty": "8.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "8.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "FG",
            "product_category": "Wheats",
            "product_name": "Fully Flavored Wheat",
            "product_sku": "FGWHT0001",
            "batch_no": "10001000",
            "inventory_date": "2023-06-03",
            "expiry_date": "2023-06-16",
            "mfg_date": "NA",
            "Receipt_qty": "1000.0000000000",
            "Debit_qty": "919.0000000000",
            "Available_qty": "81.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Hair Care",
            "product_category": "Hair Oil",
            "product_name": "My Sample Semi Finished Material 111",
            "product_sku": "HHEDD0001",
            "batch_no": "MFG-001-0012",
            "inventory_date": "2023-05-04",
            "expiry_date": "2024-05-31",
            "mfg_date": "NA",
            "Receipt_qty": "200.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "200.0000000000",
            "rec_source": "Procured"
        },
        {
            "primary_category": "Hair Care",
            "product_category": "Hair Oil",
            "product_name": "My Sample Semi Finished Material 111",
            "product_sku": "HHEDD0001",
            "batch_no": "",
            "inventory_date": "2022-06-01",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "150.0000000000",
            "Debit_qty": "75.0000000000",
            "Available_qty": "75.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Hardware",
            "product_category": "Personal Computers",
            "product_name": "Home Desktop",
            "product_sku": "HMDSK00012",
            "batch_no": "BACED00102",
            "inventory_date": "2023-05-02",
            "expiry_date": "2024-05-31",
            "mfg_date": "NA",
            "Receipt_qty": "100.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "100.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Sample Cat",
            "product_category": "Test Product Cat",
            "product_name": "LIMKCA 100ML",
            "product_sku": "LIMCA100ML",
            "batch_no": "BATCH000121541",
            "inventory_date": "2022-06-28",
            "expiry_date": "2029-06-08",
            "mfg_date": "NA",
            "Receipt_qty": "100.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "100.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Sample Cat",
            "product_category": "Test Product Cat",
            "product_name": "LIMKCA 100ML",
            "product_sku": "LIMCA100ML",
            "batch_no": "sdjkgjsdkghjksdhjk",
            "inventory_date": "2022-06-28",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "96.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "96.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Educational Kits",
            "product_category": "Stationery Kit ",
            "product_name": "My New FG with SFG",
            "product_sku": "MNFGSFG01",
            "batch_no": "FGWITHSFG01",
            "inventory_date": "2022-06-28",
            "expiry_date": "2025-10-31",
            "mfg_date": "NA",
            "Receipt_qty": "90.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "90.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Sample Cat",
            "product_category": "Test Product Cat",
            "product_name": "Namkeen 100GM",
            "product_sku": "NAMKEEN100GM",
            "batch_no": "",
            "inventory_date": "2022-07-01",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "10.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "10.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Hair Care",
            "product_category": "Hair Oil",
            "product_name": "New Semi Finished Good 121",
            "product_sku": "NEWSFGMAT0001",
            "batch_no": "NEWSFGMAT0001002",
            "inventory_date": "2022-07-07",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "100.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "100.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Hair Care",
            "product_category": "Hair Oil",
            "product_name": "New Semi Finished Good 121",
            "product_sku": "NEWSFGMAT0001",
            "batch_no": "",
            "inventory_date": "2022-07-07",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "1300.0000000000",
            "Debit_qty": "184.2500000000",
            "Available_qty": "1115.7500000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Skin Care",
            "product_category": "Face Gel",
            "product_name": "Phy Hyaluronic Acid - Skin Smoothening Face Gel ",
            "product_sku": "PHHY0060FSE5038",
            "batch_no": "ASASas001010",
            "inventory_date": "2023-03-21",
            "expiry_date": "2025-03-31",
            "mfg_date": "NA",
            "Receipt_qty": "10.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "10.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Skin Care",
            "product_category": "Face Gel",
            "product_name": "Phy Hyaluronic Acid - Skin Smoothening Face Gel ",
            "product_sku": "PHHY0060FSE5038",
            "batch_no": "NEW0092134",
            "inventory_date": "2022-05-10",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "50.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "50.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Semi Finished",
            "product_category": "Wheets",
            "product_name": "MI2 SFG",
            "product_sku": "SFG/001/001",
            "batch_no": "20231103",
            "inventory_date": "2023-11-30",
            "expiry_date": "2024-12-31",
            "mfg_date": "2023-11-01",
            "Receipt_qty": "60.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "60.0000000000",
            "rec_source": "Procured"
        },
        {
            "primary_category": "Semi Finished",
            "product_category": "Wheets",
            "product_name": "MI2 SFG",
            "product_sku": "SFG/001/001",
            "batch_no": "ABC0012-001-01",
            "inventory_date": "2023-11-28",
            "expiry_date": "2024-11-27",
            "mfg_date": "NA",
            "Receipt_qty": "60.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "60.0000000000",
            "rec_source": "Procured"
        },
        {
            "primary_category": "Semi Finished",
            "product_category": "Wheets",
            "product_name": "MI2 SFG",
            "product_sku": "SFG/001/001",
            "batch_no": "57647647646",
            "inventory_date": "2023-09-30",
            "expiry_date": "2023-10-31",
            "mfg_date": "NA",
            "Receipt_qty": "60.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "60.0000000000",
            "rec_source": "Procured"
        },
        {
            "primary_category": "Semi Finished",
            "product_category": "Wheets",
            "product_name": "MI2 SFG",
            "product_sku": "SFG/001/001",
            "batch_no": "FRBAT003",
            "inventory_date": "2023-06-23",
            "expiry_date": "2023-08-31",
            "mfg_date": "NA",
            "Receipt_qty": "103.0000000000",
            "Debit_qty": "86.0000000000",
            "Available_qty": "17.0000000000",
            "rec_source": "Procured"
        },
        {
            "primary_category": "Semi Finished",
            "product_category": "Wheets",
            "product_name": "MI SFG 2",
            "product_sku": "SFG/001/002",
            "batch_no": "MYSFG-0001",
            "inventory_date": "2023-07-18",
            "expiry_date": "2023-10-31",
            "mfg_date": "NA",
            "Receipt_qty": "1234.0000000000",
            "Debit_qty": "1165.0000000000",
            "Available_qty": "69.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Semi Finished",
            "product_category": "Wheets",
            "product_name": "MI SFG 2",
            "product_sku": "SFG/001/002",
            "batch_no": "FRBAT001",
            "inventory_date": "2023-06-23",
            "expiry_date": "2023-09-30",
            "mfg_date": "NA",
            "Receipt_qty": "103.0000000000",
            "Debit_qty": "102.0000000000",
            "Available_qty": "1.0000000000",
            "rec_source": "Procured"
        },
        {
            "primary_category": "Semi Finished",
            "product_category": "Wheets",
            "product_name": "Flavored Wheat",
            "product_sku": "SFGFLWHT01",
            "batch_no": "",
            "inventory_date": "2023-06-07",
            "expiry_date": "2024-06-29",
            "mfg_date": "NA",
            "Receipt_qty": "1220.0000000000",
            "Debit_qty": "361.2500000000",
            "Available_qty": "858.7500000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Educational Kits",
            "product_category": "Stationery Kit ",
            "product_name": "Stationery Kit KG : Basic",
            "product_sku": "SKKB01",
            "batch_no": "15walabach",
            "inventory_date": "2022-07-11",
            "expiry_date": null,
            "mfg_date": "NA",
            "Receipt_qty": "15.0000000000",
            "Debit_qty": "0.0000000000",
            "Available_qty": "15.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Hair Care",
            "product_category": "Hair Oil",
            "product_name": "Hair OIL primary item first",
            "product_sku": "VE/HC/HO/MY0001",
            "batch_no": "ASASAS343500",
            "inventory_date": "2023-03-21",
            "expiry_date": "2026-03-11",
            "mfg_date": "NA",
            "Receipt_qty": "5000.0000000000",
            "Debit_qty": "2210.0000000000",
            "Available_qty": "2790.0000000000",
            "rec_source": "Manually"
        },
        {
            "primary_category": "Educational Kits",
            "product_category": "Stationery Kit ",
            "product_name": "New KIT for Vth Grage",
            "product_sku": "VEEK0001001",
            "batch_no": "ABCDE40-100",
            "inventory_date": "2023-06-23",
            "expiry_date": "2023-10-27",
            "mfg_date": "NA",
            "Receipt_qty": "1000.0000000000",
            "Debit_qty": "999.0000000000",
            "Available_qty": "1.0000000000",
            "rec_source": "Manually"
        }
    ],
    "_links": {
        "self": {
            "href": "http://localhost/bizeebuy/rest/web/v1/truegrad/invetory-snapshot?page=1"
        },
        "first": {
            "href": "http://localhost/bizeebuy/rest/web/v1/truegrad/invetory-snapshot?page=1"
        },
        "last": {
            "href": "http://localhost/bizeebuy/rest/web/v1/truegrad/invetory-snapshot?page=1"
        }
    },
    "_meta": {
        "totalCount": 34,
        "pageCount": 1,
        "currentPage": 1,
        "perPage": 500
    }
}
Previous
Sales Order Status
Next
Open Purchase Orders
Built with