Please find my worksheet which keep follow and update all oversea p.o status ;
-green line means finished clearing and delivered to our factory.
-Yellow line means the shipment already received confirmation accept the P.O from the supplier or received shipping schedule or documents from the supplier as detail indicated in each column.
-Red line means delay schedule from supplier or urgent case by requester(which nothing)
Every p.o is sequence by requested/ confirmed ETA date which easy for us following up status update from each supplier.
If other requestors would like to see the table at anytime, we can share file together(read-0nly) but that means it have all detail which show supplier name until others items which not only for trading but also raw mat. for factory.
The table isn’t shown estimate delivery date to factory, that means we have to add it up one more column for requestor.
Or 1 alternative, I usually update estimate delivery date for factory by reply e-mail on top their PR e-mail as soon as received update from supplier. This method can screen only detail what requestor should know.
Please consider and confirm which method you require.
For 1st container of Gelatin shipment, the supplier confirmed us as schedule(ETD end of this month) so end of this week or begin of next week, we should receive shipping documents.