Skip to main content

Google Shopping

To export item data to Google Shopping, you need the following plugins:

You can download these plugins in the plentyMarketplace .

Adding and installing the plugin Elastic Export in your plentymarkets system

Adding plugin to the system:

  1. Go to Plugins » plentyMarketplace.
    → The marketplace opens in a new tab.

  2. Navigate to the plugin Elastic Export.
    Tip: Either use the search function or open the category Plugins » Sales » Marketplaces.

  3. Open the detail view of the plugin.

  4. In the column to the right, click on Go to checkout.
    → The Checkout window opens.

  5. Read and accept the General Terms and Conditions.

  6. Click on Order now.
    → Wait a few minutes before installing the plugin.

Installing plugins:

  1. Go to Plugins » Plugin set overview.

  2. Click on the plugin set in which you want to install the plugin.
    → The plugin set opens.

  3. Click on Add new plugin.

  4. Select Elastic Export from the plugin list.

  5. Click on Install.
    → The plugin is installed.
    → The plugin set is shown.

  6. Switch the plugin active ().

  7. Save () the plugin set.
    Tip: Problems saving the plugin set? Click on Open details to show additional information.

Adding and installing the plugin Google Shopping in your plentymarkets system

Adding plugin to the system:

  1. Go to Plugins » plentyMarketplace.
    → The marketplace opens in a new tab.

  2. Navigate to the plugin Google Shopping.
    Tip: Either use the search function or open the category Plugins » Sales » Marketplaces.

  3. Open the detail view of the plugin.

  4. In the column to the right, click on Go to checkout.
    → The Checkout window opens.

  5. Read and accept the General Terms and Conditions.

  6. Click on Order now.
    → Wait a few minutes before installing the plugin.

Installing plugins:

  1. Go to Plugins » Plugin set overview.

  2. Click on the plugin set in which you want to install the plugin.
    → The plugin set opens.

  3. Click on Add new plugin.

  4. Select Google Shopping from the plugin list.

  5. Click on Install.
    → The plugin is installed.
    → The plugin set is shown.

  6. Switch the plugin active ().

  7. Save () the plugin set.
    Tip: Problems saving the plugin set? Click on Open details to show additional information.

1. Registering with Google Shopping

The price comparison portal Google Shopping offers search and comparison functions as well as links to the product pages in other online shops.

Store owners can display their products in Google Shopping lists within the Google search. Stores are billed for the service per click. This format is based on Google Shopping International. Therefore, linked characteristic values and availabilities have to be saved in English.

In order to set up the Google Shopping plugin in plentymarkets, you have to register with Google Shopping  first.

2. Setting up the data format GoogleShopping-Plugin in plentymarkets

By installing this plugin you will receive the export format GoogleShopping-Plugin. Use this format to exchange data between plentymarkets and GoogleShopping using the elastic export. You also need to install the plugin Elastic export from the plentyMarketplace first before you can use the format in plentymarkets.

Once both plugins are installed in your plentymarkets system, you can create the export format GoogleShopping-Plugin. For more information on export formats, see the elastic export page.

GoogleShopping retrieves item data via an URL. To make sure that your item data can be exported to GoogleShopping, you have to save the URL at GoogleShopping.

Creating a new export format:

  1. Go to Data » Elastic export.

  2. Click on New export ().

  3. Carry out the desired settings. Pay attention to the information given in Table 1.
    Note: There are no item filters set by default. If you do not add any item filterBy installing this plugin you will receive the export format GoogleShopping-Plugin. Use this format to exchange data between plentymarkets and GoogleShopping using the elastic export. You need to install the plugin Elastic export from the plentyMarketplace before you can use the format in plentymarkets.

Once both plugins are installed in your plentymarkets system, you can create the export format GoogleShopping-Plugin. For more information on export formats, see the elastic export page.

GoogleShopping retrieves item data via an URL. To make sure that your item data can be exported to GoogleShopping, you have to save the URL at GoogleShopping.

Creating an export format:

  1. Go to Data » Elastic export.

  2. Click on New export.
    → The New export tab opens.

  3. Carry out the desired settings. Pay attention to the explanations given in Table 1.
    Note: There are no item filters set by default. If you do not add any item filters, all items are exported.

  4. Save () the settings.
    → The export format GoogleShopping-Plugin is given an ID.
    → The export format is shown in the Exports overview.

  5. Save the URL displayed in the URL field at GoogleShopping.

Table 1 lists details for settings, format settings and recommended item filters for the format GoogleShopping-Plugin.

Table 1. Format settings and recommended item filters for the format GoogleShopping-Plugin
Setting Explanation

Settings

Name

Enter a name for the export. This is an internal name, i.e. it is not visible to customers. The export format is listed under this name in the overview.

Type

Select the type item from the drop-down list.

Format

Select GoogleShopping-Plugin.

Limit

Enter a number. This number specifies how many data records should be exported at maximum.

Note: Do you want to transmit more than 9999 data records?

  • Then the output file will not be generated again for another 24 hours. This is to save resources.

  • Then also select the option Generate cache file further below.

Generate cache file

Select this option () if you want to transmit more than 9999 data records. We recommend that you do not activate this option for more than 20 export formats. This is to ensure a high performance of the elastic export.

Provisioning

Select URL. This option allows external access to the file. Third parties access the file with a URL and an authentication token.

Additional settings:

  1. Click on Generate token ().
    The token and URL will be entered automatically.

File name

The file name must have the ending .csv or .txt for GoogleShopping to be able to import the file successfully.

Item filters

Add item filters

Select the items you wish to export. To do so, select one or more item filters from the drop-down list and click on Add. There are no filters set by default. You can add all item filters listed below from the drop-down list.

  • Variations = Select the variations to be transferred.

    • Transfer all = All variations are transferred.

    • Only transfer main variations = Only main variations are transferred.

    • Do not transfer main variations = Only the item’s sub-variations are transferred. Main variations are not transferred.
      Tip: Use this filter option if the main variations are virtual and not for sale.

    • Only transfer single variations = Only those main variations of items are transferred that only have a main variation and no other variations.

  • Markets = Select one or more order referrers. The selected order referrer has to be active at the variation for the item to be exported.

  • Currency = Select a currency.

  • Category = Activate to transfer the item with its category link. Only items belonging to this category are exported.

  • Image = Activate to transfer the item with its image. Only items with images are transferred.

  • Client = Select a client.

  • Stock = Select which stocks should be exported.

  • Flag 1-2 = Select a flag.

  • Manufacturer = Select one, several or ALL manufacturers.

  • Active = Activate if you only want to export active variations.

Format settings

Product URL

Choose the URL that you wish to transfer to the interface. You can choose between the item’s URL and the variation’s URL.
Note: URLs of variations can only be transferred in combination with the Ceres plentyShop.

Client

Select a client. This setting is used for the URL structure.

URL parameter

Enter a suffix for the product URL if this is required for the export.
→ This character string is added to the product URL if you have activated the transfer option for the product URL further up.

Order referrer

Select the order referrer that should be assigned during the order import from the drop-down list.
→ The selected referrer is added to the product URL so that sales can be analysed later.

Marketplace account

Select the marketplace account from the drop-down list.

Language

Select the language from the drop-down list.

Item name

Select Name 1, Name 2 or Name 3. The names are saved in the Texts tab of the item. Enter a number into the Maximum number of characters (def. text) field if desired. This specifies how many characters are exported for the item name.

Preview text

This option does not affect this format.

Description

Select the text that you want to transfer as description. Enter a number into the Maximum number of characters (def. text) field if desired. This specifies how many characters are exported for the description. Activate the option Remove HTML tags if you want HTML tags to be removed during the export. If you only want to allow specific HTML tags to be exported, then enter these tags into the field * Permitted HTML tags, separated by comma (def. text)* field. Use commas to separate multiple tags.

Target country

Select the target country from the drop-down list.

Barcode

Select the ASIN, ISBN or a GTIN from the drop-down list.
Note: The barcode has to be linked to the order referrer selected above. Otherwise, the barcode will not be exported.

Image

Select Position 0 or First image.

  • Position 0 = An image with position 0 is transferred.

  • First image = The first image is transferred.

Image position of the energy label

Enter the position of the energy label. Every image that should be transferred as an energy label has to have this position.

Stock buffer

This option does not affect this format.

Stock for variations without stock limitation

This option does not affect this format.

Stock for variations with no stock administration

This option does not affect this format.

Live currency conversion

Activate this option to convert the price into the currency of the selected country of delivery. The price has to be released for the corresponding currency.

Sales price

Select gross price or net price from the drop-down list.

Offer price

Activate to transfer the offer price.

RRP

This option does not affect this format.

Shipping costs

