Skip to content
fileshape

Create a Google Merchant Center feed from Shopify products

Export your Shopify products as CSV, drop the file below, choose Google Merchant Center and replace YOUR-STORE.com in the link column with your domain. Fileshape writes the feed attributes Google requires (id, title, description, link, image_link, availability, price) with descriptions stripped of HTML and prices formatted with a currency code.

01

Your file

Stays on your device. Nothing is uploaded.

Drop a file here

CSV, Excel, ODS, JSON, XML, YAML, HTML or Markdown tables. It stays on this device.

No file handy? Try a sample:

Step by step

Export, convert, import

1 · Export from Shopify products

  1. 01In Shopify admin, go to Products → Export, choose all products and the plain CSV format.

2 · Import into Google Merchant Center feed

  1. 01In Merchant Center, add products from a file and upload the converted file. It downloads as tab-separated text (.tsv), Google's text feed format.
  2. 02Check the diagnostics page after processing. Missing GTINs and image issues are the most common warnings.

When you need this (and when you don't)

If you use Shopify's Google sales channel app, products sync to Merchant Center automatically and you don't need a file feed. A file is the better option when you want full control over titles and descriptions, need a supplemental feed, manage several stores in one Merchant Center account, or are building a feed for another tool that reads Google's format, such as many price comparison sites.

How the attributes are built

id is the SKU, so it stays stable when you rename a product. title is truncated to Google's 150-character limit. description comes from Shopify's HTML description with tags removed. link is built from a template, https://YOUR-STORE.com/products/{URL handle}, and you must replace YOUR-STORE.com with your own domain in the mapping step before downloading. Otherwise every product will be disapproved for an invalid landing page.

availability is in_stock when the inventory quantity is above zero and out_of_stock otherwise. price and sale_price follow Google's format: a number with a period as the decimal point, then an ISO 4217 currency code, like 1499.00 INR. The recipe uses INR. Change “ INR” in the two price formulas if your store sells in another currency. When a compare-at price exists, price is the original and sale_price is what customers pay. item_group_id is the URL handle, which groups variants of the same product.

Identifiers and brand

Google uses gtin (barcode), brand and mpn to match your products to its catalogue. Shopify's Barcodes column becomes gtin and Vendor becomes brand. For handmade or private-label products without barcodes, leave gtin empty and set identifier_exists to no in Merchant Center rather than inventing numbers, which leads to disapprovals.

Column mapping

How each Google Merchant Center feed column is filled

These are the exact rules the converter applies to your Shopify products file. You can change any of them in step 3 before downloading.

Google Merchant Center feed columnValue
idCopied from SKU
titleCopied from Title; cut to 150 characters
descriptionCopied from Description; HTML tags removed, extra spaces removed
link“https://YOUR-STORE.com/products/” + URL handle
image_linkCopied from Product image URL
availabilityIf Inventory quantity is greater than 0, then “in_stock”, otherwise “out_of_stock”
priceIf Compare-at price is greater than Price, then Compare-at price, otherwise Price followed by “ INR”
sale_priceIf Compare-at price is greater than Price, then Price followed by “ INR”, otherwise empty
brandCopied from Vendor
gtinCopied from Barcodes
mpnCopied from SKU
conditionAlways “new”
product_typeCopied from Type
item_group_idCopied from URL handle
shipping_weightCopied from Weight value (grams)

FAQ

Questions

Which file format should I upload to Merchant Center?

Use tab-separated text (TSV), which this guide selects for you in step 4. Product descriptions are full of commas and quotes, and tabs avoid any quoting problems.

Can I make a Meta (Facebook/Instagram) catalog the same way?

Yes. Pick Meta catalog as the output layout; it uses the same idea with Meta's availability wording (in stock / out of stock).

Is my product data uploaded?

No, the conversion runs locally in your browser.

Related

Updated 2026-11-20