Picklists
Picklists are generated by Picqer when an order is closed or when backorders are processed. Picklists are orders that need to be collected in the warehouse and be send to the customer.
We have a seperate page about picklist batches in the API.
Attributes
| Name | Type | Description |
|---|---|---|
| idpicklist | integer | Unique Picqer reference |
| picklistid | string | Per-account picklist ID |
| idcustomer | integer | Linked to resource Customers |
| idorder | integer | Linked to resource Orders |
| idreturn | integer | Linked to resource Returns |
| idwarehouse | integer | Linked to resource Warehouse |
| idtemplate | integer | Linked to resource Templates |
| deliveryname | string | Defined in Order resource |
| deliverycontact | string | Defined in Order resource |
| deliveryaddress | string | Defined in Order resource |
| deliveryaddress2 | string | Defined in Order resource |
| deliveryzipcode | string | Defined in Order resource |
| deliverycity | string | Defined in Order resource |
| deliveryregion | string | Defined in Order resource |
| deliverycountry | string | Defined in Order resource, 2-letter ISO country code |
| telephone | string | |
| emailaddress | string | |
| reference | string | Defined in Order resource |
| assigned_to_iduser | integer | Linked to User resource that is responsible for this picklist |
| invoiced | boolean | Is this picklist invoiced yet |
| urgent | boolean | Is this picklist marked as urgent |
| preferred_delivery_date | date | If the customer requested a preferred delivery date |
| status | string | What is the status of this picklist: new, closed, snoozed, cancelled |
| totalproducts | integer | Amount of products on this picklist |
| totalpicked | integer | Amount of products that are already picked |
| snoozed_until | datetime | If a picklist is snoozed, it will be unsnoozed at this moment |
| closed_by_iduser | integer | If picklist is closed, which User closed it |
| closed_at | datetime | Moment this picklist was closed |
| created | datetime | Moment this picklist was created |
| updated | datetime | Last moment this picklist was changed |
| products | array | Collection of all products in this picklist |
| products.idproduct | integer | Linked to Product resource |
| products.idorder_product | integer | Linked to the order line that resulted in this picklist line. Can be null if this picklist is from a return |
| products.idreturn_product_replacement | integer | Linked to the product replacement of a return that resulted in this picklist line. Can be null if this picklist is from a order |
| products.idvatgroup | integer | Linked to VAT group resource |
| products.productcode | string | |
| products.name | string | |
| products.remarks | string | |
| products.amount | integer | Total amount needed |
| products.amount_picked | integer | Amount already picked |
| products.price | float | Price per product |
| products.weight | integer | Weight in grams per product |
| products.stock_location | string | Location name for this product in this warehouse |
Get all picklists
GET
https://example.picqer.com/api/v1/picklists
HTTP/1.1 200 OK
[
{
"idpicklist":76859,
"picklistid":"20140095",
"idcustomer":5621,
"idorder":119087,
"idreturn":null,
"idwarehouse":18,
"idtemplate":2,
"deliveryname":"Desmonds Formal Wear",
"deliverycontact":null,
"deliveryaddress":"Emmerikseweg 57",
"deliveryaddress2":null,
"deliveryzipcode":"7077 AP",
"deliverycity":"Netterden",
"deliveryregion":null,
"deliverycountry":"NL",
"emailaddress":"YassinevanLingen@mailinator.com",
"telephone": null,
"reference": "",
"assigned_to_iduser": null,
"invoiced":false,
"urgent":false,
"status":"new",
"totalproducts":2,
"totalpicked":0,
"snoozed_until": null,
"closed_by_iduser":null,
"closed_at":null,
"created":"2014-08-19 12:13:38",
"updated":"2014-08-19 12:13:38",
"products":[
{
"idpicklist_product":27836,
"idproduct":147,
"idorder_product":188,
"idreturn_product_replacement":null,
"idvatgroup":18,
"productcode":"502.052.16",
"name":"SUNDEROe",
"remarks":null,
"amount":1,
"amount_picked":0,
"price":69.95,
"weight":10200,
"stock_location":"Plein C",
"partof_idpicklist_product":null,
"has_parts":false
},
{
"idpicklist_product":27837,
"idproduct":126654,
"idorder_product":189,
"idreturn_product_replacement":null,
"idvatgroup":18,
"productcode":"1318512",
"name":"4GB DDR3 PC10600\/1333Mhz REG ECC MEMORY (x4)",
"remarks":null,
"amount":1,
"amount_picked":0,
"price":0,
"weight":0,
"stock_location":null,
"partof_idpicklist_product":null,
"has_parts":false
}
]
}
]
Filters
You can filter the picklists with the following parameters. Add these filters as querystring parameters to the URL.
| Attribute | Description | Example |
|---|---|---|
| sinceid | Get picklists after this idpicklist | |
| sincedate | Get picklists created after this datetime | 2018-01-01 12:00:00 |
| untildate | Get picklists created before this datetime | 2018-01-01 12:00:00 |
| closed_after | Get picklists closed after this datetime | 2018-01-01 12:00:00 |
| closed_before | Get picklists closed before this datetime | 2018-01-01 12:00:00 |
| picklistid | Get picklist with the provided picklistid. | P2015-90282 |
| assigned_to_iduser | Get picklists that are assigned to this iduser. | 28190 |
| idwarehouse | Get picklists for this idwarehouse. | 28190 |
| status | Get picklists with this status. | new, closed, snoozed or cancelled |
Get single picklist
GET
https://example.picqer.com/api/v1/picklists/{idpicklist}
HTTP/1.1 200 OK
{
"idpicklist":76859,
"picklistid":"20140095",
"idcustomer":5621,
"idorder":119087,
"idwarehouse":18,
"deliveryname":"Desmonds Formal Wear",
"deliverycontact":"",
"deliveryaddress":"Emmerikseweg 57",
"deliveryaddress2":"",
"deliveryzipcode":"7077 AP",
"deliverycity":"Netterden",
"deliveryregion":null,
"deliverycountry":"NL",
"emailaddress":"YassinevanLingen@mailinator.com",
"telephone": null,
"reference": "",
"assigned_to_iduser": null,
"invoiced":false,
"urgent":false,
"status":"new",
"totalproducts":2,
"totalpicked":0,
"snoozed_until": null,
"created":"2014-08-19 12:13:38",
"updated":"2014-08-19 12:13:38",
"products":[
{
"idpicklist_product": 611,
"idproduct":147,
"idorder_product": 1008,
"idreturn_product_replacement": null,
"idvatgroup":18,
"productcode":"502.052.16",
"name":"SUNDEROe",
"remarks":"",
"amount":1,
"amount_picked":0,
"price":69.95,
"weight":10200,
"stocklocation":"Plein C",
"partof_idpicklist_product": null,
"has_parts": false
},
{
"idpicklist_product": 612,
"idproduct":126654,
"idorder_product": 1009,
"idreturn_product_replacement": null,
"idvatgroup":18,
"productcode":"1318512",
"name":"4GB DDR3 PC10600\/1333Mhz REG ECC MEMORY (x4)",
"remarks":null,
"amount":1,
"amount_picked":0,
"price":0,
"weight":0,
"stocklocation":null,
"partof_idpicklist_product": null,
"has_parts": false
}
]
}
Update picklist
At this moment you can only update these fields of picklists.
- urgent
- invoiced
- idcompanyshippingproviderprofile
PUT
https://example.picqer.com/api/v1/picklists/{idpicklist}
{
"urgent": true
}
HTTP/1.1 200 OK
{
"idpicklist":76859,
"picklistid":"20140095",
...
"urgent":true,
"status":"new",
...
}
Close a picklist
A picklist will be closed automatically when all products are picked. If not all products will be picked, you can close the picklist specifically. Products that are not yet picked, will be converted to backorders.
POST
https://example.picqer.com/api/v1/picklists/{idpicklist}/close
HTTP/1.1 200 OK
{
"idpicklist":76859,
"picklistid":"20140095",
"idcustomer":5621,
"idorder":119087,
"idwarehouse":18,
"deliveryname":"Desmonds Formal Wear",
"deliverycontact":"",
"deliveryaddress":"Emmerikseweg 57",
"deliveryaddress2":"",
"deliveryzipcode":"7077 AP",
"deliverycity":"Netterden",
"deliveryregion":null,
"deliverycountry":"NL",
"emailaddress":"YassinevanLingen@mailinator.com",
"telephone": null,
"reference": "",
"assigned_to_iduser": null,
"invoiced":false,
"status":"closed",
"totalproducts":2,
"totalpicked":0,
"snoozed_until": null,
"created":"2014-08-19 12:13:38",
"updated":"2014-08-19 12:13:38",
"products":[
{
"idproduct":147,
"idvatgroup":18,
"productcode":"502.052.16",
"name":"SUNDEROe",
"remarks":"",
"amount":1,
"amount_picked":0,
"price":69.95,
"weight":10200,
"stocklocation":"Plein C"
},
{
"idproduct":126654,
"idvatgroup":18,
"productcode":"1318512",
"name":"4GB DDR3 PC10600\/1333Mhz REG ECC MEMORY (x4)",
"remarks":null,
"amount":1,
"amount_picked":0,
"price":0,
"weight":0,
"stocklocation":null
}
]
}
Pick a product from the picklist
To notify to Picqer which products are picked, you can send it 'pick' notifies. As parameters the product and amount fields are required.
- The product parameter expects the productcode, barcode or supplier's productcode of the product you want to pick.
- The amount parameter can be a number or the text 'all' to indicate you want to pick the total amount of products with this productcode.
POST
https://example.picqer.com/api/v1/picklists/{idpicklist}/pick
{
"product": "502.052.16",
"amount": 1
}
HTTP/1.1 200 OK
{
"idpicklist":76859,
"picklistid":"20140095",
"idcustomer":5621,
"idorder":119087,
"idwarehouse":18,
"deliveryname":"Desmonds Formal Wear",
"deliverycontact":"",
"deliveryaddress":"Emmerikseweg 57",
"deliveryaddress2":"",
"deliveryzipcode":"7077 AP",
"deliverycity":"Netterden",
"deliveryregion":null,
"deliverycountry":"NL",
"emailaddress":"YassinevanLingen@mailinator.com",
"telephone": null,
"reference": "",
"assigned_to_iduser": null,
"invoiced":false,
"status":"new",
"totalproducts":2,
"totalpicked":1,
"created":"2014-08-19 12:13:38",
"updated":"2014-08-19 12:13:38",
"products":[
{
"idproduct":147,
"idvatgroup":18,
"productcode":"502.052.16",
"name":"SUNDEROe",
"remarks":"",
"amount":1,
"amount_picked":1,
"price":69.95,
"weight":10200,
"stocklocation":"Plein C"
},
{
"idproduct":126654,
"idvatgroup":18,
"productcode":"1318512",
"name":"4GB DDR3 PC10600\/1333Mhz REG ECC MEMORY (x4)",
"remarks":null,
"amount":1,
"amount_picked":0,
"price":0,
"weight":0,
"stocklocation":null
}
]
}
Pick all products from the picklist
With this one call, you can mark all products from a picklist as picked.
POST
https://example.picqer.com/api/v1/picklists/{idpicklist}/pickall
HTTP/1.1 200 OK
{
"idpicklist":76859,
"picklistid":"20140095",
"idcustomer":5621,
"idorder":119087,
"idwarehouse":18,
"deliveryname":"Desmonds Formal Wear",
"deliverycontact":"",
"deliveryaddress":"Emmerikseweg 57",
"deliveryaddress2":"",
"deliveryzipcode":"7077 AP",
"deliverycity":"Netterden",
"deliveryregion":null,
"deliverycountry":"NL",
"emailaddress":"YassinevanLingen@mailinator.com",
"telephone": null,
"reference": "",
"assigned_to_iduser": null,
"invoiced":false,
"status":"new",
"totalproducts":2,
"totalpicked":2,
"created":"2014-08-19 12:13:38",
"updated":"2014-08-19 12:13:38",
"products":[
{
"idproduct":147,
"idvatgroup":18,
"productcode":"502.052.16",
"name":"SUNDEROe",
"remarks":"",
"amount":1,
"amount_picked":1,
"price":69.95,
"weight":10200,
"stocklocation":"Plein C"
},
{
"idproduct":126654,
"idvatgroup":18,
"productcode":"1318512",
"name":"4GB DDR3 PC10600\/1333Mhz REG ECC MEMORY (x4)",
"remarks":null,
"amount":1,
"amount_picked":2,
"price":0,
"weight":0,
"stocklocation":null
}
]
}
Shipments
More information about shipments and creating a shipment, can be found on the Picklist Shipments page.
Assign a user to picklist
POST
https://example.picqer.com/api/v1/picklists/{idpicklist}/assign
{
"iduser": 2991
}
HTTP/1.1 200 OK
{
"idpicklist":76859,
"picklistid":"20140095",
"idcustomer":5621,
"idorder":119087,
"idwarehouse":18,
"deliveryname":"Desmonds Formal Wear",
"deliverycontact":"",
"deliveryaddress":"Emmerikseweg 57",
"deliveryaddress2":"",
"deliveryzipcode":"7077 AP",
"deliverycity":"Netterden",
"deliveryregion":null,
"deliverycountry":"NL",
"emailaddress":"YassinevanLingen@mailinator.com",
"telephone": null,
"reference": "",
"assigned_to_iduser": 2991,
"invoiced":false,
...
}
Unassign a user to picklist
POST
https://example.picqer.com/api/v1/picklists/{idpicklist}/unassign
HTTP/1.1 200 OK
{
"idpicklist":76859,
"picklistid":"20140095",
"idcustomer":5621,
"idorder":119087,
"idwarehouse":18,
"deliveryname":"Desmonds Formal Wear",
"deliverycontact":"",
"deliveryaddress":"Emmerikseweg 57",
"deliveryaddress2":"",
"deliveryzipcode":"7077 AP",
"deliverycity":"Netterden",
"deliveryregion":null,
"deliverycountry":"NL",
"emailaddress":"YassinevanLingen@mailinator.com",
"telephone": null,
"reference": "",
"assigned_to_iduser": null,
"invoiced":false,
...
}
Get PDF of picklist
PDF of a picklist can be retrieved as a base64 encoded document in JSON, or as a direct PDF document.
If the header Accept: application/json is given in the request, we will give you a response as shown below. Otherwise we will send you the PDF document directly with an Content-Type: application/pdf header as response.
GET
https://example.picqer.com/api/v1/picklists/{idpicklist}/picklistpdf
HTTP/1.1 200 OK
{
"idpicklist": 76859,
"pdf": "JVBERi0xLjMKMSAwIG9iago8PCAvVHlwZSAvQ2F..."
}
Get PDF of packinglist
Same thing applies as with a picklist PDF (see above), but with a different endpoint.
GET
https://example.picqer.com/api/v1/picklists/{idpicklist}/packinglistpdf
Snooze picklist
You can snooze open picklists. This picklist will be hidden from the list of picklists and will reappear on the given moment.
You can 'unsnooze' a snoozen picklist by posting "snooze_until" with null.
POST
https://example.picqer.com/api/v1/picklists/{idpicklist}/snooze
{
"snooze_until": "2017-03-01 12:00:00"
}
HTTP/1.1 200 OK
{
"idpicklist":76859,
"picklistid":"20140095",
"idcustomer":5621,
"idorder":119087,
"idwarehouse":18,
"deliveryname":"Desmonds Formal Wear",
"deliverycontact":"",
"deliveryaddress":"Emmerikseweg 57",
"deliveryaddress2":"",
"deliveryzipcode":"7077 AP",
"deliverycity":"Netterden",
"deliverycountry":"NL",
"emailaddress":"YassinevanLingen@mailinator.com",
"telephone": null,
"reference": "",
"assigned_to_iduser": 2991,
"invoiced":false,
"snooze_until": "2017-03-01 12:00:00",
"status": "snoozed",
...
}
Cancel picklist
This cancels a picklist. Picklist products will be converted into backorders.
Warning: Cancelling an already closed picklist will re-add product to the stock and remove any shipments attached to this picklist.
POST
https://example.picqer.com/api/v1/picklists/{idpicklist}/cancel
Read more Purchase Orders