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)(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 (optional)(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.

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.

status (integer:1): transaction status. 1 for success or 0 for failure.

message (string:500): description of the status of the transaction.

purchaseOrders: array of purchase orders

id (integer:20): Komet Sales internal purchase order ID.

number (integer:10): purchase order number.

origin (string:4): origin code.

vendorId(integer:20): vendor Komet Sales internal ID.

vendorName(string:200): vendor name.

shipDate(date): order ship date. (date format YYYY-MM-DD).

status (string:1): status code (CF = Confirmed by Farm, A = Approved, PA = Pending Approval, CA = Cancelled).

locationId(integer:20): location Komet Sales internal 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 will be in the GMT time zone.

createdOn(datetime):date when the order was created. (format YYYY-MM-DD'T'hh:mm:ss).

details (array)

Purchase Order details.

poItemId(integer:20): PO item internal 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): carrier Komet Sales internal ID.

carrierName(string:200): carrier name.

standingOrder(string:10): standing order number.

orderType(string:1): P for prebook, S for standing Order, D for 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.  

shipState (string:200): ship state name. 

shipAddress (string:200): ship address. 

shipZipCode (string:10): ship zip code.  

shipCountry (string:200): ship country name.  

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.

totalUnits(integer:10):total of units.

totalCost(decimal:10,3): total cost.

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(integer:10): 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.