Shopify Products CSV to Google Shopping Feed

How to turn a Shopify export into a Google Shopping feed

A Shopify Google Shopping feed needs things the product CSV doesn't have: Google's attribute names, a currency on each price, a link per product and a stock status. This tool reads the export as described in Shopify's product CSV guide, builds a Merchant Center feed and checks it against Google's product data specification.

1. Export from Shopify. From the Products page in Shopify admin, export all products as a CSV file. Old exports with headers like Handle and Variant Price work too.
2. Load it here. Drop the file in, or press Try sample data to convert a small demo store.
3. Enter your domain and currency. Both are missing from the export. Then pick a condition and decide what to do with products that have no identifiers.
4. Read the report. You see how many products went in, which were left out (drafts, archived, unpublished) and every Google problem, grouped by type.
5. Download the feed. The .tsv file is ready for Merchant Center; the "feed items to fix" list tells you what to correct in Shopify.

How Shopify columns become Google attributes

• SKU → id; without a SKU the id is built from the handle and option values.
• URL handle → item_group_id for products with variants, and the product link.
• Title + option values → title, e.g. "Organic Cotton Tee - M / Navy".
• Price and Compare-at price → price and sale_price.
• Inventory → availability: in stock if quantity is above 0, stock isn't tracked, or selling continues when out of stock.
• Vendor, Type, Weight value (grams) → brand, product_type, shipping_weight.
• Google Shopping / … columns → product category, gender, age group, MPN, condition and custom labels.

What to do next

1. Fix the listed problems in Shopify. Wrong barcodes, missing SKUs and empty prices belong in Shopify, so the next export is clean.
2. Upload the feed. In Merchant Center: Settings > Data sources > Add product source > Add products from a file. Google recommends one primary data source for all products, so don't also upload products the Google & YouTube app already syncs.
3. Set shipping. The feed has no shipping column, so add rates under Products & store > Shipping and returns.
4. Check variant pages. All variants link to the product page because the export has no variant IDs. Google compares price and availability with the page, so make sure each variant's details are visible there.

Common Shopify to Merchant Center problems

Shopify product CSV barcode column isn't a GTIN

Stores often keep their own codes in Barcodes. Google only wants real GTINs, so codes like INTERNAL-123 are dropped. A barcode that lost its first zero in Excel is restored when the check digit proves it.

Shopify variants item_group_id and duplicate IDs

Two variants with the same SKU become two products with one id, which Google refuses. Give every variant its own SKU in Shopify.

Apparel without color or size

Google requires age group, gender and color for clothing and accessories in Brazil, France, Germany, Japan, the UK and the US, plus size for clothing and shoes. Fill the Google Shopping columns in Shopify, or name your options Size and Color in English.

Google Merchant Center not syncing with Shopify

When products don't arrive through the app, Shopify's channel requirements are often the reason: a GTIN must be added if the product has one, products without one need brand and MPN, and option values must be in English. The problem list here shows the same gaps product by product.

Prices without a currency

The export stores 19.99 with no currency. If your Merchant Center country uses another currency than the one you picked, prices won't match the site.