> For the complete documentation index, see [llms.txt](https://tech.x2bee.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://tech.x2bee.com/api/api-en/back-office-api-reference/statistics-bo-api/product-analysis.md).

# Product Analysis

## Retrieve Cart Status List

> \## Function Description\
> \* Retrieves the cart status list.\
> \---\
> \## Detailed Description\
> \* Aggregates 30 days of cart data based on 09:00 daily.\
> \* The cart status can be retrieved up to a maximum of 30 days prior.\
> \---\
> \## Revision History\
> \* Release v2.00\_240827 : Initial creation<br>

```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"BasketStatusRequest":{"type":"object","properties":{"siteNo":{"type":"string","description":"Site No."},"startDate":{"type":"string","format":"date","description":"Search Start Date"},"endDate":{"type":"string","format":"date","description":"Search End Date"},"stdCtgNo":{"type":"string","description":"Standard Category No."},"mdId":{"type":"string","description":"Assigned MD ID"},"infDispCtgNoGbCd":{"type":"string","description":"Inflow Display Category No. Classification Code"},"infDispCtgNo":{"type":"string","description":"Referral Display Category No."},"entrNo":{"type":"string","description":"Vendor No."},"brandNo":{"type":"string","description":"Brand No."}}},"RealGridListResponseBasketStatusResponse":{"type":"object","properties":{"totalCount":{"type":"integer","format":"int32"},"payloads":{"type":"array","items":{"$ref":"#/components/schemas/BasketStatusResponse"}}}},"BasketStatusResponse":{"type":"object","properties":{"siteNo":{"type":"string","description":"Site No."},"basketRegDt":{"type":"string","description":"Cart Registration Date"},"siteNm":{"type":"string","description":"Site Name"},"goodsNo":{"type":"string","description":"Product No."},"infDispCtgNoGbCd":{"type":"string","description":"Referral Display Category No. Classification Code (OM041)"},"infDispCtgNoGbNm":{"type":"string","description":"Inflow Display Category No. Type Name"},"infDispCtgNo":{"type":"string","description":"Referral Display Category No."},"infDispCtgNm":{"type":"string","description":"Inflow Display Category Name"},"entrNo":{"type":"string","description":"Vendor No."},"entrNm":{"type":"string","description":"Vendor Name"},"brandNo":{"type":"string","description":"Brand No."},"brandNm":{"type":"string","description":"Brand Name"},"mdId":{"type":"string","description":"Assigned MD ID"},"mdNm":{"type":"string","description":"MD in Charge Name"},"stdCtgNo":{"type":"string","description":"Standard Category No."},"stdCtgNm":{"type":"string","description":"Standard Category Name"},"imgPath":{"type":"string","description":"Image Path"},"qty":{"type":"integer","format":"int32","description":"Quantity"},"goodsNm":{"type":"string","description":"Product Name"},"totalByGoods":{"type":"integer","format":"int32","description":"Total Quantity Added by Product"},"totalByInfDisp":{"type":"integer","format":"int32","description":"Quantity Added by Inflow Display"}}},"Response":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v1/statistics/basketStatus/getBasketStatusList":{"get":{"tags":["Product Analysis"],"summary":"Retrieve Cart Status List","description":"## Function Description\n* Retrieves the cart status list.\n---\n## Detailed Description\n* Aggregates 30 days of cart data based on 09:00 daily.\n* The cart status can be retrieved up to a maximum of 30 days prior.\n---\n## Revision History\n* Release v2.00_240827 : Initial creation\n","operationId":"getBasketStatusList","parameters":[{"name":"basketStatusRequest","in":"query","required":true,"schema":{"$ref":"#/components/schemas/BasketStatusRequest"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"stdCtgNo","in":"query","description":"Standard Category No.","schema":{"type":"String"}},{"name":"mdId","in":"query","description":"MD in Charge","schema":{"type":"String"}},{"name":"infDispCtgNoGbCd","in":"query","description":"Referral Display Category No. Classification Code (OM041)","schema":{"type":"String"}},{"name":"infDispCtgNo","in":"query","description":"Referral Display Category No.","schema":{"type":"String"}},{"name":"entrNo","in":"query","description":"Vendor No.","schema":{"type":"String"}},{"name":"siteNo","in":"query","description":"Site No.","schema":{"type":"String"}}],"responses":{"200":{"description":"Success","content":{"*/*":{"schema":{"$ref":"#/components/schemas/RealGridListResponseBasketStatusResponse"}}}},"900":{"description":"Business processing error details","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```

## Download Cart Status List as Excel

> \## Function Description\
> \* Downloads the cart status list as an Excel file.\
> \---\
> \## Detailed Description\
> \* Downloads the cart status list matching the search conditions as an Excel file with unpaged data.\
> \---\
> \## Revision History\
> \* Release v2.00\_240827 : Initial creation<br>

```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"BasketStatusRequest":{"type":"object","properties":{"siteNo":{"type":"string","description":"Site No."},"startDate":{"type":"string","format":"date","description":"Search Start Date"},"endDate":{"type":"string","format":"date","description":"Search End Date"},"stdCtgNo":{"type":"string","description":"Standard Category No."},"mdId":{"type":"string","description":"Assigned MD ID"},"infDispCtgNoGbCd":{"type":"string","description":"Inflow Display Category No. Classification Code"},"infDispCtgNo":{"type":"string","description":"Referral Display Category No."},"entrNo":{"type":"string","description":"Vendor No."},"brandNo":{"type":"string","description":"Brand No."}}},"Response":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v1/statistics/basketStatus/basketStatusExcelDownload":{"get":{"tags":["Product Analysis"],"summary":"Download Cart Status List as Excel","description":"## Function Description\n* Downloads the cart status list as an Excel file.\n---\n## Detailed Description\n* Downloads the cart status list matching the search conditions as an Excel file with unpaged data.\n---\n## Revision History\n* Release v2.00_240827 : Initial creation\n","operationId":"basketStatusExcelDownload","parameters":[{"name":"request","in":"query","required":true,"schema":{"$ref":"#/components/schemas/BasketStatusRequest"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"stdCtgNo","in":"query","description":"Standard Category No.","schema":{"type":"String"}},{"name":"mdId","in":"query","description":"Assigned MD ID","required":true,"schema":{"type":"String"}},{"name":"infDispCtgNoGbCd","in":"query","description":"Referral Display Category No. Classification Code (OM041)","required":true,"schema":{"type":"String"}},{"name":"infDispCtgNo","in":"query","description":"Referral Display Category No.","required":true,"schema":{"type":"String"}},{"name":"entrNo","in":"query","description":"Vendor No.","required":true,"schema":{"type":"String"}},{"name":"brandNo","in":"query","description":"Brand No.","required":true,"schema":{"type":"String"}},{"name":"siteNo","in":"query","description":"Site No.","required":true,"schema":{"type":"String"}}],"responses":{"200":{"description":"Success"},"900":{"description":"Business processing error details","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```