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

Automatic item updates due to incorrect prices

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I keep getting the error: Automatic item updates due to incorrect prices. The prices are correct. I have 30 prices that are similar to 35.99 USD and there is no problem, the two prices that are 1200.00 USD keep getting the error. I am using and excel spreadsheet and saving as Tab deliminated. I do not know what to change. Thanks for any help.

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Chris S
September 2015

Re: Automatic item updates due to incorrect prices

[ Edited ]
Top Contributor
# 2
Top Contributor


be certain there are no commas or quotes seen within
the resulting .txt tab-delimited file, after saving -- check
the .txt file within a browser window.

 

e.g. the price and currency seen in the .txt file should be exactly

1200.00 USD

not

1,200.00 USD or "1,200 USD" or similar.


also, try changing the entire column format to text;
some spreadsheets add commas or quotation-marks
automatically after re-saving the file -- that can only
be seen within the re-saved .txt file.

 

also, be certain there is no sale_price data being submitted or displayed.

 

if quotes are seen, check the use-quoted-fields settings for the feed;

if commas are seen, check the format of the spreadsheet's column;

generally, sale_price data will override the regular price information.

importantly, automatic-item-updates usually refers to
the website and specifically to schema.org micro-data
(rich snippets) being out of sync with the spreadsheet --
if so, the change would need to be the automatic-item
update setting within the account or the microdata on
the website landing-pages.

if automatic-item-updates are enabled then, the submitted price
and currency, the (single) displayed price and currency on the

link landing-page, the default add-to-cart price and currency,

and the microdata (itemprop) price and especially the currency,

must all initially match exactly, for all users regardless of location --

otherwise, this feature may need to be disabled.

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Chris S
September 2015

Re: Automatic item updates due to incorrect prices

[ Edited ]
Top Contributor
# 2
Top Contributor


be certain there are no commas or quotes seen within
the resulting .txt tab-delimited file, after saving -- check
the .txt file within a browser window.

 

e.g. the price and currency seen in the .txt file should be exactly

1200.00 USD

not

1,200.00 USD or "1,200 USD" or similar.


also, try changing the entire column format to text;
some spreadsheets add commas or quotation-marks
automatically after re-saving the file -- that can only
be seen within the re-saved .txt file.

 

also, be certain there is no sale_price data being submitted or displayed.

 

if quotes are seen, check the use-quoted-fields settings for the feed;

if commas are seen, check the format of the spreadsheet's column;

generally, sale_price data will override the regular price information.

importantly, automatic-item-updates usually refers to
the website and specifically to schema.org micro-data
(rich snippets) being out of sync with the spreadsheet --
if so, the change would need to be the automatic-item
update setting within the account or the microdata on
the website landing-pages.

if automatic-item-updates are enabled then, the submitted price
and currency, the (single) displayed price and currency on the

link landing-page, the default add-to-cart price and currency,

and the microdata (itemprop) price and especially the currency,

must all initially match exactly, for all users regardless of location --

otherwise, this feature may need to be disabled.

 

Re: Automatic item updates due to incorrect prices

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
I'm experiencing something similar and I think it might have to do with the trailing zeroes.

On my website, all of my prices are in full dollars (i.e. $33 USD rather than $33.47 USD). By dropping the trailing zeroes, the site looks cleaner and less cluttered, I can show the price in a larger font, it displays better on mobile, etc. In my feed, however, they show up as 33.00 USD. I think Google is looking at 33.00 and 33 and considering that a discrepancy.

Is it acceptable to put 33 USD into the feed rather than 33.00 USD? Or can Google confirm how they handle trailing zeros and fix it if there's a genuine bug there?

Re: Automatic item updates due to incorrect prices

[ Edited ]
Top Contributor
# 4
Top Contributor


33 USD and 33.00 USD should be acceptable;
33 USD and 33.47 USD would not -- under any circumstances.

similarly, (currency) symbols -- other than three-letter iso --
should not be used in any such data submitted to google.

otherwise, the issue depends on google's crawls,
any microdata, and other specifics on the website.

generally, be certain that there is only one, single, item
with one, single, price on the landing-page that matches
the submitted data exactly, as seen during a crawl and

for all users, regardless of physical location.