Get a list of Purchase Orders
Use this method to get a detailed list of Purchase Orders based on the applied filters within a date range.
Valid Tokens: Company and Vendor.
When using this method, take the following statements into account:
The maximum range for this request is six months.
Filtering by
vendorId
,status
,number
,origin
,prebook
andlocationId
uses an exact match.Filtering by
vendor
andproduct
uses a "LIKE" expression.Filters are not case-sensitive.
The
boxes
array is only available when the Purchase Order was shipped by the Grower.
Related Articles
-
Substitute Items (Knowledge Base)
-
Confirm PO's - "V" Mark (Knowledge Base)
-
Confirm POs from the Vendor Portal (Knowledge Base)
-
Purchase Order Management (Knowledge Base)
-
Problems finding Purchase Orders (Knowledge Base)
Request
URL: https://api.kometsales.com/api/purchase.order.list
Method: GET
Content-Type: URL Parameters
Input parameters:
authenticationToken (required)(string:50)
Komet Sales security token.
date (required if number
is not sent)(date)
Vendor Ship Date.
Date format: YYYY-MM-DD
futureInventoryAvailableFrom (optional)(date)
Date when the product will be available.
The specified date range must not exceed 4 days.
Date format: YYYY-MM-DD
futureInventoryAvailableTo (optional)(date)
Date when the product stops being available.
Date format: YYYY-MM-DD
The specified date range must not exceed 4 days.
vendor (optional)(string:50)
Vendor name or code.
vendorId(optional)(integer:10)
Komet Sales internal Vendor ID.
This parameter is used to search purchase orders from only one vendor.
You can get this value from the vendor.list API method.
customerId(optional)(integer:20)
Komet Sales internal Customer ID.
You can get this value from the customer.list API method.
customerPONumber (optional)(string:20)
Customer PO Number.
product (optional)(string:100)
Product description.
number (required if date
is not sent)(string:10)
Purchase order number.
You can send a set of numbers separated by commas.
origin (optional)(string:4)
Origin code. For example: MIA, MDE, and BOG.
prebook(optional)(string:10)
Prebook number.
awbId (optional)(integer)
AWB ID of the order.
If you use this parameter, or inboundTruckId
, you don’t need to send any other parameters aside from the authenticationToken
.
inboundTruckId (optional)(integer)
Inbound Truck ID.
If you use this parameter, or awbId
, you don’t need to send any other parameters aside from the authenticationToken
.
locationId (optional)(integer:10)
Komet Sales internal Location ID.
You can obtain this value from the location.list API method.
status (optional)(string:20)
Prebook status.
Valid values: Confirmed by Farm, Approved, Pending Approval, Cancelled.
If this filter is not set, the system will return every Purchase Order, including those that have the Pending Approval status.
statusLine (optional)(string:20)
Product line status.
Valid values: Pending, Confirmed, Cancelled, Partial Confirm, Shipped.
purchaseOrderItemIds (optional)(string:200)
A set of Purchase Order Item IDs separated by commas.
This is very useful for the Vendor Availability integration.
includeVendorAvailabilityDetails (optional)(boolean)
Include Vendor Availability information.
Valid values: True | False
Default it's false.
updatedAsOf (optional)(datetime)
When provided the system will only return orders that have been updated as of the date/time that is specified.
Date format: YYYY-MM-DDhh:mm:ss
Time must be in the GMT time zone.
excludeDetails(optional)(integer:1)
If the result should include only headers and exclude details.
Valid values: 0 = Include details | 1 = Exclude details
Default is 0.
https://api.kometsales.com/api/purchase.order.list?
authenticationToken=token_info_goes_here&date=2014-09-24&status=A
Response
status (integer:1)
Transaction status.
Valid values: 1 = Success | 0 = Failure
message (string:500)
Transaction status description.
purchaseOrders (array)
An array containing Purchase Orders.
id (integer:20)
Komet Sales internal Purchase Order ID.
number (integer:10)
Purchase Order number.
carrierName (string:200)
Purchase Order carrier name.
carrierId (integer:20)
Purchase Order Carrier ID.
networkCodeId (integer)
Purchase Order Carrier’s Komet Network Code.
origin (string:4)
Origin code.
vendorId (integer:20)
Komet Sales internal Vendor ID.
vendorName (string:200)
Vendor name.
shipDate (date)
Purchase Order shipping date.
Date format: YYYY-MM-DD
arrivalDate (date)
Purchase Order arrival date.
Date format: YYYY-MM-DD
status (string:1)
Status code.
Valid values: CF = Confirmed by Farm | A = Approved | PA = Pending Approval | CA = Cancelled
locationId (integer:20)
Komet Sales internal Location ID.
locationName (string:200)
Location name.
totalCost (decimal:10,3)
Total cost of the order.
comments (string:500)
Special instructions or comments.
totalBoxes (integer:10)
Number of boxes.
updatedOn (datetime)
Last time when the order was updated.
Date format: YYYY-MM-DD'T'hh:mm:ss
Time is in the GMT time zone.
createdOn (datetime)
Date when the order was created.
Date format: YYYY-MM-DD'T'hh:mm:ss
hardGoodsDetails (array)
Hard Good purchase order details.
hardGoodCompanyProductId (long)
Hard good product ID.
quantity (Integer)
Amount.
unitCost (float)
Product cost.
ids (string)
Product IDs, separated by commas.
description (string)
Product description.
referenceNumbers (string)
Reference numbers, separated by a comma.
pack (Integer)
Product pack.
totalCost (float)
Total cost.
totalUnits (Integer)
Total units.
details (array)
Purchase Order details.
poItemId (integer:20)
Komet Sales internal Purchase Order Item ID.
prebookItemId (integer:20)
Prebook item internal ID.
prebook(integer:10)
Prebook number.
prebookTruckDate(date)
Prebook Truck Date.
Date format: YYYY-MM-DD
carrierId(integer:20)
Prebook Carrier ID.
carrierName(string:200)
Prebook Carrier Name.
standingOrder(string:10)
Standing order number.
orderType(string:1)
Order type.
Valid values: P = Prebook | S = Standing Order | D = Double
customerId(integer:20): customer Komet Sales internal ID.
customerName(string:200): customer name.
customerCode (string:50): Customer code.
shipName (string:200): Ship To name.
shipCity (string:200): ship city name.
subtotalCost(decimal:10,2)
Purchase Order total cost plus additional charges.
shipState (string:200): ship state name.
shipAddress (string:200): ship address.
shipZipCode (string:10): ship zip code.
shipCountry (string:200)
Ship country name.
shipVia (string)
Assigned ship via. i.e. Vendor, Warehouse.
productId (integer:20) product Komet Sales internal ID.
productDescription(string:200): product description.
recipes (array) of the products included within the recipe:
productDescription(string:200): item description.
stems(integer: 3): the number of stems.
laborAndMaterials: array of the labor and materials included within the recipe:
productDescription(string:200): product description.
quantity(integer: 3): the number of units.
totalBoxes(integer:10): number of boxes.
quantityConfirmed(integer:10): number of boxes confirmed by the vendor.
boxType(string:3): box type code. (HB, QB, EB, etc).
bunches (integer:10): number of bunches per box.
stemsBunch(integer:10): stems per bunch.
unitCost(decimal:10,3): unit flower cost.
units (integer:10): units per box.
unitType(string:5): stem or bunch.
totalFbe(decimal:10,2)
Total Full Box Equivalent (FBE) of every box in the Purchase Order.
totalUnits(integer:10):total of units.
totalCost(decimal:10,3): total cost.
totalAdditionalCharges (decimal:10,2)
Total additional charges.
unitPrice(decimal:10,3): unit flower price. This field is only available if the token type is Company Token.
totalPrice(decimal:10,3): total price. This field is only available if the token type is Company Token.
markCode(string:20): special mark code or slot number.
customField1 (string:50): additional field #1.
notes (string:200): general notes for each line.
notesForVendor (string:200): notes for the vendor associated to the prebook item.
lineItemStatus(string:1): vendor status code of the product line. P for Pending, C for Confirmed, CA for Cancelled, PC for Partial Confirm, S for Shipped.
breakdowns: array of breakdowns
productId (integer:20) product Komet Sales internal ID.
productDescription(string:200) product description.
stemsBunch(integer:10): stems per bunch.
bunches (integer:10): number of bunches.
cost (decimal:10,3): unit flower cost.
boxes: array of boxes
boxCode(string:20): box code number.
lotNumber(string)
Box lot number.
position (string:5): physical position of the box.
statusId(integer:10): status Komet Sales internal ID.
statusName(string:20): status name (Farm Shipped, Received Warehouse, Shipped Warehouse)
customFields: array of custom fields of the line, only if they exist.
name and value of the custom field (string:20).
vendorAvailabilityDetails: details of the vendor availability items associated to this line of the order.
productDescription(string:200): product description.
availableFrom(date): date when the product was available from the vendor. (date format YYYY-MM-DD).
postHarvest (string:20): post harvest.
unitType(string:20): unit type. Stem or Bunch.
unitsAllocated(integer:10): number of units allocated to this line of the order.
downgraded (boolean): true if the product was downgraded.
originalProductDescription(string:200)
product where the item was downgraded from.
upc: details of the upc information added to the product.
number (string: 50): UPC number.
checkDigit(integer: 2): UPC check digit.
pullDate(string: 20): UPC Pull date
price (string:20): UPC unit price.
description (string:200): Product description for the UPC.
instructions (string:200)
Additional UPC instructions.
The Ship-To information is only displayed with Company-type Tokens.
{
"message": "OK",
"purchaseOrders": [
{
"origin": "MIA",
"vendorId": 25211,
"totalBoxes": 15,
"shipName": "",
"createdOn": "2024-10-07T08:06:28",
"shipCountry": "",
"number": "P002937",
"locationId": 4,
"id": 90456,
"shipZipCode": "",
"shipCity": "",
"locationName": "Omaha Mod",
"updatedOn": "2024-10-07T07:06:37",
"vendorName": "AgriFarms",
"shipDate": "2024-10-07",
"arrivalDate": "2024-10-10",
"shipAddress": "",
"subtotalCost": "15",
"shipState": "",
"totalCost": "15",
"totalAdditionalCharges": "0",
"status": "PA",
"carrierId": 1357,
"carrierName": "Armellini",
"networkCodeId": 0,
"hardGoodsDetails": [
{
"hardGoodCompanyProductId": 98,
"quantity": 100,
"unitCost": 0.99,
"ids": "276",
"description": "Bolsa Flores Pink ( Bolsas )",
"referenceNumbers": "",
"pack": 17,
"totalCost": 0.99,
"totalUnits": 1700
},
{
"hardGoodCompanyProductId": 106,
"quantity": 88,
"unitCost": 0.55,
"ids": "279,280",
"description": "Jarron Blue ( JARRONES )",
"referenceNumbers": "",
"pack": 1,
"totalCost": 1.1,
"totalUnits": 88
}
],
"details": [
{
"orderType": "P",
"stemsBunch": 2,
"totalPrice": "10",
"notesForVendor": "",
"customFields": [],
"breakdowns": [],
"bunches": 1,
"prebookItemId": 934637,
"customerCode": "main code",
"units": 1,
"totalBoxes": 5,
"unitType": "Bunch",
"shipVia": "Warehouse",
"totalFbe": "10",
"carrierName": "Elite",
"referenceNumber": "",
"poItemId": 288102,
"customerId": 29330,
"lineItemStatus": "P",
"productDescription": "Fancy Alstro",
"unitPrice": "2",
"boxes": [],
"recipes": [],
"productId": 217045,
"laborAndMaterials": [],
"boxType": "FB",
"customerName": "customer test main",
"totalUnits": 5,
"prebook": 3280,
"unitCost": "1",
"prebookTruckDate": "2024-10-07",
"quantityConfirmed": 0,
"carrierId": 3000,
"totalCost": "5"
},
{
"orderType": "P",
"stemsBunch": 2,
"totalPrice": "20",
"notesForVendor": "",
"customFields": [],
"breakdowns": [],
"bunches": 1,
"prebookItemId": 934636,
"customerCode": "main code",
"units": 1,
"totalBoxes": 10,
"unitType": "Bunch",
"totalFbe": "20",
"carrierName": "FedEx",
"referenceNumber": "",
"poItemId": 288103,
"customerId": 29330,
"lineItemStatus": "P",
"productDescription": "10 pack Leather Leaf",
"unitPrice": "2",
"boxes": [],
"recipes": [],
"productId": 219070,
"laborAndMaterials": [],
"boxType": "FB",
"customerName": "customer test main",
"totalUnits": 10,
"prebook": 3279,
"unitCost": "1",
"prebookTruckDate": "2024-10-07",
"quantityConfirmed": 0,
"carrierId": 4605,
"totalCost": "10"
}
]
}
],
"status": 1
}