Boxes - Boxes for Google Merchant Center

Google accepts the following five entries for the age group: - adult - kid - infant - toddler - newborn

When using this box a static value is added to your data.

With this box you can set the age group by using Regular Expressions. When using this box you should be familiar with Regular Expressions. More information about working with Regular Expressions can be found here.

In this example the age group depends on the regular expressions appearing in the column.

If Women, female, Men or male appears in the column the age group is set to adult. If boys are girls appears in the column the age group is set to kids.

Google accepts the following four statuses for the availability of products: - in stock - out of stock - preorder - refurbished

When using this box a static value is added to your data.

This box sets the status "in stock" for every product with a stock larger than 0. Therefore you need to choose the column were the stock information is included in your feed.

Google accepts the following three statuses for the condition of a product. - new - refurbished - used

When using this box a static value is added to your data.

With this box you can set the condition by using Regular Expressions. When using this box you should be familiar with Regular Expressions. More information about working with Regular Expressions can be found here.

This box is used to set the expiration date for a product. This date refers to the date after which an offer will no longer be available. When using this box count the days (X) and always include today's day as 1 count.

If your offer is not going to expire any time soon we suggest you to insert 30 (days) here.

Google accepts the following three statuses for the gender. - unisex - male - female

When using this box a static value is added to your data.

With this box you can set the gender by using Regular Expressions. When using this box you should be familiar with Regular Expressions. More information about working with Regular Expressions can be found here.

Example: Your data includes the value "Herren". To replace this value and set "male" instead you can fill the box according to the example below. All products containing "Herren" will be set to "male" in that specific column for gender. Every product without that information in it are set to "unisex".

To add this optional information Google requires certain values if the identifier exists or not. This box uses the information filled in the intermediate columns brand, gtin, mpn and category or Google Category Column (choose from the dropdown list which column includes the information about the categories) to detect if an identifier exists or not.If an identifier exists for a product this column is left empty which equals the value "true" when exporting to the Google Merchant Center. If there is no identifier for that product the column is set to "false".

This box is used to add the information of which payment method you accept. Enter one or more of the following accepted values seperated by comma and no whitespace: - Überweisung - Bar - MasterCard - AmericanExpress - Visa - PayPal

When using this box a static value is added to your data.

Set the size type by choosing an option out of the dropdown. This dropdown list includes the values that are accepted in the Google Merchant Center.

With this box you can set the size type by using Regular Expressions. When using this box you should be familiar with Regular Expressions. More information about working with Regular Expressions can be found here.

In this example every product including the value "reg" in it are set to the size type "regular", every product including the value "small" in it are set to the size type "petite".

Set the country your size system is from. The dropdown list includes the values that are accepted in the Google Merchant Center.

When using this box a static value is added to your data.

Use this box if you have categories in your feed that include more than 1000 items. That is sensible because for the Google Merchant Center exists a limited of 1000 items for each category.

ID Column: Fill in the column where the product ID is in.

Split category: Fill in the full name the separated categories shall have.

Subgroups: Fill in the number of groups you want to have.

Example:

We have 4000 books (Bücher) and want to have as few subgroups as possible.

This box is used to extract one or more parts from a specific category path, even though the rule can be applied to any column in your feed. It works in a similar way to the Split String box explainded here, yet if no splitter is found, the value will be deleted.

The extraction is achieved by splitting the text using a delimiter. You can use it if you only need one part of a value or just the beginning/end.

If you already have the Google Taxonomy in one column of your feed you can now - automatically translate it into another language referring to the Google Merchant Center taxonomy OR - replace the the text with Google's ID number system(which is the same for all languages).

Example:

The google_product_category in your feed contains the English taxonomy and you want to export the taxonomy in German.

Step 1: In Data Edit add the box Translate Google Category.

Step 2: Select the relevant (existing) Source Format (en-US for US Taxonomy)

Step 3: Select the (desired) Target Format (de-DE for German)

The output will be the German taxonomy:

Please note: If the source language is the same as the target (for example en-US to en-US) the taxonomy will obviously remain the same but the box will filter all invalid categories. So you can use the Translate Google Category box to remove all the invalid categories from your feed.

However, Productsup recommends fixing invalid categories (using our List feature, for example) instead of removing them.