Hi all,
My affiliate partner merge merchants feeds by products in 1 feed. That's usefull because we haven't duplicate products but it's hard parse.
example :
<products>
<product>
<id>582593</id>
<name>Samsung PS-42E71H</name>
<manufacturer>Samsung</manufacturer>
<description>107 cm, Widescreen, Plasma, HDTV, Stereo</description>
<category>Audiovisuel > Image > Téléviseurs</category>
<number-of-retailers>22</number-of-retailers>
<image-url width="700" height="600">http://i.goodoo.com/prod/4_11_19_18_582593s/Samsung_PS-42E71H.jpeg</image-url>
<image-url width="700" height="600">http://i.goodoo.com/prod/4_11_19_18_582593s/Samsung_PS-42E71H.jpeg</image-url>
<category-url>/ref-site=meaou_feed/s/2/Comparer-les-Televiseurs</category-url>
<prices-url>/ref-site=meaou_feed/pl/2-582593/Televiseurs/Samsung-PS-42E71H-comparer-les-prix</prices-url>
<details-url>/ref-site=meaou_feed/pi/2-582593/Televiseurs/Samsung-PS-42E71H-informations-produit</details-url>
<reviews-url>/ref-site=meaou_feed/pu/2-582593/Televiseurs/Samsung-PS-42E71H-avis-consommateurs</reviews-url>
<expertreviews-url>/ref-site=meaou_feed/pe/2-582593/Televiseurs/Samsung-PS-42E71H-tests-produit</expertreviews-url>
<rating type="professional">
<num-ratings>1</num-ratings>
</rating>
<lowest-price currency="EUR">919.00</lowest-price>
<retailer>
<name>MondialDiscount</name>
<info-url>/ref-site=meaou_feed/retailer/25959</info-url>
<link>/ref-site=meaou_feed/exec/Redirect?w=direct&af_ref=&af_subname=&t=prdmdl&prdcat=2&ret=25959&url=http%3A%2F%2Fwww.mondialdiscount.com%2Fboutique%2Findex_affilie.cfm%3Fnum%3Dgoodoo%26url_aff%3Dhttp%3A%2F%2Fwww.mondialdiscount.com%2Fboutique%2Ffiche_produit.cfm%3Fref%3DPS42E71H%26num%3D2%26type%3D2%26code_lg%3Dlg_fr&af_name=&id=582593</link>
<logo height="50" width="106">http://i.goodoo.com/images/logos/fr/logomondialdiscount2.gif</logo>
<lead-time>2 jours</lead-time>
<stock-info>Disponible en stock</stock-info>
<price currency="EUR">961.00</price>
<source-type>Site Web</source-type>
<source-date>09/04/07</source-date>
<price-with-shipping-min currency="EUR">961.00</price-with-shipping-min>
<price-with-shipping-max currency="EUR">961.00</price-with-shipping-max>
</retailer>
<retailer>
<name>Multidiscount</name>
<info-url>/ref-site=meaou_feed/retailer/5715</info-url>
<link>/ref-site=meaou_feed/exec/Redirect?w=direct&af_ref=&af_subname=&t=prdmdl&prdcat=2&ret=5715&url=http%3A%2F%2Fwww.multidiscount.com%2Fmultidiscount%2Fmd_produit_tv.asp%3Fident%3D3744%26partenaire%3Dpartner&af_name=&id=582593</link>
<logo height="35" width="140">http://i.goodoo.com/images/logos/multidisdciount_logo.gif</logo>
<lead-time>5 - 20 jours</lead-time>
<price currency="EUR">978.00</price>
<source-type>Site Web</source-type>
<source-date>09/04/07</source-date>
<price-with-shipping-min currency="EUR">978.00</price-with-shipping-min>
<price-with-shipping-max currency="EUR">978.00</price-with-shipping-max>
</retailer>
<retailer>
... retailer
</retailer>
<product>
...
</product>
</products>
I need to parse it and inject it in the current database. I think I will create a special import.php file which use MagicParser.
What do you think of that ? Will it be hard to code ?
Cheers
Hi,
Yes, this kind of merged feed as it stands is not really compatible with Price Tapestry, which requires individual feeds by merchant as they are usually supplied.
It would certainly be possible to construct a script using Magic Parser to insert the product records manually for each retailer. I'm afriad i'm away from regular Internet access for the rest of this week but it looks like a reasonably straight forward format to process. It would help if you could email me a full version of one of these feeds as that will help (zipped if possible!). Either reply to your reg code or forum registration email is the easiest way to get me!
I have two support scripts in mind that will help several users in this situation. One to support this sort of price comparison feed; and another to split up feeds containing product records from multiple merchants.
Cheers,
David.