Categories
View Replies (25)

Resolved Google MC XML Export tweaks needed

  1. sandstorm871
    sandstorm871
  2. RO CSVI
  3. Wednesday, 10 August 2016
  4.  Subscribe via email
3 points here relate to the new/updated Google MC XML export that you have worked brilliantly on. We have pushed this live in on our sites this week & have these following notices. :pinch:


1 - Price needs to have the currency ie, GBP after the value not before, as per requirements from Google
currently <g:price><![CDATA[GBP 9.95]]></g:price>
needs to be <g:price><![CDATA[9.95 GBP]]></g:price>
------------------------------------------------------------------------------------------

2 - Shipping is wrong on any item that is 'out of stock'

In our case, this defaults back to RM 24 recorded with 4.50
<g:country>GB</g:country>
<g:service>Royal Mail 24 Recorded</g:service>
<g:price>4.50 GBP</g:price>
</g:shipping>
------------------------------------------------------------------------------------------

3 - Products with Price 0.00 are being exported
Please can products that have a price of 0.00 be excluded from the export
------------------------------------------------------------------------------------------

4 - When exporting URL's for images, product URL, etc the word "Helper" is added to the URL ,making all the URLs invalid.
i.e instead of http://mywebsite.com/images/myimage.jpg it exports as mywebsite.com/helper/images/myimage.jpg
0
Responses (25)
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Andy,

Point 1 I have fixed.

As for point 2, which shipping rule do you get on items that are out of stock? Are items that are out of stock allowed on Google Merchant?

Products with a price of 0.00 are they not unpublished or you can't have free products on Google Merchant?

The extra "helper" does it happen for all images? I don't understand how this could happen because CSVI adds the domain name you have set in the global settings with the name of the image that is in the database. Does the domain name by any chance have the word helper in it?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
1 - Great Thanks

2 -
Which shipping rule do you get on items that are out of stock?
We seem to get the same shipping rule showing up that was showing when there was a problem in this plugin
Are items that are out of stock allowed on Google Merchant?
They are allowed, but have to state they are out of stock. We already have a rule in place to show out of stock - https://dl.dropboxusercontent.com/u/29102555/csvi/Screen%20Shot%202016-08-11%20at%2009.46.05.png


3 -
or you can't have free products on Google Merchant?
I don't think you can advertise free products in Google MC

4 - Sorry a bit of incorrect information here.
Image links are OK. The problem is with the exported product_url link.
See the full export here, where all products have the extra "helper" in place - https://www.lowenergysupermarket.com/Google-MC/LES-GMC.xml

The URL we have in settings doesn't have helper in it - https://dl.dropboxusercontent.com/u/29102555/csvi/Screen%20Shot%202016-08-11%20at%2009.50.00.png
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Andy,

Do you still have that test site up and running so I can check it there? Please give me the SKUs of each product that has an issue with shipping, no price and image URL issue. I will check them to see what is going on.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
I edited the last post as you replied.
I will set up a new staging copy of the site and send info over to you.

Heres what I edited
4 - Sorry a bit of incorrect information here.
Image links are OK. The problem is with the exported product_url link.
See the full export here, where all products have the extra "helper" in place - http://www.lowenergysupermarket.com/Google-MC/LES-GMC.xml
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Andy,

Going to summarize the status here:
  1. Price has been fixed
  2. Shipping: Do you have a product where I can see this? I can't seem to find one
  3. In your template you can set a minimum price for the export, so that should fix this issue.
  4. I can't reproduce this on the staging site.
Let me know what you think.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
4 - Helper in URL

Testing the issue with "helper" in the exported URL in our live site, I have found the issue.

When we manually export (as you did with the staging1 site) "helper" doesn't show up.

But we have started using CRON to export this to our server so that Google can check it daily.

I followed these instructions to set up a CSVi CRON Job , in there it suggests that we use the path "/home/domain/public_html/administrator/components/com_csvi/helper/cron.php"

I did this, swapped out domain form my own domain, added template id, secret key, etc & the CRON runs fine, but the URL has the word "helper" in it.

