Merchant API: Getting Big With E-commerce Data. Part 1: Google Shopping API

Merchant API: Getting Big With E-commerce Data. Part 1: Google Shopping API

"Google
One of the most popular activities on the Web is shopping. It’s not surprising given that we can shop anywhere anytime: at home, at work, or even without getting out of bed.

As of 2019, e-commerce sales make up 13.7% of total sales representing $3.53 trillion of the $25.038 trillion value of the global retail market. What’s more, this trend is growing steadily. By 2021, global e-commerce is expected to approach $5 trillion and seize 17.5% of the market.

It’s only natural that more and more retail businesses move their operations to the Internet to keep up with the new buyer needs.

No wonder Google has its own e-commerce platform. Launched in far 2002, Google Product Search (known as Froogle back then) quickly took off and eventually became the dominant player in the online retail market.

Google Shopping: What You Need To Know About It

Google Shopping ads are designed to serve users with direct product overview related to their search. Here is how Google Shopping ads can be displayed:

Google Shopping rich snippet

We’ve long been working on adding Google Shopping rich snippets into Extra SERP API. It provides all valuable details of the shopping element: the snippet’s position, each product’s title, URL, price, and source.

That, however, doesn’t mean that Google Shopping is just another rich-snippet block in SERPs. Although it may sound a bit left field, Google Shopping is a stand-alone e-commerce platform extending far beyond the traditional ad-based business model. In fact, by adding a Shopping tab to the SERP and building a unique interface for it, Google quickly repositioned itself as a place where people can actually buy and sell things.

If you type the same “harry potter book set” query in Google Shopping, you’d see the following:
Google Shopping results page

The results page consists exclusively of paid product ads. You can also click on certain results to get more information about a particular product, including its reviews, sellers, similar items, and details.

It’s worth noting that the platform is expanding its reach and is currently available in 94 countries, with 50 called beta countries, where advertising performance may be a bit different from non-beta countries.

Google Shopping campaigns are of great use for promoting particular items, driving website traffic, and generating qualified leads. The cost of Google Shopping ads is established by bidding the maximum amount you are willing to pay for a click or an engagement. Though, you will often pay less than your max. CPC/CPE.

The higher click-through rate of Google Shopping ads vs. Search Ads or traditional text ads attracts more investment in the service. According to Merkle’s research, Google Shopping ads spend increased by 38% this year compared to last year. At the same time, Search Ads spend decreased by 12%.

Since Google Shopping is a paid service, no surprise it’s powered by Google Ads (formerly known as Google AdWords). However, there’s also another service involved – viz., the Google Merchant Center. While the first one represents the control panel for your shopping campaigns (including bids, budget, sales analytics, and more), the second one is used for managing your product feed, which is a file containing all the data on your merchandise.

While setting up Google Shopping ads is somewhat similar to configuring standard Google Ads, there’s one thing that makes them different. At Google Shopping, keywords don’t matter. Google takes into account your product data to define what queries can trigger your ads.

To make your Google Shopping ads campaign a revenue generator, you need:

  • A well-maintained product feed
  • Carefully thought-out account setup
  • Recurring campaign optimization
  • Systematic monitoring of performance metrics

Still, keeping tabs on overall campaign outcomes can be tough as it requires implementing effective data management. For this reason, as the platform evolved, it became necessary to provide advertisers with a resource to use its data for e-commerce analytics.

The Search API for Google Shopping: Evolution and Collapse

Google launched Search API for Shopping in 2010. It allowed businesses that advertised products on Google Shopping to extract and analyze the necessary information (such as prices, product descriptions, etc.) from the results pages. This API displayed outputs relying on the data gathered from users’ Merchant Center feeds. What’s more, back then, Google offered a separate Search API for Shopping, that allowed collecting product information programmatically.

Nonetheless, all that was too good to last long. In 2013 Google decided to shut down Search API for Shopping, leaving thousands of retailers without a reliable source of e-commerce data.

