Google Shopping - Online Products provides you with errors reports indicating the blocking points for creating and / or updating your offers on the platform.
You can receive 3 types of alerts from Google:
- account alerts: a simple warning, with resolution deadline or immediate suspension
- feed alerts: usually problems with attributes
- article alerts: automatic or manual refusal of certain articles; or refusal of articles for preventive purposes.
This article refers to the last two points.
Google_product_category / Valeur incorrecte [catégorie de produits google]
It is important to categorise products well to display them in the right category.
In Lengow, match the categories you want to send to Google Shopping.
Thanks to our predictive tool, categories are suggested to ease this step (For example: « Shirts & tops » categories suggestion for our “Tops” category below).
Lengow tip: If your categories are large and you want to add more granularity, you can create rules to refine the matching and manage your Google Shopping ads campaigns. To do so, use the 'product_type' attribute.
According to categories, attributes are mandatory. Make sure to fill in these fields in Lengow.
Google limits the use of capital letters in fields. Make sure your titles are not in capital letters. If so, use the UPPERWORD function for the Title, Description, and Brand attributes.
Upperword function to replace capital letters with lower cases in the title
Missing value [brand]
The brand has to be included in the title. Brand could be added before or after the product name.
Compose your title with attributes you want
Lengow tips: For better reading of your title add a space between the '$BRAND' field and the '$NAME' field.
Size & coulour → Missing value [color] / Missing value [size]
This is a very common mistake, especially on products with variations like in the fashion industry (shoes, clothes ...)
In the search results, Google offers, according to categories, filters based on size or color. Filling in these fields maximizes your visibility and click-through rate.
What you can do:
1 – Indicate the size and color in the title of your product (in addition to the brand and product name)
Title composition example
Lengow tip: For better reading of your title, consider adding a space between each field.
2 – In the ‘color’ or ‘size’ field match you color/size with values expected by Google by creating a rule using conversion list.
Convert your values with those expected by Google
- Example #1: Turn your size S into Small (value expected by Google)(Refer to the list of authorized sizes)
- Example #2: Change the color 'Navy' to the value requested by Google: Blue (Refer to the list of authorized colors)
3 - The color field may be empty in your catalogue. This color is sometimes indicated in the product description.
In the color field, in Lengow, create a rule to get this color and transform it into Google taxonomy
4 - Use the “Color Finder” app
"Color Finder" app allows you to automatically extract all colors from your catalog from one of your existing fields (title or description ...) and inject them into a new color field.
Gender: Missing value [gender]
As for size and color, Google is waiting for a specific field for this attribute.
For products with genders, you have to categorize these products with one of the values expected by Google.
You can indicate it:
- in your title
- in the ‘Gender” field, Dans le champ ‘Gender’, follow Google standard for the product to be accepted. Create a rule in Lengow to change the word “woman” in 'Female' / 'man' in 'Male' / “all gender” in 'Unisex')
Convert your gender values with those expected by Google
Google Shopping may reject your images if they don’t comply with their policies.
Your images must not contain a logo, text on the image of several products on the same image.
Image is a mandatory attribute. Make sure to fill in the ‘Image_link’ field.
If you have other product views display them by using the 'additionnal_image_link' field (You can put up to 10 images).
Send up to 10 views for your product
- White background image
- No border
- Weight of the image less than 16MB/image
- Minimum size 100*100 pixels except for clothes. 250*250 pixels for clothes
Non-compatible HTML tags [description]
Your description should not contain HTML tags. Remove HTML content from your descriptions with a STRIPHTML function
Remove HTML tags from your data using this function
Field description is too long
Google limits the description field to 5000 characters.
To truncate it 2 functions can be used.
- Use the 'TRUNC' function to truncate your description.
Truncate your descriptions with this function
- If you don’t want to cut the last word, use the SMARTTRUNC function : SMARTTRUNC($textual_field,number of characters)
Truncate your description without cutting the last word using this function
Google may also decline some of your products if the following statements are present in your description field:
- Promotional text “free shipping”,
- Capital letter or fancy fields (PRO-MO-TION, ಠ_ಠ)
- Foreign language words
- Redirection link
Refer to this non-exhaustive list, to go further.
Missing or invalid data [condition]
Describe the status of the product being sold to users. It is important to define this value precisely because this data is used to refine the search results.
- new [new]. Your product is new and has never been used. It is in its original packaging and has not been opened.
- refurbished [refurbished]. Your product is not new; it has been repaired by a professional, it is "like new" and under warranty. The product may be in its original packaging or not. Sometimes we talk about remanufactured product.
- second hand [used]. It is a second-hand product. It may be, for example, a product that has already been used, a product whose original packaging has been opened or is missing.
If in your catalog you have new products and refurbished products for example, you’ll create a rule to assign a status to each product or group of products.
Apply "new" value to products with "pretty" brand
Google tells you that the unique product code is missing for some products. In this case you must specify a value for the EAN or MPN attributes.
1- Fill in the GTIN field
In this case, the EAN makes it possible to distinguish the products.
If your product has an EAN code that you do not have, ask your provider to insert it into your source feed.
2 - If a product has no GTIN code (customizable product for example) fill in the 'No' value in the ‘Identifer_exist' attribute.
Rule to assign the value "no" to the "Identifer_exist" attribute
Lengow tip: if you don’t have a GTIN code, make sure to fill in your feed at least the attributes mpn [mpn] and brand [brand].
3 - If you do not want to export these products without a GTIN code, create an exclusion to avoid sending the products if the 'gtin' field is empty.
Policy → “Item disapprovals for policy violations”
This is related to Google Shopping rules (Drugstore products, adult products), please refer to Google rules before displaying your offers)
This error indicates that landing pages can not be controlled by Google, which blocks the display of your product(s).
Google wants you to indicate your price and the currency.
Apply the desired currency at your price
The price displayed in Google Shopping must be the same as the price displayed on your site page. In other cases, your product will be in error and won't be displayed. Clearly indicate the currency and the price including VAT.
If you're offering a promotion in Google Shopping, make sure you change your landing page with the right price.
Also enter a price without the shipping costs.
Don’t send prices to 0.
Your shipping costs must be filled in as follows FR:::5.90 (Country initials, 3 times the ”:” character and price (Write a point (.) as a decimal separator)
Fill in your shipping costs by following this nomenclature
If you sell elsewhere than in France, change the first 2 letters and the amount of shipping if applicable.
If you want to offer shipping costs, you’ll have to set up a rule to empty the field. Make sure the same offer is available on your website.
Rule to offer shipping costs
Lengow advice: for each rule or exclusion, keep in mind to give it a name to remember to name it in Lengow in order to find it more easily and see what it's all about at a glance.