Ecwid / Google Merchant Integration Launched
Late last night, I put the finishing touches on a small, simple script that allows users with Ecwid Silver accounts to upload their products to Google Merchants on an automated basis. We’re hosting it here on gadsdengraphics.com, at the following address:
http://ecwid-gbase.gadsdengraphics.com/1003.xml
Replacing “1003″ with your Ecwid store ID is all you need to do to get your properly formatted XML, ready to upload to Google. Feel free to specify the URL as an automated upload, as it will continue to be hosted here for the foreseeable future. I’d like to see this feature eventually rolled into Ecwid, at which point I will phase out the script after contacting any remaining users.
There are a few limitations:
- All products are listed as “new”. Ecwid does not have an attribute for condition, and this was the simplest way to implement the script.
- The store description is currently not specified. Google accepts the data feed fine, and I’m not sure what it is used for. At any rate, the Ecwid profile does not contain a text description of the store, so again – it was omitted for expediency.
I have created a project on Google Code for the source – if you’re the geeky type like myself, feel free to download it and use it on your own server. It has currently only been tested on PHP 5.3.x, but it doesn’t use any features that haven’t been around for a long time.
If you run across a problem or have a suggestion for improvement, you can leave a comment here, use our contact form, or contact me through Twitter or Facebook.
Enjoy!
10 Comments
Trackbacks/Pingbacks
- Why Should You Consider a Hosted Shopping Cart? | Lyndsy Simon - [...] While the stock Ecwid does not allow for automated updating of Google Merchant Center, I’ve written a simple script ...
Hello,
I have a problem with my Google Products listing with Ecwid store.
My Google Merchant Center show me Data quality problem.
Problem is: Missing Product Type Values (product type [product_type])
It’s possible to solve this problem? What do you think about this problem?
Please write me the answer to my email.
Thank you.
Roman.
Thanks so much for this tool, I could never get Ecwid's manual upload to work … crossing my fingers that your tool does the trick!
Great. ECWID's manual system strips out products with 0 price, any chance you could modify this to do the same?
It's possible, but I really don't have the time to do it right now. The code is hosted at Google, it shouldn't be too horribly hard to modify it for that purpose.
I've got to keep my efforts focused on profitability, unfortunately. I'm working on building a business that doesn't require me to constantly be packing and shipping orders!
I have upgraded to the auto loading version but google does not load my catagories.
Any help with that?
Thank you!
I've just discovered that a disabled category with enabled products in it are unsearchable through your stores but will be listed in Google Shopping just because the products are still enabled. Just disabling a category won't work. So be sure to disable all products inside of any disabled category. We use ours just for testing, but sure don't want them to show up in Google Shopping.
Just a note for those who haven't thought about this or tested it.
Hi I am having problem getting the price that dispays in google shoppping to include tax – this code on the feed
<g:price>41.62</g:price>
is different to the price that displays on the site – which we have set to include tax on product displayed items – can this is overcome ?
and would also like to see Free shipping in google search when it applies to an item – is this possible?
Thanks in advance
First, thanks for your excellent work! I was using your generated feed- and it was working beautifully- but there's also a problem that the new "unique identifiers" are not allowed for with your script. Is there any possibility of an update?
I don't have any plans to get back to it at this point – but that doesn't mean it's completely out of the question, either.
I'd like to see this functionality taken up by the Ecwid team, to be honest. I'm not a professional programmer, nor do I intend to become one in the near future online.
The code for this is hosted on Google Code – you can see what it is I've done, and it's pretty simple. You might consider hiring a developer on oDesk or a similar freelancer site, having them modify it, and host it yourself?