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.