Data operations

Supplier feeds and product data

Feeds that change shape, prices that mean the wrong unit, catalogues that drift from the supplier's file.

• One-off outcome

  Stop supplier CSV rows splitting at commas, quotes and line breaks

  A named supplier CSV with commas, quotes and line breaks in descriptions imports at the right column count on every row. Bad rows are listed by line, and a file with an unclosed quote is rejected.

  £195 · untested offer price

• One-off outcome

  Make a supplier CSV import keep accented and special characters intact

  A named supplier CSV with accents, symbols and a leading byte-order mark imports with every agreed test value unchanged and its first column recognised; before and after results attached.

  £195 · untested offer price

• One-off outcome

  Turn your ERP stock and price export into the exact file your store importer accepts

  A tested script converts one named ERP export layout into the exact import file your store needs, rejecting rows it cannot convert with reasons, so nobody re-formats it by hand.

  From £595 · untested offer price

• One-off outcome

  Check every supplier image link before products go live in your store

  Each product in a named supplier feed gets an image result: working, redirected, missing, not an image, too small or unreachable. Products with bad images are held or flagged, not lost.

  £345 · untested offer price

• Composed outcome

  Rebuild one supplier feed pipeline with checks at every step

  Replace one fragile supplier-to-store import with a tested pipeline: fetch, check, compare with the last file, then hold or release, with category and image stages if your feed needs them.

  From £4,500 · untested offer price

• One-off outcome

  Get a change report comparing two supplier feed versions before you import

  For two named versions of one supplier feed you get a repeatable report of every added, removed and changed product, with price and stock moves over your thresholds and counts that reconcile.

  £225 · untested offer price

• Recurring responsibility

  Keep your supplier feed imports correct, month after month

  We watch the supplier feeds you name. When a new file fails checks or changes shape we investigate and propose a fix, or tell you exactly what only your supplier can change.

  £395/month · untested offer price

• One-off outcome

  Map a supplier's category names onto your store categories, with no silent defaults

  Every category value in a named supplier feed maps to exactly one of your store categories, or lands in a visible unmapped list. Nothing falls silently into a default category.

  From £395 · untested offer price

• Composed outcome

  Clear the warned and disapproved products in one Merchant Center data source

  We work through the flagged products in one Merchant Center data source by cause (file errors, price and stock mismatches, images) and return each group fixed or explained, with diagnostics.

  From £1,900 · untested offer price

• One-off outcome

  Get your product file fetched and processed by Merchant Center without errors

  Merchant Center fetches your named product file on schedule and processes it, with file-level errors in the data source report cleared or explained and the item count matching your file.

  £245 · untested offer price

• Recurring responsibility

  Keep your Merchant Center product data fetched, approved and in step with your site

  We watch the Merchant Center data source you name. When a fetch, price, availability or image problem appears, we propose a small fix (up to two a month), or say what only you can change.

  £295/month · untested offer price

• One-off outcome

  Fix Merchant Center price and stock mismatches between your feed and your product pages

  For an agreed set of products the feed's price and availability match the page, checkout and markup, and processed diagnostics show no mismatch. Google's approval is not guaranteed.

  £345 · untested offer price

• One-off outcome

  Make a scheduled supplier file fetch import only complete, new files

  A scheduled job fetches the latest supplier file over SFTP, skips files still being uploaded, never imports the same file twice, and fails loudly on a changed host key, tested on a synthetic server.

  From £445 · untested offer price

• One-off outcome

  Read every item in a supplier XML feed, and reject a broken file cleanly

  A named supplier XML sample imports every well-formed item, with namespaces, CDATA and escapes read correctly; a broken copy is rejected with its line and column and changes nothing.

  £295 · untested offer price

Accounting and payment data

Invoices, payouts and spreadsheets that must agree with the accounting system. Software integrity work, not accountancy or tax advice.

• One-off outcome

  Import an expense export as draft Xero bills with the right account and receipt attached

  A synthetic expense export becomes one draft Xero bill per expense with the agreed account, supplier and receipt attached, a re-import creates nothing new, and a missing receipt is flagged.

  From £395 · untested offer price

• One-off outcome

  Make foreign-currency orders create invoices in the right currency, with the right rate

  Synthetic orders in the base currency, a two-decimal currency and a zero-decimal currency create invoices with the order currency and amount, and no default or inverted rate is stored.

  From £395 · untested offer price

• One-off outcome

  Stop a retried automation from creating a second invoice in Xero or QuickBooks Online

  Replaying, retrying or double-running one named invoice automation leaves exactly one invoice per source order in a test accounting file, and an unknown outcome is held for a person.

  From £395 · untested offer price

