AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
4K members online now
4K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Re: Google Shopping - salePrice is not recognised

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

hi celebird,

 

I am new to this forum. sorry for writing in another thread. i was unable to find link to create a new threadScreenshot 2018-01-04 04.55.31.png. I am having issue with Merchant add on with Google spreadsheets. Every time I hit update I get oops something went wrong error. I am providing ld+json format in the head for the data.

 

<!--
* AUTHOR : MANOJ BHAGCHAND HEMNANI
*
* PROJECT : SANTEX
*
-->
<!DOCTYPE html>
<html dir="auto" lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="mobile-web-app-capable" content="yes">
<meta property="fb:app_id" content="367392587049893">
<!-- <meta property="og:title" content="Santex.io">
<meta property="og:description" content="Awesome fabrics at your doorstep!!">
<meta property="og:type" content="website">
<meta property="og:url" content="https://www.santex.io">
<meta property="og:image" content="https://storage.googleapis.com/santex-asia/logo_facebook.png">
<meta property="og:image:type" content="image/png">
<meta property="og:image:width" content="400">
<meta property="og:image:height" content="200">
<meta property="og:locale" content="en_US">
<meta property="og:locale:alternate" content="ar_AR"> -->
<link href="https://fonts.googleapis.com/css?family=Dancing+Script" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Droid+Serif" rel="stylesheet">
<link rel="apple-touch-icon" href="https://storage.googleapis.com/santex-asia/mobileLogo.png">
<link rel="apple-touch-startup-image" href="https://storage.googleapis.com/santex-asia/logo.png">
<meta name="apple-mobile-web-app-status-bar-style" content="black-translucent">
<link rel="manifest" href="manifest.json">
<link rel="shortcut icon" type="image/x-icon" href="https://storage.googleapis.com/santex-asia/logo.ico">
<title>Santex</title>
<script type='application/ld+json'>{"@context":"http://schema.org","@type":"Product","description":"Content: 100% co, Country: Japan, Weight: 150 GSM, Width: 44"/ 112 cms, Stretch: No, Stiffness: Flowy, Purpose: Jalabiya, Dresses, Tops","sku":255,"material":"cotton","category":"cotton","name":"Artsy Damask Cotton Jacquard","offers":{"@type":"Offer","url":"https://www.santex.io/stItem=255","availability":"http://schema.org/InStock","itemCondition":"http:/... #4, Plot #92, Mussafah Sector #37, Mussafah Industrial Zone"},"url":"https://www.santex.io","email":"support@santex.io","legalName":"Santex","foundingDate":"2017-01-11",... Dhabi City","addressRegion":"AZ","postOfficeBoxNumber":"35268","postalCode":"35268","streetAddress":"Shop #44, Floor #1, Madinat Zayed Shopping Centre, Muroor Rd."},"legalName":"Century Textiles Est.","foundingDate":"1987-12-19","telephone":"0097126334231","founder":[{"@type":"Person","nationality":"India","givenName":"Bhagchand","familyName":"Gordhandas Hemnani","gender":"http://schema.org/Male"}]},"founder":[{"@type":"Person","nationality":"India","givenName":"Nikhil","... Hemnani","email":"nikhil@santex.io","gender":"http://schema.org/Male","url":"https://www.linkedin.com/in/nikhil-hemnani-ba433017"},{"@type":"Perso... Hemnani","email":"manoj@santex.io","gender":"http://schema.org/Male","url":"https://ae.linkedin.com/in/manojhemnani"}]},"eligibleQuantity":{"@typ...>
</html>

 

I then get item error and warnings that none of the attributes were detected. I have provided id numbers and also the urls for the product pages. Please help!

 

 

1 Expert replyverified_user

Re: Google Shopping - salePrice is not recognised

[ Edited ]
Top Contributor
# 2
Top Contributor

the update-from-website/upload-sheet are optional features

from an ancillary add-on that requires proper id and link values

within the sheet before the update and before any upload, and
requires proper structured-data within the website, to properly
update the google-sheet cells -- these add-ons are not directly

connected with the normal merchant-center feed process.

json-ld with client-side scripts is not supported -- json-ld
must be static text, optionally with server-side scripting.

also, the structured-data must conform to all google's shopping-ad policies.

otherwise, the best likely course is to update the sheet manually, by-hand,
and then submit the feed directly from the merchant-center -- by clicking on
the feed-name and selecting fetch-now, from the drop-down three-dot-menu,
directly within the processing-tab.

otherwise, simply contact google-support directly --

to report the issue and for account-specific guidance.

 

see also

https://support.google.com/merchants/topic/3404780

 

<script type="application/ld+json">
{
  "@context": "http://schema.org/",
  "@type": "Product",
  "sku": "EXAMPLE-1337-json",
  "gtin14" : "12345678901234",
  "mpn": "925873",
  "image": "http://fake.example.com/test_executive.jpg",
  "name": "Executive test JSON-LD",
  "description": "This is just a boring example",
  "brand": {
    "@type": "Thing",
    "name": "EXAMPLE"
  },
  "color" : "Silver",
  "audience": {
    "@type": "PeopleAudience",
    "suggestedGender": "unisex"
  },
  "offers": {
    "@type": "Offer",
    "priceCurrency": "USD",
    "price": "119.99",
    "itemCondition": "http://schema.org/UsedCondition",
    "availability": "http://schema.org/InStock"
  }
}
</script>

 

Re: Google Shopping - salePrice is not recognised

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Celebird,

 

Thanks for the response. I believe that I am missing only the gtin14, mpn attributes and that I am providing an image object with url, width and height. I am currently, from my server, handling googlebot requests seperately providing a head-only html file with json ld setup. I am currently looking for user-agent strings to detect the crawlers. Here is the response I provide to a google crawler:

 

 

<!--  
 * AUTHOR : MANOJ BHAGCHAND HEMNANI
 * 
 * PROJECT : SANTEX 
 *
 -->
<!DOCTYPE html>
<html dir="auto" lang="en">
	<head>
		<meta charset="UTF-8">
		<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
		<meta name="apple-mobile-web-app-capable" content="yes">
		<meta name="mobile-web-app-capable" content="yes">
		<meta property="fb:app_id" content="367392587049893">
		<!-- <meta property="og:title" content="Santex.io">
		<meta property="og:description" content="Awesome fabrics at your doorstep!!">
		<meta property="og:type" content="website">
		<meta property="og:url" content="https://www.santex.io">
		<meta property="og:image" content="https://storage.googleapis.com/santex-asia/logo_facebook.png">
		<meta property="og:image:type" content="image/png">
		<meta property="og:image:width" content="400">
		<meta property="og:image:height" content="200">
		<meta property="og:locale" content="en_US">
		<meta property="og:locale:alternate" content="ar_AR"> -->
		<link href="https://fonts.googleapis.com/css?family=Dancing+Script" rel="stylesheet">
		<link href="https://fonts.googleapis.com/css?family=Droid+Serif" rel="stylesheet">
		<link rel="apple-touch-icon" href="https://storage.googleapis.com/santex-asia/mobileLogo.png">
		<link rel="apple-touch-startup-image" href="https://storage.googleapis.com/santex-asia/logo.png">
		<meta name="apple-mobile-web-app-status-bar-style" content="black-translucent">		
		<link rel="manifest" href="manifest.json">
		<link rel="shortcut icon" type="image/x-icon" href="https://storage.googleapis.com/santex-asia/logo.ico">
		<title>Santex</title>
		<script type='application/ld+json'>{"@context":"http://schema.org","@type":"Product","description":"Content: 100% co, Country: Japan, Weight: 150 GSM, Width: 44\"/ 112 cms, Stretch: No, Stiffness: Flowy, Purpose: Jalabiya, Dresses, Tops","sku":255,"material":"cotton","category":"cotton","name":"Artsy Damask Cotton Jacquard","offers":{"@type":"Offer","url":"https://www.santex.io/stItem=255","availability":"http://schema.org/InStock","itemCondition":"http://schema.org/NewCondition","offeredBy":{"@type":"Organization","vatID":"","address":{"addressCountry":"AE","addressLocality":"Mussafah","addressRegion":"AZ","postOfficeBoxNumber":"35268","postalCode":"35268","streetAddress":"Store #4, Plot #92, Mussafah Sector #37, Mussafah Industrial Zone"},"url":"https://www.santex.io","email":"support@santex.io","legalName":"Santex","foundingDate":"2017-01-11","logo":{"@type":"ImageObject","url":"https://storage.googleapis.com/santex-asia/logo.png","width":551,"height":158},"parentOrganization":{"@type":"Organization","vatID":"","address":{"addressCountry":"AE","addressLocality":"Abu Dhabi City","addressRegion":"AZ","postOfficeBoxNumber":"35268","postalCode":"35268","streetAddress":"Shop #44, Floor #1, Madinat Zayed Shopping Centre, Muroor Rd."},"legalName":"Century Textiles Est.","foundingDate":"1987-12-19","telephone":"0097126334231","founder":[{"@type":"Person","nationality":"India","givenName":"Bhagchand","familyName":"Gordhandas Hemnani","gender":"http://schema.org/Male"}]},"founder":[{"@type":"Person","nationality":"India","givenName":"Nikhil","familyName":"Bhagchand Hemnani","email":"nikhil@santex.io","gender":"http://schema.org/Male","url":"https://www.linkedin.com/in/nikhil-hemnani-ba433017"},{"@type":"Person","nationality":"India","givenName":"Manoj","familyName":"Bhagchand Hemnani","email":"manoj@santex.io","gender":"http://schema.org/Male","url":"https://ae.linkedin.com/in/manojhemnani"}]},"eligibleQuantity":{"@type":"QuantitativeValue","unitCode":"M","value":1},"priceSpecification":{"@type":"UnitPriceSpecification","valueAddedTaxIncluded":false,"priceCurrency":"AED","price":30}},"image":{"@type":"ImageObject","url":"https://storage.googleapis.com/santex-asia/20170726_145626.jpg","width":1920,"height":1080}}</script></head>
</html>

 

Here is the ld json script from the html file above:

 

 

<script type='application/ld+json'>
{
    "@context":"http://schema.org",
    "@type":"Product",
    "description":"Content: 100% co, Country: Japan, Weight: 150 GSM, Width: 44\"/ 112 cms, Stretch: No, Stiffness: Flowy, Purpose: Jalabiya, Dresses, Tops",
    "sku":255,
    "material":"cotton",
    "category":"cotton",
    "name":"Artsy Damask Cotton Jacquard",
    "offers":
    {
        "@type":"Offer",
        "url":"https://www.santex.io/stItem=255",
        "availability":"http://schema.org/InStock",
        "itemCondition":"http://schema.org/NewCondition",
        "offeredBy":
        {
            "@type":"Organization",
            "vatID":"",
            "address":
            {
                "addressCountry":"AE",
                "addressLocality":"Mussafah",
                "addressRegion":"AZ",
                "postOfficeBoxNumber":"35268",
                "postalCode":"35268",
                "streetAddress":"Store #4, Plot #92, Mussafah Sector #37, Mussafah Industrial Zone"
            },
            "url":"https://www.santex.io",
            "email":"support@santex.io",
            "legalName":"Santex",
            "foundingDate":"2017-01-11",
            "logo":
            {
                "@type":"ImageObject",
                "url":"https://storage.googleapis.com/santex-asia/logo.png",
                "width":551,
                "height":158
            },
            "parentOrganization":
            {
                "@type":"Organization",
                "vatID":"",
                "address":
                {
                    "addressCountry":"AE",
                    "addressLocality":"Abu Dhabi City",
                    "addressRegion":"AZ",
                    "postOfficeBoxNumber":"35268",
                    "postalCode":"35268",
                    "streetAddress":"Shop #44, Floor #1, Madinat Zayed Shopping Centre, Muroor Rd."
                },
                "legalName":"Century Textiles Est.",
                "foundingDate":"1987-12-19",
                "telephone":"0097126334231",
                "founder":
                [
                    {
                        "@type":"Person",
                        "nationality":"India",
                        "givenName":"Bhagchand",
                        "familyName":"Gordhandas Hemnani",
                        "gender":"http://schema.org/Male"
                    }
                ]
            },
            "founder":
            [
                {
                    "@type":"Person",
                    "nationality":"India",
                    "givenName":"Nikhil",
                    "familyName":"Bhagchand Hemnani",
                    "email":"nikhil@santex.io",
                    "gender":"http://schema.org/Male",
                    "url":"https://www.linkedin.com/in/nikhil-hemnani-ba433017"
                }, {
                    "@type":"Person",
                    "nationality":"India",
                    "givenName":"Manoj",
                    "familyName":"Bhagchand Hemnani",
                    "email":"manoj@santex.io",
                    "gender":"http://schema.org/Male",
                    "url":"https://ae.linkedin.com/in/manojhemnani"
                    }
            ]
        },
        "eligibleQuantity":
        {
            "@type":"QuantitativeValue",
            "unitCode":"M",
            "value":1
        },
        "priceSpecification":
        {
            "@type":"UnitPriceSpecification",
            "valueAddedTaxIncluded":false,
            "priceCurrency":"AED",
            "price":30
        }
    },
    "image":
    {
        "@type":"ImageObject",
        "url":"https://storage.googleapis.com/santex-asia/20170726_145626.jpg",
        "width":1920,
        "height":1080
    }
}
</script>

 

At the moment, ld+json is fully supported by merchant center and also that I am providing my response from the server as requested. How does merchant center make its requests?

 

I checked my logs after clicking the update button but couldnt detect any crawlers so I am unsure whether the merchant center is running at all or maybe I maybe I am missing the crawler.

 

Here is the crawlers I look for according to what is defined by google:

 

var googleBots = [
	"Google-Structured-Data-Testing-Tool",
	"GoogleBot",
	"APIs-Google",
	"Mediapartners-Google",
	"AdsBot-Google-Mobile",
	"AdsBot-Google-Mobile",
	"AdsBot-Google",
	"AdsBot-Google-Mobile-Apps"
];

I dont think that merchant center is doing a fresh fetch. If it was I would see the user-agent in my google cloud console logs.

 

Please any help would be much appreciated.

 

I wouldnt mind using content api either but I am not sure if there is a node js version of it.

 

Thanks,

 

Manoj Hemnani

Re: Google Shopping - salePrice is not recognised

[ Edited ]
Top Contributor
# 4
Top Contributor

first, you're welcome.

(a) again, the add-on is not part of the normal merchant-center process
for submitting inventory data -- any issues with the ancillary sheets-add-on
are best reported directly to google.

google has not documented any details concerning how the new add-on works.


otherwise, if the add-on is not functioning properly and contacting google
support directly cannot resolve the issue, the best likely course is to
fill-in the data directly into the sheet, by hand, or use another method
to populate the sheet with data, or to submit a feed-file more directly --
such as a plug-in, or more direct method such as a database-export into
a tab-delimited or google-xml formatted file, that adheres to all google's
rules and policies for shopping-ads.


(b) the merchant-center is not making any requests --
the add-on is making the requests and google has
not documented how the sheet-add-on gathers data;
the sheet-add-on may not use any crawler, at all.

(c) normally, the merchant-center crawls websites *after* proper inventory
(feed) data has been submitted -- to verify the submitted data matches the
website data and to verify that all shopping-ad rules and policies are being
followed; the merchant-center-crawls happen randomly and usually 72-hours
or so after inventory (feed) data has been submitted -- the merchant-center
crawls have nothing whatever to do with the sheet-add-on.

(d) the merchant-center uses structured-data for the automatic-item-updates
feature -- not to collect sheet-data; the sheets-add-on uses structured-data
to collect data and populate the sheet, but google has not documented how
this is accomplished; these two features are in no way connected and have
very different requirements and rules that must be met.

 

the structured-data on the website must conform to all shopping-ads rules;

shopping-ad rules are entirely separate from schema.org requirements --

the automatic-item-updates feature and the sheets-add-on have separate

and different requirements with respect to structured-data and the website

and landing-pages.

 

for example, pop-ups or overlays on landing-pages are not allowed.

 

for example, using user-agent strings to present different information

from what is presented to all users is a policy violation and is grounds

for a disapproval or a suspension from the program, at any time --

all data, including structured-data, should be displayed exactly

the same, regardless of any user specific detail, such as where

a user or robot is physically located, user-agent-string, browser,

device, ip-address, etc.

(e) questions about the content-api-for-shopping are
best asked within within their dedicated forum/group --
https://groups.google.com/forum/#!forum/google-content-api-for-shopping

generally, using both a feed and content-api
to submit inventory data is not recommended --
only one method should ever be used.

 

see also

https://support.google.com/merchants/answer/6363310

https://support.google.com/merchants/answer/7052112

https://support.google.com/merchants/topic/6386199

 

Re: Google Shopping - salePrice is not recognised

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi Celebird,

 

I am using user-agent strings to provide same information but in a suitable format for google platforms. There are formats of microdata that are required by each crawler. If I were, for example, to use html annotated microdata and json-ld as well in my web page then it would result in duplicate entries. I don't believe I am violating any policies by my approach. I guess I have to ask google support for how the merchant center add on works. Obviously I wouldn't use both feed and content api because again that would lead to duplicate entries. If content-api is available for node js then I would happily use that.

 

Thanks,

 

Manoj Hemnani