We’re deprecating our Search API for Shopping, which has enabled developers to create shopping apps based on Google’s Product Search data. While we believe in the value this offering provided, we’re shifting our focus to concentrate on creating a better shopping experience for users through Google Shopping. We’ll shut the API down completely on September 16, 2013. – Google Official Blog

Moreover, Google never announced they had plans to provide a replacement. So, the door to Google Shopping data was closed.

DataForSEO Google Shopping API: Get Back In The Game

When Google first announced they would shut down Search API for Shopping, nobody could imagine how big of a gap would emerge in its place.

That, however, didn’t mean the connection point between Google’s e-commerce platform data and large retailers was lost. The gap got quickly filled up with third-party data providers that pretended to “have an ultimate substitute for Google’s API.”

Here at DataForSEO, we decided to invest our efforts in building something that an overwhelming majority of e-commerce API providers are not capable of. Namely, we designed the Google Shopping API so that our clients can regularly retrieve vast volumes of data. We are able to crawl Google Shopping SERPs and deliver real-time results at exceptional speed.

DataForSEO Google Shopping API is a concise set of endpoints for e-commerce analytics.

Google Shopping and Google Shopping HTML endpoints require defining the keyword, search engine, location, and language you need the results for. You can additionally specify the minimum or maximum price and set up sorting by prices. When using the second endpoint, you will get the HTML page of Google Shopping results. The first endpoint will supply the following details about each product displayed in the Google Shopping SERP:

  • Position
  • Product description
  • Product ID
  • Price
  • Rating
  • Feedback
  • Shop rating
  • Shop feedback
  • The URL of the shop

Google Shopping Sellers and Google Shopping Product Specification endpoints work similarly to the ones described above. The only difference is that you should specify the product ID instead of a keyword to retrieve the results.
The second endpoint will serve you with accurate product data: ID, title, price on the specification page, base price, product specification (including title and description, brand, part numbers, GTIN).

Google Shopping Sellers endpoint is designed to deliver a full overview of sellers and market prices of a particular product, including:

  • Product ID
  • Position of the product
  • Product title
  • Seller’s name
  • Base price
  • Delivery price
  • Total price
  • Shop rating
  • Shop feedback
  • Ad’s ‘aclk’ parameter

Speaking of the former, you can use the unique click referral parameter in Google Shopping Sellers Ad URL endpoint to retrieve a direct URL linked to the product, promoted by Google Ads on Google Shopping store.

As you can see, this complex of endpoints provides an extensive e-commerce dataset. The next part of the article showcases how you can leverage it to develop a measurable data strategy for your business.

DataForSEO Google Shopping API: What Is It Capable Of?

Our Google Shopping API can be used for many different purposes. It has been created for helping retailers get a solid data foundation for expedient business decisions.

Google Shopping endpoint: pricing and competitive research
Before setting up your Google Shopping ads campaign, you would want to estimate the competition in Google Shopping SERP for the keywords you plan to target. With DataForSEO, you can review accurate ads positions for various locations. It will help you evaluate the competition and build a viable pricing strategy adjusted to specific regions.

When you have your ads campaign up and running, there is another benefit in using this endpoint. You can compare your vs. competitors’ rankings for the keywords you target to make the necessary adjustments to your product info.

Google Shopping Product Specification: automate product descriptions management
We know that launching a Google Shopping ads campaign can be tough, especially when it comes to creating and managing the product feed. However, you can cross out the daunting task of writing product descriptions from your ‘to-do-list.’ Just enter your product IDs to set the Google Shopping Product Specification task, receive their descriptions collected by our API, and use them for your products.

Google Shopping Sellers endpoint: competitive price analysis
You must be well aware that any ads campaign needs monitoring and timely updates. To get the product prices list of your competitor advertisers, use Google Shopping Sellers endpoint.

By indicating the product ID and the necessary locations, you will receive the list of sellers and prices. In addition to base product price, the endpoint provides the delivery price to the region of search. The retrieved data will help you adjust the pricing to better advertise and market your product for target locations.

