Magento Forum

   
Page 1 of 43
Export Module for Google Base
 
Lenny2
Sr. Member
 
Total Posts:  171
Joined:  2008-05-21
München
 

I am looking for an possiblity to export an product list to import with Google Base.
Can somebody help?

 
Magento Community Magento Community
Magento Community
Magento Community
 
seudo
Guru
 
Avatar
Total Posts:  344
Joined:  2008-04-21
 

This would be great. Anyone know if it might be included with v1.1?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Lenny2
Sr. Member
 
Total Posts:  171
Joined:  2008-05-21
München
 

Any ideas??

 
Magento Community Magento Community
Magento Community
Magento Community
 
jan212
Guru
 
Avatar
Total Posts:  407
Joined:  2008-01-03
 

We just started working on a commercial google base extension for magento… Stay tuned.

 
Magento Community Magento Community
Magento Community
Magento Community
 
seudo
Guru
 
Avatar
Total Posts:  344
Joined:  2008-04-21
 
jan212 - 13 July 2008 12:58 PM

We just started working on a commercial google base extension for magento… Stay tuned.

Ron Seigel - 13 July 2008 03:09 PM

Guess that mean it’s time for me to start working on a free one.

Any idea of when these might surface?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Very Clever Stuff
Sr. Member
 
Avatar
Total Posts:  90
Joined:  2008-05-06
Sheffield, UK
 

The free one sounds good rasberry

It most definitely should be a core module for a system like Magento.

 
Magento Community Magento Community
Magento Community
Magento Community
 
speedyss
Jr. Member
 
Total Posts:  24
Joined:  2008-07-02
 

any updates?

have any of you guys tried using the export function of magento to load up a google base xml?

 
Magento Community Magento Community
Magento Community
Magento Community
 
TemplatesMaster
Guru
 
Avatar
Total Posts:  304
Joined:  2008-04-01
Switzerland
 

You can do this in next way.

#1 Export all your products using Data Flow
#2 Create tab delimited file for importing into google base using this tutorial http://base.google.com/support/bin/answer.py?hl=en&answer;=58083 and this recipes http://base.google.com/support/bin/answer.py?hl=en&answer;=66773 and import fields you need to this file
#3 Add url of your site to images and url fields
#4 Save as txt file and upload to Google base

Send you orders grin

 
Magento Community Magento Community
Magento Community
Magento Community
 
OurWorldTalks
Member
 
Total Posts:  60
Joined:  2008-07-08
 

Thanks TemplatesMaster, first time i learned about the export function (great feature!) and getting my products up at google base. Now awaiting for it to process.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ODB
Sr. Member
 
Avatar
Total Posts:  142
Joined:  2008-02-06
London
 

Has anyone had any results with this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
seudo
Guru
 
Avatar
Total Posts:  344
Joined:  2008-04-21
 

This is a nice way to export to google base, but manually editing can be time consuming when you have many products. An automated system would be nice that incorporates a ftp protocol using a scheduling, maybe through cron.

@jan212 - you had mentioned a commercial version. Will this have ftp abilities to upload directly to google and be configurable in the admin?

 
Magento Community Magento Community
Magento Community
Magento Community
 
mikefifield
Member
 
Avatar
Total Posts:  49
Joined:  2008-05-24
 

Any progress on this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
hyteckit
Sr. Member
 
Avatar
Total Posts:  166
Joined:  2008-04-01
Los Angeles, CA
 

I just look into Magento’s capabilities and the possibility of creating a datafeed for Google Base.

From what I’m seeing, it looks fairly easy thing to implement.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dunc
Member
 
Avatar
Total Posts:  56
Joined:  2008-08-05
 

It should be easy. I’ve set up a profile for export which meets the Google Base requirements in every way, except for the link and image_link attributes which only show the relative url and not the full path, if somebody knows how to export the full path then the whole thing’s achievable.

The following is the XML for the Export Profile…

<action type="catalog/convert_adapter_product" method="load">
    <var 
name="store"><![CDATA[0]]></var>
    <var 
name="filter/type"><![CDATA[simple]]></var>
    <var 
name="filter/status"><![CDATA[1]]></var>
</
action>

<
action type="catalog/convert_parser_product" method="unparse">
    <var 
name="store"><![CDATA[0]]></var>
</
action>

<
action type="dataflow/convert_mapper_column" method="map">
    <var 
name="map">
        <
map name="sku"><![CDATA[id]]></map>
        <
map name="name"><![CDATA[title]]></map>
        <
map name="short_description"><![CDATA[description]]></map>
        <
map name="price"><![CDATA[price]]></map>
        <
map name="thumbnail"><![CDATA[image_link]]></map>
        <
map name="url_path"><![CDATA[link]]></map>
    </var>
    <var 
name="_only_specified">true</var>
</
action>

<
action type="dataflow/convert_parser_csv" method="unparse">
    <var 
name="delimiter"><![CDATA[\t]]></var>
    <var 
name="enclose"><![CDATA[]]></var>
    <var 
name="fieldnames">true</var>
</
action>

<
action type="dataflow/convert_adapter_io" method="save">
    <var 
name="type">file</var>
    <var 
name="path">var/export</var>
    <var 
name="filename"><![CDATA[google_products.tsv]]></var>
</
action>

 
Magento Community Magento Community
Magento Community
Magento Community
 
seudo
Guru
 
Avatar
Total Posts:  344
Joined:  2008-04-21
 

@Dunc - Thank you very much for sharing your profile. That is something we can use for the time being.

We came from a shop that allowed you to ftp the exported file with a single click to Google Base.

Very interested in seeing an ftp mod that can be set to upload at an admin set time schedule.

I know Google Base excepts scheduling of downloading the feed but it is limited to 15mb or less.

So for shops that don’t have a 15mb file you “could” set a different location that google base scheduler can grab the file automatically. That is once we figure out how to get the skin url into the path of the images.

 
Magento Community Magento Community
Magento Community
Magento Community
 
hyteckit
Sr. Member
 
Avatar
Total Posts:  166
Joined:  2008-04-01
Los Angeles, CA
 

I’m working on a solution where you can just use Google Base scheduler get your datafeed.

No messing with ftp or export/import.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 1 of 43