• One-off outcome

  Replace hard-coded account codes in a finance sync with a checked mapping table

  Up to 25 source categories map to active ledger accounts through one reviewed table, and an unmapped or archived account is held with its name instead of posting to a default.

  £345 · untested offer price

• Recurring responsibility

  Keep a finance sync healthy: failed runs, lapsing connections and duplicates reviewed

  We check the named finance sync at an agreed interval, investigate each failed run, lapsing connection or duplicate, and write up the fix for your developer or what only you can change.

  £195/month · untested offer price

• Composed outcome

  Restore a broken invoice sync, proven on a synthetic trading month

  We agree the failures of one invoice sync, fix them in a safe order and prove on a test file that a synthetic trading month creates every invoice once, in the agreed account, matching its source.

  From £2,950 · untested offer price

• One-off outcome

  Make every Stripe payout match one bank deposit line in Xero or QuickBooks Online

  Each automatic Stripe payout in an agreed test period becomes one ledger entry equal to the bank deposit, with its gross, fees and refunds explained and a clearing balance that returns to zero.

  From £495 · untested offer price

• One-off outcome

  Make PayPal refunds and fees appear in the ledger once each, linked to their sale

  In a sandbox month with sales, a full refund and partial refunds, every PayPal refund and fee reaches the ledger exactly once, linked to its sale, and ledger net equals PayPal net.

  From £445 · untested offer price

• One-off outcome

  Stop QuickBooks Online invoice updates from failing with a Stale Object Error

  Two quick edits to one synthetic QuickBooks Online invoice from a sync and a person both land as agreed, and a stale update is re-read once and then held, not looped or lost.

  From £395 · untested offer price

• Recurring responsibility

  Detect reconciliation drift between your payment processor and ledger every month

  Each month we compare your processor's payouts, refunds and fees with the ledger entries for them and send a drift list in which every difference is explained or marked open.

  £295/month · untested offer price

• Composed outcome

  Fix your payment-to-ledger links and prove them on a test-month reconciliation

  We fix the links between payments, refunds, payouts and ledger entries for the flows you name, and prove them in a test-month reconciliation report built from stated rules over test data.

  From £3,950 · untested offer price

• One-off outcome

  Make a scheduled finance export to Google Sheets complete, current and honest on failure

  One scheduled export to one Google Sheet shows every source row, a data-as-of time and a matching count; a failed run, including a silently short read, leaves the last good report with a warning.

  £245 · untested offer price

• One-off outcome

  Make a customer sync reuse the right Xero contact instead of creating near-duplicates

  Replaying a synthetic customer list through one named sync creates each customer once in a Xero demo organisation, and a changed email or name updates the same contact.

  From £345 · untested offer price

• One-off outcome

  Make a bulk Xero invoice run finish every order, or list exactly which ones it held

  A synthetic run of 150 orders against a simulated limit of 60 calls a minute, with a simulated 429 and an interruption, ends with every order created, already present or held, and counts that add up.

  From £445 · untested offer price

• One-off outcome

  Send every mapped Google Sheets invoice field to Xero

  One disposable row with the agreed columns makes one draft Xero invoice containing every agreed line item and amount.

  £145 · untested offer price

Guides for this work

• Troubleshooting guide

  A nightly SFTP fetch imports half a file, repeats a file or stops after the supplier's server changes

  How to tell a finished supplier file from one still uploading, stop the same file being imported twice, and treat a changed server host key as a stop sign rather than an error to switch off.

• Troubleshooting guide

  Merchant Center rejects product images: file type, size, URL rules, robots access and overlays

  What Google's image_link attribute requires and why images are disapproved: the extension must match the real format, the size minimum, URL and robots rules, stable addresses and disallowed content.

• Troubleshooting guide

  Merchant Center says your price does not match the page: compare feed, page, checkout and markup

  What Google compares when it flags an inaccurate price, the causes in order of likelihood, tax and format rules that cause mismatches, and how fixing and review work after you correct the data.

• Troubleshooting guide

  A comma in a product description pushes the price into the wrong column: read quoted fields properly

  Why only some supplier CSV rows shift, how quotes, doubled quotes and line breaks inside fields should be read, why semicolon files break a comma reader, and how to prove the row count.

• Troubleshooting guide

  A PayPal report export leaves gaps: 31-day windows, a three-hour delay and a per-request record cap

  Plan non-overlapping report windows with a lag, page through every result, deduplicate, and treat a too-large error as a signal to shrink the window, so an export or replay neither misses nor repeats PayPal transactions.

• Troubleshooting guide

  A scheduled Google Sheets export stops at the same row or shows old numbers: check limits and state

  Understand Apps Script run-time and daily trigger limits, trigger ownership, Sheets API quotas and locks, and design a staging swap and status block so failures are visible.

