Laddawn.com : Freight Quote by standardizing shipping

NEXT STEPS:

Test the Freight estimate process for Sterling. Capture the estimates for evaluation and provide access to them for CE.

The packing algorithm should kick in after the Bundling stage of checkout  →  a separate call to 3D Bin-Packaging for each bundle → A separate call to UPS API for each box packed by 3D Bin-Packaging → Sum the shipping costs as Freight Estimates → Capture estimates on SQL and make them available to CE

RESEARCH TILL NOW:

In line with the advanced features of Laddawn.com ,It is important to give a freight quote on pre-pay and add orders of value < $500 on Laddawn.com. This task has till now been elusive as it is impossible to estimate how items will be master packed for a shipment. We have therefore decided the flip the problem a=on its head and standardize shipping.

The details were discussed in a meeting on Jan 10 2019. Attached below is the handout for the same.

Freight Quote Meeting.docx

Process Followed:

1. Collect details of orders:
   1. Item Number
   2. Item Quantity
   3. Item Dimensions
   4. Item Weight
2. Bundle the shipments based on warehouse locations being used
3. Pack Items in available master packs by making a web service call and passing bundle details to https://www.3dbinpacking.com/en/
4. Assign Carrier, UPS for Fed Ex
5. Estimate freight by making a web service call to The carrier API
   1. A separate call for each master pack is required

Collect Details of Orders

For the shipping tests, I used details from already placed orders:

1. Item Number - OrderHeader and OrderLine
2. Item Quantity -   OrderHeader and OrderLine
3. Item Dimensions - Stock Item Spreadsheet
4. Item Weight - Stock Item Spreadsheet (Attached below)

It would be good if we an access Item dimensions and wt from Avante and get order details when order is still in cart. Also clean up the data.

Bundle Shipment based on warehouse locations

This feature is already available on laddawn.com.

Pack Items into Master Packs 

Web Link: https://www.3dbinpacking.com/en/

Sample Input JSON for Items: 

Sample Input JSON for Bins:

Python Code for API Call:

Output JSON Sample:

Things to parse here:

1. Pick Slip:
   1. Box ID: response['bins_packed'][<List Index>]['bin_data']['id']
   2. Items to be packed in the box: response['bins_packed'][<List Index>]['items'][<List Index>]['id']
   3. Images(optional):
      1. for overall bin: response['bins_packed'][<List Index>]['image_complete']
      2. for individual item in Bin:  response['bins_packed'][<List Index>]['items'][<List Index>]['image_separated']
2. Input for UPS or FedEx api:
   1. Depth: response['bins_packed'][<List Index>]['bin_data']['d']
   2. Width:response['bins_packed'][<List Index>]['bin_data']['w']
   3. Height:response['bins_packed'][<List Index>]['bin_data']['stack_height']+0.5
   4. weight: response['bins_packed'][<List Index>]['bin_data']['weight']

Box Sizes to create the input json giving details of Bins (Master Packs):

Pricing Tiers: https://www.3dbinpacking.com/en/pricing

Assign Carrier, UPS for Fed Ex

Already working in shipping

UPS API Documentation:

Estimate freight by making a web service call to The carrier API

Python Query for API Call: