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
2.4K members online now
2.4K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Use of "take latest" rule on merchant center doesn't work as documented

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

I am trying to set a Rule, which will take the latest value of a sale_price based on two feeds (one primary and one supplemental). Both feeds are fetched at different times, so the price should take the latest value from the later fetched feed.

 

Google support states (link):

We can set up a rule: my_first_feed.sale_price and my_supplemental_feed.sale_price

 

Problem

When trying to apply this rule, it doesn't work. It only takes one feed as a source so it always keeps the latest value from one feed. Also adding another source doesn't work because the second source has a predefined condition "Update attribute if sale price has no value", and as a result, this won't be applied. It seems like a bug or miss-alignment between documentation and UI. 

Screenshot 2018-07-24 10.45.01.png

 

Question:

Is there any way to update sale price 2 times per day using 2 different feeds for the same product, by using a feed rules?

 

Thank you,

John

2 Expert replyverified_user

Re: Use of "take latest" rule on merchant center doesn't work as documented

Top Contributor
# 2
Top Contributor
Simple answer no.

Supplement feeds are not intended to update the final attributes at different times. If you wan to update the price more than once per day, you need to use Google Shopping Content API https://developers.google.com/shopping-content/v2/quickstart
Supplement feed is intended to merge data, when the primary feed does not have the final attribute you want to use.

Using a static data feed does not allow you to update the feed more than once per day.

Hope this helps.
Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

Re: Use of "take latest" rule on merchant center doesn't work as documented

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
It makes total sense and we would go with content API if there is no workaround.

My only concern is that Google mentions the following, that can't be replicated with merchant rules:
For attributes related to price and availability only, use Take latest to find the most recently updated value from two or more feeds, and use it to populate your attribute.

Re: Use of "take latest" rule on merchant center doesn't work as documented

Top Contributor
# 4
Top Contributor
You are right, it does say that in the documentation.

When you update the supplement feed, to check the results you need to wait at least 2 to 3 hours. The products will not update quicker than that.

Are you sure you waited long enough?
Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

Re: Use of "take latest" rule on merchant center doesn't work as documented

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Yes. Actually, I let it the whole night to check if there will be a change but didn't work. 

 

From what I see, what is mentioned on documentation, it can't be replicated with merchant rules; Or I am just misunderstanding something from the docs Smiley Happy 

Re: Use of "take latest" rule on merchant center doesn't work as documented

[ Edited ]
Top Contributor
# 6
Top Contributor

in the legacy-merchant-center, an inventory-feed was allowed,
to submit only a price or availability, so that the entire item-data
need not be submitted, simply to update a price or availability.

the take-latest-rule was primarily intended to replace an inventory-feed.

at last check, take-latest worked as documented --

be certain to verify at least the following:

(a) the primary-feed shown, under the item's technical-details,
when clicking on the item's title under the products-list-tab,
exactly matches the primary-feed used for the rules-settings.

(b) the id value, within the supplemental-feed, exactly matches
the id value, set within the primary-feed, for the item-offer --

also, be certain any price includes a number, space, and a

proper three-letter iso-currency that matches the currency

of the primary-feed's registered target-country.

(c) only price, sale_price, or availability are set for the take-recent-rule.

(d) there are at least two feed (sources) set for the take-recent-rule --
typically, at least both the supplemental-feed and primary-feed.

generally, ignore final, no-value rules -- these are always the default.

(e) the supplemental-feed is properly-linked to the primary-feed (used-in)
and the primary-feed-rule lists at least three rules for the attribute --
one for each source, and the default.

(f) the supplemental-feed as been successfully fetched and fully processed --
via fetch-now for a google-sheet, or a manual-fetch, or ftp, or scheduled-fetch.

(g) verify the results under the products-lists-tab --
by clicking on the item's title and carefully inspecting the item-status,
raw-feed-attributes for the supplemental-feed, the raw-feed-attributes
for the primary-feed, and the final-attributes -- after full processing of
the matching feed-rule's supplemental-feed.

 

the processed rule values may also be verified under the edit-rule-settings,
by clicking on the summary/final-draft-box/arrow, aside cancel/save-as-draft.


importantly perhaps, if an item-offer has price or availability details
that update too often, or too quickly, to meet shopping-ad policies --
even with a take-latest-rule/inventory-feed or the api, then in those
cases, other ad-formats or campaign-types may be a better fit, to
avoid disapprovals or a permanent suspension from the program.

 

Re: Use of "take latest" rule on merchant center doesn't work as documented

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

@Celebird So based on what you mentioned, a, b, c, d, f and g are ok

 

My concern is about e). Below a screenshot of what I've got (BE_NL->primary, test benl..->supplemental). Does this align with what you mentioned?

 

Screenshot 2018-07-24 12.52.40.png

Re: Use of "take latest" rule on merchant center doesn't work as documented

[ Edited ]
Top Contributor
# 8
Top Contributor


the rules in that screen-capture look to be reversed --

especially with respect to (d) and (e).

if so, the reversal may sometimes be fixed by simply clicking on
the up/down arrows, in the data-source-rules, under edit-rule --
and verifying the result by clicking the greater-than-arrow,
in the summary/final-draft-box, aside cancel/save-as-draft.

however, forum-members can mainly offer suggestions,
based on information posted, here in the public-forum --
forum-members cannot verify account-specific details,
such as feed-registration or feed-rule data-sources.

google may be contacted for account-specific guidance.

 

Re: Use of "take latest" rule on merchant center doesn't work as documented

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭
Yes, I expect that I just wanted to be on the same page.

It seems that even the re-ordering didn't work out. I'll reach to Google or proceed with the Content API

Re: Use of "take latest" rule on merchant center doesn't work as documented

[ Edited ]
Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭

Update for anyone interested, there is a technical issue on 'take latest' rule. I have spoken with Google Support and they confirmed that are working to fix it.