Picklist batches
Multiple picklists can be collected in a single run through the warehouse with picklist batches.
Attributes
| Name | Type | Description |
|---|---|---|
| idpicklist_batch | integer | Unique Picqer reference |
| picklist_batchid | string | Per-account batch ID |
| idwarehouse | integer | Linked to resource Warehouse |
| type | string | Type of batch: "singles" or "normal" |
| status | string | "open" or "completed" |
| assigned_to | array | Data of the assigned user (iduser, full_name, username) |
| completed_by | array | Data of the user that completed the batch (iduser, full_name, username) |
| total_products | integer | Total amount of products in the batch |
| total_picklists | integer | Amount of picklists in the batch |
| completed_at | datetime | Date and time from when the batch became completed |
| created_at | datetime | Date and time from when the batch was created |
| updated_at | datetime | Date and time from when the batch was last updated |
Get all picklist batches
GET
https://example.picqer.com/api/v1/picklists/batches
HTTP/1.1 200 OK
[
{
"idpicklist_batch": 3,
"idwarehouse": 1,
"picklist_batchid": 3,
"type": "singles",
"status": "open",
"assigned_to": {
"iduser": 2,
"full_name": "Casper Bakker",
"username": "casper"
},
"completed_by": null,
"total_products": 31,
"total_picklists": 25,
"completed_at": null,
"created_at": "2020-03-18 12:21:25",
"updated_at": "2020-03-18 12:21:25"
}
]
This endpoint uses pagination.
Filters
You can filter the picklists with the following parameters. Add these filters as querystring parameters to the URL.
| Attribute | Description | Example |
|---|---|---|
| idwarehouse | Get batches after this idwarehouse | |
| assigned_to_iduser | Get batches assigned to this iduser | |
| type | Get batches from only a single type, only "singles" or "normal" allowed | normal |
| status | Get batches with this status, only "open" and "completed" allowed | open |
| products | Array of products for this picklist batch, from all the picklists combined | open |
Get single picklist batch
GET
https://example.picqer.com/api/v1/picklists/batches/{idpicklist_batch}
HTTP/1.1 200 OK
{
"idpicklist_batch": 3,
"idwarehouse": 1,
"picklist_batchid": 3,
"type": "singles",
"status": "open",
"assigned_to": {
"iduser": 2,
"full_name": "Casper Bakker",
"username": "casper"
},
"completed_by": null,
"total_products": 31,
"total_picklists": 25,
"completed_at": null,
"created_at": "2020-03-18 12:21:25",
"updated_at": "2020-03-18 12:21:25",
"products": [
{
"idproduct": 262,
"name": "Opel HC-V100 Lounge Black",
"productcode": "TF748199",
"productcode_supplier": "OPE-TF748199",
"stock_location": "A.4.8.3",
"image": "https:\/\/example.org\/original.jpg",
"barcodes": [
"9228161561252"
],
"productfields": [],
"amount": 2,
"amount_picked": 0,
"amount_collected": 0
},
{
"idproduct": 236,
"name": "Opel Record Needle Blue Wide-Format Black\/White",
"productcode": "HQ725608",
"productcode_supplier": "OPE-HQ725608",
"stock_location": "A.5.1.2",
"image": "https:\/\/example.org\/original.jpg",
"barcodes": [
"2699996573289"
],
"productfields": [],
"amount": 1,
"amount_picked": 0,
"amount_collected": 0
}
],
"picklists": [
{
"idpicklist": 422,
"picklistid": "P2021-1002",
"reference": null,
"status": "new",
"alias": "A",
"picking_container": null,
"total_products": 1,
"delivery_name": "Stephan Groen",
"has_notes": false,
"has_customer_remarks": false,
"customer_remarks": null,
"created_at": "2021-07-29 10:53:18"
},
{
"idpicklist": 763,
"picklistid": "P2021-1003",
"reference": null,
"status": "new",
"alias": "B",
"picking_container": null,
"total_products": 1,
"delivery_name": "Stephan Groen",
"has_notes": false,
"has_customer_remarks": false,
"customer_remarks": null,
"created_at": "2021-07-29 11:34:28"
}
]
}
Get PDF of picklist batch
PDF of a picklist batch can be retrieved as a direct PDF document from the API.
You will get different documents based on the type, a normal batch has a different format then a singles batch.
GET
https://example.picqer.com/api/v1/picklists/batches/{idpicklist_batch}/pdf
HTTP/1.1 200 OK
--PDF Blob--
You can also get the batch PDF with the picklists or packinglists of the linked picklists included. There you can add the querystring parameter "includePicklists" or "includePackinglists", like "https://example.picqer.com/api/v1/picklists/batches/{idpicklist_batch}/pdf?includePicklists".
Create new batch
You can create a new batch via the API. You can create one based on a batch preset, or by providing specific picklists.
Use idpicklist_batch_preset to create a new batch based on a preset.
Use idpicklists to create a new batch with specific picklists in it.
POST
https://example.picqer.com/api/v1/picklists/batches
{
"idpicklists": [
422,
763
]
}
HTTP/1.1 201 Created
{
"idpicklist_batch": 9,
"idwarehouse": 1,
"picklist_batchid": 9,
"type": "singles",
"status": "open",
"assigned_to": null,
"completed_by": null,
"total_products": 2,
"total_picklists": 2,
"completed_at": null,
"created_at": "2021-07-30 16:13:53",
"updated_at": "2021-07-30 16:13:53",
"idfulfilment_customer": null,
"products": [
{
"idproduct": 512,
"name": "Juliana Short-Sleeve Tee-XL-Black",
"productcode": "WS07-XL-Black",
"productcode_supplier": null,
"image": null,
"barcodes": [
"WS07-XL-Black"
],
"productfields": [],
"stock_location": "",
"amount": 2,
"amount_picked": 0,
"amount_collected": 0
}
],
"picklists": [
{
"idpicklist": 422,
"picklistid": "P2021-1002",
"reference": null,
"status": "new",
"alias": "A",
"picking_container": null,
"total_products": 1,
"delivery_name": "Stephan Groen",
"has_notes": false,
"has_customer_remarks": false,
"customer_remarks": null,
"created_at": "2021-07-29 10:53:18"
},
{
"idpicklist": 763,
"picklistid": "P2021-1003",
"reference": null,
"status": "new",
"alias": "B",
"picking_container": null,
"total_products": 1,
"delivery_name": "Stephan Groen",
"has_notes": false,
"has_customer_remarks": false,
"customer_remarks": null,
"created_at": "2021-07-29 11:34:28"
}
]
}
You can only add open picklists to a batch. All picklists should be for the same warehouse.
Add picklist to existing batch
If you want to add a picklist to an existing batch, use this endpoint.
The picklist should be for the same warehouse as the batch is linked to.
Picklists with more then 1 product can only be added to normal batches, not to singles batches.
POST
https://example.picqer.com/api/v1/picklists/batches/{idpicklist_batch}/picklists
{
"idpicklist": 382
}
HTTP/1.1 201 Created
{
"idpicklist_batch": 9,
"idwarehouse": 1,
...
"picklists": [
{
"idpicklist": 422,
"picklistid": "P2021-1002",
"reference": null,
"status": "new",
"alias": "A",
"picking_container": null,
"total_products": 1,
"delivery_name": "Stephan Groen",
"has_notes": false,
"has_customer_remarks": false,
"customer_remarks": null,
"created_at": "2021-07-29 10:53:18"
},
{
"idpicklist": 763,
"picklistid": "P2021-1003",
"reference": null,
"status": "new",
"alias": "B",
"picking_container": null,
"total_products": 1,
"delivery_name": "Stephan Groen",
"has_notes": false,
"has_customer_remarks": false,
"customer_remarks": null,
"created_at": "2021-07-29 11:34:28"
},
{
"idpicklist": 382,
"picklistid": "P2021-1004",
"reference": null,
"status": "new",
"alias": "C",
"picking_container": null,
"total_products": 1,
"delivery_name": "Stephan Groen",
"has_notes": false,
"has_customer_remarks": false,
"customer_remarks": null,
"created_at": "2021-07-29 11:34:28"
}
]
}
Remove picklist from batch
You can remove (or unlink) a picklist from a batch. The picklist will still exist, but it is unlinked from the batch.
DELETE
https://example.picqer.com/api/v1/picklists/batches/{idpicklist_batch}/picklists/{idpicklist}
HTTP/1.1 200 OK
{
"idpicklist_batch": 9,
"idwarehouse": 1,
...
"picklists": [
{
"idpicklist": 422,
"picklistid": "P2021-1002",
"reference": null,
"status": "new",
"alias": "A",
"picking_container": null,
"total_products": 1,
"delivery_name": "Stephan Groen",
"has_notes": false,
"has_customer_remarks": false,
"customer_remarks": null,
"created_at": "2021-07-29 10:53:18"
}
]
}
Assign batch to user
You can assign (or unassign) a batch to a user. This will also assign all included picklists to the same user.
Use the iduser of the user to assign, or use `null` to unassign the batch.
POST
https://example.picqer.com/api/v1/picklists/batches/{idpicklist_batch}/assign
{
"iduser": 233
}
HTTP/1.1 200 OK
{
"idpicklist_batch": 9,
"idwarehouse": 1,
"assigned_to": {
"iduser": 2,
"full_name": "John Vorhees",
"username": "john"
},
...
}
View picklists of product in batch
If you want to view all picklists of a specific product in a picklist batch, you can retrieve this through the API.
GET
https://example.picqer.com/api/v1/picklists/batches/{idpicklist_batch}/product/{idproduct}/picklists
[
{
"idpicklist": 1,
"picklistid": "P2024-1001",
"idcustomer": 44,
"idorder": 776,
"idreturn": null,
"idwarehouse": 1,
"idtemplate": 1,
"idpicklist_batch": 83,
"idshippingprovider_profile": null,
"deliveryname": "Amelia Zevenboom",
"deliverycontact": null,
"deliveryaddress": "Kuipershof 85",
"deliveryaddress2": null,
"deliveryzipcode": "6461JD",
"deliverycity": "Koningsbosch",
"deliveryregion": "Noord-Brabant",
"deliverycountry": "NL",
...
"products": [
{
"idpicklist_product": 409,
"idproduct": 69,
"idorder_product": 1039,
"idreturn_product_replacement": null,
"idvatgroup": 1,
"productcode": "ZV329330",
"name": "Panasonic Eco Drive Black/White",
"remarks": null,
"amount": 1,
"amountpicked": 0,
"amount_picked": 0,
"price": 300.73,
"weight": 2930,
"stocklocation": "B.2.3.3",
"stock_location": "B.2.3.3",
"partof_idpicklist_product": null,
"has_parts": false,
"pick_locations": [
{
"idlocation": 404,
"name": "B.2.3.3",
"amount": 1
}
]
}
],
"comment_count": 0
},
{
"idpicklist": 2,
"picklistid": "P2024-1001",
"idcustomer": 5,
"idorder": 684,
"idreturn": null,
"idwarehouse": 1,
"idtemplate": 1,
"idpicklist_batch": 83,
"idshippingprovider_profile": null,
"deliveryname": "Seth Olykan",
"deliverycontact": null,
"deliveryaddress": "Erhoutlaan 24-d",
"deliveryaddress2": null,
"deliveryzipcode": "3132CS",
"deliverycity": "Barsingerhorn",
"deliveryregion": "Drenthe",
"deliverycountry": "NL",
...
"products": [
{
"idpicklist_product": 516,
"idproduct": 69,
"idorder_product": 902,
"idreturn_product_replacement": null,
"idvatgroup": 1,
"productcode": "ZV329330",
"name": "Panasonic Eco Drive Black/White",
"remarks": null,
"amount": 1,
"amountpicked": 1,
"amount_picked": 1,
"price": 300.73,
"weight": 2930,
"stocklocation": "B.2.3.3",
"stock_location": "B.2.3.3",
"partof_idpicklist_product": null,
"has_parts": false,
"pick_locations": [
{
"idlocation": 404,
"name": "B.2.3.3",
"amount": 1
}
]
}
],
"comment_count": 0
}
]
Read more Shipments
