import a catalogue xml into oscommerce's mysql

[da_vi_ta]

hi guys

i would need a solution in order to import a catalogue xml into oscommerce's mysql :

 

could you please help me telling where ask about ? thanks

this is a portion of xml

 

<?xml version="1.0" encoding="ISO-8859-1" ?>

- <catalogo>

- <prodotto>

- <prodotto>

<ID>CRISTALDIFILM2336</ID>

<NAME>DVD IL NOME DELLA ROSA</NAME>

<DESCRIPTION_IT>Dal libro più venduto e meno letto del mondo un drammone tetro e monotono, che ha perduto l'ironia di Umberto Eco conservandone...</DESCRIPTION_IT>

<PRICE>12,00</PRICE>

<PRICE_RES>8,44</PRICE_RES>

- <IMAGES>

<IMAGE1>http://www.nomefornitore.com/imagesprods/nomerosa.jpg</IMAGE1>

<IMAGE2>http://www.nomefornitore.com/imagesprod/nomerosa1.jpg</IMAGE2>

</IMAGES>

<VIDEO>http://www.nomefornitore.com/trailer/nomerosa.flv</VIDEO>

- <FEATURES>

<FEATURE name="PRODUTTORE">cristaldi</FEATURE>

<FEATURE name="SUPPORTO">DVD</FEATURE>

<FEATURE name="DURATA">129 MIN</FEATURE>

 

</FEATURES>

<QUANTITY>105</QUANTITY>

<BARCODE>06342000</BARCODE>

</prodotto>

</prodotto>

</catalogo>

[♥mdtaylorlrim]

hi guys

i would need a solution in order to import a catalogue xml into oscommerce's mysql :

 

could you please help me telling where ask about ? thanks

this is a portion of xml

 

<?xml version="1.0" encoding="ISO-8859-1" ?>

- <catalogo>

- <prodotto>

- <prodotto>

<ID>CRISTALDIFILM2336</ID>

<NAME>DVD IL NOME DELLA ROSA</NAME>

<DESCRIPTION_IT>Dal libro più venduto e meno letto del mondo un drammone tetro e monotono, che ha perduto l'ironia di Umberto Eco conservandone...</DESCRIPTION_IT>

<PRICE>12,00</PRICE>

<PRICE_RES>8,44</PRICE_RES>

- <IMAGES>

<IMAGE1>http://www.nomefornitore.com/imagesprods/nomerosa.jpg</IMAGE1>

<IMAGE2>http://www.nomefornitore.com/imagesprod/nomerosa1.jpg</IMAGE2>

</IMAGES>

<VIDEO>http://www.nomefornitore.com/trailer/nomerosa.flv</VIDEO>

- <FEATURES>

<FEATURE name="PRODUTTORE">cristaldi</FEATURE>

<FEATURE name="SUPPORTO">DVD</FEATURE>

<FEATURE name="DURATA">129 MIN</FEATURE>

 

</FEATURES>

<QUANTITY>105</QUANTITY>

<BARCODE>06342000</BARCODE>

</prodotto>

</prodotto>

</catalogo>

I use a solution that updates prices and quantity on hand from an xml every 30 minutes. If you cannot find another ready made solution let me know and I can send you my code and you can edit it to add your products.

 

Shouldn't be too hard.

[dinesh4monto]

I use a solution that updates prices and quantity on hand from an xml every 30 minutes. If you cannot find another ready made solution let me know and I can send you my code and you can edit it to add your products.

 

Shouldn't be too hard.

Hello, I have an existing osCommerce setup. And, I want to only display in my current osCommerce product listing. So, it will not be permanently imported in my current setup.