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

sales price effective date.

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi!
I am a newbie to product feeds and xml, I try to get my productfeed in GMC correct, but have one last struggle.
The struggle is <g:sales_price_effective_date> 

 

The xml I use to extract the date from my Magento shop is the following:

<g:sale_price_effective_date>{type="attribute" value="special_from_date" format="date" length="" optional="no" parent="no"}T00:01+0100/
{type="attribute" value="special_to_date" format="date" length="" optional="no" parent="no"}T23:59+0100</g:sale_price_effective_date>

 

But something with the above is wrong, anybody got any ideas or feedback on this?

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Ted F
September 2015

Re: sales price effective date.

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
The solution was in my feed generator application.
I needed to do some mapping and replace some data.
I guess this maybe was the wrong forum for this question.
Anyhow, now it is solved and thanks for support! Smiley Happy

View solution in original post

Re: sales price effective date.

[ Edited ]
Top Contributor
# 2
Top Contributor


the result should be of the form --
<g:sale_price_effective_date>2011-03-01T13:00-0800/2011-03-11T15:30-0800</g:sale_price_effective_date>

otherwise, the best likely course would be to contact
whoever is supporting the exact extension or version
of magento being used or try asking in the magento
community forums --
http://community.magento.com/

see also
https://support.google.com/merchants/answer/188494

Re: sales price effective date.

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thanks for answer Celebird!

I have already been on the different links you suggested.
My entire productfeed is already done and everything is free of errors, except the "sales price effective date"
The "dateform" that you suggested is correct offcource, but my problem is to extract this from Magento automatically for all my products in MAgento.

I use attributes and I am not sure if attributes support two different values, as I am trying to do here. I try to extract the "sales price from date" and the "sales price to date"

After sales price from date, I need the manual value to be: "T00:01+0100/"
After the sales price to date, I need the manual value to be: "T23:59+0100"

But with the above formula I use, all info that comes out is: "T23:59+0100"

So if anybody has experience with XML and attributes, please let me know if you have any suggestions in regards to the formula I use!?
Marked as Best Answer.
Solution
Accepted by topic author Ted F
September 2015

Re: sales price effective date.

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
The solution was in my feed generator application.
I needed to do some mapping and replace some data.
I guess this maybe was the wrong forum for this question.
Anyhow, now it is solved and thanks for support! Smiley Happy