---
title: "POST /ProductDetailQuery/SearchByWarehouse"
method: POST
path: "/ProductDetailQuery/SearchByWarehouse"
tags: ["ProductDetailQuery"]
---

# POST /ProductDetailQuery/SearchByWarehouse

`POST /ProductDetailQuery/SearchByWarehouse`

## Request

- Base URL: `https://api.khaasfood.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.khaasfood.com/ProductDetailQuery/SearchByWarehouse`
- Auth: OAuth 2
  - Authorization code: `https://api.khaasfood.com/connect/authorize`
  - Token URL: `https://api.khaasfood.com/connect/token`

## Request body

- KhaasFoodProductsDTOsProductDetailsProductFilterInputDto
  - `maxResultCount` integer
  - `skipCount` integer
  - `sorting` string, nullable
  - `filter` string, nullable
  - `isProductActive` boolean
  - `warehouseId` string, uuid, nullable
  - `isRawProduct` boolean
  - `orderState` string, nullable
  - `checkedOrderState` boolean, nullable
  - `isIncludeGroup` boolean, nullable
  - `productCategoryId` string, uuid, nullable
  - `unitOfMeasurementId` string, uuid, nullable
  - `brandId` string, uuid, nullable
  - `isInventoryWarehouse` boolean
  - `isStockOut` boolean
  - `isDirectSupply` boolean
  - `isPurchaseOrder` boolean
  - `isOfficeSupply` boolean
  - `type` string, nullable
  - `isFinishedProduct` boolean
  - `productName` string, nullable
  - `requisitionId` string, uuid, nullable
  - `requisitionType` 1 | 2 | 3 | 4
  - `getAll` boolean
  - `checkType` boolean

## Response `200`

Success

