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)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Andy,
The latest version of CSVI is 6.6.4 and it was released on 25 August 2016, all the fixes/patches till this date have been included with CSVI 6.6.4 version. Of course my latest patch is not in there and if you think if you have included any patches more after this date you may need to track them.
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. # 1
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
The patch for pulling manufacturer from parent to children is done.

Thanks Tharuna, I hadn't seen that until today so will test it later & let you know if there are any issues.

Also I am running a couple of versions behind, now & worried to update, because of so may patch files have been used.
If I update CSVi & the VM Plugin, are the patch files that you /roland have created all in the latest versions?

Thanks again,
Andy
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Andy,
The patch for pulling manufacturer from parent to children is done. Please load the attached patch file and let me know how it goes.


patch_google_export_2016_09_09.zip
Attachments (1)
patch_google_export_2016_09_09.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. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Andy,

Isn't this what you already do for children products for other ares such as
That is what we do but these individual queries are becoming hard to maintain, so we are looking at a more solid solution. Advantage will be that we only need to load the parent once for all it's child products, that is some performance win we can get over the current implementation.
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. # 4
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
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.


Isn't this what you already do for children products for other ares such as;
categories, prices (where price is the same), image (where image is the same)
  1. more than a month ago
  2. RO CSVI
  3. # 5
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. # 6
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. # 7
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. # 8
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. # 9
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. # 10
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. # 11
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. # 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
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. # 14
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. # 15
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. # 16
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. # 17
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. # 18
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. # 19
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. # 20
  • Page :
  • 1
  • 2


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