If I remove "helper" from the CRON path, the the CRON doesn't run.
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
The price issue has been solved?

I will have a look at the cron issue.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
The price issue has been solved?

Yes.
Setting to ignore products with a value greater than 0, still exported products that where 0.00?
So, I set to greater than 0.01 & this works.

I will have a look at the cron issue.

Thanks, keep me posted ;)
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Andy,

Can you check if the SEF URL is OK now on the testing site?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
Not sure if you want this on a new thread or happy to keep in here.

We noticed a issue with exporting manufacturer information for children products.
Where a parent/child product is set up, the child is exporting correctly, but doesn't pull the manufacturer data from the parent. Instead just shows as ;

<g:brand>

<![CDATA[ ]]>

</g:brand>


Is it possible to modify this to pull the parent manufacturer?

Google have also informed us that the shipping exported data is cosmetically incorrect?
Not sure what this means exactly, so am awaiting more information from them.

Thanks
Andy
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Andy,
Can you please send your template xml file to test? I couldn't see this issue with a normal google export template unless the parent product has no manufacturer set.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
You still have access to the staging1 copy of the site if you need to check there.
Let me know if you need me to send credentials over again.
Thanks
Andy
  1. more than a month ago
  2. RO CSVI
  3. # 12
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
Exported XML file is here - http://bit.ly/2chIzaF

Every bit of data is wrapped in CDATA ? Is this needed?
  1. more than a month ago
  2. RO CSVI
  3. # 13
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Andy,

You can edit each field in your template fields and enable/disable CDATA tags.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
You can edit each field in your template fields and enable/disable CDATA tags.


Thanks, I wasn't aware of that ;)
However, when switching them all off, CDATA, still shows for Link & Manufacturer as seen here - http://bit.ly/2chIzaF
I checked and cleared all cache too?

Also is it possible to pull manufacturer name from parent for children or do I need to set Manufacturer for all children when setting products up?
  1. more than a month ago
  2. RO CSVI
  3. # 15
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Andy,
However, when switching them all off, CDATA, still shows for Link & Manufacturer as seen here - http://bit.ly/2chIzaF
I checked and cleared all cache too?

Please apply the attached patch file so to remove CDATA according to template field setting for manufacturer and link.

Also is it possible to pull manufacturer name from parent for children or do I need to set Manufacturer for all children when setting products up?

You may need to set up manufacturer for children while setting up the product. There is no option now to pull parent manufacturer for child products.


patch_google_cdata_2016-09-06.zip
Attachments (1)
patch_google_cdata_2016-09-06.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 16
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
That patch fixes the CDATA issue, thanks.

As a workaround I have set a default Manufacturer in the export field, but would be handy if children could pull the parent manufacturer when not present.
  1. more than a month ago
  2. RO CSVI
  3. # 17
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Andy,

You do know that CDATA is part of the XML standard and having them isn't an issue?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 18
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
CDATA is part of the XML standard and having them isn't an issue?

I would have assumed so too & was telling my client the same too. But removed them just to test & over 90% of the cosmetic errors reporting back from Google disappeared.

So it seems there is another Hoop to jump through to satisfy Google?

What do you think about pulling the manufacturer for children products, when no manufacturer is already set?
  1. more than a month ago
  2. RO CSVI
  3. # 19
rolandd
rolandd
Accepted Answer Pending Moderation
But removed them just to test & over 90% of the cosmetic errors reporting back from Google disappeared.
Beats me.

So it seems there is another Hoop to jump through to satisfy Google?
Definitely looks like that, as there should be nothing wrong with using CDATA tags.

As for the manufacturer info, this is a funky one. What this means is that for every child we also need to load the parent information as VirtueMart does. That is OK for VirtueMart as it only needs to load 1 parent per page load, we will need to do it for the complete dataset you are exporting, which is possibly the complete database. This will be a performance penalty. I have asked Tharuna to come up with a proof of concept and see if we can use that. We are sure that after manufacturer, other fields will follow ;)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!