Customers / P&WC AllianceCS 04

Scattered sales data, made usable. How P&WC Alliance brought its spreadsheets and CRM into one place

P&WC Alliance supplies specialty chemicals, catalysts and packaging to industrial customers from Tashkent. Its sales data was spread across spreadsheets and a CRM, and PromptLab pulled it into one place the team can actually use.

A conversation with

CEO, P&WC Alliance

Two colleagues walking through a warehouse aisle.

Challenge

One industrial customer can buy chemicals, catalysts and containers from the group. With information spread across spreadsheets and a CRM, building the full picture of an account meant opening both. The data existed, but it was hard to work with.

Solution

Use PromptLab to bring the spreadsheet and CRM data into one place, in a form the team can search, filter and act on. Each customer starts from a single record.

Results

  • Spreadsheet and CRM data pulled into one place
  • Account data the team can actually use
  • A single starting point for each customer

P&WC Alliance’s story

P&WC Specialties was one of the first companies to produce high-quality chemicals in Uzbekistan and Central Asia, and today it describes itself as a leading manufacturer and supplier of specialty chemical solutions. It serves water treatment, oil and gas, chemical processing, power generation, primary metals and mining, and points to more than 20 years of industry experience and compliance with ASTM and GOST standards.

Alongside it, P&WC Ucatco makes high-performance industrial catalysts and P&WC InfinityPlast makes IBC containers. Together, the three companies form P&WC Alliance, which offers industrial customers chemicals, catalysts and packaging from a single source, run from its headquarters in Tashkent.

The Alliance presents that integrated structure as its advantage: supply-chain efficiency, reliable quality and flexible operations for customers. Its mission is summed up as “Unlocking Efficiency, Maximizing Performance”, backed by customer-focused technical support and process optimization consulting.

Behind that offer sits a demanding customer base. Water treatment plants, refineries, power stations and mines run around the clock, and the chemicals, catalysts and containers they buy have to arrive on time and to specification.

Three companies, one customer

The group’s breadth is its selling point, and it also makes data harder to keep together. A plant might buy water treatment chemicals from one company, catalysts from another and containers from the third. Each relationship has its own contacts, its own history and its own open questions.

To serve that customer well, the team needs to see the whole account: what it buys, who it talks to and what is in progress across the group. Without that, an opportunity in one part of the business can be missed by another, and the customer gets less of the single-source service the Alliance is built to offer.

The questions are rarely complicated. Who is our contact at this plant? What did we quote them last? Do they also buy from our sister company? Each one should take seconds to answer, and each one depends on the data being in one place.

Two systems, half a picture

Information was split between spreadsheets and a CRM. Some customer details had been kept in files for years, others had been entered into the CRM, and neither held everything. A simple question about one customer meant checking both and reconciling what they said.

Spreadsheets are easy to start and hard to share. Versions multiply, columns drift, and the person who built a file is often the only one who fully understands it. The CRM, meanwhile, held records that did not always match what the spreadsheets said.

The result was data the company owned but could not easily use. It was there when someone had time to dig for it, but it did not help the team answer questions quickly or see an account at a glance.

That gap had a cost that was easy to miss. Each time someone rebuilt a customer’s picture by hand, the time it took was time not spent with the customer, and the picture they built was gone the next time someone needed it.

The PromptLab moment

The Alliance needed more than a new place to put its data. It needed the data to become usable: searchable, organised around the customer and ready to work with. PromptLab can import spreadsheets and sync with other CRMs, and it is built for industrial suppliers, with quotes, samples, price lists and sales orders alongside accounts.

PromptLab pulled the spreadsheet and CRM data into one place, and the data became something the team works from rather than files it keeps. The point was not to move data for its own sake. It was to give every person in the Alliance the same starting point for every customer, so that time goes into the relationship instead of into finding the facts.

“We had everything spread across spreadsheets and our CRM. This pulled it into one place and made it actually usable.”

CEO, P&WC Alliance

How P&WC Alliance uses PromptLab

The Alliance uses PromptLab as the home for its customer data and the starting point for work on each account. Three changes stand out.

None of the three is complicated on its own. Together, they turn customer data from something the team has to look for into something it works with every day.

One home for the data

Information that used to sit in spreadsheets and in the CRM now lives in PromptLab. Spreadsheet files can be imported directly, and PromptLab can sync accounts, contacts and deals with other CRMs, so the data arrives without being retyped.

Once it is there, it stays in one place. Updates happen on the record rather than in a copy of a file, so the next person to open it sees the current version.

Bringing the data together also meant cleaning it once instead of repeatedly. Duplicates and gaps that appeared when two sources disagreed could be resolved in one place, and the result stays resolved.

Data the team can work with

With records in one place, the team can search, filter and act on them instead of hunting through files. Saved views keep the lists people use most, with the filters, columns and sort order they need, one click away.

Reports read from the same data. The team can count accounts by industry, follow deals by stage or review sales orders over time, and save those reports to a shared dashboard. Questions that once meant building a spreadsheet now have an answer on screen.

The same records can be used by AI as well as by people. PromptLab’s assistant answers questions from the data in the CRM, so a question about an account can be asked in plain words and answered from the records themselves.

The difference is the starting point. Instead of opening several files and rebuilding a customer’s picture, the team opens PromptLab and starts from the record.

Each customer on one record

A customer’s information sits together, so a question about an account starts from a single record. Contacts, conversations, deals, quotes and orders are linked to the account they belong to.

For a group of three companies, that matters. Whoever is working with a customer can see the whole relationship, not only their own part of it, and the Alliance can offer chemicals, catalysts and packaging to a customer it understands as one account.

Tasks and notes sit on the record too. When someone agrees a next step with a customer, it is recorded where the next person will look, not in a personal file that leaves with them.

A shared base for the whole Alliance

With its data in one place, the Alliance has a base it can build on. Each new customer and each new conversation adds to records the whole team can see, instead of to another file on someone’s computer. The single-source promise the Alliance makes to its customers now has a counterpart inside the business: one source of customer data, organised around the account, that the team can actually use.

From that base, the Alliance can take on more of its sales process in PromptLab, with quotes, samples, price lists and sales orders already part of the system. Each step it adds builds on the same customer records rather than starting another file.