How to track purchase orders with overseas suppliers
The short answer
Purchase order tracking for an overseas order means following it through every stage, not only the shipment. A typical order with a factory passes through seven stages: purchase order sent, pro forma invoice received, deposit paid, production, inspection, balance paid, and shipment. Keep one row per order, record the current pro forma invoice version and the confirmed ship date, and ask the factory for an update every week.
On this page
What purchase order tracking means for importers
For a domestic purchase, tracking a purchase order usually means tracking a delivery. The supplier confirms the order, ships it, and you follow the tracking number.
An order from an overseas factory works differently. The goods do not exist yet when you send the PO. The factory confirms the order with a pro forma invoice, asks for a deposit, buys materials, and makes the goods over several weeks. By the time there is a shipment to follow, most of the risk is already behind you, or already in the cartons.
So tracking an overseas order means tracking three things at once:
- Where the order is: which stage it has reached, and its ship date. In this guide, the ship date is the day the goods leave the factory; after that, your freight forwarder tracks the vessel.
- Which version is current: the latest pro forma invoice, after every change to specification, price, or ship date.
- What is owed: whether the deposit has been paid, and what balance is due before shipment.
Miss any one of the three and a problem surfaces late, when it costs the most to fix.
The seven stages to track on every overseas order
Goods made to your specification usually move through the same seven stages. Some orders skip one, but this is the sequence to track against.
1. Purchase order sent
You send the factory your PO. Record the PO number, the date you sent it, and the ship date you asked for.
2. Order confirmed with a pro forma invoice
The factory confirms by sending a pro forma invoice (also written proforma invoice, or PI) that restates your order and asks for a deposit. Some factories send an order acknowledgment first. Record the PI number and revision, and check it against your PO line by line before you pay anything. Our guide to purchase order vs invoice explains what to compare.
3. Deposit paid
Most factories start buying materials only once the deposit arrives. Record the amount, the date, and the balance still due.
4. Production
The longest stage, and the one where delays usually start. Record the factory’s planned dates for materials, production, and packing, and the latest ship date it has confirmed.
5. Inspection
Before you pay the balance, someone checks the goods: your own team, a third-party inspector, or at minimum photos and video from the factory. Record the date, the result, and any rework agreed.
6. Balance paid
Depending on your payment terms, the balance is due before shipment or against the shipping documents. Check the commercial invoice against the latest approved PI first, then record the date.
7. Shipped
Record the ship date and the commercial invoice number. From here, your freight forwarder tracks the vessel.
A walkthrough: tracking 400 dining chairs from PO to shipment
Here is one order tracked from start to finish, week by week. The prices and timings are illustrative, chosen to keep the math simple.
Example
Your purchase order, PO-1057, is for 400 upholstered dining chairs in a gray performance fabric, at $90 each. The total is $36,000. Your payment terms are a 30% deposit ($10,800) before production and the balance ($25,200) before the chairs ship. You ask for the chairs to leave the factory in week 10.
| Week | Stage | What happened | What you update in the tracker |
|---|---|---|---|
| 1 | Purchase order sent | You send PO-1057. | PO number, date sent, original ship date: week 10 |
| 1 | Pro forma invoice | The factory sends PI-311, revision 1. The fabric code does not match your approved swatch. | PI version: revision 1, not approved |
| 2 | Pro forma invoice | The factory sends revision 2 with the correct fabric code. | PI version: revision 2, approved |
| 2 | Deposit paid | You send the $10,800 deposit. | Deposit: paid. Balance due: $25,200 |
| 5 | Production | Frames are built, but the fabric will arrive a week late. The factory reissues the PI as revision 3 with the new ship date, and you approve it. | Production: frames done. PI version: revision 3, approved. Confirmed ship date: week 11 |
| 8 | Production | Upholstery is finished and packing has started. | Production: packing |
| 9 | Inspection | The inspector finds loose stitching on 12 chairs. The factory agrees to rework them. | Inspection: rework on 12 chairs, re-check booked |
| 10 | Inspection | The re-check passes. | Inspection: passed |
| 10 | Balance paid | The commercial invoice matches revision 3, so you send $25,200. | Balance: paid |
| 11 | Shipped | The chairs leave the factory. | Shipped: week 11, handed to your forwarder |
Two things in this order would have been easy to miss: the wrong fabric code on revision 1, and the ship date moving a week in the middle of production. The fabric code was caught by checking the pro forma invoice against the approved swatch before paying the deposit. The delay was caught by the weekly check-in. The tracker did not catch either one; it is where each finding was recorded, so everyone worked from the same version and the same dates.
Common mistake
The factory mentions the fabric delay in a WeChat or WhatsApp message, and nobody updates the tracker. The row still says week 10, so your sales team promises customers a date the factory is no longer working to.
Production tracking: what to ask your factory each week
Production is the longest stage and the hardest to see from your side. A short weekly check-in with the same five questions keeps it in view:
- What stage is the order in today: materials, production, finishing, or packing?
- Are all materials in? If not, what is missing, and when will it arrive?
- Is the ship date still the date on the latest pro forma invoice?
- Can you send photos or a short video of the goods in production?
- Has anything changed that needs a revised pro forma invoice?
Ask on the same day each week, in the same channel, and update the tracker the day the answers arrive. If the price, specification, or ship date changes, ask the factory for a revised pro forma invoice instead of accepting the change in a chat message.
A simple purchase tracker you can copy
You do not need special software to start. A spreadsheet with one row per purchase order and these ten columns covers all seven stages:
| PO number | Supplier | PI version | Deposit | Production stage | Inspection | Balance | Original ship date | Confirmed ship date | Next action |
|---|---|---|---|---|---|---|---|---|---|
| PO-1057 | Chair factory | PI-311, rev 3, approved | Paid, $10,800 | Packing | Booked, Mar 12 | $25,200 due | Mar 9 | Mar 16 | Confirm the inspector’s arrival |
| PO-1061 | Table factory | PI-88, rev 2, not approved | Paid, $18,000 | Production | Not booked | $45,000 due | Apr 6 | Apr 13 | Review rev 2: new finish and price |
| PO-1064 | Lighting factory | Waiting for PI | Not paid | Not started | Not booked | Not due | Apr 20 | Not confirmed | Ask the factory for the PI |
A few habits make it work:
- Use the same words in every row. In Excel or Google Sheets, a dropdown for each status column keeps everyone from inventing their own terms.
- Show approval in the PI version. Write the revision number and whether you have approved it, so an unapproved revision stands out.
- Never overwrite the original ship date. Keep it next to the confirmed date, so every delay is visible.
- Give every row a next action, even if it is only “wait for the weekly update”.
- Add a “Last updated” column with the date and the name of whoever changed the row.
- Sort by confirmed ship date, so the orders that need attention this week sit at the top.
Where spreadsheet tracking breaks down
A tracker works well when one person owns it and there are only a few orders. It gets harder as orders multiply, because someone has to keep every row in line with the approved order and the factory’s latest updates.
- Updates are copied by hand. Even in a shared sheet, the factory’s news arrives by email or chat, so each row is only as current as the last message someone copied over.
- The versions live somewhere else. The PI version column says revision 2, but revision 2 is a PDF in someone’s inbox, and revision 3 may already be in a chat thread.
- Changes skip the spreadsheet. A delay or a price change agreed in a chat never reaches the row unless someone remembers to add it.
- Several people edit it. Purchasing, sales, and accounts each update different columns, and nobody can tell which figures are current.
These problems share one cause. You and the factory each keep your own copy of the order, and the tracker becomes a third copy.
How neet tracks purchase orders with your supplier
neet is purchase order management for importers and brands, built around one shared order instead of separate copies. Your supplier builds its pro forma invoice in neet, and the order lives there, so your team and the factory’s team work on the same order instead of trading files.
When the fabric, the price, or the ship date changes, the supplier revises the order in neet. Each revision sits alongside the last, both sides see which version is current, and your team approves it once it is right. When the commercial invoice arrives, you check it against that approved version.
Every order across your suppliers sits in one list, with its status (draft, in progress, approved, or closed), its total, and when it last changed. neet holds the current version and its full approval history, so the PI version column in your tracker can simply point to the order in neet. Production updates, inspections, and ship dates still come from your factory and your inspector, so keep those in your tracker.
Purchase order tracking FAQ
How do you track purchase orders?
Give each order one row in a tracker and record its stage, current pro forma invoice version, deposit, balance, and ship date. For overseas orders, ask the factory for an update every week and record any change the same day.
How do you keep track of purchase orders in Excel?
Create one row per purchase order with columns for PO number, supplier, PI version, deposit, production stage, inspection, balance, original and confirmed ship dates, and next action. Use dropdowns for the status columns and sort by confirmed ship date so the most urgent orders stay at the top.
How do suppliers acknowledge and track purchase orders?
Most overseas factories acknowledge a purchase order by sending a pro forma invoice, or an order acknowledgement, that restates the order and the deposit due. They track production on their own internal schedule, so ask them each week for the current stage, the ship date, and photos.
What is production tracking?
Production tracking means following an order’s progress inside the factory, from materials to packing, before anything ships. For importers, it is the stage where most delays begin, so it deserves a weekly check-in.
Read next
Purchase orders
Purchase order vs invoice: what importers need to know
A purchase order is the buyer’s order, sent before the goods are made; an invoice is the seller’s bill for those goods.
· 12 min read