Digitizing a Trading Company: Move the Business Out of Employees' Heads

Daily life at many trading companies still runs on this loop: a customer asks over LINE or email, "Is this one still in stock? What's the price?" — the salesperson digs through Excel to quote, calls the warehouse to check stock, and once the customer orders, writes up the order by hand. By day's end, a senior salesperson has spent half their time answering questions a system could answer in ten seconds. More dangerous still, the whole process lives inside people: product knowledge in the veteran salesperson's head, customer relationships in his LINE, pricing logic in his personal Excel. While he's there, the company runs. When he leaves, it breaks.

The Three Stages of Trading-Company Digitization

Stage 1: Digitize the Catalog — Build the Product Database

The foundation of everything is consolidating product data from scattered Excel files and paper catalogs into one structured database: SKU, specifications, images, packaging units, minimum order quantities, and tiered pricing. Trading has always priced per customer and per volume, so the price structure must express "tier-A distributors see tier-A prices; hit this quantity and it jumps to wholesale" — the most fundamental difference between B2B and B2C e-commerce. Once the database exists, the digital catalog, quotations, and ordering system are all different outlets of the same data — change it once, and it's correct everywhere.

Stage 2: A Customer Ordering Portal — Turn Inquiry Replies Into Self-Service

Give each customer a login, and what they see is a world of their own: their prices, their order history, current stock status, ordering and shipment tracking. For the customer, that means ordering at midnight without waiting for a salesperson's reply. For you, it means sales staff are freed from being human price-lookup machines to do what genuinely needs a human — developing new customers, negotiating annual contracts. "Buy again" on order history is the highest-frequency feature of any B2B portal; customers with routine restocking needs will stick to you because of that one button.

Stage 3: Transparent Inventory — Let the Numbers Tell the Truth

Whether you dare show customers your inventory is the maturity watershed of trading-company digitization. Transparency requires accuracy, and accuracy is a process problem, not a character problem: purchasing, sales, returns, and stocktakes must each leave records in the system for the numbers to reconcile (we unpacked this in inventory system design). For goods in transit, showing "expected arrival week" is smarter than showing zero stock — it turns "out of stock" into "available for pre-order." We operate an inventory SaaS ourselves that supports physical retail channels, watching real stock movements every day, and our deepest lesson is this: what a system can never catch is the exception that happens outside the process — so design the exceptions (loans, samples, giveaways) into the workflow instead of leaving them to human memory.

A trading company's biggest risk isn't a lack of orders — it's that the way the company operates exists only in employees' heads. The essence of digitization is moving the business from "people's memory" into "company assets."

Common Mistakes

1. Jumping straight to public e-commerce: B2B pricing is highly sensitive; put tiered prices on a public website and your distributor network will revolt first. Build a login-gated customer portal; the public side carries only the catalog and an inquiry form.
2. Rushing product data into the system before cleaning it: importing duplicate SKUs and muddled units (nobody can even say how many pieces per carton) just digitizes the garbage. Data cleaning is the least glamorous, most critical work in the project.
3. Ignoring peaceful coexistence with Excel: customers and internal staff will still want Excel, so batch import/export must be designed as a first-class feature — see import and export features.
4. Leaving salespeople out of the design process: the system is for salespeople and customers. An ordering flow built behind closed doors means sales will quietly route orders back through LINE, and the system becomes decoration.

Budget and Timeline Expectations

The three stages needn't — and shouldn't — be built all at once. The product database plus digital catalog is on the order of one to two months; the customer ordering portal with tiered pricing adds another one to two; inventory integration depends on the state of your existing inventory system. A sensible validation rhythm: once stage two launches, invite your ten or so most active customers to trial it — adoption among repeat-purchase customers is this project's report card. To figure out which stage your own processes should start from, see how we work at our system development services.