Menu Close

    Opencart Google Shopping Feed

    If you have ever searched any product then you must be aware of the Google Shopping Ads which are available on the top right page of the Google search.

    With the help of this extension, the store owner will be able to display their products on the Google search page in an attractive and visual manner.

    Allowing the Opencart store owners to create Google Product feeds for their store’s products, exporting the products to the Google Merchant account.

    The admin can also map the categories of the Opencart Store with the Google Shopping Feed Categories.

    Features

    • Store products add to Google Feed using content API.
    • Products get updated on Google Feed once synced on the store.
    • Dynamic Attribute mapping.
    • Map store category with Google shopping feed categories.
    • Export all products in a single go.
    • The admin can add unique shopping feed product value for each product.
    • Supports Simple and Downloadable products.
    • Option to Authenticate the Merchant account of the user.

    Video Tutorial

    2-IGf4lUfXU

    Get the Keys/ Consent Screen –

    b0aGlUa1BPI

    Installation

    Customers will get a zip folder then they have to extract the contents of this zip folder on their system. The extracted folder has – admin, catalog, system, vendor folder, composer file, and ocmod file.

    Searching for an experienced
    Opencart Company ?
    Read More

    You need to transfer the admin, catalog, system, vendor folders, composer file, and ocmod file into the Opencart root directory on the server as shown below.

    installation

    Run Commands

    After uploading the files, run the following commands in the terminal for installing the composer.json file.

    curl -s http://getcomposer.org/installer | php

    php composer.phar install

    Note: – You have to increase post_max_size to 200M.

    After that, you will navigate to-> Extension Installer then upload the file google_shopping_feed.ocmod.xml which you will find inside the ocmod folder.

    After uploading the file click continue as shown below.

    extension upload

    Now navigate to->Extensions->Modifications then click refresh on the top right-hand side as shown below.

    modification

    Edit User Groups

    After that, go to System>Users>Usergroups. And then edit ‘Administrator’. Click Select All for both Access Permission then Modify Permission and Save it.

    edit permissions

    After that under Extension > Modules>Google Shopping Feed. You can install the Opencart Google Shopping Feed by clicking on the plus option as shown in the image below.

    installation

    Module Configuration

    After the installation is completed, the admin can navigate to Extensions > Module > Google Shopping Feeds. After that, the admin can click on the edit button as shown in the image below.

    edit

    By clicking on the edit button, the admin can configure the module. The following sections will appear:

    Status:  The admin can select the status of the module as enable or disable.

    Configuration Setting: The admin needs to enter the Consumer Key ID and the Consumer Secret ID which the admin can get by clicking on the here button.

    authenticate account

    After entering the credentials, the admin needs to click on the authenticate account to authenticate the credentials.

    The admin needs to verify with the registered email id via which the Google Shopping Feed credentials are created.

    account

    After the authentication, the admin can export all the products by clicking on the Export Product as shown in the image below.

    shopping feed

    Category Mapping Setting:

    The admin can set the default Google Feed Category which will be applied when the category is not mapped for the product.

    category mapping setting

    Product Setting:

    The admin can set the default setting which will be applied to the products whose details are not filled.

    product setting

    The listed settings that can be set are as follow:

    Age Group: 

    The admin can set the default Age Group for which the product is suitable like: Adult, Infant, Kid, Toddler, and Newborn.

    Product Available For: 

    The admin can set the product availability for the Male, Female, and Unisex.

    Product Condition: 

    The admin can set the default conditions of the products like New, Used, and Refurbished.

    Apply Tax on Ship: 

    The admin can choose to set the tax on a product or not.

    Note: Tax on ship will only be applicable in the US if set as “Yes”

    Tax Rate(%): 

    The admin can set the tax rate under the following entity.

    Target Country: 

    The admin can set the target country in which the product feeds are to be displayed.

    Content Language: 

    The admin can set the language in which the product content will be displayed.

    Product Color: 

    The admin can set the product option which is to be displayed on the color description of the product.

    How To Get The Google Shopping Feed Credentials

    Create APP, Get the Client Id & Secret:

    1: Go to console.developers.google then log in using your Gmail Id. After login click Select a Project option.
    google shopping feed magento 2

    2: Click the NEW PROJECT option.

    google shopping feed magento 2

    3: Enter your project name and select the location and click the Create button.

    google shopping feed magento 2

    4: Select your created project then click ENABLE APIS & SERVICES button.

    google shopping feed magento 2

    5: Now type Shopping in search box.

    google shopping feed magento 2

    6: The results will populate and then select – Content API for Shopping.

    google shopping feed magento 2

    7: Now select the created app. Then click on the Create Credentials button.

    google shopping feed magento 2

    8: Now select OAuth client ID as shown below in the snapshot.

    google shopping feed magento 2

    9: Under Application type select the Web Application, under the Authorized redirect URIs enter the redirect URL.

    Example:

    For version 3.x.x.x & 2.3.x.x:

    https://www.example.com/index.php?route=extension/module/google_feed/callback

    For version 2.2.x.x & lower versions:

    https://www.example.com/index.php?route=module/google_feed/callback

    Now, click the Create button.

    redirect url10: Now you can see the Consumer Key and the Consumer Secret Key. Copy them into the module configuration settings.

    credentials

    In order to create an OAuth client ID, you required to submit App name on the consent screen for verification. To do so, the admin will follow the below steps –

    1. Go to Google Cloud Console and navigate to the Oauth consent screen page as shown below.

    Google-Cloud-Platform

    2. Now, select your App’s project from the drop-down.

    Select-project

    3. Now, on the OAuth consent screen page, a create a consent screen will display. Here, select External and click on create button if you want to available this app to any test user with a Google Account.

    oauth-consent-screen-creation

    Else, click the Edit App button at the top of the page if you have already created a consent screen.

    edit-app

    4. Once you will click on Edit button, it brings you to configuration page. Here you need to enter all required details as shown in below screenshot –

    App-details

    After that, click on Save and continue button.

    5. To continue, also click on Save and continue button for Scopes and Optional info tab.

    6. You will be redirected to summary tab, once all required details is filled in. Here, verify that details on each page is correct then click on Prepare for verification button at the bottom.

    submit-the-app

    Sign Up Google Merchant

    1: Go to Merchant Center and click on the Sign-Up button.

    google shopping feed magento 2

    2Login with your Gmail address that you have used for creating the credentials and click the Next button.

    google shopping feed magento 2

    3: On the Terms & Condition page check the checkbox to agree to the terms & conditions and click Continue button after that.google shopping feed magento 2

    4: Now, you need to verify and claim your website URL as shown in the image below.

    google shopping feed magento 2 veriy and claim websiteAfter the above steps click Verify URL button.

    5: After clicking the verify button a pop-up will appear. Click Continue to proceed further for verification.

    google shopping feed magento 2 verify and claim website

    6: After clicking the Continue button in the image above, you can see that the website is verified and claimed. Lastly, click the Finish button.

    google shopping feed magento 2 verify and claim websiteNow, you can see the Google Merchant Center dashboard.

    merchant account

    Google Shopping Feeds – Admin’s End

    After the configuration of the module is completed, the admin will be able to see the Google Product Feeds menu with two sub-options:

    1. Category Mapping

    2. Product List 

    Category Mapping

    The admin can map the Opencart Category with the Google Category, by navigating through Google Product Feed >Category Mapping as shown in the image below:

    Category Mapping

    The admin can edit the existing Mapped Category or Map New Category. On clicking on the Map New Category, the following page will appear as shown in the image below.

    mapping category

    The Opencart category will be mapped with the Google feed category and its subcategory. After the category is selected, the admin needs to click on the Save Mapped Category button to map the categories. The Saved Categories will get listed on the Map Category List.

    If require the admin can also filter out the map categories based on Category Id, Category Name, Mapped Date From, Mapped Date To.

    Product List

    The admin can view the export products under this section as shown in the image below.

    export product list

    The admin can delete the selected products. To do so admin needs to click on the delete button.

    If the export product listing is not visible then the admin can click on here button. After that, the admin can authenticate the credentials again.

    authenticate

    If the admin requires to access the Google Merchant Account, then he/she can click on the here option as shown in the image below.

    here button

    Google Merchant Account

    After the admin has configured the extension, mapped categories, and exported the products to Google’s Merchant Account, the exported products will be visible under the Products>List section.

    List:

    Google-merchant-account
    Final Attributes:

    The admin can select any product and view the details of the respective products as well under the Final Attributes section as shown in the image below.

    merchants.google.com-2021.10.05-18_42_37-1

    Product Edit Page

    Apart from adding the products setting as default, the admin can edit the product feeds for any particular product as well. For this, the admin needs to navigate to the Catalog>Products>Edit Product.

    Under the Google Shopping Feed Fields section, the admin can enter the following fields that with the corresponding values that are needed to be sent.

    The admin needs to save the values for them before saving the product otherwise the default values set in the admin panel will be applicable for these new attributes.

    Google-shopping-feed-4

    That’s all for theOpencart Google Shopping Feed. Furthermore, If you have any queries or doubts get back to us at [email protected] or raise a ticket at webkul.uvdesk.com.

    Current Product Version - 2.0.2.0

    Supported Framework Version - 2.x.x.x,3.x.x.x

    . . .
    Discuss on Helpdesk

    Leave a Comment

    Your email address will not be published. Required fields are marked*


    6 comments

  • enoch
    from where I can get the redirect URL !! how can I get it ??
    • abhishek oberoi (Moderator)
      Hello Enoch,
      Greetings for the day!
      You need to add the same url as to where the admin will be redirected after they have authenticated the Google Feed Account.
      Thanks & Regards
      Team Webkul
  • Hieu Pham
    will it also upload images and all the variance and option in google merchant account
    • abhishek oberoi (Moderator)
      Hello Hieu,
      Greetings for the day!
      The product image link gets exported to the Google Merchant account and you can map any option with the product color option in the admin configuration. If you still have any issue or query then please mail us at [email protected].
      Thanks
      • PRATIK MOORJANI
        can you please check my web site is compatible for it fingerprint price
        • abhishek oberoi (Moderator)
          Hello Pratik,
          The module will work with any Opencart website, you just need to have a Google Merchant account. In case of any issue, you can mail us at [email protected].
          Thanks & Regards
          Team Webkul
  • Back to Top

    Table of Content