Google Shopping Sellers Ad URL endpoint: discover your competitors
Apart from knowing the prices and brand names of your competitors, sometimes it is also necessary to have at hand a list of direct webpages where the product is being sold. This endpoint is designed for pulling out those direct URLs.

The thing is, Google uses a different URL in Google Shopping results. Meaning, when a user clicks on an ad, they get redirected to the seller’s website through the link you can find in the ‘result_shop_ad_url’ field of Google Shopping Sellers results. This link contains information encoded by Google for tracking the ad clicks.

That’s why, if you need a webpage link of the advertised product, you can’t get it from Google SERP or Google Shopping results. But you can get it with Google Shopping Sellers Ad URL endpoint specifying the ‘aclk’ parameter.

As now you get the idea of what purposes each endpoint may serve, let’s observe how Google Shopping API works.

DataForSEO Google Shopping API In Action

Monitoring products’ positions on the Google Shopping results pages can sometimes get tricky because sellers can’t specify keywords they want their product to show up for. As you already know, Google automatically determines what keywords this or that product will be ranking for based on the seller and product descriptions. Secondly, the positions of the items on the Google Shopping SERP change incredibly fast. Something as simple as page reload can cause a complete regrouping of the results.

Nonetheless, checking up with the results is very useful when it comes to monitoring competitor’s product rankings for your targeted keywords. You can take these keywords from the Search Terms Reports at Google Ads and then get Google Shopping results for them using our Google Shopping endpoint.

1Let’s get a results page for the “harry potter book set” query.

Request Sample

https://api.dataforseo.com/v2/merchant_google_shopping_tasks_post
   
{
    "data":
        {
            "874654654":
                {
                    "priority": 2,
                    "se_id": 2933,
                    "se_language":"English",
                    "loc_name_canonical":"United Kingdom",
                    "key":"harry potter book set"
                }
        }
}

Response Sample

{
    "status": "ok",
    "results_time": "0.1234 sec.",
    "results_count": 1,
    "results": {
        "874654654": {
            "post_id": 874654654,
            "post_key": "harry potter book set",
            "task_id": 13154465947,
            "se_id": 2933,
            "loc_id": 2826,
            "key_id": 326170,
            "status": "ok"
        }
    }
}

2The response contains TOP100 Google Shopping results for the specified keyword. Each result includes the product’s name, description, price, rating, number of reviews, plus both Google Shopping and product page URLs. Along with this data, you will get related search queries info and ads positions from SERP in the “paid” field.
Google Shopping search results

Request Sample

https://api.dataforseo.com/v2/merchant_google_shopping_tasks_get/13154465947

Response Sample

