How to Export WooCommerce Products to Google Merchant Center

If you're looking to expand your online WooCommerce shop and venture into the world of Google, then you'll need to start exporting your WooCommerce products to the Google Merchant Center. WP All Export helps you do so by simplifying the process, using their drag-and-drop function. This plugin is packed with features. Let's see how you can export your product feed and schedule it to keep your Google Merchant Center up to date.
Share on facebook
Share on twitter
Share on email
Share on facebook
Share on twitter
Share on email

If you’re looking to expand your online WooCommerce shop and venture into the world of Google, then you’ll need to start exporting your WooCommerce products to the Google Merchant Center.

WP All Export helps you do so by simplifying the process, using their drag-and-drop function. This plugin is packed with features! Let’s see how you can export your product feed and schedule it to keep your Google Merchant Center up to date.

Creating a new WooCommerce export to Google Merchant Center

Creating a new export is easy if you follow these step-by-step instructions. First, head on over to All Export in the sidebar, click on New Export and select whether you want to export a specific post type or WP_Query Results. Since we are exporting WooCommerce Products in this example, make sure to select it from the drop-down menu.

The plugin will let you know how many products will be exported. Unless you want to add any filtering, continue on to the next step.

Step 1

Scroll down to the Export Type section, select “Feed” and “Google Merchant Center Product Feed” from the drop-down menu.

Export type

Basic product information

As we’ve seen in our previous articles on WP All Import, the plugin uses a simple drag-and-drop system. WP All Export works in much the same way to make it easy to export your WordPress and WooCommerce data.

All you have to do is map the product information using WooCommerce values or drag them in from the right-hand side of your screen into the respective fields.

Under “Item Title”, select “Custom data”. This will open up a field so that you can then select your attribute from the right-hand side of your screen and drag-and-drop. WP All Export allows multiple attributes. In this case, I will be placing the {Title} attribute.

Basic product information

Availability & price

Under “Availability & Price”, you can opt to use the product’s price or select a custom price from the available attributes. The plugin also lets you adjust the price for your Google Merchant Center export. The same applies for Sales Price and Availability.

Under “Advanced Options”, set the currency, availability date, and sale price effective date.

Availability and price

Mapping product categories to Google categories

Moving on to product categories. WP All Export has some great features here. Since we’re exporting our WooCommerce products to Google, we need to use Google’s categories for them to be accepted on its platform.

To do this, WP All Export displays your WooCommerce Categories on the left and all you need to do is browse through the Google Categories on the right, find the one that matches, and select it. It’s really that simple!

Map categories

To make things simpler, WP All Export also allows you to type and search for the category you want.

Map categories auto complete

The great thing is that once you’ve mapped a category to a parent category in a hierarchy, all the child categories are automatically assigned that same mapped parent category. This saves you loads of time, especially when dealing with long lists of products.

Unique identifiers

Unique identifiers are what Google uses to classify your products, set adverts to work better, and make it easier for your clients to locate the product they want. Map your GTIN (Global Trade Item Number), MPN (Manufacturer Part Number), and Brand fields by dragging and dropping them from the right-hand side.

If you do not have an MPN or GTIN, simply enable the “Set to false if the product has no GTIN or MPN” option.

Unique identifiers

Detailed product attributes & item grouping

In this next section, we’ll map the Item Group ID for variable products. When it comes to variable products, each variant is exported as a separate product. Therefore, in order for Google to group them up, they must all have the same Group ID.

Another good thing about WP All Export is that it can automatically set the Group IDs for you. Next, set the color, size, and gender of your products if needed, by using WooCommerce Attribute values. Alternatively, drag and drop the custom value attribute.

Item grouping

Under the “Advanced Options” section, map the Size Type and Size System, Age Group, Material, and Pattern, as necessary. Of course, you can skip the ones that are not relevant to your product types. WP All Export can also automatically find these values from your WooCommerce Attributes.

Shipping

Now we need to set up one of the most important parts of any online shop – Shipping. Map the shipping price and adjust it, if need be. Use WooCommerce values to define the Length, Width, and Height of your products and choose whether to export the shipping weight and shipping label.

Shipping

Advanced attributes

If you’re selling packages that include identical products grouped together and sold as a single item, such as 3 pairs of socks, you will need to map the multipack value – in this case 3.

If your products are not adult products, select false.

Advanced attributes

Next, you can start setting your AdWords Redirect URL and shopping campaigns by creating custom labels. This is useful when indicating that products are either seasonal, on sale, or clearance or are best sellers.

Adwords custom labels

Now, if you are selling products that require unit pricing, you can set them up in this next section. This comes in handy when selling products by weight, for instance, $2 every 200g.

Unit prices

WP All Export also lets you set the Expiration Date, Energy Class, and Promotion ID. As with most of these options, if you do not require it, simply skip ahead to the next section.

Additional attributes

Export settings and running the export

In order for you to keep your Google Merchant Center up to date, you can set the WP All Export plugin to automatically export your WooCommerce Product data on a schedule.

You can set the days and time to do so and the plugin will run automatically.

Scheduling options

All you need to do now is run the export!

Creating a new product feed in Google shopping

Once your feed has been exported, the plugin will display instructions on how to set up your WooCommerce Product feed in Google Merchant Center, together with the feed URL.

Head over to the Google Merchant Center, select “Create a new feed” > “Scheduled fetch” and name your feed.

Scheduled fetch

Paste in the file URL as provided by the WP All Export plugin and fetch and process the feed.

Merchant centre file URL

Google Merchant Center will then notify you when it is done processing your feed. And there you have it – you’ve successfully exported your product feed to the Google Merchant Center!

Fetch complete

Conclusion

WP All Export does an excellent job of helping shop owners of any niche to export their WooCommerce products to the Google Merchant Center. The plugin comes packed with lots of options and features such as scheduling.

WP All Export is an effective tool for any WooCommerce product.

Table of Contents
Our Sponsors
Our sponsors

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *

Stay up-to-date with the Mayor
Sign up to receive one weekly email about our latest reviews, tutorials, giveaways and more.