Developer need for API linking of Shipment tracking to Website

Need to read input data from google sheets and display pre shipment and after arrival, data to be displayed on tracking website

in between the package tracking api needs to be connected for air and sea shipments real-time tracking data

Just to summarize the work flow:

Shipment when received in warehouse at origin country (china), our staff would enter Unique shipment reference number and package number for each package and this data is added to google sheet

Then this package when handed over to airline or sealine, then master airwaybills would be added to the shipment reference on google sheet

After the shipment arrived at destination (example: Dubai) then the warehouse team would confirm arrival of each master airwaybil/container receipt

stage 1: shipment receiving time data on google sheet to be updated on tracking page of our wp website

stage 2: air or sea airwaybil/bill of lading number to be tracked and linked using api and update google sheet with real time data and also the same to be updated on website live tracking when shipment reference is being queried by customer.

stage3: when shipment being received at destination warehouse, the same data is being added to google sheet, and this data is to be linked to website and display status as shipment received in dubai warehouse.

stage 4: when shipment delivered, this data also will be updated on google sheet and the same shall be displayed on website as shipment delivered.

PHP WordPress JavaScript Google App Engine สถาปัตยกรรมซอฟต์แวร์

หมายเลขโปรเจค: #32633316

เกี่ยวกับโปรเจกต์