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.

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.

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
| Before | With Patisco | |
|---|---|---|
| Finding all of one customer's orders | Dig through Excel, inboxes, ask colleagues | [Filters] on the PI list by buyer company and date |
| A new hire wants to know who this customer is | Wait for a veteran to have time for the backstory | Read it yourself under Partners and [By company] |
| Working out each customer's share | Three days, then check it again | Filtered in a morning, add it up yourself |
| What's easiest to miss | The few orders that aren't on your own computer | All 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"
