"Where is the goods?" This is the most frequently asked question by customers to every exporter. In the past, many factories would answer, "I'll check for you," and then wait several hours. A Chinese LVL factory used the simplest tool-a shared spreadsheet-to allow customers to see the status of their goods at any time: produced, loaded into container, cleared through customs, loaded onto ship, arrived at port. With increased transparency in logistics, customer follow-up calls decreased, and trust increased.
1. "Where is the goods?"-A question that causes anxiety for everyone
"Where is the goods?" a customer messages.
The salesperson turns to the documentation clerk: "Where is our goods?"
The documentation clerk opens a pile of documents, checks the shipping company's website, the terminal information, and the customs clearance progress. After a while, they reply: "Maybe...it's already on board?"
The word "maybe" leaves both the salesperson and the customer uncertain.
"Previously, when we answered customers' questions about the shipment status, we often relied on intuition," said a foreign trade manager. "This was because the information was scattered across different places: shipping companies on website A, ports on website B, and customs brokers on system C. Integrating all of this took time and specialized personnel."
2. From "Dispersed" to "Centralized": The Birth of a Shared Spreadsheet
To solve this problem, the factory made a simple decision: to create an "order tracking spreadsheet"-an online, shared spreadsheet that records the complete logistics status of each order.
The table's columns are simple:
- Order Number
- Customer Name
- Product Specifications
- Production Status (Not Started/In Progress/Completed)
- Container Loading Date (Loaded/Not Loaded)
- Customs Declaration Status (Declared/In Progress)
- Vessel Name & Voyage Number
- Estimated Arrival Date
- Actual Arrival Date
"Our table is very simple, just an Excel spreadsheet," said a sales manager. "We update it daily, and if a customer asks, we can find all the information within 5 minutes."
3. Increased Trust Through "Visibility"
After this simple table went live, the customer experience improved significantly:
- Customers can check themselves: Some customers have been granted viewing privileges and can log in to check their order status without having to ask every time.
- More accurate responses: When a customer asks, "Where is the goods?", the salesperson can accurately answer, "They've been loaded into the container. The ship departs tomorrow, and they are expected to arrive in 20 days."
- Reduced anxiety: Customers know that "someone is tracking the order," and even if there are delays, they will be notified promptly without repeated inquiries.
"Once, our shipping schedule was delayed, and we notified the customer three days in advance," said a sales manager. "The customer said, 'Thank you for informing me in advance; I can adjust my construction plan.' If we had waited until the customer asked, the effect would have been completely different."
4. From "Tracking Sheets" to "Proactive Notifications"
With accurate order status information, this factory did one more thing: proactively notify customers.
- Production Completed: "Your goods have been produced and are being packed. Expected container loading date is [Date]."
- Container Loading Completed: "Your goods have been loaded into the container. Vessel name: [Vehicle Name], Voyage number: [Vehicle Number], expected arrival date: [Date]."
- Arrival Notification: "Your goods have arrived at the port. Please arrange customs clearance and pickup."
"Every time customers receive our proactive notifications, they reply with a 'Received, thank you,'" said a sales manager. "Although it's just a few words, you can feel the customer's satisfaction. They don't need to bother following up; the information is automatically delivered to their door."
5. "Transparency" is also a form of competitiveness.
The head of this factory made a thought-provoking statement:
"What customers really want isn't the 'goods' themselves, but the certainty that the goods will arrive on time. If we can proactively tell customers 'when it will arrive' and 'where it is now,' they don't have to worry about it."
He added, "Our logistics tracking isn't high-tech; it's just a form, a document, and a sense of responsibility. But customers feel 'your management is effective,' and their trust in us has significantly increased."
"Where is the goods?" is a question every exporter is asked. When LVL factories in China are willing to use the simplest tools to make the logistics status "visible," they deliver not only products, but also "certainty" and "peace of mind." This practice of "making information transparent" is one of the most basic and effective ways to build customer trust.
