StriveFormats
CSV Fixer

Google Merchant Center

Google Merchant Center Feed Checker

Merchant Center disapproves products for small things: a price without a currency code, "In Stock" instead of in_stock, a barcode a spreadsheet rounded off. Check your product file here before you upload it, and fix most of it in one click.

Check your file, free →Download a sample CSV

Runs in your browser · No sign-up · 3 free exports a month

checks
20checks
import blockers caught
11import blockers caught
automatic fixes in the example below
3automatic fixes in the example below

What it does to a messy file

A small Google Merchant Center file with typical mistakes, and the fixer's actual output for it. Green cells were fixed automatically; red and amber cells need a decision.

Before
idtitledescriptionlinkimage_linkavailabilitypricebrandgtincondition
MUG-01Acme Ceramic Coffee MugHand-thrown stoneware mug.https://example.com/p/mughttps://example.com/i/mug.jpgIn Stock18,00 EURAcme4006381333931New
TOTE-01Acme Canvas ToteNatural cotton tote bag.https://example.com/p/totetote.jpgpreorder$24Acme4006-3813-3393-2new
After
idtitledescriptionlinkimage_linkavailabilitypricebrandgtincondition
MUG-01Acme Ceramic Coffee MugHand-thrown stoneware mug.https://example.com/p/mughttps://example.com/i/mug.jpgin_stock18.00 EURAcme4006381333931new
TOTE-01Acme Canvas ToteNatural cotton tote bag.https://example.com/p/totetote.jpgpreorder$24Acme4006-3813-3393-2new

Fixed automatically (3)

  • Normalized availability to 'in_stock' on row 1
  • Normalized price to '18.00 EUR' on row 1
  • Normalized condition to 'new' on row 1

Left for you (4)

Three things Google Merchant Center files get wrong

  1. Prices need a currency code

    Google wants 19.99 USD, not $19.99 or 19,99. Symbols that name one currency, like € and £, are converted; a bare $ is flagged, because US, Canadian and Australian dollars all use it.

  2. Google's own words only

    availability must be in_stock, out_of_stock, preorder or backorder, and condition new, used or refurbished. Common spellings like "In Stock" or "pre-order" are rewritten automatically.

  3. Barcodes are checked digit by digit

    Every GTIN's check digit is recalculated. Spaces and dashes are removed, a leading zero the spreadsheet dropped is restored when the check digit proves it, and numbers in scientific notation are flagged.

How to use it

  1. 1Export the product feed from your store or feed app, or start from the template. In Merchant Center, add the fixed file under Products → Add products from a file.
  2. 2Open the fixer and drop in the file. Safe fixes are applied straight away.
  3. 3Work through what's left in the table; every issue says which row and column it's on.
  4. 4Export the fixed file and download the fix log if you want a record of every change.

Import blockers it catches

See all 20 checks →

Questions

Which file format does it download?

A tab-delimited .txt file with your original column names, which is what Merchant Center expects for uploaded feeds. You can upload a .txt, .tsv or .csv file.

Does it check apparel attributes?

It checks the values of gender and age_group and converts common spellings. It doesn't yet require color and size, so check those yourself for clothing.

Does it visit my product pages or images?

No. Everything runs in your browser and nothing is uploaded. Links and images are checked for being full https:// addresses, but Google still crawls them, so make sure they load.

Guides

All Google Merchant Center guides →