Skip to main content

Google Merchant Data Feed

More
15 years 5 months ago #15029 by netd
Google Merchant Data Feed was created by netd
Recently purchased Essentials and wondered whether there is any intention to provide a Google Merchant Data Feed facility to create / upload a delimited file with all the relevant information required by Google Merchant? ( www.google.com/support/merchants/bin/answer.py?answer=188478 )

I realize this could be done manually by exporting and manipulating data in Excel, or similar, but much of this could be automated.

Please Log in or Create an account to join the conversation.

More
15 years 5 months ago #15034 by nicolas
Replied by nicolas on topic Re: Google Merchant Data Feed
There is no solution for it yet. That's something we want to add to HikaShop in the near future.

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #18688 by netd
Replied by netd on topic Re: Google Merchant Data Feed
I notice that 1.5.1 has a Google products plugin - is this the solution for the Google Merchant Data Feed?

If so,what does the, 'commercial editions' comment on the Change Log refer to? I have Essentials, but cannot see this feature...

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #18698 by netd
Replied by netd on topic Re: Google Merchant Data Feed
Apologies - now found the plugin and set the parameters (including Auto Update) - how is this triggered?

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #18717 by nicolas
Replied by nicolas on topic Re: Google Merchant Data Feed
You need to setup your cron task in the configuration of HikaShop so that it can publish automatically the feed to google.
www.hikashop.com/en/support/documentatio...ashop-cron-task.html

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #18966 by netd
Replied by netd on topic Re: Google Merchant Data Feed
Where is the XML file stored? I have tried to submit this feed, but get XML formatting errors. I would like to see the file to try to determine what needs to be corrected.

How does the 'Download' feature work on the plugin? That way I could get the xml file and manually upload it.

Thanks in anticipation!

Alan

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #18970 by nicolas
Replied by nicolas on topic Re: Google Merchant Data Feed
The XML file is not stored. It's directly sent to google.
You can download it by clicking on the trigger link in the options of the plugin.

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19424 by netd
Replied by netd on topic Re: Google Merchant Data Feed
Sorry - I don't see the trigger link! When I go to the Plugin Manager options - there is a field to name the download file, but no trigger link...

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19425 by nicolas
Replied by nicolas on topic Re: Google Merchant Data Feed
Could you do a screenshot ?
The trigger link is the last option of the plugin: www.hikashop.com/en/support/documentatio...google-products.html

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19428 by netd
Replied by netd on topic Re: Google Merchant Data Feed
No, mine is definitely different:

400

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19430 by nicolas
Replied by nicolas on topic Re: Google Merchant Data Feed
It seems that a file is missing for joomla 1.6
Please upload the file in the archive enclosed in the folder components/com_hikashop/fields/ via FTP and try again.

This attachment is hidden for guests.
Please log in or register to see it.

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19434 by netd
Replied by netd on topic Re: Google Merchant Data Feed
Hi, thanks for the prompt response. Tried unzipping the file and uploaded as requested. Now there is no field to specify the name for the download file but the field label is still there, and still no trigger link. :(

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19437 by nicolas
Replied by nicolas on topic Re: Google Merchant Data Feed
Please try to edit that file and change the line:
$id = hikashop::getCID('id');

to:
$id = hikashop::getCID('extension_id');

and try again

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19438 by netd
Replied by netd on topic Re: Google Merchant Data Feed
Sorry to be a nuisance! Still exactly the same.

As an aside - the main reason I am trying to download the file, is because I get an error in the Google Merchant Cnter with an invalid price attribute...

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19439 by nicolas
Replied by nicolas on topic Re: Google Merchant Data Feed
I can see the link on my end with these modifications. However, it's on the top right corner instead of being placed next to the download label because of the way the CSS of the default template of joomla 1.6 is done in the back end.
We'll change a bit the code of that file so that it goes at the correct position. But you shoudl already be able to use the link.

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19440 by netd
Replied by netd on topic Re: Google Merchant Data Feed
Super - found it! Also found the problem with pices - file is adding NZD as the currency instead of GBP!!!

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19441 by nicolas
Replied by nicolas on topic Re: Google Merchant Data Feed
HikaShop should use your main currency (configured in the configuration page of hikashop) which generating the data feed for google. Is that the case ?

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19442 by netd
Replied by netd on topic Re: Google Merchant Data Feed
'fraid not!

Having done a find and replace on that and a manual upload, it is still not right. Only adding 2 of 3 products, but there are >300 items in the shop, and on the file.

More investigation required... (tomorrow!!!)

Please Log in or Create an account to join the conversation.

More
15 years 3 months ago #19444 by netd
Replied by netd on topic Re: Google Merchant Data Feed
Found a culprit: an unescaped ampersand in the Product type

<g:product_type>"Manufacturers &gt; Jay-be","Sofas & Folding Beds &gt; Folding Beds"</g:product_type>

Also some stray characters preceding the pound sign within the descriptions:

"...finest Scandinavian pine.4 DRAWER TALL: £219.50 5 DRAWER TALL: £269.50..."

Please Log in or Create an account to join the conversation.

Time to create page: 0.271 seconds
Powered by Kunena Forum