Get Products Turn Over
GET
/desktop/product-reports/stats
Request
Query Params
Responses
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request GET '/desktop/product-reports/stats?criteria=april' \
--header 'Authorization: Bearer <token>'Response Response Example
200 - Get Products Turn Over - Get Products Turn Over
{
"success": true,
"message": "Products Inventory Turnover fetched successfully!",
"data": {
"meta": {
"total": 48,
"per_page": 50,
"current_page": 1,
"last_page": 1,
"first_page": 1,
"first_page_url": "/?page=1",
"last_page_url": "/?page=1",
"next_page_url": null,
"previous_page_url": null
},
"data": [
{
"product_id": "19741",
"product_variant_id": "20128",
"product_name": "ABC",
"variant_name": "Yellow",
"total_amount": 480000,
"profitAmount": 80000,
"formattedProfitAmount": "£ 80,000.00",
"formatted_total_amount": "£ 480,000.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19741",
"product_variant_id": "20129",
"product_name": "ABC",
"variant_name": "Green",
"total_amount": 478200,
"profitAmount": 78200,
"formattedProfitAmount": "£ 78,200.00",
"formatted_total_amount": "£ 478,200.00",
"profit": "16%",
"unformattedProfit": 16.291666666666668
},
{
"product_id": "19729",
"product_variant_id": "20117",
"product_name": "Laptop",
"variant_name": "Asus",
"total_amount": 385000,
"profitAmount": 25000,
"formattedProfitAmount": "£ 25,000.00",
"formatted_total_amount": "£ 385,000.00",
"profit": "6%",
"unformattedProfit": 6.4935064935064934
},
{
"product_id": "19741",
"product_variant_id": "20130",
"product_name": "ABC",
"variant_name": "Blue",
"total_amount": 312000,
"profitAmount": 62000,
"formattedProfitAmount": "£ 62,000.00",
"formatted_total_amount": "£ 312,000.00",
"profit": "20%",
"unformattedProfit": 19.871794871794872
},
{
"product_id": "19725",
"product_variant_id": "20108",
"product_name": "Beverages ",
"variant_name": "Milo",
"total_amount": 257890,
"profitAmount": 12890,
"formattedProfitAmount": "£ 12,890.00",
"formatted_total_amount": "£ 257,890.00",
"profit": "5%",
"unformattedProfit": 4.976833976833976
},
{
"product_id": "19726",
"product_variant_id": "20111",
"product_name": "Milk",
"variant_name": "Peak",
"total_amount": 198000,
"profitAmount": 6000,
"formattedProfitAmount": "£ 6,000.00",
"formatted_total_amount": "£ 198,000.00",
"profit": "3%",
"unformattedProfit": 3.0303030303030303
},
{
"product_id": "19726",
"product_variant_id": "20109",
"product_name": "Milk",
"variant_name": "Hollandia",
"total_amount": 190080,
"profitAmount": 4080,
"formattedProfitAmount": "£ 4,080.00",
"formatted_total_amount": "£ 190,080.00",
"profit": "2%",
"unformattedProfit": 2.125
},
{
"product_id": "19725",
"product_variant_id": "20106",
"product_name": "Beverages ",
"variant_name": "Ovaltine",
"total_amount": 165000,
"profitAmount": 10000,
"formattedProfitAmount": "£ 10,000.00",
"formatted_total_amount": "£ 165,000.00",
"profit": "6%",
"unformattedProfit": 6.0606060606060606
},
{
"product_id": "19726",
"product_variant_id": "20110",
"product_name": "Milk",
"variant_name": "Dano",
"total_amount": 123165,
"profitAmount": 3165,
"formattedProfitAmount": "£ 3,165.00",
"formatted_total_amount": "£ 123,165.00",
"profit": "3%",
"unformattedProfit": 2.511904761904762
},
{
"product_id": "19734",
"product_variant_id": "20119",
"product_name": "Semovita",
"variant_name": "null",
"total_amount": 95280,
"profitAmount": 35280,
"formattedProfitAmount": "£ 35,280.00",
"formatted_total_amount": "£ 95,280.00",
"profit": "37%",
"unformattedProfit": 36.75
},
{
"product_id": "19757",
"product_variant_id": "20170",
"product_name": "Sausage roll",
"variant_name": "Bigi",
"total_amount": 80000,
"profitAmount": 40000,
"formattedProfitAmount": "£ 40,000.00",
"formatted_total_amount": "£ 80,000.00",
"profit": "50%",
"unformattedProfit": 50
},
{
"product_id": "19757",
"product_variant_id": "20170",
"product_name": "Sausage roll",
"variant_name": "Bigi",
"total_amount": 80000,
"profitAmount": 40000,
"formattedProfitAmount": "£ 40,000.00",
"formatted_total_amount": "£ 80,000.00",
"profit": "50%",
"unformattedProfit": 50
},
{
"product_id": "19757",
"product_variant_id": "20171",
"product_name": "Sausage roll",
"variant_name": "Gala",
"total_amount": 60000,
"profitAmount": 30000,
"formattedProfitAmount": "£ 30,000.00",
"formatted_total_amount": "£ 60,000.00",
"profit": "50%",
"unformattedProfit": 50
},
{
"product_id": "19757",
"product_variant_id": "20171",
"product_name": "Sausage roll",
"variant_name": "Gala",
"total_amount": 60000,
"profitAmount": 30000,
"formattedProfitAmount": "£ 30,000.00",
"formatted_total_amount": "£ 60,000.00",
"profit": "50%",
"unformattedProfit": 50
},
{
"product_id": "19736",
"product_variant_id": "20122",
"product_name": "AAA",
"variant_name": "Blue",
"total_amount": 51000,
"profitAmount": 6000,
"formattedProfitAmount": "£ 6,000.00",
"formatted_total_amount": "£ 51,000.00",
"profit": "12%",
"unformattedProfit": 11.764705882352942
},
{
"product_id": "19724",
"product_variant_id": "20115",
"product_name": "Samsung phone",
"variant_name": "S10",
"total_amount": 43340,
"profitAmount": 3340,
"formattedProfitAmount": "£ 3,340.00",
"formatted_total_amount": "£ 43,340.00",
"profit": "8%",
"unformattedProfit": 7.590909090909091
},
{
"product_id": "19725",
"product_variant_id": "20107",
"product_name": "Beverages ",
"variant_name": "Bournvita",
"total_amount": 35000,
"profitAmount": 2000,
"formattedProfitAmount": "£ 2,000.00",
"formatted_total_amount": "£ 35,000.00",
"profit": "6%",
"unformattedProfit": 5.714285714285714
},
{
"product_id": "19724",
"product_variant_id": "20114",
"product_name": "Samsung phone",
"variant_name": "",
"total_amount": 33000,
"profitAmount": 3000,
"formattedProfitAmount": "£ 3,000.00",
"formatted_total_amount": "£ 33,000.00",
"profit": "9%",
"unformattedProfit": 9.090909090909092
},
{
"product_id": "19736",
"product_variant_id": "20123",
"product_name": "AAA",
"variant_name": "Yellow edit",
"total_amount": 17000,
"profitAmount": 2000,
"formattedProfitAmount": "£ 2,000.00",
"formatted_total_amount": "£ 17,000.00",
"profit": "12%",
"unformattedProfit": 11.764705882352942
},
{
"product_id": "19742",
"product_variant_id": "20131",
"product_name": "Aqua",
"variant_name": "Aqua type",
"total_amount": 8640,
"profitAmount": 1440,
"formattedProfitAmount": "£ 1,440.00",
"formatted_total_amount": "£ 8,640.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20150",
"product_name": "Pro",
"variant_name": "I",
"total_amount": 4800,
"profitAmount": 800,
"formattedProfitAmount": "£ 800.00",
"formatted_total_amount": "£ 4,800.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20153",
"product_name": "Pro",
"variant_name": "F",
"total_amount": 4800,
"profitAmount": 800,
"formattedProfitAmount": "£ 800.00",
"formatted_total_amount": "£ 4,800.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20154",
"product_name": "Pro",
"variant_name": "E",
"total_amount": 4800,
"profitAmount": 800,
"formattedProfitAmount": "£ 800.00",
"formatted_total_amount": "£ 4,800.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20155",
"product_name": "Pro",
"variant_name": "D",
"total_amount": 4800,
"profitAmount": 800,
"formattedProfitAmount": "£ 800.00",
"formatted_total_amount": "£ 4,800.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19727",
"product_variant_id": "20112",
"product_name": "Mouse",
"variant_name": "Wireless",
"total_amount": 4200,
"profitAmount": 200,
"formattedProfitAmount": "£ 200.00",
"formatted_total_amount": "£ 4,200.00",
"profit": "5%",
"unformattedProfit": 4.761904761904762
},
{
"product_id": "19746",
"product_variant_id": "20156",
"product_name": "Pro",
"variant_name": "C",
"total_amount": 3600,
"profitAmount": 600,
"formattedProfitAmount": "£ 600.00",
"formatted_total_amount": "£ 3,600.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20151",
"product_name": "Pro",
"variant_name": "H",
"total_amount": 3600,
"profitAmount": 600,
"formattedProfitAmount": "£ 600.00",
"formatted_total_amount": "£ 3,600.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20152",
"product_name": "Pro",
"variant_name": "G",
"total_amount": 3600,
"profitAmount": 600,
"formattedProfitAmount": "£ 600.00",
"formatted_total_amount": "£ 3,600.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20158",
"product_name": "Pro",
"variant_name": "A",
"total_amount": 3600,
"profitAmount": 600,
"formattedProfitAmount": "£ 600.00",
"formatted_total_amount": "£ 3,600.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20149",
"product_name": "Pro",
"variant_name": "J",
"total_amount": 3600,
"profitAmount": 600,
"formattedProfitAmount": "£ 600.00",
"formatted_total_amount": "£ 3,600.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20134",
"product_name": "Pro",
"variant_name": "Y",
"total_amount": 3600,
"profitAmount": 600,
"formattedProfitAmount": "£ 600.00",
"formatted_total_amount": "£ 3,600.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20157",
"product_name": "Pro",
"variant_name": "B",
"total_amount": 3600,
"profitAmount": 600,
"formattedProfitAmount": "£ 600.00",
"formatted_total_amount": "£ 3,600.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20147",
"product_name": "Pro",
"variant_name": "L",
"total_amount": 3600,
"profitAmount": 600,
"formattedProfitAmount": "£ 600.00",
"formatted_total_amount": "£ 3,600.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19728",
"product_variant_id": "20113",
"product_name": "Bulb",
"variant_name": "White",
"total_amount": 3564,
"profitAmount": 564,
"formattedProfitAmount": "£ 564.00",
"formatted_total_amount": "£ 3,564.00",
"profit": "16%",
"unformattedProfit": 15.666666666666666
},
{
"product_id": "19746",
"product_variant_id": "20139",
"product_name": "Pro",
"variant_name": "T",
"total_amount": 2400,
"profitAmount": 400,
"formattedProfitAmount": "£ 400.00",
"formatted_total_amount": "£ 2,400.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20143",
"product_name": "Pro",
"variant_name": "P",
"total_amount": 2400,
"profitAmount": 400,
"formattedProfitAmount": "£ 400.00",
"formatted_total_amount": "£ 2,400.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20145",
"product_name": "Pro",
"variant_name": "N",
"total_amount": 2400,
"profitAmount": 400,
"formattedProfitAmount": "£ 400.00",
"formatted_total_amount": "£ 2,400.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20146",
"product_name": "Pro",
"variant_name": "M",
"total_amount": 2400,
"profitAmount": 400,
"formattedProfitAmount": "£ 400.00",
"formatted_total_amount": "£ 2,400.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20148",
"product_name": "Pro",
"variant_name": "K",
"total_amount": 2400,
"profitAmount": 400,
"formattedProfitAmount": "£ 400.00",
"formatted_total_amount": "£ 2,400.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20135",
"product_name": "Pro",
"variant_name": "X",
"total_amount": 2400,
"profitAmount": 400,
"formattedProfitAmount": "£ 400.00",
"formatted_total_amount": "£ 2,400.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20133",
"product_name": "Pro",
"variant_name": "Z",
"total_amount": 2400,
"profitAmount": 400,
"formattedProfitAmount": "£ 400.00",
"formatted_total_amount": "£ 2,400.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20136",
"product_name": "Pro",
"variant_name": "W",
"total_amount": 2400,
"profitAmount": 400,
"formattedProfitAmount": "£ 400.00",
"formatted_total_amount": "£ 2,400.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20142",
"product_name": "Pro",
"variant_name": "Qqq",
"total_amount": 1200,
"profitAmount": 200,
"formattedProfitAmount": "£ 200.00",
"formatted_total_amount": "£ 1,200.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20141",
"product_name": "Pro",
"variant_name": "R",
"total_amount": 1200,
"profitAmount": 200,
"formattedProfitAmount": "£ 200.00",
"formatted_total_amount": "£ 1,200.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20140",
"product_name": "Pro",
"variant_name": "S",
"total_amount": 1200,
"profitAmount": 200,
"formattedProfitAmount": "£ 200.00",
"formatted_total_amount": "£ 1,200.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20138",
"product_name": "Pro",
"variant_name": "U",
"total_amount": 1200,
"profitAmount": 200,
"formattedProfitAmount": "£ 200.00",
"formatted_total_amount": "£ 1,200.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20137",
"product_name": "Pro",
"variant_name": "V",
"total_amount": 1200,
"profitAmount": 200,
"formattedProfitAmount": "£ 200.00",
"formatted_total_amount": "£ 1,200.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
},
{
"product_id": "19746",
"product_variant_id": "20144",
"product_name": "Pro",
"variant_name": "O",
"total_amount": 1200,
"profitAmount": 200,
"formattedProfitAmount": "£ 200.00",
"formatted_total_amount": "£ 1,200.00",
"profit": "17%",
"unformattedProfit": 16.666666666666668
}
]
}
}Modified at 2025-09-01 22:54:16