{
    "status": "ok",
    "results_time": "0.1044 sec.",
    "results_count": 101,
    "results": {
        "organic": [
            {
                "task_id": 13154465947,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 2826,
                "key_id": 326170,
                "post_key": "harry potter book set",
                "result_position": 1,
                "result_datetime": "2019-12-09 13:45:31 +00:00",
                "result_title": "Harry Potter Complete Collection",
                "result_description": "A beautiful boxed set containing all seven Harry Potter novels in paperback. These new editions of the classic and internationally bestselling, multi-award-winning series ...",
                "result_product_id": "17521530567564758368",
                "result_price": 27.99,
                "result_currency": "GBP",
                "result_stars": 4.84,
                "result_reviews_count": 425,
                "result_shop_stat": 95,
                "result_shop_stat_type": "stars",
                "result_shop_stat_count": null,
                "result_tags": [
                    "by J. K. Rowling, Jonny Duddle",
                    "Bloomsbury Publishing Plc",
                    "Paperback",
                    "3422 pages"
                ],
                "result_spell": null,
                "result_best_match": false,
                "result_url": "https://www.aldi.co.uk/harry-potter-complete-collection/p/020475332803200",
                "result_shopping_url": "https://www.google.co.uk/shopping/product/17521530567564758368?q=harry+potter+book+set&num=100&ie=UTF-8&oe=UTF-8&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE&prds=epd:14735185823686168433,paur:ClkAsKraX9OKAsXAVvmfd2Qoce-rnNKFjOKQfim-LpGtydW2ygy2kQoDDt2ps3eSTPA_WosGAIEQbRhgsWj6QnMWYmQ2OXpDodQny8ZR54R-aYJydFka9AczHBIZAFPVH70DfQmEtoh7Fmuhff9o11pFLtWLNw,prmr:1&sa=X&ved=0ahUKEwiw1aPV2ajmAhULmRQKHadvAeQQ8gIIogg",
                "result_se_check_url": "https://www.google.co.uk/search?q=harry%20potter%20book%20set&num=100&tbm=shop&ie=UTF-8&oe=UTF-8&tbs=vw:l&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE"
            },
            {
                "task_id": 13154465947,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 2826,
                "key_id": 326170,
                "post_key": "harry potter book set",
                "result_position": 2,
                "result_datetime": "2019-12-09 13:45:31 +00:00",
                "result_title": "Harry Potter Boxed Set: The Complete Collection (Adult Paperback)",
                "result_description": "These adult editions of J.K. Rowling's Harry Potter novels have been stylishly redesigned to showcase beautiful jackets by renowned woodcut artist Andrew Davidson. This ...",
                "result_product_id": "255981164494259516",
                "result_price": 34.88,
                "result_currency": "GBP",
                "result_stars": 5,
                "result_reviews_count": 1,
                "result_shop_stat": null,
                "result_shop_stat_type": "stars",
                "result_shop_stat_count": null,
                "result_tags": [
                    "by J. K. Rowling",
                    "Bloomsbury Publishing Plc",
                    "Paperback",
                    "3422 pages"
                ],
                "result_spell": null,
                "result_best_match": false,
                "result_url": "https://www.amazon.co.uk/Harry-Potter-Boxed-Set-Collection/dp/1408898659?source=ps-sl-shoppingads-lpcontext&psc=1?source=ps-sl-shoppingads-lpcontext&psc=1'",
                "result_shopping_url": "https://www.google.co.uk/shopping/product/255981164494259516?q=harry+potter+book+set&num=100&ie=UTF-8&oe=UTF-8&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE&prds=epd:10690842031609886033,paur:ClkAsKraX0HBwZ-ZR7aPXsoWillL5Wp1Uy84_7lsDGayA2WjFf99Ky1l7VQbwf6PhVTLnnTH2STKLYUmWCM_MBH_dFQypY9EC8Zxm-7cmUghaAwvw6KIdogD3RIZAFPVH73f_rwgVfNj0Gkz_WQZIzSQRCGQVw,prmr:1&sa=X&ved=0ahUKEwiw1aPV2ajmAhULmRQKHadvAeQQ8gIIsQg",
                "result_se_check_url": "https://www.google.co.uk/search?q=harry%20potter%20book%20set&num=100&tbm=shop&ie=UTF-8&oe=UTF-8&tbs=vw:l&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE"
            },
            {
                "task_id": 13154465947,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 2826,
                "key_id": 326170,
                "post_key": "harry potter book set",
                "result_position": 3,
                "result_datetime": "2019-12-09 13:45:31 +00:00",
                "result_title": "Harry Potter Box Set: The Complete Collection Children's Hardback",
                "result_description": "A beautiful boxed set containing all seven Harry Potter novels in hardback. These new editions of the classic and internationally bestselling, multi-award-winning series ...",
                "result_product_id": "6994987812640068390",
                "result_price": 37.89,
                "result_currency": "GBP",
                "result_stars": 4.84,
                "result_reviews_count": 425,
                "result_shop_stat": 97,
                "result_shop_stat_type": "stars",
                "result_shop_stat_count": 181,
                "result_tags": [
                    "by J. K. Rowling",
                    "Bloomsbury Publishing Plc",
                    "Hardback",
                    "3422 pages"
                ],
                "result_spell": null,
                "result_best_match": false,
                "result_url": "https://wilkesandotis.com/product/harry-potter-box-set-the-complete-collection-childrens-hardback/",
                "result_shopping_url": "https://www.google.co.uk/shopping/product/6994987812640068390?q=harry+potter+book+set&num=100&ie=UTF-8&oe=UTF-8&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE&prds=epd:14628254351748788100,paur:ClkAsKraXw2WfZob0L5qE4wNcV_go04NU8OelN8AznGxSyKFEFj1mnU5lsnPfWH6Hj8qMpXVZ1iTT8CALG9SHg96UvhRqHo8l5Xni0Fz71RoGNxHQ_iVLUykuhIZAFPVH72NOXnC_KQHr72daEccElupu8At_Q,prmr:1&sa=X&ved=0ahUKEwiw1aPV2ajmAhULmRQKHadvAeQQ8gIIvwg",
                "result_se_check_url": "https://www.google.co.uk/search?q=harry%20potter%20book%20set&num=100&tbm=shop&ie=UTF-8&oe=UTF-8&tbs=vw:l&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE"
            },

...

                      {
                "task_id": 13154465947,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 2826,
                "key_id": 326170,
                "post_key": "harry potter book set",
                "result_position": 100,
                "result_datetime": "2019-12-09 13:45:31 +00:00",
                "result_title": "Harry Potter Books Box Set",
                "result_description": "Find Harry Potter Books Box Set on eBay in the category Books, Comics & Magazines>Children's & Young Adults>Fiction.",
                "result_product_id": null,
                "result_price": 30,
                "result_currency": "GBP",
                "result_stars": null,
                "result_reviews_count": null,
                "result_shop_stat": null,
                "result_shop_stat_type": "stars",
                "result_shop_stat_count": null,
                "result_tags": [],
                "result_spell": null,
                "result_best_match": false,
                "result_url": "http://www.ebay.co.uk/i/113998400375?chn=ps",
                "result_shopping_url": null,
                "result_se_check_url": "https://www.google.co.uk/search?q=harry%20potter%20book%20set&num=100&tbm=shop&ie=UTF-8&oe=UTF-8&tbs=vw:l&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE"
            }
        ],
        "paid": [
            {
                "task_id": 13154465947,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 2826,
                "key_id": 326170,
                "post_key": "harry potter book set",
                "result_position": 1,
                "result_datetime": "2019-12-09 13:45:31 +00:00",
                "result_title": "Rating",
                "result_snippet": "New Top Quality Products Every Thursday & Sunday. Hurry, Once They're Gone, They're Gone. A Beautiful Boxed Book Set Containing All 7 Harry Potter Novels In Paperback. Types: Specialbuys, Pet Accessories, Kitchen, Garden Shop, DIY, Everyday Collections, Ski Wear, Toys.",
                "result_location": "",
                "result_spell": null,
                "result_url": "/url?esrc=s&q=&rct=j&sa=U&url=https://www.google.com/shopping/ratings/account/metrics%3Fq%3Daldi.co.uk%26c%3DGB%26v%3D4&ved=2ahUKEwiw1aPV2ajmAhULmRQKHadvAeQQ_aQDegQIABAE&usg=AOvVaw2FnWGf4Fo9dkbYRAyEyoDP",
                "result_se_check_url": "https://www.google.co.uk/search?q=harry%20potter%20book%20set&num=100&tbm=shop&ie=UTF-8&oe=UTF-8&tbs=vw:l&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCamRx0IRO1oCEXoliDJDoPjE"
            }
        ],
        "extra": {
            "related": [
                [
                    "harry potter complete book set",
                    "harry potter book set hardcover",
                    "harry potter hardback book set",
                    "harry potter book box set",
                    "harry potter full book set",
                    "harry potter book set special edition",
                    "harry potter paperback book set"
                ]
            ]
        }
    }
}

