ImportFixed

Free forever · No account · Your file never leaves your device

Google Merchant Center Feed Fixer

Google Shopping shows the products whose feeds follow its rules, and quietly limits or disapproves the rest — usually for reasons written in policy sentences. Drop your feed in: every product is checked against Google’s product data rules, the mechanical faults are repaired, and the rest is explained in plain words, product by product.

Drop your Merchant Center feed here

A tab-delimited .txt, a .csv spreadsheet, or an XML feed — the file you are about to upload to Google, or the one Google complained about.

Your file is read by your own browser, on this computer. Your file never leaves your device.

What it checks, in plain words

The basics Google demands

Every product needs an id, a title, a description, a link, a photo link, an availability and a price. Missing ones are named, product by product — a whole missing column is called out at the top.

Prices in Google’s shape

Google wants a plain number, a space, and the currency code: 19.99 USD. Prices written as $1,299.00 or 19,99 are rewritten into that shape; a sale price that is not lower than the real price is flagged.

Availability and condition

Google accepts only the exact words “in stock”, “out of stock”, “preorder” and “backorder” — and new, used or refurbished for condition. “In Stock” and “in_stock” are corrected to the exact words.

Barcodes that check out

A GTIN (the number under the barcode) carries a check digit, and the fixer verifies it. A wrong digit is named, never guessed at. Products with no brand, no GTIN and no part number are marked identifier_exists = no, with the reason stated.

Clothing extras

Clothing needs color, size, gender and age group. When a product looks like clothing and some of those are missing, the missing ones are named.

Links and photos

Addresses missing their https:// beginning get it; addresses with spaces are repaired. A photo living on a different domain than the product page earns a warning — Google cares about domains more than sellers expect.

About file shapes — stated plainly

Tab-delimited (.txt, .tsv) and comma-delimited (.csv) feeds are fully checked and fully fixed. The fixed file downloads as a tab-delimited .txt, because that is the format Merchant Center uploads directly.

XML feeds (RSS or Atom with Google’s g: attributes) are checked and reported in exactly the same way — and their fixed file also comes back as a tab-delimited .txt with the same products and the same fixes in it. We do not pretend to rebuild your XML; the .txt carries everything Google needs.

New to the refusals themselves? The plain-words guide to Merchant Center errors →

Questions

What files can I drop in?

A Google Merchant Center product feed in any of its usual shapes: a tab-delimited .txt or .tsv (the format Merchant Center uploads), a comma-delimited .csv spreadsheet, or an XML feed (RSS or Atom carrying Google’s g: attributes). Delimited feeds are checked, fixed and handed back as a tab-delimited .txt. XML feeds are checked and reported in full, and their fixed file also comes back as a tab-delimited .txt — we state that plainly rather than pretend to rebuild your XML.

Will Google accept the fixed file?

The fixed file follows Google’s published product data rules, and anything we could not fix for you is listed before you download, so nothing is left to surprise you at upload time. One thing no file tool can check: Google also compares your feed against your store’s pages, so the prices and availability there must match the feed.

My GTIN was flagged as wrong. Can’t you just fix the digit?

No — and be careful with any tool that offers to. A GTIN’s last digit is a check on all the others; when it fails, one digit was typed wrong somewhere, and guessing which one could attach your product to somebody else’s. Copy the number from the barcode again — that is the whole fix.

Where does my feed go?

Nowhere. Like every tool on this site, the fixer runs inside your web browser, on your computer. Your file never leaves your device, so we could not look at your products even if we wanted to.