ssossossosso

Google Shopping connector

 
Google Shopping connector
  • 5.00 / 5 5
1 vote

Short Overview

DndGoogleShoppingConnectorBundle is a Symfony 2 extension that allows you to import your catalog from Akeneo XML files into Google Shopping.

HOW IT WORKS

This connector allows you to export your products into XML for Google Shopping and map your attributes to Google Shopping attributes.

You can read this Documentation to know the required attributes.

 

REQUIREMENTS

Akeneo PIM = 1.5

Akeneo labs CustomEntityBundle >= 1.7

 

INSTALLATION

If it's not already done, install Akeneo PIM.

Get composer (with command line):

$ cd /my/pim/installation/dir
$ curl -sS https://getcomposer.org/installer | php

First of all, install Akeneo labs CustomEntityBundle.

Then, install DnD-GoogleShoppingConnectorBundle with composer:

In your composer.json, add the following code:

In require:

{
    "agencednd/google-shopping-connector-bundle": "1.0.*"
}

In repositories:

{
    "type": "composer",
    "url": "https://packages.dnd.fr/"
}

Next, enter the following command line:

$ php composer.phar update

Enable the bundle in app/AppKernel.php file, in the registerBundles function, before the line return $bundles:

$bundles[] = new Dnd\Bundle\GoogleShoppingConnectorBundle\DndGoogleShoppingConnectorBundle();

If you use Akeneo PIM Enterprise Edition:

$ cd /my/pim/installation/dir
$ cp vendor/agencednd/google-shopping-connector-bundle/Dnd/Bundle/GoogleShoppingConnectorBundle/Model/ProductValue.php vendor/agencednd/google-shopping-connector-bundle/Dnd/Bundle/GoogleShoppingConnectorBundle/ModelProductValue.php

Next, in the app/config/config.yml file, add the following line under the pim_referencedata_ node :

   googleCategory:
        class: Dnd\Bundle\GoogleShoppingConnectorBundle\Entity\GoogleCategory
        type: simple

And, this line in the mapping_overrides node, under all the overrides :

       -
            original: PimEnterprise\Bundle\CatalogBundle\Model\ProductValue
            override: Dnd\Bundle\GoogleShoppingConnectorBundle\Model\ProductValue

End Akeneo PIM Enterprise Edition Specific

If you use Akeneo PIM Community Edition:

$ cd /my/pim/installation/dir
$ cp vendor/agencednd/google-shopping-connector-bundle/Dnd/Bundle/GoogleShoppingConnectorBundle/Model/ProductValue.php.ce vendor/agencednd/google-shopping-connector-bundle/Dnd/Bundle/GoogleShoppingConnectorBundle/Model/ProductValue.php

Next, in the app/config/config.yml file, add the following line under the pim_referencedata_ node :

   googleCategory:
        class: Dnd\Bundle\GoogleShoppingConnectorBundle\Entity\GoogleCategory
        type: simple

And, this line in the mapping_overrides node, under all the overrides :

       -
            original: Pim\Component\Catalog\Model\ProductValue
            override: Dnd\Bundle\GoogleShoppingConnectorBundle\Model\ProductValue

End Akeneo PIM Community Edition Specific

Finally, enter the following commands line:

$ php app/console doctrine:schema:update --force

CONFIGURATION AND USAGE

Create symlink for your images

If you manage your images in the PIM, you must create a symlink of the app/file_storage folder into the web folder :

$ ln -s /my/pim/installation/dir/web/file_storage /my/pim/installation/dir/app/file_storage

Import

  • Go to Collect > Import profiles and then create your GoogleShoppingConnectorBundle import categories profile.
  • Download the file of the taxonomies Taxonomy with numeric IDs in an Excel Spreadsheet (.xls) on Google Website.
  • Open this file in an editor like Open Office and save it as a CSV file.
  • Import this file with the previously created import profile.

 

PIM UI

  • As you can see, a new tab Reference data appeared which allows you to manage the Google categories (previously imported).
  • Create a new Reference data simple select attribute and select googleCategory in the field 'Choose the reference data type'.
  • Add the new google_category attribute to your families.
  • Classify your products with the new google_category attribute.

 

Export

  • Go to Spread > Export profiles and then create your GoogleShoppingConnectorBundle export products for Google shopping profile.
  • Fill the informations of your channel.
  • Map your attributes to Google Shopping attributes (leave empty if you don't use one of them, see the Documentation to know the required attributes).
  • You must map the field Product Category with the google_category attribute.

 

ROADMAP

  • Don't stop google export if one of the mapped attributes is not set
  • Show the name of the Google Categories in the grid depending of the PIM user default locale

 

ABOUT US

Dn’D assists companies since 12 years in the creation and development of customized digital solutions for web and E-commerce.

Founded by lovers of innovation and design, Dn’D Agency has a team of experts covering all areas of the web such as consulting, web design and development of interactive personalized solutions .The Agency Dn’D acts in all key steps of your web projects to ensure their success.

Our competence proficiency and synergy allow us to develop your competitiveness through quality and innovation , while ensuring respect for deadlines and a true customer service.

http://www.dnd.fr

to submit a support request