Google Shopping requires a unique identifier for your product in the XML feed - a brand, barcode, or manufacturer's number. If your goods do not have such a label, it is necessary to put information about them in the feed. How to do it?
Unique identifiers are located in the G:BRAND, G:MPN, and G:GTIN elements in the Google Shopping feed.
- Element G:BRAND indicates the product brand. You can find detailed information about the element here.
- Element G:GTIN is a barcode - a unique designation of your goods. It must always be stated if it is assigned by the manufacturer. It can take various forms - you can find the entire specification here.
- The G:MPN element is the manufacturer's part designation. It is required where there is no G:GTIN. An exception goes for unique goods that do not have such a designation assigned by the manufacturer. You can find details on this element here.
- These identifiers are used to uniquely find the product by the customer.
- Google requires that each item contains at least two of the three identifiers. If a product does not meet this condition, it is necessary to assign the element G:IDENTIFIER_EXISTS and fill it with the value FALSE.
So let's go through it:
- Start by creating a product query that includes products that contain one or no identifiers.
- On the Products page, switch to the Custom Query tab and enter: ([G: BRAND] = "" AND [G: MPN] = "" AND [G: GTIN] = "") OR ([G: BRAND]! = "" AND [G: MPN] = "" AND [G: GTIN] = "") OR ([G: BRAND] = "" AND [G: MPN]! = "" AND [G: GTIN] = "" ) OR ([G: BRAND] = "" AND [G: MPN] = "" AND [G: GTIN]! = "").
- Start the search.
- The search will result in products having only one or no identifier and do not meet Google's requirements.
- Save your query (e. g. "Insufficiently identified products").
Make sure your feed contains the G:IDENTIFIER_EXISTS element. You can find this in the Elements tab. If your XML does not contain it, create it on the same tab in the right corner.
- Create a new rule that you apply to the previously created query, and this rule sets the G:IDENTIFIER_EXISTS element to FALSE.
- On the Rules page, click the CREATE RULE button and enter a name for it, such as "Setting G: IDENTIFIER_EXISTS for products with insufficient identification."
- In the final condition for the product query field, check the query created in the right column from the beginning of this manual.
- Select the rule type Rewrite
- Select element G:IDENTIFIER_EXISTS.
- Enter new content: FALSE.
Then save the rule, and the next time the rules are processed automatically, this rule will already be applied and projected into the output file.
If you want to check the changes made in Mergado first, click the APPLY RULES button on the Rules page. It will reflect the changes in Mergado and check on the Products page that G:IDENTIFIER_EXISTS has been set correctly for the items in the query according to point 1. The changes are then reflected in the output XML file during the subsequent automatic processing, or you can use the GENERATE ALL button on the Settings page. It will project the changes directly into the output feed.
Read how to use Mergado in advertising management:
- Get started with Mergado (part 1)
- Get started with Mergado (part 2)
- Get started with Mergado (part 3)
With Mergado, you can edit product feeds in bulk and set the advertisement yourself. It will improve the quality of your work on managing online stores and save you the cost of hiring a programmer.