Get a detailed Prebook list

Use this method to get a list of Prebooks with their corresponding details.

Valid Tokens: Company and Vendor.

If you use a Vendor Token, the response will be affected by the following statements:

  • The system will only return items associated with the authenticated Vendor and Customer information.

  • Sales prices will not be displayed. 

  • The system will only list Prebook items that have a Ship Date, Vendor, and Cost.

  • The system will only list Prebook items with a vendorShipDate equal to or greater than the previous day.

Take the following statements into account when applying filters:

  • The maximum date range for this request is six months.

  • Filtering by prebook, date, customerId, carrierId, salesPersonId,locationId, brandId, soNumber, and customerPONumber uses an exact match.

  • Filtering by customer and carrier uses a "LIKE" expression.

  • Filters are not case-sensitive.


Table of Contents

Request


URL: https://api.kometsales.com/api/prebook.details.list

Method: GET

Content-Type: URL Parameters


Input parameters

authenticationToken (required)

Komet Sales security token.


date (required)(date)

The Prebook Truck date set in the Bulk Purchasing Mode.

Optional: If you want to search a date range, use the vendorShipDateFrom and vendorShipDateTo parameters instead.

Date format: YYYY-MM-DD


prebook (optional)(integer:10)

Prebook number.


updatedAsOf (optional)(datetime)

When provided, it will force the method to only return orders that have been updated since the specified time and date.

Time must be in the GMT zone.

Date format YYYY-MM-DD hh:mm:ss


customer (optional)(string:200)

Customer name or code.

You can get this value from the customer.list API method.


customerId (optional)(integer:20)

Komet Sales internal Customer ID.

You can get this value from the customer.list API method.


carrierName (optional)(string:200)

Carrier name.


carrierId (optional)(integer:20)

Carrier ID.

You can get this value from the carrier.list API method.


vendorShipDateFrom (optional)(date)

The Vendor's ship date. 

Date format YYYY-MM-DD


vendorShipDateTo (optional)(date)

Vendor Ship Date. 

Date format: YYYY-MM-DD

The date range between shipDateFrom and shipDateFrom must not exceed seven days.


salesPersonId (optional)(integer:20)

Customer's Salesperson ID.


soNumber (optional)(integer:20)

Standing Order number.


customerPONumber (string)(integer:20)

Customer PO number.


locationId (optional)(integer:20)

Komet Sales internal Location ID.


brandId (optional)(integer:20)

Komet Sales internal Vendor Brand ID.


unableToSource (optional)(boolean)

Only return Prebooks marked as Unable to Source and are pending to buy.

Valid values: 1 = Yes | 0 = No

Back to top


https://api.kometsales.com/api/prebook.details.list? authenticationToken=token_info_goes_here&date=2015-02-10

Response


status (integer:1)

Transaction status.

Valid values: 1 = Success | 0 = Failure


message (string:500)

Transaction status description.


prebooks (array)

An array containing Prebooks


id (integer:20)

Komet Sales internal Prebook ID.


number (integer:10)

Invoice number.


locationId (integer:20)

Komet Sales internal Location ID.


locationName (string:200)

Location name.


locationCode (string:20)

Location code.


customerName (string:200)

Customer name.


customerId (integer:20)

Komet Sales internal Customer ID.


customerCode (string:20)

Customer code.


shipName (string:200)

Customer’s Ship-To name.


shipCity (string:200)

Shipping address city.


shipState (string:200)

Shipping address state.


shipAddress (string:200)

Shipping address street.


shipZipCode (string:10)

Shipping address zip code.


shipCountry (string:200)

Shipping address Country.


shipToCode (string:50)

Ship-To Code.


type (string:1)

Type of order.

Valid values: S = Standing Orders | P = Standalone Prebooks | D = Doubles 


truckDate (date)

Order ship date.

Date format: YYYY-MM-DD


customerPONumber (string:20)

Customer PO number.


carrierId (integer:20)

Komet Sales internal Carrier ID.


carrierName (string:200)

Carrier name.


shipvia (string:10)

Warehouse or Grower. 


comments (string:200)

Additional order notes.


details (array)

An array containing Prebook details.


prebookItemId (integer:20)

Komet Sales internal Prebook Item ID.


type (string:10)

If the line was sold as Units or Boxes.

Valid values: Unit or Box.


futureSales (Boolean)

If the Prebook line belongs to Future Sales.


vendorId (integer:20)

Komet Sales internal Grower or Vendor ID.


vendorName (string:200)

Grower or Vendor name.


vendorShipDate (date)

Vendor's shipping date.

