How to Export WooCommerce Products to Google Merchant Center
To export products to the Google Merchant Center, go to All Export › New Export and select WooCommerce Products. Change the Export Type to Feed › Google Merchant Center Product Feed and configure the export as required. The exported file is automatically set up for the Google Merchant Center.
Step 1: Create a New Export for a Google Merchant Center Product Feed
Go to All Export › New Export. Choose to export WooCommerce Products, then click the blue Customize Export File button:
In the Drag & Drop interface, expand the Export Type section, change the Export Type to Feed, and select Google Merchant Center Product Feed:
The edit export page will then change to show the Google Merchant Center options:
Fields under Available Data can be used when selecting Custom Data. Inline PHP can also be used.
Step 2: Define Basic Product Information
Expand the Basic Product Information section:
Basic product information to export can be defined as follows:
- Item Title: Product title to export, the default option uses the product's current title, but Custom data can be used. This field has a checkbox to make variable products use their parent product title.
- Item Description: Product description to export, the default option uses the product description, but the short description or Custom data can also be used. This field has two checkboxes controlling what descriptions should be included for variable products.
- Link: Product link to export. Select between using the product's permalink or Custom data. This export field has a checkbox that adds variation attributes to variable product URLs.
- Main Image Link: Main image for the product. Select to use the current product featured image or to use Custom data. This export field has two checkboxes to define how images are handled for variable products.
- Additional Image Link: Secondary product images to export. Select to use current images in the product gallery, or Custom data.
Expand the Advanced Options subsection:
Here, you can define the following export fields:
- Item ID: Unique item ID used to identify products.
- Item Condition: Condition of the item being sold. Accepted values are
used. This export field allows using Data Mapping. Exports
- Mobile Link: used to define a mobile-friendly version of the same product.
Step 3: Define Availability & Price
Expand the Availability & Price section:
Here are the available settings:
- Price: Price for the product. The default option uses the current price, but Custom data can also be enabled. This export field has an Adjust Price setting which allows to mark up the price by a percentage or a fixed amount.
- Sale Price: Sale price for the product. The default option uses the current sale price but Custom data is available. This export field also has an Adjust Price setting.
- Availability: Stock for the product. The default option uses WooCommerce stock values but Custom data can also be used.
Under Advanced Options, change the Currency setting to any currency supported by WooCommerce and GMC, then modify the following export fields:
- Availability Date: Used to define when an anticipated or delayed product will be available. Accepted format: YYYY-MM-DDThh:mmZ. Example:
- Sale Price Effective Date: Used to define for how long a sale price will be shown to users. Accepted format:
YYYY-MM-DDThh:mmZ, separated by a slash (
- Cost Of Goods Sold: Used when reporting conversions with cart data to get reports on gross profits. Can be a rough estimate. Accepted format: number plus currency. Example:
Step 4: Assign Product Categories
Expand the Product Categories section:
Here, you can change how the categories are assigned to the exported products. The following settings are available:
- Product Type: Used to include a different product categorization system. Select either Use WooCommerce's product category or Custom data.
- Product Category: There are 3 available settings to define how product categories are exported:
- Map WooCommerce's product categories to Google's product categories: This allows to manually map the WooCommerce categories into Google's product categories. Default option.
- Use WooCommerce's product categories: Uses the existing WooCommerce categories to import into Google Merchant Center.
- Custom data: Allows defining categories dynamically.
Step 5: Assign Unique Identifiers
Expand the Unique Identifiers section:
Unique Identifiers are unique codes and values used to classify the exported products. Learn more about this here. These are the available settings:
- GTIN: Product’s Global Trade Item Number. Supported values: UPC, EAN, JAN, ISBN, or ITF-14. Example:
- MPN: Product’s Manufacturer Part Number. Example:
- Brand: Product's brand name. Example:
- Identifier Exists: Used to indicate whether or not the unique product identifiers are available for the product. Supported values:
no. Available settings: Set to false if product has no GTIN or MPN or Custom data.
Step 6: Define Detailed Product Attributes & Item Grouping
Expand the Detailed Product Attributes & Item Grouping section:
This section contains settings to define how variable products are grouped, as well as how attributes are exported. Here are the available settings:
Under Item Group ID, define how to group exported variable products. Each variant is exported as a separate product and assigned the same identifier. Choose between either Automatically set the item group ID or Custom data.
The following attributes can be defined when exporting products to the Google Merchant Center:
- Color: Select an existing WooCommerce product attribute, choose to Leave Blank, or use Custom data.
- Size: Select an existing WooCommerce product attribute, choose to Leave Blank, or use Custom data.
- Gender: Select an existing WooCommerce product attribute, choose to Leave Blank, autodetect or select from WooCommerce product categories, or use Custom data.
More detailed product attributes can be defined under Advanced Options. Here are the available settings:
- Size Type: Used to describe the cut of the product. Supported values:
- Size System: Country sizing system selected. Exports as blank by default. Supported values:
- Age Group: Used to set the demographic that the product is designed for. Select from WooCommerce product attributes, choose to Leave Blank, select from WooCommerce product categories, or use Custom data. Supported values:
- Material: Used to describe the main fabric or material the product is made of. Select from WooCommerce product attributes, choose to Leave Blank, or use Custom data.
- Pattern: Used to describe the pattern or graphic print found on the product. Select from WooCommerce product attributes, choose to Leave Blank, or use Custom data.
Step 7: Modify Product Shipping Information
Expand the Shipping section:
This section allows you to modify the following settings:
- Shipping Price: This estimated amount allows Google to provide a shipping estimate for the product. This export field has an Adjust Shipping Price setting.
- Length, Width, Height: This selects the length, width, and height for the product. By default, it will use WooCommerce's product values and convert them to cm, but Custom data can also be used.
- Shipping Weight: Exports the shipping weight for the product, the default option selected is Do not include in the feed. Allows using WooCommerce's product values or Custom data.
- Shipping Label: Used to group products together so specific shipping rates can be configured in GMC. Expects a string or plain text.
Step 8: Modify Advanced Attributes
Expand the Advanced Attributes section:
This section contains additional settings that can be applied to the exported products, separated into multiple subsections.
Under the Product Type subsection, you can define the following export fields:
- Multipack: Used to indicate that multiple identical products have been grouped for sale as one product. Expects a numerical value.
- Adult: Used to indicate that an individual product is for adults only, because it contains adult content such as nudity, sexually suggestive content, or is intended to enhance sexual activity. Supported values:
The Adwords & Shopping Campaigns subsection consists of the following:
- Adwords Redirect: Used to specify additional landing page parameters (used for Shopping ads) on the product page. Expects a URL.
- Custom Labels: Used to create specific filters to use in Shopping campaigns. Learn more here. Expects a string or plain text.
Unit Prices allows to define pricing for products that rely on unit pricing:
- Unit Pricing Measure: Used to define the measure and dimension of the product. This value allows users to understand the exact cost per unit for the product. Expects a positive number plus unit. Example:
- Unit Pricing Base Measure: Allows to include denominator for unit price. For example, even if the product is 750ml, users may be interested in seeing the price per
100ml. Expects a positive number plus unit.
There are Additional Attributes that can be defined at the end of this section:
- Expiration Date: Used to cause a product to stop showing on a specific date (before the 30 days default). Expects a date, time, and timezone. Format: YYYY-MM-DDThh:mmZ. Example:
- Energy Efficiency Class: Used to tell users the energy label of the product. Supported values:
- Promotion ID: Used to match products to promotions. Supports alphanumeric values, underscores, and dashes.
Step 9: Preview Exported Google Merchant Center Feed
After the Google Merchant Center Product Feed Export has been configured, click Continue and then click on Confirm & Run Export. Download the exported products by clicking on the Export Feed URL.
Here's a sample preview of a default Google Merchant Center Product Feed export:
Frequently Asked Questions
How to Link Google Merchant Center to My WooCommerce Feed?
- Go to the Google Merchants Dashboard.
- Click the big blue button to create a new feed.
- On page 2, select Scheduled fetch.
- Use whatever you want for the File Name.
- Use the Export Feed URL generated by Step 9 of the process described above.
How to Schedule My Product Feed?
You can do this by scheduling your export with Cron jobs.
How to Sync Google Products with WooCommerce?
As long as you set up the product export feed generated by WP All Export so that it completes before the scheduled fetch that you've set up for the Merchant Center, synchronization should occur at the scheduled intervals. You might also consider setting up email notification to verify that the export was successful.
Why Do Google Merchant Center Feeds Have Fewer Products Than Regular Exports?
A Google Merchant Center export won't include parent products, so, if you have a lot of variable products, that could account for the difference. If this is the case, the total product count in the feed should equal your total expected count less the count of parent products.
How Can I Export Specific Product Categories to the Google Merchant Center Instead of the Whole Catalog?
Google Product Feeds can be filtered using the same powerful filter tools available for any other export. So, all you have to do, is create a filter for the specific product categories that you are targeting.
Drag and drop to create a spreadsheet with your WordPress data. CSV or Excel.
Use a powerful templating engine to create custom WordPress XML exports.