How to bulk-assign Google product categories in WooCommerce

Where the category lives in WooCommerce

WooCommerce core has no notion of a Google product category. It arrives with whatever feed extension you use — most often Google for WooCommerce (formerly Google Listings & Ads), which adds a Google for WooCommerce tab to the product editing screen with the category field on it, and stores the value as product meta.

That matters for bulk work: the value is meta on the product, not a WooCommerce product category term. So the tools that bulk-edit taxonomy terms will not touch it, and the tools that bulk-edit meta will.

Bulk term editors cannot see it because it was never a category term in the first place.

The attribute mapping tool, and why it may not help

Google for WooCommerce has an attribute mapping feature — Marketing → Google for WooCommerce → Attributes → Create attribute rule — which maps a WooCommerce attribute or a fixed value onto a Google feed attribute, optionally scoped to specific product categories. It is the right shape for this job.

The catch: merchants have reported on the plugin’s support forum that Google Product Category does not appear in the target attribute dropdown, while it is available on individual product screens. A support representative reproduced the behaviour and escalated it. That is a report, not documented behaviour, and it may have been addressed — so check the dropdown before assuming, and if the target is there, use it. If it is not, the CSV route below is what WooCommerce support recommends in its place.

One thing worth knowing either way: a value set on an individual product overrides a global attribute rule. Rules fill gaps; they do not overwrite deliberate choices.

The CSV round-trip

This is the reliable route, and it is the one WooCommerce support points to: export, fill the column, import back.

1. Export. Products → All Products → Export. Include the meta columns; the file you get back is the one that tells you the exact meta key the category is stored under, which varies by extension.
2. Find the column. Open the export and look for a Meta: column holding the Google category for a product you have already set by hand. Setting one product manually first, before exporting, is the quickest way to identify the column with certainty.
3. Fill it in. Put the numeric category ID in that column for every product. Google accepts the ID or the full path and recommends the ID.
4. Import. Products → All Products → Import, tick Update existing products, and map the column back to the same meta key.

Import only the columns you are changing — id or sku plus the category column. A CSV importer that receives a blank cell for a field it recognises will generally write that blank, and a wide re-import is how people accidentally clear descriptions and prices.

Filling in five thousand rows

The export gives you a file with product titles and an empty category column, which is exactly the input our Bulk Category Mapper takes. Upload it, point it at the title column and the id or SKU column, and you get the same file back with the category, its ID, the full path and a confidence figure appended — plus a separate file of the rows it was not confident about, with the runner-up categories attached.

Paste the ID column into your export, import it back, and the manual work is reading the short uncertain list rather than the whole catalog. Identical products in several variations are charged once, so a catalog of one shirt in twenty sizes is one decision.

The first rows of your own file run free, with the same engine, so you can see whether it works on your data before paying for any of it.

While you are in there

WooCommerce stores product reviews as WordPress comments, and core has no export for them — the built-in Product CSV Importer and Exporter handles products only, and WooCommerce’s own reviews import/export documentation points at a paid extension. If that is your next job, the WooCommerce review page lays out the options, including the free copy-and-paste route.

Verify before you trust it

After the import, open two or three products and check the Google tab shows the category you expect. Then check Merchant Center once the feed has resynced — you can watch the pending re-sync task under WooCommerce → Status → Action Scheduler if nothing appears to be happening.

Remember that google_product_category is optional and Google assigns a category automatically, so “no error” does not mean “value accepted”. Look at the product, not the absence of a warning.