- VoloAbpApplicationDtosPagedResultDto1KhaasFoodProductsDTOsProductDetailsProductDetailDtoKhaasFoodApplicationContractsVersion1000CultureNeutralPublicKeyTokenNull
  - `items` KhaasFoodProductsDTOsProductDetailsProductDetailDto[], nullable
    - `id` string, uuid
    - `creationTime` string, date-time
    - `creatorId` string, uuid, nullable
    - `lastModificationTime` string, date-time, nullable
    - `lastModifierId` string, uuid, nullable
    - `isDeleted` boolean
    - `deleterId` string, uuid, nullable
    - `deletionTime` string, date-time, nullable
    - `wcId` integer
    - `wcSku` string, nullable
    - `wcCategoryId` integer
    - `wcType` string, nullable
    - `wcVariationId` integer
    - `wcVariationOption` string, nullable
    - `wcVariationPermalink` string, nullable
    - `shopId` string, nullable
    - `name` string, nullable
    - `parentName` string, nullable
    - `variationName` string, nullable
    - `model` string, nullable
    - `year` string, nullable
    - `barcode` string, nullable
    - `slug` string, nullable
    - `productCode` string, nullable
    - `hasUniqueSerial` boolean
    - `hasWarrenty` boolean
    - `salePrice` number, double
    - `dealerPrice` number, double
    - `nationalDistributionPrice` number, double
    - `costPrice` number, double
    - `dealerCashPrice` number, double
    - `dealerDuePrice` number, double
    - `franchisePrice` number, double
    - `partnershipPrice` number, double
    - `type` string, nullable
    - `color` string, nullable
    - `processingQty` number, double
    - `pendingQty` number, double
    - `minimumStockToNotify` integer
    - `startingInventory` integer
    - `purchased` number, double
    - `sold` number, double
    - `onHand` number, double
    - `homeDeliveryCharge` number, double
    - `courierCharge` number, double
    - `displayOrder` integer
    - `stockIn` number, double
    - `stockOut` number, double
    - `productCategoryId` string, nullable
    - `productName` string, nullable
    - `brandId` string, uuid
    - `brandName` string, nullable
    - `tags` string, nullable
    - `relatedProductNames` string[], nullable
    - `description` string, nullable
    - `shortDescription` string, nullable
    - `additionalDetails` string, nullable
    - `isRawProduct` boolean
    - `damage` number, double
    - `gift` number, double
    - `return` number, double
    - `discountPercent` number, double, nullable
    - `webDiscountPercent` number, double, nullable
    - `bizBookDiscountPercent` number, double, nullable
    - `isStockOut` boolean
    - `isDirectSupply` boolean
    - `isPackagingMaterial` boolean
    - `isShowPackagingProductOnOrder` boolean
    - `isPackagingMaterialExcludedFromBom` boolean
    - `isExcludedFromRequisition` boolean
    - `applyDiscount` boolean
    - `webApplyDiscount` boolean
    - `bizBookApplyDiscount` boolean
    - `isDiscountOnlyForApp` boolean
    - `isShowDiscountAmount` boolean
    - `webIsShowDiscountAmount` boolean
    - `bizBookIsShowDiscountAmount` boolean
    - `discountAmount` number, double
    - `sendToVoucherInventory` boolean
    - `unitOfMeasurementId` string, nullable
    - `unitOfMeasurementName` string, nullable
    - `isActive` boolean
    - `isNationalDistributionSaleProduct` boolean
    - `isRegularSaleProduct` boolean
    - `salePricePerUnitBeforeDiscount` number, double
    - `isBundleProduct` boolean
    - `isPriceEditable` boolean
    - `isPreOrderProduct` boolean
    - `isPreOrderAllowWithRegularProduct` boolean
    - `isShowOnApp` boolean
    - `isShowOnWeb` boolean
    - `isDeliveryChargeMultipliedByQuantity` boolean
    - `isOfficeSupply` boolean
    - `hasSeparateDeliveryCharge` boolean
    - `preOrderDeliveryDate` string, date-time, nullable
    - `estimatedDeliveryFrom` string, date-time, nullable
    - `estimatedDeliveryTo` string, date-time, nullable
    - `productImages` KhaasFoodProductsDTOsProductDetailsProductImageCreateUpdateInputDto[], nullable
      - `id` string, uuid, nullable
      - `image` KhaasFoodProductsDTOsImageDto
        - `url` string, nullable
        - `alt` string, nullable
        - `title` string, nullable
        - `caption` string, nullable
        - `description` string, nullable
      - `name` string, nullable
      - `isPrimary` boolean
      - `displayOrder` integer
    - `packageProductInfos` KhaasFoodProductsDTOsPackageProductInfosPackageProductInfoDto[], nullable
      - `id` string, uuid
      - `packageProductId` string, uuid
      - `productDetailId` string, uuid
      - `quantity` number, double
      - `mrp` number, double
    - `productMappings` KhaasFoodProductsDTOsProductDetailsProductMappingDto[], nullable
      - `id` string, uuid
      - `creationTime` string, date-time
      - `creatorId` string, uuid, nullable
      - `lastModificationTime` string, date-time, nullable
      - `lastModifierId` string, uuid, nullable
      - `isDeleted` boolean
      - `deleterId` string, uuid, nullable
      - `deletionTime` string, date-time, nullable
      - `originalProductId` string, uuid
      - `mappedProductId` string, uuid
      - `mappedProductQuantity` number, double
      - `contributionPercentage` number, double
    - `seoTitle` string, nullable
    - `focusKeyphrase` string, nullable
    - `metaDescription` string, nullable
  - `totalCount` integer

## Other responses

- `400`: Bad Request
- `401`: Unauthorized
- `403`: Forbidden
- `404`: Not Found
- `500`: Server Error
- `501`: Server Error

## Changes

> 11 revisions in range; 1 not diffed.

- **2026-09-06** `388b452fc6d7`: 3 info
  - added the optional property `items/items/isExcludedFromRequisition` to the response with the `200` status (media type: text/plain)
  - added the optional property `items/items/isExcludedFromRequisition` to the response with the `200` status (media type: application/json)
  - added the optional property `items/items/isExcludedFromRequisition` to the response with the `200` status (media type: text/json)

[Operation history](https://skmtc.dev/khaasfood/apis/khaasfood-api/changes/ProductDetailQuery/SearchByWarehouse/post.md)

---

[API](https://skmtc.dev/khaasfood/apis/khaasfood-api.md) - [All operations](https://skmtc.dev/khaasfood/apis/khaasfood-api/llms.txt) - [OpenAPI document](https://skmtc.dev/khaasfood/apis/khaasfood-api/revisions/149b6034bea9?raw)
