Moments in Trade #23|Dana's email was four lines long

Moments in Trade #23|Dana's email was four lines long
This series uses Dingli, a Patisco demo account. Every system screen and all the data shown here came from real operations in the system, including the exchanges between buyers and suppliers; they are not mock-ups. The people and dialogue are dramatized, and the illustrations are for illustration only. Screens are shown in the system's Chinese interface; Patisco is also available in English and other languages.

In the story: the third month after the trade show, Monday, 8:30 a.m.

Four lines

A-Zhe hadn't even opened his lunchbox when the email arrived.

It was from Dana at Northwind. Four lines:

Dear A-Zhe, From next year, we will consolidate our chain and cassette supply with another vendor. Thank you for the years of partnership. It has been a pleasure. Best, Dana

A-Zhe read it three times. Back at the trade show, she'd written that they "might consolidate to two suppliers." Now the answer was in: not Dingli.

He hit reply, typed "Could we have a call this week?", then deleted it.

Chairman Lin came out of his office holding his tea and glanced at the screen.

"No need to reply."

"Chairman, at least let me ask whether it's the price or—"

"She hasn't done anything wrong, and neither have we." Chairman Lin set his tea down. "I just want one number. With Northwind gone, how much does each remaining customer account for? And how long since each of them last ordered?"

A-Mei's desk was empty. She was on maternity leave. Her notebook was still sitting there, and the cover said "Don't touch. I'll need this when I'm back."

"Who's Dana?"

Xiao-Yu, just over a month into the job, leaned over from the next desk.

"Who's Dana?"

A-Zhe paused. Right: by the time Xiao-Yu started, Northwind hadn't ordered in quite a while.

It used to be that answering that meant digging through inboxes, digging through the shared folder, and asking A-Mei. Now A-Zhe opened Northwind under [Partners], and every quotation and PI Dingli had issued them, plus their own purchase orders, was on one page.

Northwind's buyer detail page, with all of this company's documents on one page
Every quotation and PI issued to one customer, plus their purchase orders, on a single page.

Then he switched to [By company] in Discussion and picked Northwind. Years of exchanges with Dana lined up thread by thread: the first inquiry, the first round of haggling, the year a shipment came late and she wrote a very polite email about it.

"She seems really nice," Xiao-Yu said when he'd finished.

"Yeah," said A-Zhe. "That's why I read it three times."

How it used to go

When Chairman Lin wanted a number like that, it used to land on Hsiu-Chin.

She'd open every customer's Excel file one by one, copy out this year's invoice amounts, add them up, and work out the percentages. Some orders were on A-Zhe's computer, some in A-Mei's folders, and some only in emails. Three days later she'd hand over a sheet. Chairman Lin would glance at it and ask: "Does this include that order from last month?"

And Hsiu-Chin would have to check it all again.

How it goes in Patisco

A-Zhe opened the PI list and clicked [Filters].

He picked one company under [Buyer Company], set [Created Date] from January of this year to today, and the list narrowed to that company's PIs, each with its amount and creation date right there.

Filters on the PI list: one Buyer Company and a custom Created Date range, leaving only that company's PIs with amounts and dates
Filter one company at a time and the amounts and dates are all there; the totals are still yours to add up.

One company done, on to the next. A dozen or so customers, all filtered in one morning.

Patisco didn't build him a share-of-sales report. Adding up the numbers and working out the percentages was still Hsiu-Chin on her calculator. The difference was that she no longer had to ask "did this one get counted?" The PIs were all in one place, so whatever the filter showed was everything.

At noon, Hsiu-Chin put a handwritten table on Chairman Lin's desk.

She'd circled the Northwind column in red.

Before vs. With Patisco

BeforeWith Patisco
Finding all of one customer's ordersDig through Excel, inboxes, ask colleagues[Filters] on the PI list by buyer company and date
A new hire wants to know who this customer isWait for a veteran to have time for the backstoryRead it yourself under Partners and [By company]
Working out each customer's shareThree days, then check it againFiltered in a morning, add it up yourself
What's easiest to missThe few orders that aren't on your own computerAll the orders are in one place
A word for the boss: When a customer wants to leave, you usually can't stop them. But on the day they go, you should be able to work out in one morning how much you still have.

The real-world backdrop: Chairman Lin said it back in season one: your customer once beat their own rivals with your help, and sooner or later someone will come along to take your place. Big customers not renewing is something that was always going to happen. Further reading (in Chinese): "Why Be Surprised When a Big Customer Doesn't Renew? It Was Always Going to Happen"

Further reading

Next episodeMoments in Trade #24|Don't go after number oneChairman Lin looked at that table for a long time. His tea went cold, untouched.Finally he said, "This time, let's not go looking for another big one."A-Zhe asked, "Then who?"Read the next episode →
Share:
Facing this problem yourself?
Book 20 minutes and walk through it with your own data. Nothing to prepare.
See it on real screens →