pdconsults.

How can Shopify businesses connect fragmented business data?

Fragmentation is usually a history of sensible decisions. Accounting went into one system, stock into another, customer conversations into an inbox, and quoting into a spreadsheet. Each was right at the time. What was never decided is which system holds the authoritative version of a customer, a product or a job.

( The Detail )

The constraint underneath

Without that decision, connecting data means settling dozens of small disputes: two spellings of a supplier, three codes for one product, a customer who exists twice. The technical join is the straightforward part. The real work is agreeing on identifiers and on who is allowed to change them.

How this plays out here

An online store generates a large volume of structured records and has a small team to look after them. Problems present as data problems first: a wrong variant, an out-of-date price on a feed, stock that sold twice, a description that no longer matches what is in the box.

Because so much is measurable, the risk is measuring the convenient things. Sessions and conversion rate are visible by default, while landed cost, return rate by product and repeat purchase behaviour have to be assembled, and are therefore reviewed far less often than they should be.

How to approach it

Begin with the decision rather than the tool. Name the recurring judgement this affects, the information it depends on, and the person accountable for acting on the result. That framing keeps the first build small enough to inspect and useful enough to matter.

Keep a human review point in the loop until the quality and the failure modes are understood. A system that shows its working - what it drew on, where it is uncertain, and what it deliberately left alone - is one a business can keep running after the initial build.

( Next Step )

Start small enough to review, but on a workflow important enough to show whether a better system is worth building.