Activate this option if you want to use the shipping costs that are saved in a configuration. If this option is activated, then you are able to select the configuration and the payment method from the drop-down lists. Activate the option Transfer flat rate shipping charge if you want to use a flat rate shipping charge. If this option is activated, a value has to be entered in the line underneath.

VAT note

This option does not affect this format.

Item availability

Activate the overwrite option and enter item availabilities into the fields 1 to 10. The fields represent the IDs of the availabilities. This overwrites the item availabilities that are saved in the Setup » Item » Availability menu.

s, all items are exported. . Save () the settings.
→ The export format GoogleShopping-Plugin is given an ID.
→ The export format is shown in the Exports overview. . Save the URL displayed in the URL field at GoogleShopping.

Table 1 lists details for settings, format settings and recommended item filters for the format GoogleShopping-Plugin.

Table 2. Format settings and recommended item filters for the format GoogleShopping-Plugin
Setting Explanation

Settings

Name

Enter a name. The export format is listed under this name in the overview in the Exports tab.

Type

Select the type item from the drop-down list.

Format

Select GoogleShopping-Plugin.

Limit

Enter a number. If you want to transfer more than 9,999 data records to the interface, the output file will not be generated again for another 24 hours. This is to save resources. If more than 9999 data records are necessary, activate the option Generate cache file.

Generate cache file

Activate this option if you want to transfer more than 9999 data records to the interface.
Note: We recommend that you do not activate this option for more than 20 export formats. This is to ensure a high performance of the elastic export.

Provisioning

Select URL. Use this option to generate a token for authentication in order to allow external access.

Token, URL

Click on Generate token.
→ The token is entered automatically.
→ A URL is created in the field URL.

File name

The file name must have the ending .csv or .txt for GoogleShopping to be able to import the file successfully.

Item filters

Add item filters

Select the items you wish to export. Select one or more of the following item filters from the drop-down list and click on Add. There are no filters set by default. It is possible to add all of the item filters listed below from the drop-down list one after the other.

  • Variations = Select the variations to be transferred.

    • Transfer all = All variations are transferred.

    • Only transfer main variations = Only main variations are transferred.

    • Do not transfer main variations = Only the variations of an item are transferred. Main variations are not transferred.
      Tip: Use this filter option if the main variations are virtual and not for sale.

    • Only transfer single variations = Only the main variations of items are transferred that have only a main variation and no other variations.

  • Markets = Select one or more order referrers. The selected order referrer has to be active at the variation for the item to be exported.

  • Currency = Select a currency.

  • Category = Activate to transfer the item with its category link. Only items that belong to this category are exported.

  • Image = Activate to transfer the item with its image. Only items with images are transferred.

  • Client = Select a client.

  • Stock = Select which stocks should be exported.

  • Flag 1-2 = Select a flag.

  • Manufacturers = Select one, several or ALL manufacturers.

  • Active = Activate if you only want to export active variations.

Format settings

Product URL

Choose the URL that you wish to transfer to the interface. You can choose between the item’s URL and the variation’s URL.
Note: URLs of variations can only be transferred in combination with the Ceres plentyShop.

Client

Select a client. This setting is used for the URL structure.

URL parameter

Enter a suffix for the product URL if this is required for the export.
→ This character string is added to the product URL if you have activated the transfer option for the product URL further up.

Order referrer

Select the order referrer that should be assigned during the order import from the drop-down list.
→ The selected referrer is added to the product URL so that sales can be analysed later.

Marketplace account

Select the marketplace account from the drop-down list.

Language

Select the language from the drop-down list.

Item name

Select Name 1, Name 2 or Name 3. The names are saved in the Texts tab of the item. Enter a number into the Maximum number of characters (def. text) field if desired. This specifies how many characters are exported for the item name.

Preview text

This option does not affect this format.

Description

Select the text that you want to transfer as description. Enter a number into the Maximum number of characters (def. text) field if desired. This specifies how many characters are exported for the description. Activate the option Remove HTML tags if you want HTML tags to be removed during the export. If you only want to allow specific HTML tags to be exported, then enter these tags into the field Permitted HTML tags, separated by comma (def. text) field. Use commas to separate multiple tags.

Target country

Select the target country from the drop-down list.

Barcode

Select the ASIN, ISBN or a GTIN from the drop-down list.
Note: The barcode has to be linked to the order referrer selected above. Otherwise, the barcode will not be exported.

Image

Select Position 0 or First image.

  • Position 0 = An image with position 0 is transferred.

  • First image = The first image is transferred.

Image position of the energy label