• Troubleshooting guide

  A scheduled supplier fetch runs at the wrong time, twice or not at all: time zones, clock changes and cron surprises

  Why a cron-style schedule can fire an hour off, skip or repeat around clock changes, run on the wrong days, or break on a percent sign, and how to make the job safe whichever happens.

• Troubleshooting guide

  A supplier XML feed stops with a parse error: find the first error before blaming your importer

  What well-formed XML requires, why a conforming parser stops instead of skipping a bad item, the usual first errors in a feed, and how to separate a supplier fault from an importer fault.

• Troubleshooting guide

  Comparing two supplier feed versions: match products by key, not by line, and make the counts add up

  Why a text comparison of two supplier files buries real changes, how a key-based comparison reports added, absent and changed products, and the arithmetic that proves nothing was missed.

• Troubleshooting guide

  Converting an ERP export for a store import: decimal commas, day-first dates, codes and rejects

  Why hand-editing an ERP export produces different files on different days, and how explicit number, date and code rules, exact decimal arithmetic and a reject file make the conversion repeatable.

• Troubleshooting guide

  Expenses import as bills but the receipts are missing or on the wrong bill

  Link expense, bill and receipt through one expense id, attach files after the bill exists within Xero's limits, and make a re-import safe, with draft-only creation.

• Troubleshooting guide

  Merchant Center flags availability: pre-orders, sold-out lines, variants and a feed that refreshes too slowly

  The availability values and situations that Merchant Center flags, why a daily fetch cannot follow fast stock changes, and which fixes belong in the feed, the page or the refresh route.

Showing 12 of 42 that touch this work. See all guides on the site.

Examples you can inspect

• Inspectable example

  Synthetic mapping table: eight categories and what a sync should do with each

  An invented category-to-account table shows mapped, unmapped, archived, renamed and reused-code cases, with the disposition a checked mapping should give each line.

• Inspectable example

  Synthetic Stripe payout: five charges, two refunds, one deposit and a clearing balance that returns to zero

  A worked, invented payout shows how gross charges, fees and refunds add up to the single bank deposit and what ledger entries make the bank line match.

• Inspectable example

  Synthetic CSV encoding fixture: a byte-order mark, accents and the wrong reading side by side

  An invented four-line CSV with a leading byte-order mark and accented, currency and trademark characters, with the bytes, the wrong readings and the expected values an importer test should assert.

• Inspectable example

  Synthetic CSV quoting matrix: commas, doubled quotes, line breaks, semicolons and an unclosed quote

  An invented supplier CSV read two ways, by splitting at commas and with a real CSV reader, with the record and line counts, a semicolon file read with the wrong delimiter and an unclosed quote.

• Inspectable example

  Synthetic feed comparison: eight products, planted changes, formatting noise and a counts check

  Two invented supplier file versions with a reordered file, formatting-only differences and six real differences (three changed, two added, one absent), and the key-based report and reconciliation an acceptance test should expect.

• Inspectable example

  Synthetic foreign-currency check: the same 100.00 USD order with Xero-style and QuickBooks-style rates

  Invented arithmetic shows how a copied, inverted or default rate changes the base total, and how treating minor units as whole units shrinks a yen amount a hundredfold.

• Inspectable example

  Synthetic image-link fixture: eight cases an image check must classify, and what each does to a product

  An invented fixture of eight image-address outcomes with the status, declared type, recorded class and the action under a hold-for-review rule, plus four destinations the check must refuse, as an acceptance matrix for an import image check.

• Inspectable example

  Synthetic invoice reconciliation: identical net lines, two different tax totals

  Three invented small-value lines show how line-level and invoice-level tax rounding can disagree even when net values and line counts match.

Showing 8 of 15 that touch this work. See all examples on the site.

Free tools

• Free tool

  CSV header diff: find missing, added, renamed and duplicate columns between two files

  Paste two CSV header rows, or read the header of two small files in your browser, and see missing, added and likely renamed columns, duplicate and empty headers and the delimiter. Nothing is uploaded.

• Free tool

  Invoice rounding bench: compare per-line and total rounding, half-up and half-even

  Enter invoice lines and see net, tax and gross under four rounding rules side by side, in exact whole-number minor units, with the difference between summing lines and rounding the total. Not tax or accounting advice.

• Free tool

  Pack and case unit-price calculator: compare supplier prices per single unit

  Enter supplier price lines priced per unit, pack or case. Get the exact price per single unit, the working, and the lines whose pack basis is unclear. No floating point.

• Free tool

  Workflow time-value calculator: show the assumptions behind automation payback

  Use your own time, volume, cost and running-cost inputs to calculate simple monthly value and payback; not a quote or guaranteed saving.