SoftwarePublished

Connecting your own tools without a developer

Most shops have data trapped in separate systems. What an API actually gives you, what can be connected without code, and when to stop.

  • 12 min read
  • 1,000 words
Connecting your own tools without a developer — software tech at a print shop
Software12 min readA1printsoft EditorialPhoto: prashant hiremath / Unsplash
On this page7 sections

The short answer

  • Most shop inefficiency is retyping the same data between systems
  • An API lets one system read and write another's data automatically
  • Automation tools connect common systems without any code
  • Start with the connection that removes the most retyping
  • Every integration is something that can break — keep it few and simple

A typical decorating shop runs an ordering system, an accounts package, an email account and a spreadsheet or two. The same customer name, order and price gets typed into several of them, and every retype is time and an opportunity for error.

Connecting systems removes that, and a good deal of it can be done without hiring anybody.

The problem

Where the same data goes

  • Order taken in one system
  • Retyped into accounts for invoicing
  • Copied into a production spreadsheet
  • Customer added to a mailing list separately
  • Supplier order typed into their portal
  • Status emailed manually to the customer

Each step takes a couple of minutes and happens on every order. Across a week that is a substantial part of somebody's time spent moving information that a computer could move.

If a person is copying data from one screen to another, that is a job for software, not a job for a person.

What an API is

An API is a defined way for one piece of software to read and write another's data — a documented door, rather than a person copying and pasting.

What it enables

  • An order created in one system appearing in another
  • Invoices raised automatically from completed jobs
  • Stock levels read from a supplier
  • Status updates sent without anybody writing them
  • Customers added to a mailing list on their first order
  • Reports pulling from several sources at once

You do not need to understand how one works to benefit from it. What matters when choosing software is whether it has one, since a system without an API is a system whose data will always be moved by hand — a point worth raising among the questions a demo will not answer.

Without writing code

ApproachNeeds
Built-in integrationNothing — switch it on
Automation platformConfiguration, no code
Import and export filesA routine, manual but simple
Custom integrationA developer

Always check for a built-in integration first. Accounts packages, email tools and ordering systems commonly connect to each other directly, and switching that on is a configuration task rather than a project.

Automation platforms fill the gap for everything else. They connect common systems through a visual interface — when this happens in system A, do that in system B — and a shop owner can build one in an afternoon.

Worth connecting

In order of return

  • Orders to accounts — removes invoice retyping
  • Supplier stock into your product data
  • Order status to customer notifications
  • New customers into your mailing list
  • Store orders into production
  • Job data into whatever you report from

Orders to accounts is almost always the first one worth doing, because invoicing is high-volume, repetitive and error-prone. It is also the connection most systems support natively.

Supplier stock is the second, since it removes a permanent maintenance job and prevents selling what cannot be delivered — the case in keeping catalogue data current.

What to check first

Before starting

  • Does each system actually have an API, and is it included?
  • Is there an existing integration between them?
  • What does the automation platform cost at your volume?
  • What happens when the connection fails — silently, or visibly?
  • Who fixes it when it breaks?
  • Are you sending customer data somewhere it should not go?

The failure question is the important one. An integration that stops working without telling anybody is worse than no integration, because people assume it is running and nobody checks — so understand how you will find out.

Data protection deserves a genuine thought. Customer details flowing through a third-party automation platform is a processing arrangement, and it belongs in the same consideration as the rest of your security basics.

Keeping it reliable

Practical rules

  • Build one connection at a time and let it settle
  • Test with real data before trusting it
  • Set up failure alerts that reach a person
  • Write down what each connection does and why
  • Review them when either system is updated
  • Know how to do the task manually if it stops

Documentation matters more than it sounds, because integrations are invisible. A connection built two years ago by somebody who has left, doing something nobody can quite describe, is a liability rather than an asset.

Keep the manual fallback alive in somebody's head. Integrations do break, usually when a system updates, and a shop that cannot invoice manually for two days has a real problem.

When not to

Do not integrate

  • A task that happens rarely — do it by hand
  • A process you are about to change anyway
  • Systems you are considering replacing
  • Anything where the fix would be to use one system instead of two
  • Where the connection would take longer to maintain than the task

That fourth point is the most important. Integration is frequently a way of preserving a fragmented setup that should be consolidated, and connecting four tools that half-overlap is more work than moving to one that does the job — the argument in moving off spreadsheets.

Count the time honestly before building anything. A connection that saves two minutes on a task performed twice a week is not worth maintaining, and the enthusiasm for automation frequently outruns the arithmetic.

Where quoting, orders, production, stores and stock already live in one system, most of the connections above become unnecessary, because the data was never in separate places to begin with. Integration is the right answer for the systems you genuinely need to keep separate — accounts being the usual one — and the wrong answer for a collection of tools that were never meant to be a system. The rest of the software archive assumes nobody is retyping an order twice.

Filed underSoftware
Share
Written byA1printsoft Editorial
175 articles

The print production desk at A1Printsoft. Writes the practical side of running a decorating shop: what things cost, how long they take and what to charge, checked against published trade figures.

Keep reading

More on software

All Software articles

Set up in an afternoon. From what you already do.

Free for 14 days · no card · pick what you make and we preload the methods, products and price tables.