With the Volusion API, you can integrate your store with Google Merchant Center to upload product listings that can be used for Google Shopping, Google Product Ads, and Google Commerce Search. Nifty, right? For a deeper look at Google Merchant Center — including what you need to do once you've integrated your store and set up the product feed — check out Google's About Merchant Center page.
Quick Note: 🚨 Be sure to read this article in its entirety! 🚨 Follow all steps and notices listed here so your store can communicate properly with Google Merchant Center. There are multiple required fields for your products that can prevent your feed from generating or block your products from being listed in Google. Read on for details!
Integration with Google Merchant Center requires access to the Volusion API, which is available on Business or Prime monthly hosting plans.
Integration involves connecting to the Google Merchant Center service and submitting XML data that will report your store's product information to the service. You’ll need to set up an FTP account to transmit this data to Google Merchant Center!
The following steps will guide you through connecting your store with Google Merchant Center.
Registering for a Google Merchant Center Account
To use Google Merchant Center, you need to create a Google account. For instructions, see Google's documentation.
Configuring Google Merchant Center FTP Access
Now that your Google Merchant Center data feed is configured, you need to set up FTP access within your Google Merchant Center account. For instructions, see Google's documentation.
Next, you need to configure your store's Google Merchant Center settings.
Google Merchant Center Settings in Volusion
In your Admin Area, go to Inventory > Volusion API.
In the Google section, click Google Shopping Feed.
Enter the FTP username, password, and the file name exactly as you entered them in the Google Merchant Center configuration process above.
Enter a title and description for your Google Merchant Center export into the corresponding fields on this page. You can enter anything you wish but note that these fields are required by Google's system.
If you are producing a feed for the UK, select Include VAT in ProductPrice.
Click Generate XML. Note that the XML file generation process may take some time, depending on the number of products in your store's database. Once the XML generation is complete, XML code will appear in the large text box on the page.
Finally, click Publish to Google to send this XML data to your Google Merchant Center account. If the data is sent correctly you’ll see a confirmation message. However, you will have to go to your Google Merchant Center dashboard to see if the data has been inserted correctly.
Congratulations! Your store is now integrated with your Google Merchant Center account and your products will be listed online through Google's service.
Please note that it may take some time for Google to publish your product information online after you have transmitted the XML information to your Merchant Center account.
On the Google Merchant Center Dashboard, click Products to display details of the products you have uploaded.
Include VAT in ProductPrice (for UK feed)
This VAT will calculate based on the default tax with the lowest value configured at Settings > Tax. The product prices exported in the Google Feed (when this box is selected) will automatically have the VAT added into the price.
For more information on configuring tax, see "Tackling Tax Rate Setup".
The Volusion Google Merchant Center export will only send product data for products with a Google Product Category configured in their Advanced Info > 3rd Party Integrations section. Some products, however, will be exempt from the export.
Please note that the Google Merchant Center export will not send product data for products that meet any of the following conditions:
Products marked as Hidden (unless it has a parent product code in the Is Child of Product Code field, which indicates that it is a child product)
Products marked for Private Section Customers Only
Any product configured as a Gift Certificate
Any product configured with a Setup Cost
Products configured with a Membership Cost
Any product configured to be a Donation Product
Parent products (products with Enable Options Inventory Control or Enable Multi Child Add To Cart selected)
Any product with 0 or fewer stock available if Display Stock Status (formerly Config_EnableDisplayStockStatus) is enabled*
Any child product with 0 or fewer in the Stock Status field, if Do Not Allow Backorders is also enabled/checked on the product
*To enable, go to Inventory > Products > Settings.
You can find a list of Google Product Category examples here!
Child Products 👶
If you have automatically created child products, you will need to ensure that each child product has its own product image uploaded using the child product's image management section. This is because Google will not accept child products without product images.
To ensure that you are able to upload unique images for each child product, you will need to delete the parent product code from the Use Same Photos As ProductCode field at Advanced Info > Misc in the Admin Area for each child product.
Note on Google Required Fields
As of September 22, 2011, there are additional fields required by Google for products to be posted successfully to Google Product Searches. To learn more about Google’s Required and Recommended fields, see Google's Products Feed Specification and their simplified table on the Summary of Attribute Requirements.
Google-specific fields for Products (Advanced Settings > 3rd Party Integrations):
Google Product Type (merchant's category/taxonomy of the product)
Google Product Category* (Google's category/taxonomy or the product. Find acceptable values for this field here.)
Google Adult Product
Google Unique Product
Google Availability* (If you're using a default value for your Availability, it will be mapped for you)
Google Age Group*
If you've enabled options inventory control and your store contains both parent and child products, Google pulls information from the following fields for parent products:
Google Product Type
Google Product Category*
Google Adult Product
Google Age Group*
Google pulls information from the following fields for child products:
Google Size Type
Google Size System
Additional fields that relay information to Google (check Summary of Attribute Requirements to see which fields are required for your specific products):
Product Description Short (if the Product Description Short field is blank, the main product Description field will be used)
Vendor Part #**
*Must use Google's taxonomy for these fields. Check the Products Feed Specification article for the accepted predefined values.
**These fields are used as "Unique Product Identifier" values for Google and must use the prescribed values assigned by the manufacturer. Inventing or approximating values for these fields will result in the values being flagged as invalid.
Google Unique Product Requirement
In Google product categories where unique product identifiers are required by Google, you must select True or False for all products in the Google Merchant Center feed to indicate whether the required unique product identifiers exist for the product.
Google Merchant Center automatically sets a 30-day expiration date for any product data exported to the service. This expiration date is 30 days from the date Google received your exported data. You will want to re-generate your Google Merchant Center XML and re-send it using the controls provided in the Volusion API page every 30 days to update your product listings in Google Merchant Center.
When working with Google Merchant Center, there are a couple of common errors you may encounter.
After publishing your feed to Merchant Center, you may see this error:
Invalid or missing required attribute: price
This error is the result of failure to complete all required account setup steps. Please review them to ensure you're meeting Google's requirements.
When trying to publish to your feed, you may see an error like this:
EnterpriseDT.Net.Ftp.FTPException: Authentication failed. (code=530) at EnterpriseDT.Net.Ftp.FTPControlSocket.ValidateReply(FTPReply reply, String expectedReplyCodes) at EnterpriseDT.Net.Ftp.FTPClient.Password(String password) at google_base_integration.DoFTPUpload() in C:\BuildAgent\work\6c778b44865aa92e\V6.5\net\net\google_base_integration.aspx.cs:line 202
You can resolve this error by ensuring that you're using the correct FTP credentials to connect. Also, be sure to use FTP (rather than SFTP).
Your store should now be fully integrated with Google's Merchant Center service, a great avenue for getting your products noticed and driving traffic to your store!