---
title: "How to Export WooCommerce Products for Google Merchant Center"
url: "https://wpimportexport.com/export-woocommerce-products-google-merchant-center/"
description: "Build a Google Merchant Center product file from WooCommerce: Google column names, 49.00 USD prices, in_stock values and one row per variation."
type: post
published: 2026-11-08T19:21:35+00:00
modified: 2026-11-14T10:41:49+00:00
categories: ["Export Guides", "Tutorials", "WooCommerce"]
tags: ["Import Export by RockStarLab", "WooCommerce", "WordPress export"]
docs_topics: ["Export guides", "WooCommerce"]
---

# How to Export WooCommerce Products for Google Merchant Center

Google Merchant Center needs a product file before your products can appear in Google Shopping and free listings. The file has to use Google’s column names (`id`, `title`, `price`, `availability` and so on) and Google’s value formats. A price must look like `49.00 USD`, and stock must say `in_stock` rather than WooCommerce’s `instock`. Variable products have to be split into one row per variation.

[Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) builds that file. You don’t need a separate feed plugin. You choose the products, rename the columns to Google’s attribute names, fix the value formats with transformations and export a tab-separated file that Merchant Center accepts. Exporting WooCommerce products and transformations need the PRO add-on, which you can [get for free](https://wpimportexport.com/get-pro-for-free/).

## What goes into the file

These are the columns used in this guide and where each one comes from in WooCommerce:

| Google attribute | WooCommerce field | Notes |
| --- | --- | --- |
| id | SKU | Must be unique and stay the same over time. |
| title | Product name | Variations get names like “Hoodie – Red”. |
| description | Description | HTML tags removed. |
| link | Permalink | Variation links pre-select the color or size. |
| image_link / additional_image_link | Featured image URL / gallery | A variation uses its own image when it has one. |
| price / sale_price | Regular price / sale price | Formatted as `49.00 USD`. |
| availability | Stock status | `in_stock`, `out_of_stock` or `backorder`. |
| item_group_id | Parent SKU | Groups variations of one product. |
| brand, condition, identifier_exists | Fixed values | The same value on every row. |

Use `identifier_exists = no` only for products without a GTIN (barcode), such as your own merchandise or handmade goods. If your products have GTINs, add them as a `gtin` column from the custom field where you store them.

## Step 1: Create two transformations

Transformations are small functions that change a value during export. The library has 48 ready-made ones. For Google you need two of your own. Go to **Import Export → Functions → New Function** and create:

**Price for Google** turns `49` into `49.00 USD`, using your store currency. An empty price stays empty, so products that aren’t on sale get an empty `sale_price`.

```
$value = trim( (string) $value );
if ( '' === $value ) {
	return '';
}
return number_format( (float) $value, 2, '.', '' ) . ' ' . get_woocommerce_currency();
```

**Availability for Google** converts WooCommerce stock statuses to Google’s values:

```
$map = [
	'instock'     => 'in_stock',
	'outofstock'  => 'out_of_stock',
	'onbackorder' => 'backorder',
];
return $map[ $value ] ?? 'out_of_stock';
```

If you’ve connected an AI key, you can also describe the function in the AI Generator box instead of pasting code. Either way, check the result with **Test** before you save.

## Step 2: Choose the products

Go to **Import Export → Export**, choose **WooCommerce Products** and click **Next Step**. Add two filters:

- **Status** equals `publish`, so drafts and private products stay out of Google.
- **Product Type** not equals `grouped`. A grouped product has no price of its own; the products inside it are exported as their own rows anyway.

![Export Step 2 Filter Data for WooCommerce Products: Status equals publish, Product Type not equals grouped, total items available 16](https://wpimportexport.com/wp-content/uploads/2026/11/01-filter-published-products.webp)

_Only published products, without grouped products._

The counter shows 16 products for this store.

## Step 3: Add the columns and give them Google’s names

Add these fields to **Export File Structure**: SKU, Product Name, Description, Permalink, Featured Image URL, Gallery Images, Regular Price, Sale Price, Stock Status and Parent SKU.

Click the pencil icon on each column and enter the name Google expects: `id` for SKU, `title` for Product Name, `link` for Permalink, and so on (see the table above). The small gray label under each name shows which WooCommerce field fills it.

Then click **Add Custom** three times for the columns that are the same for every product. Enter the column name first, then the value: `brand` = your brand, `condition` = `new`, `identifier_exists` = `no`.

![Export File Structure with 13 columns renamed to Google attributes: id (sku), title, description, link (permalink), image_link, additional_image_link, price, sale_price, availability with transformations, item_group_id (parent_sku), brand, condition, identifier_exists custom columns](https://wpimportexport.com/wp-content/uploads/2026/11/02-columns-renamed-to-google-attributes.webp)

_Columns renamed to Google's attribute names._

Now assign the transformations with the gear icon on the column:

- **description**: Strip HTML Tags (from the library)
- **price** and **sale_price**: Price for Google
- **availability**: Availability for Google

![Field Transformations window for Regular Price: Price for Google applied, test value 49 gives 49.00 USD](https://wpimportexport.com/wp-content/uploads/2026/11/03-price-for-google-transformation.webp)

_The Price for Google transformation turns 49 into 49.00 USD._

Type a value into **Test Value** and click **Test Pipeline** to see the result before you export: `49` becomes `49.00 USD`.

## Step 4: Export a tab-separated file with one row per variation

On **Export Format**, choose **CSV** and set **Delimiter** to **Tab**. Merchant Center accepts tab-separated .txt and .tsv files, and a tab-delimited export is saved as `.tsv`. Keep **First row contains column names** on.

Under **Variations**, check **One row per variation**. Each variable product is replaced by its enabled variations. Each variation row gets its own SKU, price, stock status, image and link, and `item_group_id` holds the parent’s SKU. Disabled variations are left out.

![Export Format: CSV with Tab delimiter, header row on, file name google-merchant-products, Variations: One row per variation checked](https://wpimportexport.com/wp-content/uploads/2026/11/04-tab-delimited-one-row-per-variation.webp)

_Tab-separated file with one row per variation._

Enter a file name and click **Start Export**, then **Download Export File**.

![Export Completed Successfully: Items Exported 16, File Size 13.4 KB, Download Export File button](https://wpimportexport.com/wp-content/uploads/2026/11/05-export-complete.webp)

_Export finished; the file downloads as google-merchant-products.tsv._

The counter shows 16 products. The file has 21 rows because the two variable products became seven variation rows.

![google-merchant-products.tsv rows: woo-logo-mug 14.00 USD in_stock, Beanie with Logo 20.00 USD sale 18.00 USD, V-Neck T-Shirt Red Green Blue with item_group_id woo-vneck-tee and links with attribute_pa_color, Hoodie Red 45.00 USD sale 42.00 USD, brand Example Store, condition new, identifier_exists no](https://wpimportexport.com/wp-content/uploads/2026/11/06-google-merchant-tsv-file-scaled.webp)

_The exported file: Google values, and variations grouped by item_group_id._

The V-Neck T-Shirt is now three items, each with its own color in the link, and the red hoodie keeps its sale price. Every row has a price with the currency and a Google availability value.

## Step 5: Upload the file to Merchant Center

In Merchant Center, go to **Settings → Data sources** and click **Add product source**. Choose **Add products from a file**, then **Upload a file from your computer**, and select the .tsv file. Google processes it and lists any problems under **Products**.

A file uploaded from your computer doesn’t update by itself. When prices or stock change, run the same export again and upload the new file to the same data source. Because `id` is the SKU, the same products are updated rather than added twice.

Google may also ask for more attributes depending on your products and country, for example `gtin`, `google_product_category`, or `color` and `size` for clothing. Add them the same way: a field or custom field from your products, a renamed column, and a transformation if the format needs changing. Check Google’s [product data specification](https://support.google.com/merchants/answer/7052112) for what your category needs.

## Common problems

- **“Invalid price”**: the **price** column has no transformation, so it contains `49` instead of `49.00 USD`. Assign Price for Google to both price columns.
- **“Invalid value [availability]”**: `instock` wasn’t converted. Assign Availability for Google to the stock status column.
- **Variable products have no price**: **One row per variation** was off. A variable product doesn’t have a price of its own, only its variations do.
- **Duplicate or missing id**: some products or variations have no SKU. Add SKUs in WooCommerce, or [fill them in bulk](https://wpimportexport.com/how-to-bulk-update-woocommerce-products/).
- **Drafts in the feed**: add the Status = publish filter from Step 2.

The same file works for other catalogs too. For a general product export to CSV or Excel, see [exporting WooCommerce products](https://wpimportexport.com/how-to-export-woocommerce-products-to-csv-excel-or-xml/). For more about transformations, see [how transformation functions work](https://wpimportexport.com/what-are-transformation-functions-and-how-to-use-them-during-import-or-export/).

## With an AI agent

With PRO, an AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) can build the whole feed. It creates the two transformations with `rsl-ie-pro/function-create` and runs the export with `rsl-ie-pro/export-start`, using `column_headers` for Google’s names, `custom_values` for brand, condition and identifier_exists, `field_functions` for the transformations and `variation_rows` for one row per variation. A prompt:

```
Create a Google Merchant Center product file: published products except
grouped ones, one row per variation, Google column names, prices like
49.00 USD, Google availability values, brand "Example Store", condition
new, identifier_exists no, tab-separated. Create the transformations you
need and tell me how many rows the file has.
```

In our run on the same store, the agent created “Price for Google” and “Availability for Google”, added the library function Strip HTML Tags to the description, and started the export with the Tab delimiter. The job processed 16 products and the file google-merchant-feed.tsv had 21 rows under the header `id, title, description, link, image_link, additional_image_link, price, sale_price, availability, item_group_id, brand, condition, identifier_exists`. Every row had its price as, for example, “14.00 USD” and an availability like in_stock.

## FAQ

### Which file format does Merchant Center accept?

Tab-separated text (.tsv or .txt) and XML. Choose CSV with the Tab delimiter; the file is saved as .tsv.

### How do variable products appear in the file?

With One row per variation, each enabled variation is its own row with its SKU, price, stock, image and link, and item_group_id holds the parent SKU.

### Do I need the PRO add-on?

Yes. Exporting WooCommerce products and using transformations are part of the PRO add-on.

### How do I keep the products up to date in Merchant Center?

Run the same export again after prices or stock change and upload the new file to the same data source. Products are matched by id, so they are updated, not added again.

### My products have GTINs. How do I add them?

Add the custom field that stores the GTIN as a column and rename it to gtin. Remove the identifier_exists column for those products.

## Related Guides

- [How to Export WooCommerce Products to CSV, Excel, or XML](https://wpimportexport.com/how-to-export-woocommerce-products-to-csv-excel-or-xml/)
- [What Are Transformation Functions and How to Use Them During Import or Export](https://wpimportexport.com/what-are-transformation-functions-and-how-to-use-them-during-import-or-export/)
- [WebToffee Product Import Export Alternative for WooCommerce](https://wpimportexport.com/webtoffee-product-import-export-alternative/)
- [How to Import WooCommerce Product Reviews from CSV](https://wpimportexport.com/import-woocommerce-product-reviews-csv/)
