Export WooCommerce Products to Google Shopping
Are you selling physical products in your WooCommerce store and want to promote them with free product listings or shopping ads on Google? Then you first need to create and upload product feed to Google Merchant Center.
In this article, we’ll show you how to create such a feed using the Export Wizard with Store Manager for WooCommerce.
The Export Wizard with Store Manager for WooCommerce gives you the following possibilities:
- Pick the fields for export (required and optional Google fields).
- Apply SQL expressions to get data that’s missing in WooCommerce but required by Google (product URL).
- Save export configuration to update feed in the future.
- Export products to Google Sheets (connect your Google Account with Google Merchant).
- Export all or selected products.
To ensure that our file fits Google requirements, we’ll rely on Google’s product data specification. Let’s go through the procedure step by step.
Steps to Export WooCommerce Products for Google Merchant Feed
- Install and connect Store Manager to your store database (download 14 days free trial).
- Go to Catalog > Products and select the items you want to export for Google feed.
- Follow the prompts in the Wizard to export WooCommerce products for Google feed.
![WooCommerce Export Products Google Merchant Feed](https://woocommerce-manager.com/img/WooCommerce-Export-Products-Google-Merchant-Feed.png)
In step 1, you can specify whether to save the export file locally or as a Google Sheet. We’ll stick to Google Sheets export and create a new spreadsheet. Note: if you want to update a feed, you should select the existing sheet.
![WooCommerce Export Products Google Sheet](https://woocommerce-manager.com/img/WooCommerceExportProductsGoogleSheet.png)
In step 2, we’ll select the fields to be added to the export file. For our example, we’ll add just basic required fields.
![Google Merchant Feed Sample](https://woocommerce-manager.com/img/GoogleMerchantFeedSample.png)
To add a field to the export file, find it in the left pane and double-click. Selected fields will be listed in the right pane:
![WooCommerce Export Products Google Feed Fields](https://woocommerce-manager.com/img/WooCommerceExportProductsGoogleFeedFields.jpg)
As WooCommerce doesn’t provide a product page URL, we’ll have to generate it ourselves. For this, we’ll be using the built-in SQL editor.
An URL can be generated by concatenating the domain/product URL and a post_name field. Click +Add simple expression field to open SQL Editor:
![WooCommerce URL export](https://woocommerce-manager.com/img/WooCommerceURLexport.png)
Enter the expression CONCAT('http://domain.com/product/',[post_name])
and press OK:
![WooCommerce URL export Concat Expression](https://woocommerce-manager.com/img/WooCommerceURLexportConcatExpression.png)
Now, when the expression is added, we can proceed with the next step:
![WooCommerce Export Proceed](https://woocommerce-manager.com/img/WooCommerceExportProceed.png)
Specify what records you want to export. Expand the Advanced Options section to ensure that images will be exported as links. Once you are done, click Export:
![WooCommerce Export Product Image URL](https://woocommerce-manager.com/img/WooCommerceEportProductImageURL.png)
Click View Export File to open the spreadsheet. Before you close the Wizard, you can save configuration. Thus you’ll be able to apply the export setting automatically during future exports:
![WooCommerce View Product Sheet](https://woocommerce-manager.com/img/WooCommerceViewProductSheet.png)
Let’s now check the exported product data. As you can see, the product link was generated. If you click the link, you will get to the product’s page.
![WooCommerce Product Feed Exported](https://woocommerce-manager.com/img/WooCommerceProductFeedExported.png)
Format Data in the File According to Google Specifications
Now we have to format the spreadsheet according to Google requirements. First of all, it’s necessary to change column names:
![WooCommerce Google Feed Columns](https://woocommerce-manager.com/img/WooCommerceGoogleFeedColumns.png)
Next, we should change value “instock” to “in stock” and add a currency sign to the price:
![WooCommerce Feed Values](https://woocommerce-manager.com/img/WooCommerceFeedValues.png)
Add WooCommerce Feed to Google Merchant
Once the spreadsheet is ready, you can submit it to the Merchant Center. Go to your Google Merchant Center account, click Products > Feeds, and then click the blue “+” icon.
![WooCommerce Add Feed](https://woocommerce-manager.com/img/WooCommerceAddFeed.png)
Follow the prompts to set up the feed. In step 3, name the feed and choose how you’ll input the product information (Google sheets in our case).
![WooCommerce Primary Feed Name](https://woocommerce-manager.com/img/WooCommercePrimaryFeedName.png)
Now select the sheet with exported WooCommerce product data:
![WooCommerce Products Google Feed Upload](https://woocommerce-manager.com/img/WooCommerceProductsGoogleFeedUpload.png)
As you can see, attribute names were processed correctly. To eliminate issues, it’s necessary to verify website ownership and set up shipping and tax information in the Google Merchant account settings:
![WooCommerce Feed Settings](https://woocommerce-manager.com/img/WooCommerceFeedSettings.png)
Once you’re done with the setup, you can switch to the All products page and check how products will be displayed on Google:
![WooCommerce Product Feed Preview](https://woocommerce-manager.com/img/WooCommerceProductFeedPreview.png)
Summary
Featuring products from your WooCommerce store on Google can help you boost website traffic, bring you new more leads and increase sales. Use the Store Manager for WooCommerce export tool to generate product feed and get your Google Shopping campaign up and running!
Use Store Manager to export WooCommerce products to Google Shopping!
Try now FREERelated Articles:
![Card image](/img/WooCommerce-Orders-Import-Wizard-Launch.jpg)
How to Import Orders in WooCommerce
Adding or updating order information manually may take too much time. Store Manager offers the possibility to swiftly import orders to WooCommerce as a CSV file. Read More...
![Card image](/img/2-woocommerce-chatgpt-yoast-seo-meta-description-prompt-book.jpg)
How to Export WooCommerce Orders to Google Sheets
When you export WooCommerce orders to Google Sheets you get more functionality to filter, sort and analyze data, get insights, create reports, send a link with info to your sipplier. Read More...
![Card image](/img/WooCommerce-Orders-Export-File-Explorer.jpg)
How to Translate Product Description with ChatGPT for WooCommerce
Use ChatGPT with the Store Manager for WooCommerce software for fluent automated translation with no recurring fees. Read More...
![Card image](/img/3-woocommerce-chatgpt-short-description-prompt-book.jpg)
How to Generate Product Short Description Based on Product Name, Brand and Product Attributes
Generate product short descriptions based on product name, attributes, or any other field in bulk with ChatGPT for WooCommerce Store Manager. Read More...
COMMENTS