What can we help you with?
How to set up ELEX WooCommerce Google Product Feed Plugin?
This article explains the step-by-step tutorial to set up ELEX WooCommerce Google Product Feed Plugin. For more information on the plugin, refer to the product page.
Here are some of the major highlights of the plugin:
- Creates a TSV file for your Google Shopping: The plugin lets you create a TSV file of your WooCommerce products that you can submit to Google, via Google Merchant Center.
- Creates an XML file for Google Shopping: The plugin creates an XML file of your WooCommerce products that you can submit to Google, via your Google Merchant Account.
- Creates a CSV file for Google Shopping: The plugin creates a CSV file of your WooCommerce products, which you can submit to Google, via Google Merchant Center.
- Schedules Cron job to refresh the XML/CSV/TSV file: If you update product information on your WooCommerce store, it is necessary to keep the Google Feed updated, hence the plugin allows you to schedule Cron jobs where the XML and the CSV file is fetched at scheduled times.
- Include variations: If you have variations of products, the plugin allows you to include all variations. This will be useful when an online user is searching for a specific colour, size, or other variations of your product.
- Exclude products: Since you are selecting product categories and not individual products, there may be instances where you wish to skip some certain products. You can do so by specifying the respective product names which will provide you with the products
- Include Dynamic Attribute Mapping on the need basis: Here the plugin lets users set their own conditions for any product attributes while mapping it to the Google Product attributes. Also, the plugin helps you generate a data feed file according to the search engine requirement.
- Use custom Meta Tags for attribute mapping: The plugin lets you create custom meta tags for attribute mapping.
- Manage Feeds: In here you can edit, copy, pause your feeds, delete, regenerate, download or view multiple Google feeds.
- WPML Compatible: The plugin is completely compatible with WPML.
Getting started with ELEX WooCommerce Google Product Feed Plugin
Or watch the video on Youtube to understand how to set up ELEX WooCommerce Google Product Feed Plugin easily to generate Google Product Feed errorfree.
The generic settings of the plugin are shown below.
- Project Name: Enter the desired project name for the feed. This should be a unique name to make it easy to identify.
- Project Description: Enter a description that defines the product feed or even leave it blank, if you want the project name to be taken as the project description.
- Country of Sale: Select the country from where you are selling the products. This list contains all the countries where Google Merchant Center is available.
- Include Variations: Enable this option to include all variations of your WooCommerce products.
- Auto-set identifier_exists: If you enable Auto-set identifier exists, it allows the product feeds without unique product identifiers (GTIN, MPN, and Brand) to be uploaded to the Google Merchant Center.
- Default Category: Here you can choose the default Google category you want to select for all your product categories. All you need is to type in and then the list of categories corresponding to the category you typed in will appear. The category can also be modified while mapping the category in the Map Category tab.
- File Format: The plugin currently supports CSV, TSV, and XML formats. We plan to include more file formats in the future.
- Refresh Schedule: You can schedule Cron jobs to refresh the feed generated. You can choose to refresh Daily (at a specified time), Weekly (at a specified time and on a specific day of the week when the feed was created), or Monthly (at a specified time and date of creation of the feed).
- Currency Code: The currency code for the country of sale must be entered here. The different world currencies are represented by three-letter alphabetic codes known as currency codes.
- Currency Conversion: You can specify a conversion rate here. The value you set here will be multiplied by the existing product prices before generating the product feed. For example, if you enter 2 here, and the existing product price is $10, the price that will be taken for generating the feed will be $20 (2*10).
Once the above settings are configured, click Save & Continue.
Mapping Product Category
It is mandatory to map at least one of your WooCommerce product categories with Google category that are available in the Google Taxonomy. In this plugin, you have an option to choose the Default Google product category in the General Settings. All you need to do is start typing the required category in the Google Categories text box and the related categories will be auto-filled. You can choose to add and map any number of product categories with Google product categories. While mapping categories are filled, the corresponding checkbox will be auto-checked.
Here, once you begin to map the product categories, then you get all the product categories on your store listed and a corresponding option to add the Google Product category. Here, if a default category is selected in General Settings, then by default all the google categories listed will be the same one. You can either opt to change the google category by just typing into it and the other categories will be shown on the list.
Tick the checkbox for the categories you want to select for your product feed, after choosing the relevant Google Product Category. If you want to exclude any one of the product categories, you can uncheck the checkbox corresponding to it. Once you selected the desired categories and mapped them, click on the Save & Continue button.
Mapping Individual Products
Maybe you do not want to map all products in a category with Google Categories, or you need to map some selected products for listing it on the Google Shopping. In this plugin, you have an option to choose the Default Google product category for mapping to individual products. All you need to do is start typing the required products to be mapped with Google Categories in the text box as well as the required Google Categories for mapping to the selected products. The products in your store and the related categories will be auto-filled in the respective boxes while you start typing it.
You can add as many products as you want to be mapped by a particular Google Category. And you can add more rows and remove existing rows according to the requirements. After setting these you can click the Save & Continue button.
Mapping Product Attributes
Once the product categories are mapped, you need to map attributes as well. The number of attributes in this stage depends on the country of sale you selected in the generic settings. You need to map each Google attribute with your WooCommerce attributes (both default & custom ones).
If you do not have an equivalent WooCommerce attribute for a Google attribute whose value is constant for all products, you can enter a custom value manually by clicking on the edit icon next to the WooCommerce attribute field and entering the desired value.
The product attributes mapping gives you plenty of options to edit the appearance of your product data on your feed like ;
- You can append /prepend any product attribute with other attributes to map with the Google attributes.
To know how to append or prepend attributes with other product attributes for the better mapping with Google attributes, check out the article: How to Map a Product Attribute by Appending or Prepending with Another Attributes in Your Product Feed Using ELEX WooCommerce Google Shopping Plugin?
- You can also include conditional statements to the attributes to customize your product feed as per your needs.
- Like for example if you want to prepend the brand name with the product title, then you can use the Prepend option. Or if you want to suffix the brand name, then you can use append.
- When a customer is selling a product whose stock quantity is unpredictable, you can set the condition for Stock status that, the stock quantity is less than a certain minimum quantity then display in the Product Description that the stock quantity is less.
For more details to map the product attributes with Google attributes based on specific conditions and rules, check out the article: How to Map your Product Attributes with Google Product Attributes Based on Specific Conditions Using ELEX WooCommerce Google Shopping Plugin?
The plugin gives you lots of control over how you want to set up your data for the feed. Also with the conditions, it becomes easy to set up your data as per your store requirement and generate a feed, per business need.
The plugin also allows you to add additional fields of your own. You can click Add Field and map Google attribute with your WooCommerce attribute. You can add any number of attribute fields.
If you want to map the tax attribute of your products with Google’s tax attribute, refer to an article – How to Configure Tax in ELEX WooCommerce Google Shopping Plugin?
To know how to map Google price attribute with your Product Price Including Tax, refer to the article –How to Map Google Price Attribute with your Product Price Including Tax Using the ELEX WooCommerce Google Shopping Plugin?
Click Save & Continue to proceed further.
Entering GTIN, MPN, and Brand Name in Product settings
Global Trade Item Numbers (GTINs), Manufacturer Part Numbers (MPNs), and Brand Name are unique product identifiers that helps Google identify the product and target the ads easily. This, in turn, makes it easy for users to discover your products.
- GTIN is a unique number that is provided by the manufacturer. This number can be seen below the bar-code attached to the product. Google has mandated this information for United States (U.S), United Kingdom (U.K), Germany, France, Italy, Brazil, Australia, Czech Republic, Netherlands, Spain, Switzerland, and Japan. Depending on the selected country, the sequence of the GTIN might differ. Read this Google document for more information on GTIN.
- MPN is used to uniquely identify a specific product from the same manufacturer. A product can be sold under different vendors. Hence, having a single MPN for a product makes Google identify the sole manufacturer of the product. If you have provided GTIN for a product, MPN is optional. But, you would need GTIN to add MPN or Brand Name. More information on MPN here.
- Brand Name is another unique identifier that helps users find products with the brand name. If you have provided GTIN for a product, then MPN and Brand are not mandatory.
To add this information to your products, the plugin provides three additional fields in every WooCommerce product settings. These settings can be found in the General tab of product data met-box, as shown in the screenshot below.
Provide respective GTIN, MPN, and Brand name for the product and save the product settings. In the Map Attributes step of the plugin, you can see the three fields listed. You need to make sure the meta-fields _elex_gpf_gtin, _elex_gpf_mpn, and _elex_gpf_brand are selected for GTIN, MPN, and Brand attribute fields respectively.
To know how to map a meta key for GTIN and Brand with different attributes, check out the article: How to Map a Meta Key for GTIN and Brand with Different Attributes Using ELEX WooCommerce Google Shopping Plugin?
This tab is to filter the products based on their existing Stock Quantity and the Sold Quantities (number of products sold) to date. You can filter the products by selecting a condition from options such as Equal to, Greater than or Equal to, and Less than or Equal to followed by selecting a value to go with the condition. If the conditions match the products’ stock quantity and the sold quantity, those products will be chosen for generating the feed.
Featured Products: Enable this option to include only products that are marked as ‘Featured’ in the product feed. If you have enabled this option, the feed will be generated for the featured products exclusively, even though you have set other filter options to select non-featured products. To know more about how to create a feed for featured products, refer to the article – How to create a Google Product Feed for Featured Products using the ELEX Google Shopping plugin?
Stock Status: Filter the products that you want to add to the product feed based on their stock status The available options are In stock, Out of Stock and Back Order.
Check the examples below:
According to the above example, the products will be taken for generating the product feed if and only if the products’ stock quantity is greater than or equal to 50 and their sold quantity is less than or equal to 50.
If you wish to exclude certain products from the feed, all you need to do is, just enter the product name, which will just show you the products with those words you typed in. The step simplifies the process to exclude the products.
Leave this section blank if you do not wish to exclude products.
If you have integrated a desired multi-vendor plugin in your WooCommerce store, you can filter the products based on vendors to generate the product feed. Check the screenshot below:
According to the screenshot above, the products sold by Vendor 1 will be filtered to generate the feed.
To know more about how to generate a product feed based on specific vendors, refer to the article – How to Create a Google Product feed Based on Specific Vendors using the ELEX Google Shopping plugin?
Then you will be redirected to the Generate Feed tab where it will show all products are updated if the feed generation is successful.
Click View Feed to view the generated feed.
If some of the products are excluded from the feed as they miss important attributes, you will see an additional button on the tab ‘View Excluded Simple Products’ or ‘Variations’. You can click the button to view the excluded products and their missing attributes. You can fix the issues and add the products into the feed.
When you click the button, you will be redirected to a page in which all missing products and the reasons are listed.
Click Manage Feeds to view and manage all feeds you have generated.
Once the feed is created, you can find it in the Manage Feed tab. You can also perform multiple operations on the feed as per your need. The Manage Feed tab gives you information like :
Name: Name of the Feed created.
URL: The path at which the WooCommerce Google Product Feed is created and saved.
Created: The date of creation of the product feed including the time stamp (hh:mm: ss).
Modified: The date at which the feed was modified including the timestamp (hh:mm: ss).
Next Schedule: If you have scheduled Refresh option for your feed, the feed shows the upcoming schedule date and time when it happens. Also when the schedule is paused then it shows “Paused” to indicate that the Refreshesh schedule for the corresponding feed is paused.
Actions: It shows the list of actions that can be performed on the product feed generated. Like Edit, Copy, Pause, Regenerate, Download, View, Show Report and Delete.
Edit: You can edit your feed anytime.
Copy: If you wish to create a copy of your feed, then you can do so by clicking here.
Pause: You can pause the refreshing of feed when needed and even begin again when your feed is ready to be uploaded.
Regenerate: You can manually regenerate or refresh the feed with fresh data from your store.
Download: This option lets you download the feed to your local system and then check for the feed generated.
View: This option lets you view the product feed in both XML and CSV files.
Show Report: This graph report can be used to analyze the overall feed performance. You can check the report of your generated feed, which displays the included and excluded Simple and Variable products. Using these details, you can understand which products are excluded from the feed automatically while generating the feed, and why they were excluded from the feed. That is, to view the details of excluded products, you can click on the Simple products excluded from the feed (to check the excluded simple products). Or click on the Variations excluded from the feed (to check the excluded variations).
To know the reason why your Simple products got excluded from the feed, click the Simple Products excluded from the Feed part, ie, the light blue part. It will open a new tab that lists the excluded Simple products and the reason for exclusion.
Here, you can clearly see the reason why each product got excluded from the feed. The main reason for products getting excluded is missing the important attributes in the data.
To know the reason why your Variations got excluded from the feed, click the Variations excluded from the Feed part, ie, the light orange part. It will open a new tab that lists the excluded variations and the reason for exclusion.
The mandatory attributes that need to be present in each product while generating feed, as specified by Google Merchant Center, are:
- Image link
If any of the above attributes are missing in a product, the Merchant Center will reject it. In order to reduce the feed rejection ratio in the Merchant Center, the plugin itself will reject the products with missing attributes.
After diagnosing the issue, you can go to the product page dashboard and add the missing details to generate the feed.
Delete: If you no longer need the feed then, you can easily delete the same.
Setting Meta Keys For Google Product Feed
This Settings page in the plugin, helps you set certain meta keys and provide the file path or modify the path/ location for storing the product feed files.
Here, if you are using an external plugin to create any additional product fields, you can also map them with the Google Product attributes. All you need to do is enter some meta keys and save them.
These meta keys will be visible in the map attribute page.
File Path: Add a specific file path to save the product feed in the server. If you do not add a specific path, the default path in the placeholder will be considered.
Google Product Category Language: Choose a language for Google product category taxonomy such as English, Russian, Spanish, German, and French according to the country and customers you target. By default, it will be in English.
WPML Language: You can also choose other languages available on WPML as this plugin is compatible with it. You can choose English, Russian, Spanish, German, French, Dutch, Greek, Polish, and Italian according to your need.
Submitting the Google Product Feed file to Google Merchant Center
Now that your feed is ready to be used, you need to create a Google Merchant Center Account.
Let us walk through the steps to create a Google Merchant Center account.
Signing up with Google Merchant Center
In order to sign up with Google Merchant Center, you need to have a google email id created from accounts.google.com
Once you create, then login to merchants.google.com. Upon logging in, you need to add your page details and other information required.
Here you need to enter the details of countries wherein your business is registered. Also, you can specify the business name – which is mostly the website, business you do or even the store name. This is the name that Google Merchant Center takes into consideration. The time zone is automatically selected depending on the country of selection.
Choose your programs
There are several Google Merchant center programs that can be selected as per your business needs, which includes – shopping ads, shopping actions and surface across Google. Learn more about Google Merchant Center Programs.
Navigating through Google Merchant Center
When you log in to Google Merchant Center, you can see :
Overview : Contains all the summary of your programs and even the quick glance through the announcements by Google Merchant Center.
Products : Here you can manage your feed, review the feeds and also view all the products in a centralized manner.It is easy to access all information from here.
Diagnostics: Troubleshoot and even review any issues, present or even historical ones.
All Products – View all the products you have included in the Google Product Feed as well as add new ones too.
Feeds – You can create or upload a feed from your store here.
Adding Feeds to Google Merchant Center
When you click on the ‘+’ sign to add a feed to the Google Merchant Center, then you can see that you are taken to another page, wherein you have to enter the basic information:
Country of Sales: Should be the target location, you want to sell.
Language: Depends on the region you select.
Upload Feeds to your Google Merchant Center
Google Merchant Center provides various options to upload and input the Google Product Feed.
There are four ways to set up your feed:
- Google Sheet – Lets you add a new sheet or select an existing Google sheet. When you make changes in the sheet, it’ll be automatically reflected on your Google Merchant Account.
- Scheduled Fetch – Lets you provide a URL of your product feed. From our plugins perspective, you can specify the URL of the product feed when you view your feed.
To know how to submit your Google product feeds via scheduled fetches in Google Merchant Center, check out this article: How to Submit your Google Product Feeds Via Scheduled Fetches in Google Merchant Center?
3. Upload – Lets you upload a file in XML, TXT or other supported file formats.
4. Content API – The Content API for Shopping enables you to automatically upload product listings and so make your products easily discoverable through Google Shopping.
We use Schedule Fetch to ensure that the refresh schedules are happening.
The feed will then be uploaded and shown to you in the Feeds section. It might take some time for your feed to show up depending on your products. Sometimes it shows up after a minute or even takes about 30 minutes. You can refresh the Feeds page after some time to check.
You need to fill in :
- The feed name and then create a Fetch schedule. Ensure that the name entered is exactly matching to the file name.
- Provide a fetch frequency like Daily, Weekly and Monthly and specify a time for the fetch.
Note: The time settings can be a later time to the time we set while Generating a refresh schedule for your feed in the plugin.
- Provide the file URL to fetch the feed.
Once the feed is uploaded, it then appears in the feeds uploaded.
You can set up the shipping cost of the products to be displayed on the ads using Google Merchant Center. To know how to set up the shipping cost, refer to the article: How Shipping Cost can be Set via Google Merchant Center?
If you encounter any errors after uploading the feed into the Merchant Center, you can check this article to find a solution: How to Solve the Issues Encountered After Uploading the Feed into Google Merchant Center?
If you encounter any Missing Attributes error at Google Merchant Center with Supplementary Feeds, you can check this article to find the solution: How to Fix the Missing Attributes Errors at Google Merchant Center with Supplementary Feeds?
Linking Google Merchant Center to Google Ads
Google Ads is the backbone of Google Shopping. To optimize the channels for Google Shopping results, you need to set up Google Ads. Finally, to get your Google Ads to link to the Google Merchant Center, you need to do the following :
- Request access from the Google Merchant Center to Google Ads under Accounts linking using Google Ads id.
- Approve the link to connect to the Google Merchant Center on the Google Ads account.
- Google Ads can create supporting campaigns for approval.
With all these steps, you can build your customer base with Google Shopping. It would be ideal to keep monitoring your business with Google Analytics and Google Ad conversion tracking for better results.
Verify and Claim your Website URL
It is important to verify your store URL so that Google knows you are a genuine retailer. Using Google Merchant Center, you can claim your website URL.
How does it work?
In order to verify and Claim your website, you need to ensure that you allow Google to communicate with your website in a proper channel. While doing so, Google Ad markers to your website, and allows you Google to confirm that you are an authorized user for your website and the Google Merchant Center Account.
Here are some important instructions to follow :
- Enter your website URL in the Google Merchant Center.
- Verify your URL: To verify you must use any of the four channels of Google Console– Google Analytics, Google Tag Manager, HTML Tag, HTML file upload. Once the URL Verification is done, you get a confirmation mail.
- Claim your website URL: Google Merchant Center allows you to claim your URL once this verification is done.
Learn more about verification and claiming your website from Google Merchant Center.
To explore more details about the plugin, go check out ELEX WooCommerce Google Product Feed Plugin.
check out the product documentation section for more related articles.
You can also check out other WooCommerce and WordPress plugins in ELEX.