Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 2
Export xml for price comparator
 
lemax
Guru
 
Total Posts:  318
Joined:  2008-04-03
Nantes, France
 

Dear friends,
I would like to be present in several price comparator sites.
To do that I have to export daily or weekly my entire product database to a xml or csv file on my server (like the xml sitemap).
This xml or csv file as to be formatted to the price comparator standards.
This must show several things like SKU, description, price, old price, warranty, shipping cost, ....

This could be done with the mapping feature of the dataflow.
Some fields are identical to the standard dataflow export like SKU, description.
Some others are not. Like product URL or image URL.

Question : How to make this export compliant with the price comparator standard ? I can’t spend time to modify xml or csv file every day or every week with my 1000 products database.
The solution is maybe by tweaking the xml action process in the dataflow. Today it shows :

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

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

<
action type="dataflow/convert_mapper_column" method="map">
    <var 
name="map">
        <
map name="category_ids"><![CDATA[categorie]]></map>
        <
map name="sku"><![CDATA[identifiant_unique]]></map>
        <
map name="name"><![CDATA[titre]]></map>
        <
map name="description"><![CDATA[description]]></map>
        <
map name="price"><![CDATA[prix]]></map>
        <
map name="special_price"><![CDATA[special_price]]></map>
        <
map name="url_path"><![CDATA[url_produit]]></map>
        <
map name="small_image"><![CDATA[url_image]]></map>
        <
map name="is_in_stock"><![CDATA[disponibilite]]></map>
        <
map name="warranty"><![CDATA[garantie]]></map>
        <
map name="sku"><![CDATA[reference_modele]]></map>
        <
map name="manufacturer"><![CDATA[marque]]></map>
    </var>
    <var 
name="_only_specified">true</var>
</
action>

<
action type="dataflow/convert_parser_xml_excel" method="unparse">
    <var 
name="single_sheet"><![CDATA[france]]></var>
    <var 
name="fieldnames">true</var>
</
action>

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

The problem comes with the product url and image url. They are relative urls and not a root url. it shows theproductIsell.html instead of http://www.mymagentosite.com/categoryoftheproduct/theproductIsell.html
Same thing for the image url : it is like /4/2/4275.jpg

Do someone already did something like this ?
Do someone know how to tweak the xml action code ? (if it is the solution)

Attached the price comparator standard file.

Thanks
Max

File Attachments
LeGuide.zip  (File Size: 3KB - Downloads: 474)
 
Magento Community Magento Community
Magento Community
Magento Community
 
MAtt*!
Jr. Member
 
Total Posts:  10
Joined:  2008-07-30
 

I am experencing the same problem. I will keep in touch if I find the solution.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lemax
Guru
 
Total Posts:  318
Joined:  2008-04-03
Nantes, France
 

Any idea on what XML code should be applied here ??
Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
baumpaul
Sr. Member
 
Total Posts:  94
Joined:  2008-01-18
95448 Bayreuth, Deutschland
 

Hallo,

do you habe an solution for this problem? I habe the same problem…

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

I’m stuck on this too, if the full url can be added then a Google product tsv file can be done too. Any ideas anyone?

 
Magento Community Magento Community
Magento Community
Magento Community
 
aximus
Jr. Member
 
Avatar
Total Posts:  9
Joined:  2008-09-03
Netherlands
 

Strugling with the same problem here.. just putting it out there

 
Magento Community Magento Community
Magento Community
Magento Community
 
cibernoid
Sr. Member
 
Avatar
Total Posts:  208
Joined:  2008-02-12
 

Looks like Advanced Profiles can’t be be used on that purpose.
I wonder if this extension can helps : http://www.magentocommerce.com/extension/517/yml-export-module
(my russian is a bit rusty)

 
Magento Community Magento Community
Magento Community
Magento Community
 
lemax
Guru
 
Total Posts:  318
Joined:  2008-04-03
Nantes, France
 

That’s a shame it is not a full english extension. I would try it.
Max

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tortaio
Jr. Member
 
Total Posts:  3
Joined:  2008-10-08
 

any news?

 
Magento Community Magento Community
Magento Community
Magento Community
 
joyously
Guru
 
Total Posts:  447
Joined:  2008-08-21
 

See this thread: http://www.magentocommerce.com/boards/viewthread/19398/P0/

 
Magento Community Magento Community
Magento Community
Magento Community
 
TSpark
Jr. Member
 
Total Posts:  9
Joined:  2008-03-04
Lithuania, Vilnius
 
joyously - 18 November 2008 01:10 PM

See this thread: http://www.magentocommerce.com/boards/viewthread/19398/P0/

The thread above talks more about txt based output and here we need XML output to price comparison sites.

Does anyone know how to convert Excel XML format produced by Magento export module to normal XML format without Excel tags?

 
Magento Community Magento Community
Magento Community
Magento Community
 
TSpark
Jr. Member
 
Total Posts:  9
Joined:  2008-03-04
Lithuania, Vilnius
 

Has anyone done a normal xml feed module?

I need something like this example:

<?xml version="1.0" encoding="UTF-8"?>
<product_feed version="0.1" timestamp="200609270936"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://www.prex.lt/partners/xml/productfeed_v0.1.xsd">
<
products>
<
product id="1">
<
title><![CDATA[CANON POWERSHOT A620]]></title>
<
item_price>769.65</item_price>
<
stock>1</stock>
<
ean_code>4960999279411</ean_code>
<
prex_code>100506</prex_code>
<
wholesaler><![CDATA[GNT]]></wholesaler>
<
wholesaler_code>284962</wholesaler_code>
<
vendor><![CDATA[Canon]]></vendor>
<
vendor_code><![CDATA[psa620]]></vendor_code>
<
product_url><![CDATA[http://ex.zzz/A620/]]></product_url>
<purchase_url><![CDATA[http://ex.zzz/buy/A620/]]></purchase_url>
</product>
<
product id="32">
<
title><![CDATA[EOS 350D KIT 18-55 SILVER]]></title>
<
item_price>2016.11</item_price>
<
stock>3</stock>
<
ean_code>8714574952635</ean_code>
<
prex_code>101298</prex_code>
<
wholesaler><![CDATA[ACME]]></wholesaler>
<
wholesaler_code>61283</wholesaler_code>
<
vendor><![CDATA[Canon]]></vendor>
<
vendor_code><![CDATA[eos350d1785]]></vendor_code>
<
product_url><![CDATA[http://ex.zzz/EOS_350C/]]></product_url>
<purchase_url><![CDATA[http://ex.zzz/buy/EOS_350C/]]></purchase_url>
<custom_fields>
<
field name="custom1"><![CDATA[example]]]></field>
<
field name="custom2"><![CDATA[example]]]></field>
</
custom_fields>
</
product>
</
products>
</
product_feed>
©
 
Magento Community Magento Community
Magento Community
Magento Community
 
joyously
Guru
 
Total Posts:  447
Joined:  2008-08-21
 

As of version 1.1.8, you can look at the code for the Google Base part of Magento and see what they do.

 
Magento Community Magento Community
Magento Community
Magento Community
 
jack001
Jr. Member
 
Avatar
Total Posts:  20
Joined:  2007-11-29
France
 

hello Arecuk, thank you but your website is not in english… so hard to order

 
Magento Community Magento Community
Magento Community
Magento Community
 
lemax
Guru
 
Total Posts:  318
Joined:  2008-04-03
Nantes, France
 

Any news about a community extension for this ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
suricate
Sr. Member
 
Avatar
Total Posts:  129
Joined:  2009-06-25
Brazil
 

Another solution for community

http://www.magentocommerce.com/boards/index.php/viewreply/91358/

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