Enter the position of the energy label. Every image that should be transferred as an energy label has to have this position.

Stock buffer

This option does not affect this format.

Stock for variation without stock limitation

This option does not affect this format.

Stock for variations with no stock administration

This option does not affect this format.

Live currency conversion

Activate this option to convert the price into the currency of the selected country of delivery. The price has to be released for the corresponding currency.

Sales price

Select gross price or net price from the drop-down list.

Offer price

Activate to transfer the offer price.

RRP

This option does not affect this format.

Shipping costs

Activate this option if you want to use the shipping costs that are saved in a configuration. If this option is activated, then you are able to select the configuration and the payment method from the drop-down lists. Activate the option Transfer flat rate shipping charge if you want to use a flat rate shipping charge. If this option is activated, a value has to be entered in the line underneath.

VAT note

This option does not affect this format.

Item availability

Activate the overwrite option and enter item availabilities into the fields 1 to 10. The fields represent the IDs of the availabilities. This overwrites the item availabilities that are saved in the Setup » Item » Availability menu.

3. Available columns for the export file

Open the export format GoogleShopping-Plugin in the Data » Elastic export menu to download and edit the export file.

Downloading the export file:

  1. Go to Data » Elastic export.

  2. In the line of the format GoogleShopping-Plugin, click on Download ().
    → The file is downloaded and saved on your computer.

  3. Open the export file with an appropriate program.

Table 3. Available columns of the export file for the export format GoogleShopping-Plugin
Column header Explanation

id

The Google Shopping SKU of the variation.

title

According to the format setting Item name.

description

According to the format setting Description.

google_product_category

According to the setting Setup » Markets » Google » Google Shopping Int.. The Google Shopping category for the default category.

product_type

The name of the default category linked to the variation.

link

The URL path of the item depending on the chosen client in the format settings.

image_link

URL of the image. Variation images are prioritised over item images.

additional_image_link

Additional comma separated image URLs for up to 10 images. Variation images are prioritised over item images.

condition

The condition of the item according to Item » Edit item » Global » Basic settings » Condition for API.

availability

The name of the item availability saved in the Setup » Item » Availability menu or the translation according to the format setting Overwrite item availability.

price

The sales price.

sale_price

The offer price of the variation according to the setting offer price.

brand

The name of the manufacturer of the item. The external name saved in the Setup » Item » Manufacturers menu is preferred if existing.

gtin

According to the format setting Barcode.

isbn

The ISBN of the variation.

mpn

The model of the variation.

color

The colour of the variation according to the attribute or characteristic. Characteristics are prioritised.

size

The size of the variation according to the attribute or characteristic. Characteristics are prioritised.

material

The material of the variation according to the attribute or characteristic. Characteristics are prioritised.

pattern

The pattern of the variation according to the attribute or characteristic. Characteristics are prioritised.

item_group_id

The item ID of the variation.

shipping

According to the format setting Shipping costs.

shipping_weight

The shipping weight of the variation.

gender

The gender according to the Google Shopping characteristic gender.

age_group

The age group according to the Google Shopping characteristic age group.

excluded_destination

Empty.

adwords_redirect

Adwords Redirect according to the Google Shopping characteristic AdWords Redirect.

identifier_exists

The value is true if a combination of the attributes brand + GTIN or brand + mpn is available. Otherwise the value is false.

unit_pricing_measure

The unit of the variation.

unit_pricing_base_measure

The base unit of the variation according to unit_pricing_measure.

energy_efficiency_class

The energy efficiency class according to the Google Shopping characteristic energy efficiency class.

size_system

The size system according to the Google Shopping characteristic size system.

size_type

The size type according to the Google Shopping characteristic size type.

mobile_link

The mobile link according to the Google Shopping characteristic mobile link.

sale_price_effective_date

The duration of special offers according to the Google Shopping characteristic sale price effective date.

adult

Empty.

custom_label_0

The custom label 0 according to the Google Shopping characteristic Custom label 0.

custom_label_1

The custom label 1 according to the Google Shopping characteristic Custom label 1.

custom_label_2

The custom label 2 according to the Google Shopping characteristic Custom label 2.

custom_label_3

The custom label 3 according to the Google Shopping characteristic Custom label 3.

custom_label_4

The custom label 4 according to the Google Shopping characteristic Custom label 4.

availability_date

The release date of the variation.

4. License

This project is licensed under the GNU AFFERO GENERAL PUBLIC LICENSE. Find further information in the file LICENSE.md .

To top