Feed Date (FEEDDATE) function in rules allow you to produce the current date of when the feed is being compiled. Use the current date of the feed, as well as add/subtract days from the current date to produce sale price date ranges that are always active.
To create a rule using the feed date function
- SET: choose the feed field you would like to apply a feed date to
- For example, Google's
[F].[sale_price_effective_date]
- For example, Google's
- TO: here you will write your function
- Start the feed date function with
[[
(hit 'enter' or click away) - Then type
FEEDDATE
(hit 'enter' or click away) - Close the feed date function with two closing brackets
]]
- Note: you can adjust
FEEDDATE
by any number of days by using addition and subtraction, such as,-
,+
, for example[[
FEEDDATE
+
30
]]
- Start the feed date function with
- WHERE: set the conditions for the rule and then click Save
To set Google Shopping sale price effective date using the feed date function
For example, follow the formula below to SET your Google Shopping Merchant Center feed [F].[sale_price_effective_date]
to a rolling 30 day window which will make the sale price effective always:
[[
FEEDDATE
]]
/
[[
FEEDDATE
+
30
]]
Here is this example as seen in the entire rule:
Comments
0 comments
Please sign in to leave a comment.