Find the outcome you need.
Start with a symptom, a platform or the thing you want working.
With JavaScript, search filters the whole collection in your browser. Without it, use the linked pages and section navigation below; query filters need JavaScript.
Showing entries 41–80 of 109 in this first collection.
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 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
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
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
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
Supplier categories end up in Uncategorised: use a mapping table with an unmapped list, not loose matching
How to map a supplier's category names to your store categories with one reviewed row per value, an explicit unmapped state, exact matching and a report of new or changed values.
Troubleshooting guide
Supplier image links that load a page, redirect in circles or time out: classify them before import
How to tell a working image address from a missing file, a redirect, an error page returned as success, a wrong file type or a slow host, and how to check them without stalling the import.
Troubleshooting guide
Merchant Center cannot process your product file? Check the format, header row and XML layout
The file-level rules that make Merchant Center reject or misread a product file, from accepted formats, header row, tabs and line breaks, encoding, XML namespace and tag case, extensions and compression.
Troubleshooting guide
Merchant Center scheduled fetch fails or shows an old file? Check the address, access and what comes back
Why a scheduled fetch of your product file fails or stays stale: an address that leads to a page, redirects, blocks or permissions, login handling, compression, size and the difference between a fetch and an SFTP upload.
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
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.
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.
Platform
CSV supplier files: find the first failing layer before changing the importer
For distributors and merchants who import product, stock and price data from CSV: a map of the layers a file passes through, where each fault shows up and which guide or job fits.
Platform
XML product feeds: well-formed first, then namespaces, then meaning
For distributors and merchants who receive or send product data as XML: why a broken file stops everything, where namespaces and escaping cause quiet loss, and which guide or job fits.
Platform
Google Merchant Center product data: fix the file, then the items, then the images
For merchants whose Shopping products are warned or disapproved: the order in which to diagnose file, price, availability and image problems, and where a data fix ends and Google's review begins.
Buyer collection
For an operations manager: make supplier files arrive complete, readable and only once
A page for the person who owns how supplier files are fetched, decoded and imported: what to document, how to describe a failure and which small fixed job or standing check fits.
Buyer collection
For a merchant with flagged Shopping products: find the cause group before you edit the feed
A page for the person who owns the Merchant Center data source: what to collect, how to sort flagged products by cause and which fixed job, project or monthly watch fits.
Collection
Supplier file import goes wrong: work through delivery, bytes, structure and release in order
An ordered process map for a supplier file that imports wrongly: confirm the file arrived whole, then decode it, then read its rows and fields, then check its layout, meaning, mapping and images, then compare before release.
Collection
Merchant Center products flagged: work through account, file, price, stock, images and review in order
An ordered process map for flagged Shopping products: separate account-level issues from item issues, then fix file fetch and format, price and availability, images and identifiers, then plan the refresh route and review.
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 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 monthly drift list: one duplicate, one missing refund and one timing item
An invented month shows how matching by identifier turns two differing totals into three itemised, explained or open differences with a named next step.
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.
Troubleshooting guide
Xero and QuickBooks request keys help a retry, but not for as long as you might think
Compare what Xero's Idempotency-Key and QuickBooks Online's request id protect, for how long, and why a stored order identity and a lookup remain the lasting control.
Troubleshooting guide
Duplicate Xero contacts: choose the identity your sync matches on before cleaning anything
Separate Xero's ContactID, ContactNumber, name and account number, and design a match order that survives a changed email, a same-name pair and an archived contact.
Troubleshooting guide
QuickBooks "Stale Object Error": the version token your update used is out of date
Understand SyncToken, why a sync keeps an old one, and how read-before-write, sparse updates and a written conflict rule remove intermittent update failures.
Troubleshooting guide
A bulk Xero job loses orders when it meets a rate limit: pace it and keep a checkpoint
Read Xero's limits, understand why a 429 or a batch response can silently drop orders, and design pacing, per-item checks and a checkpoint so every order ends created or held.
Troubleshooting guide
One Stripe deposit, many sales: why the bank line matches nothing in the ledger
Explain how an automatic Stripe payout bundles charges, fees and refunds into one net deposit and how a clearing account and a payout-level entry make the bank line match.
Troubleshooting guide
PayPal sales reach the ledger but refunds and fees do not: reconcile three separate records
Treat a PayPal sale, its refunds and its fees as linked but separate records, read amounts from PayPal rather than recomputing them, and hold a refund until its sale exists.
Troubleshooting guide
PayPal webhooks can repeat and arrive late: make the ledger update safe to repeat
Use PayPal's delivery contract to design an event inbox with a unique event id, raw-body verification, held dependent events and a report-based safety net.
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
Which ledger account does this line post to? Replace hard-coded codes with a checked mapping table
Design a category-to-account table keyed by account identifier, validated against the live chart before each run, with no default account and a held list for gaps.
Troubleshooting guide
The same exchange rate means opposite things in Xero and QuickBooks Online: check direction and units
Compare how Xero and QuickBooks Online express rates, why a copied rate inverts the base total, why a default of one is wrong, and how currency minor units cause factor-of-100 errors.
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
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
Reading Xero invoices: paging, itemCount and If-Modified-Since so a report is complete
Use Xero's paging defaults, pagination object and If-Modified-Since header to read every invoice, advance an incremental watermark safely and prove completeness.
Troubleshooting guide
A Xero sync that quietly stopped: refresh tokens, quiet spells and parallel refreshes
Understand Xero's token lifetimes, why an infrequent or parallel integration loses its connection, and what the connection owner must do, so a stopped sync is noticed at the next check.
Troubleshooting guide
Reconciliation drift: six kinds of difference between a payment processor and a ledger
Classify differences as missing, extra, amount, duplicate, timing or currency, match by identifiers rather than totals, and decide what is escalated before a monthly list is trusted.
Platform
Xero integrations: identity, limits, accounts and currency decide whether a sync can be trusted
What Xero documents for integration builders (contacts, invoice numbers, idempotency, paging, limits, accounts, lock dates, demo company) and which failures map to which guide or outcome.