Another use of Google Shopping API is competitive price analysis. We will go through extracting data for the “Harry Potter Boxed Set: the Complete Collection” using its Google Shopping ID and DataForSEO Google Shopping Sellers endpoint.

Note that Google Shopping ID is different from the standard GTIN or MPN identifiers. It’s a unique set of numbers assigned to products by Google and indicated in the URL of the product’s page.
Google Shopping ID

1First things first, you’ll need to configure the request to Google Shopping API. Use Google Shopping ID of the product you’re interested in. Also, don’t forget to specify the location and the Search Engine ID. We recommend checking our documentation beforehand.

Request Sample

https://api.dataforseo.com/v2/merchant_google_shopping_shops_tasks_post

{
    "data":
        {
            "874654654":
                {
                    "priority": 2,
                    "se_id": 2933,
                    "loc_name_canonical":"London,England,United Kingdom",
                    "product_id": 255981164494259516
                }
        }
}
Response Sample 
{
    "status": "ok",
    "results_time": "0.0931 sec.",
    "results_count": 1,
    "results": {
        "874654654": {
            "post_id": 874654654,
            "product_id": "255981164494259516",
            "task_id": 13175642697,
            "se_id": 2933,
            "loc_id": 1006886,
            "status": "ok"
        }
    }
}

