| page | integer Default: 1 Example: page=1 Page number |
| page_size | integer [ 1 .. 50 ] Default: 10 Example: page_size=10 Number of items per page |
| sort_key | string Default: "create_date" Enum: "item_no" "product_id" "unit_price" "create_date" Example: sort_key=create_date Field to sort by |
| sort_order | string Default: "asc" Enum: "asc" "desc" Example: sort_order=asc Sort order |
| status | string Default: "" Enum: "ACTIVE" "INACTIVE" "CANCELLED" "" FIlter by product status |
| item_no | string Filter by dpx item number |
| product_id | string Filter by customer product ID |
| CLIENT-ID required | string |
{- "success": true,
- "message": "string",
- "total_items": 0,
- "last_page": 0,
- "current_page": 0,
- "page_size": 0,
- "data": [
- {
- "item_no": "string",
- "product_id": "string",
- "description": "string",
- "unit_price": 0,
- "status": "ACTIVE",
- "create_date": "2025-01-01 13:00:00",
- "is_bundle": "Y",
- "barcodes": [
- "string"
], - "bundle_children": [
- {
- "product_id": "string",
- "item_no": "string",
- "description": "string",
- "qty": 0
}
]
}
]
}| CLIENT-ID required | string |
object |
{- "data": {
- "product_id": "string",
- "description": "string",
- "unit_price": 0,
- "brand": "string",
- "barcodes": [
- "string"
]
}
}{- "success": true,
- "message": "string",
- "data": {
- "item_no": "string",
- "product_id": "string",
- "description": "string",
- "unit_price": 0,
- "brand": "string",
- "barcodes": [
- "string"
]
}
}| CLIENT-ID required | string |
object |
{- "data": {
- "product_id": "string",
- "description": "string",
- "unit_price": 0,
- "brand": "string",
- "barcodes": [
- "string"
], - "bundle_children": [
- {
- "product_id": "string",
- "qty": "string"
}
]
}
}{- "success": true,
- "message": "string",
- "data": {
- "item_no": "string",
- "product_id": "string",
- "description": "string",
- "unit_price": 0,
- "brand": "string",
- "barcodes": [
- "string"
], - "bundle_children": [
- {
- "product_id": "string",
- "item_no": "string",
- "description": "string",
- "qty": 0
}
]
}
}Update product details by item number
Only product_id, description, unit_price, brand, barcodes can be updated
| item_no required | string Dpx item no |
| CLIENT-ID required | string |
object |
{- "data": {
- "product_id": "string",
- "description": "string",
- "unit_price": 0,
- "brand": "string",
- "barcodes": [
- "string"
]
}
}{- "success": true,
- "message": "string",
- "data": {
- "item_no": "string",
- "product_id": "string",
- "description": "string",
- "unit_price": 0,
- "brand": "string",
- "is_bundle": "Y",
- "barcodes": [
- "string"
], - "bundle_children": [
- {
- "product_id": "string",
- "item_no": "string",
- "description": "string",
- "qty": 0
}
]
}
}| CLIENT-ID required | string |
object |
{- "data": {
- "reference_number": "string",
- "arrival_datetime": "string",
- "remark": "string",
- "items": [
- {
- "item_no": "string",
- "qty": 0
}
]
}
}{- "success": true,
- "message": "string",
- "data": {
- "gr_number": "string",
- "status": "string",
- "reference_number": "string",
- "arrival_datetime": "string",
- "remark": "string",
- "items": [
- {
- "item_no": "string",
- "qty": 0
}
]
}
}| gr_number required | string |
| CLIENT-ID required | string |
{- "success": true,
- "message": "string",
- "data": {
- "gr_number": "string",
- "status": "string",
- "reference_number": "string",
- "arrival_datetime": "2025-01-01 13:00:00",
- "created_datetime": "2025-01-01 13:00:00",
- "remark": "string",
- "items": [
- {
- "product_id": "string",
- "description": "string",
- "item_no": "string",
- "qty": 0,
- "barcode_nos": "string"
}
]
}
}Only update arrival_datetime, reference_number, remark on status "DATA ENTRY"
| gr_number required | string |
| CLIENT-ID required | string |
object |
{- "data": {
- "reference_number": "string",
- "arrival_datetime": "string",
- "remark": "string"
}
}{- "success": true,
- "message": "string",
- "data": {
- "gr_number": "string",
- "status": "string",
- "reference_number": "string",
- "arrival_datetime": "2025-01-01 13:00:00",
- "created_datetime": "2025-01-01 13:00:00",
- "remark": "string",
- "items": [
- {
- "product_id": "string",
- "description": "string",
- "item_no": "string",
- "qty": 0,
- "barcode_nos": "string"
}
]
}
}List product stocks with pagination, sorting, and filtering options
Returns a paginated list of products with their stock information including available quantity, booked quantity, and on-hand quantity.
Only non-bundle products
| page | integer Default: 1 Example: page=1 Page number |
| page_size | integer [ 1 .. 50 ] Default: 10 Example: page_size=10 Number of items per page |
| sort_key | string Default: "create_date" Enum: "item_no" "product_id" "unit_price" "create_date" Example: sort_key=create_date Field to sort by |
| sort_order | string Default: "asc" Enum: "asc" "desc" Example: sort_order=asc Sort order |
| status | string Default: "ACTIVE" Enum: "ACTIVE" "INACTIVE" "CANCELLED" "" Example: status=ACTIVE FIlter by product status |
| item_no | string Filter by dpx item number |
| product_id | string Filter by customer product ID |
| CLIENT-ID required | string |
{- "success": true,
- "message": "string",
- "total_items:": 0,
- "last_page": 0,
- "current_page": 0,
- "page_size": 0,
- "data": [
- {
- "item_no": "string",
- "product_id": "string",
- "description": "string",
- "status": "ACTIVE",
- "available_qty": 0,
- "booked_qty": 0,
- "onhand_qty": 0
}
]
}