This page is for a merchandiser at a garment factory that ships both export and domestic orders, who must bring together the incoterm, the booking, the container decision, and the tracking status this course has taught across its first four lessons into one working shipment tracker. This is chiefly a decision-flow skill: taking everything already known about a shipment and recording it in one place so that a single glance answers "what stage is this shipment at, and what decision, if any, does it need next." Without this skill, the same facts a merchandiser already knows stay scattered across emails, phone calls and memory, so a shipment's true status has to be reconstructed from scratch every time someone asks.
You need: Lessons 1 through 4 of this course, since this lesson assembles the incoterm (Lesson 1), the booking and sailing date (Lesson 2), the container decision (Lesson 3), and the tracking and bill of lading status (Lesson 4) into one tracker.
By the end of this lesson you can:
Not covered here: this is the final lesson of Course 1; the next course in this track covers export and import documentation.
| Term | Meaning |
|---|---|
| Shipment tracker | This course's own workbook, one row per shipment, recording its incoterm, booking, container type, and tracking status in one place. |
| Tracker row | One complete record of a single shipment, filled in as each stage of its own journey is confirmed. |
| Status field | The single column on a tracker that states, at a glance, whether a shipment is booked, in transit, arrived, or delayed. |
| Hybrid business model | A factory's own combination of export orders and domestic orders running side by side, each tracked according to its own market's requirements. |
| Freight forwarder | A company that arranges the shipping and paperwork for moving goods from factory to buyer. |
A complete shipment tracker brings together everything a merchandiser has already learned to check separately: the incoterm (Lesson 1), the booking and sailing date (Lesson 2), the container type (Lesson 3), and the bill of lading and tracking status (Lesson 4). Each tracker row records one shipment's own facts, but not every shipment needs every column filled: an export order fills its incoterm, its container type, and its bill of lading status, while a domestic delivery leaves those columns blank or marked "not applicable," since it has no incoterm, no container decision in the export sense, and no bill of lading at all. A tracker's own status field is what lets anyone glance down the sheet and see, without reading every column, which rows are moving normally and which ones need attention.
| What can differ | The shapes you meet | Why it matters |
|---|---|---|
| Export order vs. domestic delivery, on the same tracker | An export order such as Order A fills every column, incoterm, forwarder, container type, and bill of lading status; a domestic delivery such as Cedar & Co.'s own onward distribution fills only the order, forwarder (if any), and status columns, leaving incoterm, container type, and bill of lading marked "not applicable." | Forcing a domestic row to fill columns it has no real answer for produces false entries that mislead anyone reading the tracker later. |
| Make to Order vs. Make to Stock rows on the same sheet | A Make to Order export row like Order A's is added the moment the order is confirmed, since its own ship date is already fixed; a Make to Stock domestic row like Cedar & Co.'s own restock run is added once a production run is actually planned, since there is no single confirmed order date to anchor it to. | Adding a Make to Stock row too early, before a production run is actually planned, leaves a tracker row with no real dates to track against. |
| A factory tracking its own hybrid business model in one workbook | Delta Garments, supplying both Northline Apparel's export orders and Cedar & Co.'s domestic runs, uses one shipment tracker for both, with each row's own market column making clear which rules apply to that row. | Splitting export and domestic shipments across two separate, disconnected trackers loses the single-glance view a hybrid factory actually needs across its whole shipping operation. |
| A shipment still in progress vs. one already closed out | A shipment still moving through its own stages needs its status field checked and possibly updated regularly; a shipment marked "arrived" with all fields complete needs no further action and can be left as a closed record. | Continuing to check and update a tracker row that is already closed wastes time that should go to rows still actually in progress. |
| Socks, terry, and home-textile product families | A hosiery, terry, or bedding shipment uses the exact same tracker columns and the same complete-row method; only the product description inside the order column changes. | The tracker's own structure does not change by product family; a merchandiser moving from T-shirts to towels fills the same columns the same way. |
Mona, the merchandiser at Delta Garments, is asked to build one complete shipment tracker that covers every shipment the factory currently has in progress: Order A's own export shipment to Northline Apparel, already tracked through Lessons 1 to 4's own examples, and a domestic delivery to Cedar & Co. Mona's task is not to invent new information; it is to bring together the facts already established across this course, incoterm, booking, container decision, and tracking status, into two complete rows on the same sheet, filling only the columns each shipment's own market actually needs.
The worked numberEvery figure in Order A's own row is reused directly from this course's own earlier lessons, 3,075 kg from Lesson 3's own worked number, "original issued, awaiting surrender" from Lesson 4's own workplace scenario; no new number is invented here. Cedar & Co.'s own row deliberately leaves several columns marked "not applicable," which is itself the correct, complete entry for a domestic delivery, not a missing one.
The methodA common mistake, when a domestic delivery is added to the same tracker as export shipments, is leaving its incoterm, container type, and bill of lading columns simply blank, the same way an export row's column would look if that information had not yet arrived. A blank column and a genuinely not-applicable column look identical on the page, so anyone reading the tracker later cannot tell whether a domestic row's blank incoterm column means "this shipment has none" or "someone forgot to check." Marking a column "not applicable" costs nothing and removes the ambiguity entirely.
A complete shipment tracker is one sheet, one row per shipment, that brings together everything this course has taught: the incoterm, the booking and sailing date, the container type, and the bill of lading and tracking status. Not every shipment needs every column filled. An export order like Order A fills all of them; a domestic delivery like Cedar & Co.'s own restock run leaves several marked "not applicable," since it has no incoterm, no international container decision, and no bill of lading. A tracker's own status field lets anyone see, at a glance, which shipments are moving normally and which ones need attention. Marking a column "not applicable" rather than leaving it blank is what keeps a tracker trustworthy, so a genuine gap in information is never confused with information a shipment simply never needed.
Karim, the production manager at Delta Garments, reviews the shipment tracker Mona has built, checking for any row that needs a decision today.
The relevant line from Karim's own tracker review note:
Which row needs a follow-up call today? Decide before you open the decision.
Order A's own row, since its status has not changed in three days, past Karim's own two-day flag rule, while Cedar & Co.'s own row was updated only yesterday and needs no action yet. Karim follows up with Meridian Sourcing to confirm whether the bill of lading has been surrendered.
The two facts that decide this are Karim's own rule that any row unchanged for more than two days needs a follow-up call, and the tracker's own dates showing Order A's row is three days stale against Cedar & Co.'s own row, updated only yesterday. Acting on the tracker's own status field, rather than checking every shipment from scratch, is exactly the time-saving this lesson's tool is built to provide.
Keeping a shipment tracker current, updating each row's status as new information arrives, costs a few minutes per shipment per update. The cost of letting a tracker fall out of date shows up when a genuinely delayed shipment, like Order A's own unresolved bill of lading, sits unnoticed because nobody flagged it against a simple rule like Karim's own two-day check. On a 15,000-piece order already worth USD 48,000 at FOB, a delayed pickup nobody caught for an extra week can force part of the order onto air freight to protect a retail date, turning a missed tracker check into a freight bill many times larger than the cost of the update itself.
This lesson completes the shipment tracker this course has built across all five lessons: the order, the incoterm, the forwarder, the container type, the booking and sailing dates, the bill of lading status, the arrival dates, and the overall status. [Download the tracker](templates/T14-C01-shipment-tracker.xlsx).
| Order / shipment | Incoterm | Container type | Bill of lading status | Status |
|---|---|---|---|---|
| Order A, export shipment | FOB | FCL | Original issued, awaiting surrender | Delayed (pending B/L surrender) |
| Cedar & Co., domestic delivery | Not applicable | Not applicable | Not applicable | In transit |
1. A domestic delivery's tracker row has its incoterm column left completely blank, with no note explaining why. What is the correct way to read this blank column?
2. A factory's tracker has two rows: one export shipment with a status unchanged for five days, and one domestic delivery updated this morning. Following the rule in this lesson, which row needs attention first?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Shipment tracker | متتبع الشحنات | Suivi des expéditions | Sevkiyat takip listesi | This course's own workbook, one row per shipment, recording its incoterm, booking, container type, and tracking status in one place. |
| Tracker row | صف في المتتبع | Ligne du suivi | Takip listesi satırı | One complete record of a single shipment, filled in as each stage of its own journey is confirmed. |
| Status field | حقل الحالة | Champ de statut | Durum alanı | The single column on a tracker that states, at a glance, whether a shipment is booked, in transit, arrived, or delayed. |
| Hybrid business model | نموذج عمل مختلط | Modèle économique hybride | Karma iş modeli | A factory's own combination of export orders and domestic orders running side by side, each tracked according to its own market's requirements. |
| Freight forwarder | وكيل الشحن | Transitaire | Nakliye acentesi | A company that arranges the shipping and paperwork for moving goods from factory to buyer. |
Course 1 is now complete. The next course in this track moves from shipping and logistics operations to export and import documentation. Back to the course map