Date format: YYYY-MM-DD


productId (integer:20)

Komet Sales internal product ID.


productDescription (string:200)

Product description.


totalBoxes (integer:10)

The number of boxes in the product line.


boxType (string:3)

Box type code

For example, FB, HB, QB, etc.


bunches (integer:10)

Number of Bunches per box.


stemsBunch (integer:10)

Number of stems per bunch.


unitPrice (decimal:10,2)

Unit price.


units (integer:10)

Units per Box.


unitType (string:10)

Unit-type.

Valid values: Stem or Bunch.


totalUnits (integer:10)

Total Units in the product line.


unitCost (decimal:10,2)

The product line Unit cost.

Only available for Vendor tokens with the option of changing unit cost.


totalPrice (decimal:10,2)

The amount in the product line. Calculated by Unit Price x Total Units.


markCode (string:50)

The product mark code.


brandId (integer:20)

Komet Sales internal Vendor brand ID.


brandName (string:200)

Vendor brand name.


generalNotes (string:500)

Product line notes that are visible to Customers and Vendors. 


vendorNotes (string:500)

Product line notes that are only visible to the Vendor.  


breakdowns (array)

An array containing breakdowns.


productId (integer:20)

Komet Sales internal product ID.


productDescription (string:20)

Product description.


stemsBunch (integer:10)

Number of Stems per Bunch.


bunches (integer:10)

Number of Bunches.


price (decimal:10,2)

Unit price.

Back to top


{ "message": "OK", "status": 1, "prebooks": [ { "id": 1927173, "number": "13010", "customerName": "AB Flower Shop", "customerCode": "34325", "customerId": 34325, "shipName":"Store 1", "shipCity":"Miami", "shipState":"FL", "shipAddress":"Street 21 Av 90", "shipZipCode":"32009", "shipCountry":"USA", “ShipToCode”:”MIA3”, "details": [ { "prebookItemId": 24243, "breakdowns": [], "vendorName": "Flores Capiro", "boxType": "HB", "unitType": "Stem", "productDescription": "Combos Multiple Colors Rose Combo1 Multiple Grades", "stemsBunch": 12, "unitPrice": "1.250", "vendorId": 6320, "brandId": 2, "brandName": "Demo Brand", "units": 240, "productId": 178172, "totalUnits": 2400, "unitCost": "1.000", "bunches": 20, "totalBoxes": 10, "totalPrice": "3,000.00", "futureSales": true }, { "prebookItemId": 24244, "breakdowns": [], "vendorName": "Exportadora de Flores", "boxType": "HB", "productDescription": "Carnation Assorted Select", "stemsBunch": 20, "unitType": "Bunch", "unitPrice": "1.050", "vendorId": 17684, "units": 18, "productId": 276277, "totalUnits": 180, "unitCost": "2.000", "bunches": 18, "totalBoxes": 10, "totalPrice": "9.00", "futureSales": false }, { "prebookItemId": 24246, "breakdowns": [], "vendorName": "Flores del Este", "boxType": "HB", "productDescription": "Lilies Assorted Oriental 2 Blooms", "stemsBunch": 5, "unitType": "Bunch", "unitPrice": "1.250", "vendorId": 6321, "units": 25, "productId": 139103, "totalUnits": 250, "bunches": 25, "totalBoxes": 10, "totalPrice": "312.50", "futureSales": true } ], "carrierId": 1207, "shipVia": "Warehouse", "carrierName": "American Airlines", "truckDate": "2015-02-10", "type": "P", "totalPrice": "3,501.50" }, { "id": 1949612, "number": "13949", "customerName": "Eric's Flowers", "customerCode": "6529", "customerId": 6529, "shipName":"Store 2", "shipCity":"Miami", "shipState":"FL", "shipAddress":"Street 15 Av 80", "shipZipCode":"32010", "shipCountry":"USA", "details": [ { "prebookItemId": 24912, "breakdowns": [], "vendorName": "Flores Capiro", "boxType": "HB", "unitType": "Bunch", "productDescription": "Pom Button Green Athos 70 Cm", "stemsBunch": 10, "unitPrice": "1.650", "vendorId": 6320, "brandId": 2, "brandName": "Demo Brand", "units": 24, "productId": 139478, "totalUnits": 336, "bunches": 24, "totalBoxes": 14, "totalPrice": "554.40", "futureSales": true } ], "carrierId": 1204, "shipVia": "Warehouse", "carrierName": "Armellini", "truckDate": "2015-02-10", "type": "S", "totalPrice": "554.40" } ] }

 


Related Articles

Peacock