2 The results you’ll get reflect the info extracted from the “Online Shops” table at the product’s Google Shopping page.
Online Shops table from Google Shopping

Request Sample

https://api.dataforseo.com/v2/merchant_google_shopping_shops_tasks_get/13175642697
Response Sample 

{
    "status": "ok",
    "results_time": "0.0513 sec.",
    "results_count": 16,
    "results": {
        "organic": [
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 1,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "eBay - speedyhenuk",
                "result_base_price": 37.49,
                "result_delivery_price": null,
                "result_total_price": 37.49,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABABGgJ3cw&sig=AOD64_2Ca1TVndNK2WFgn15krWK82PDAww&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABABGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 2,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "AbeBooks",
                "result_base_price": 38.99,
                "result_delivery_price": null,
                "result_total_price": 38.99,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABADGgJ3cw&sig=AOD64_22W6REks5pKKVdJuYGCv_fHMGz4Q&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABADGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 3,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "eBay - wordery",
                "result_base_price": 34.85,
                "result_delivery_price": null,
                "result_total_price": 34.85,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABANGgJ3cw&sig=AOD64_1OZygSf1JxIUurjufItM9LmHv2CA&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABANGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 4,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "Amazon.co.uk",
                "result_base_price": 34.86,
                "result_delivery_price": null,
                "result_total_price": 34.86,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=L&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABALGgJ3cw&sig=AOD64_1sEbgCRv7SKVSvUNCXUJ7ExGCnKQ&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABALGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 5,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "eBay - ilovebooksetc",
                "result_base_price": 44.16,
                "result_delivery_price": null,
                "result_total_price": 44.16,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAMGgJ3cw&sig=AOD64_3TAzX-egA3v8_c0k9KkR65VWsfqQ&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAMGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 6,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "Blackwell's",
                "result_base_price": 45.18,
                "result_delivery_price": null,
                "result_total_price": 45.18,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAFGgJ3cw&sig=AOD64_1a9e6BSGFXCAo5UAdVzHXeacf0kw&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAFGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 7,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "BrightMinds",
                "result_base_price": 62.99,
                "result_delivery_price": null,
                "result_total_price": 62.99,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAKGgJ3cw&sig=AOD64_0Oc9AIHMDhw3CWvRtRcJcm_FUVmA&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAKGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 8,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "eBay - the_cosmetic_factory",
                "result_base_price": 41.49,
                "result_delivery_price": null,
                "result_total_price": 41.49,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAQGgJ3cw&sig=AOD64_2fUKwGfLfiN29rcy3kziY1dKcZvQ&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAQGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 9,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "eBay - mediaentertainment93",
                "result_base_price": 41.44,
                "result_delivery_price": null,
                "result_total_price": 41.44,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAUGgJ3cw&sig=AOD64_15f9Aw1J14YJ_42WRrSyQcmD3_Ew&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAUGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 10,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "eBay - dealsgenie",
                "result_base_price": 42.17,
                "result_delivery_price": null,
                "result_total_price": 42.17,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAVGgJ3cw&sig=AOD64_1IBooa2lHHvx37ev2sL3LLediIAA&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAVGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 11,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "OnBuy",
                "result_base_price": 37.48,
                "result_delivery_price": null,
                "result_total_price": 37.48,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAZGgJ3cw&sig=AOD64_1V3XoCWj84vqfEf72vc6v67Zv-WQ&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAZGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 12,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "eBay - ywiwgi",
                "result_base_price": 63.71,
                "result_delivery_price": null,
                "result_total_price": 63.71,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAWGgJ3cw&sig=AOD64_04QCFr3EY1X493mekHpcaGwK6fUA&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAWGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 13,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "Wordery",
                "result_base_price": 34.84,
                "result_delivery_price": null,
                "result_total_price": 34.84,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAaGgJ3cw&sig=AOD64_3l83VEGOhQCmrfjHPaxVEVAcbt0g&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAaGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 14,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "BookDepository.com",
                "result_base_price": 34.88,
                "result_delivery_price": null,
                "result_total_price": 34.88,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAcGgJ3cw&sig=AOD64_3PNQ2fjf0hZb7332Q6ctsVVEQO8g&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAcGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 15,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "SchoolDepot.co.uk Discounts",
                "result_base_price": 44.72,
                "result_delivery_price": null,
                "result_total_price": 44.72,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "5% Extra Savings On Top Of Massive DiscountsUse Code: SCHOOLDEPOTDEAL · Enter code at checkout · Ends in 52 days · Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAdGgJ3cw&sig=AOD64_3Co3GTr-lNeaFaCVzMEKvTY2atxw&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAdGgJ3cw"
            },
            {
                "task_id": 13175642697,
                "post_id": "874654654",
                "se_id": 2933,
                "loc_id": 1006886,
                "product_id": "255981164494259516",
                "result_position": 16,
                "result_datetime": "2019-12-10 12:35:05 +00:00",
                "result_title": "",
                "result_seller_name": "Hive.co.uk",
                "result_base_price": 43.19,
                "result_delivery_price": null,
                "result_total_price": 43.19,
                "result_currency": "GBP",
                "result_shop_stat": null,
                "result_shop_stat_type": null,
                "result_shop_stat_count": null,
                "result_details": "· Free delivery",
                "result_shop_ad_url": "https://www.google.co.uk/aclk?sa=l&ai=DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAgGgJ3cw&sig=AOD64_1e3FmOVEn8oieV-6TaOd1c_d6Lhw&adurl=&ctype=5&q=",
                "result_se_check_url": "https://www.google.co.uk/shopping/product/255981164494259516/online?&hl=en&gl=GB&gws_rd=cr&uule=w+CAIQIFISCXXeIa8LoNhHEZkq1d1aOpZS",
                "result_shop_ad_aclk": "DChcSEwjmpt3ii6vmAhUT-VEKHX6cDyoYABAgGgJ3cw"
            }
        ]
    }
}

As simple as that, we retrieved the required details with DataForSEO Google Shopping API.

Bottom Line

Historically, Google APIs were considered a safe bet. However, if we take the example of the Search API for Google Shopping – it’s no longer the case. Google wants people to use its services for searching and shopping. So the shutdown of the possibility to follow a different path when looking for products online came as no surprise.

Nonetheless, we are ready to provide you with a reliable alternative. Google Shopping API will deliver all the data you need for creating an extensive product list, run price monitoring of various shops, and foresee the competition. Offered at more than affordable price, DataForSEO Google Shopping API unlocks the closed door to e-commerce data.

You can use it with a free third-party API Connector for Google Sheets, and get all valuable stats straight in the spreadsheet. As a more advanced option, you can choose any programming language (check our documentation for examples in PHP, Python, Csharp, and Java) to develop an app that would update product info and stats automatically. Or we can do it for you.

George Svash

George is the Director of Content Marketing at DataForSEO, an API suite designed to help SEO software companies and agencies gather the SEO data they need for their projects. George is a tech and marketing geek with a deep passion for Big Data and SEO. Having a broad experience in content marketing and a degree in engineering, he is particularly good at explaining complex concepts.

No Comments

Sorry, the comment form is closed at this time.