Wedlake Consulting
Menu
Book a free intro →

Wedlake Consulting · Remote or in Manchester

← Notes

Before automating copy-and-paste, ask why you enter it twice.

When an order moves from email to spreadsheet to business system, which steps still earn their place? How to remove duplicate work before connecting the systems.

Published
Reading
4 min
Topic
Automation

If your team copies the same order details into several places, automating the copying sounds like an obvious improvement. Before choosing a tool, I would ask what each copy is for.

A spreadsheet might help sales track progress while the order sits in your business system. It might hold a delivery promise that has nowhere else to go. Or it might exist because nobody has checked whether the business system can now show the same information.

Those situations need different fixes. I would start by following an order through the people doing the work, then decide which records you actually need to keep.

Follow the information, including the awkward bits

Choose a recent order and ask the people who handled it to walk you through what happened. Start with the customer’s request and follow it through to the point where the team considers the job complete. Use the actual records, with access limited to the people who need to see them.

For each place where somebody types or pastes information, write down what they copy, where it comes from and what happens next. Include the email sent to a colleague and the spreadsheet updated after the main system has been saved.

Then ask why. Who reads this record? What decision do they make from it? What would they lose if it disappeared?

Avoid treating a repeated field as proof of a pointless step. Someone entering an agreed delivery date might also be checking capacity. Copying an address might be the moment they notice that the customer has requested a different delivery site. I would separate the transfer of information from the judgement happening alongside it.

Repeat the walkthrough with an order that changed after acceptance. That helps expose the work hidden by a straightforward example: who updates the delivery date, who tells the customer and which copies need correcting.

Ask whether the extra record still needs to exist

Take the spreadsheet or secondary record to the person who uses it. Ask them to show you the fields they rely on and the action they take from each.

If it is a list of open orders, ask your system supplier whether the existing software can provide that view with the fields, filters and access the team needs. Request a demonstration using your requirements. A general promise of reporting does not establish that it can replace this particular sheet.

If the spreadsheet contains information missing from the main system, investigate why. Perhaps there is an appropriate field nobody uses, or a configuration change would help. Perhaps it serves a separate planning purpose that the order system cannot meet. Keep that question open until the people doing the work can assess the proposed replacement.

I would consider the choices in this order: remove an unnecessary record, use more of the existing software, then connect systems that have a reason to remain separate. This is what I would want to establish before choosing a route.

Remove the extra recordUse existing softwareConnect the systems
When I'd consider itNobody needs a separate recordThe required view or field can live in the current systemBoth systems serve a distinct purpose
What to establishWho relies on it and what replaces that useWhether the team can do the job with the available featuresWhich system supplies each field and how changes move
What to checkNo decision or useful check has been lostStaff can complete the real taskThe records stay correct when an order changes
My assessment of the choices to investigate after mapping duplicate entry. These are decision criteria, not measured results or promises about a particular product. Source: Wedlake Consulting's mapping and building approach.

Agree where changes belong

If separate systems are needed, decide which holds the agreed value for each piece of information. You do not necessarily need the same answer for every field. The order system might hold the accepted quantity while a planning tool holds the proposed production slot.

Write down who may change those values and how a proposed change becomes an agreed one. If a customer requests a new delivery address, establish where the request is checked, where the accepted address is recorded and which other records need updating.

This is the point at which I would write a brief for an integration: information moving from a named source to a named destination, at a defined stage of the process. Include the checks that must happen before it moves. An instruction to keep everything in sync leaves too much undecided.

Keep any necessary approval visible. If staff currently check a price before entering the order, faster transfer should still leave the business with a clear way to accept that price.

Test the job with the people who do it

Before retiring the old method, ask the team to try the proposed process on representative records in a suitable test environment. Include an ordinary order, an amendment and a cancellation. Check the finished records and what each person needs to see to do their part.

Ask someone who normally uses the spreadsheet to complete their task without it. Can they find the orders needing attention? Can they see the latest agreed date? Do they still need to make a private copy to get through the day? Use the answers to adjust the process before removing anything.

Once the replacement works, agree when the extra record will stop being updated and how its history will be retained. Tell everyone where to make future changes. Leaving both routes active indefinitely would leave the team deciding which version to trust.

Pick a repeated entry your team can show you and start with that walkthrough. The useful question is what information the next person needs, and how it can reach them with the necessary checks intact. That gives you a much clearer job to automate.

Written by

Owain Wedlake, technology and AI consultant in Manchester. Questions or a different view? Reply by email.

Next step

Start with a conversation.

A free intro session. Bring one process that eats your team's time, and leave with a straight answer on what's worth changing.

Free · No obligation · Remote or in Manchester