updating oscommerce with xml/rss feed

[smartypants007]

Hi

 

I need to automate the process of updating our

product catalogue via an RSS feed from one or more of our suppliers - is there anyone that can help?

Basically it would involve converting one set of data from the feed into a layout compatible

with our OS-Commerce database, and then updating the database, this will need to be done

automatically daily.

 

thanks,

 

richard

[Guest]

There is a contribution that you could use:

http://www.oscommerce.com/community/contributions,1513

[smartypants007]

so this will allow me to update my product catlog using an rss feed, automatically every day.

 

could you help me if I provided you with a sample of the xml file?

 

richard

[Guest]

The contribution just takes the products from the dbase and generates the xml file. You need the opposite also so you could reverse the process to upload/update products. To automate it you could take advantage of the spiders visiting your store and let them do the update by running your script.

[smartypants007]

i could really do with your help?

 

i need more detail!

 

richard

[smartypants007]

Im getting this error:

 

Fatal error: Call to undefined function: iconv() in /home/itsoftwa/public_html/catalog/rss.php on line 153

 

when trying to view rss.php in browser at:

 

http://www.itsoftwaresolutions.co.uk/catalog/rss.php

 

can anyone help?

 

richard

[Guest]

See this thread make sure the library is installed or ask your host about it.

http://www.oscommerce.com/forums/index.php?showtopic=185843

 

you need it for this type of contributions

[smartypants007]

ny hosts are installing iconv function on the server.

 

im starting to get somewhere, if you look at:

 

http://www.itsoftwaresolutions.co.uk/catalog/rss.php

 

its loading product information from my oscommerce database into the browser, what I need though is the opposite to be able to change details in the database by uploading my xml file which looks like this:

 

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

- <ROOT>

- <PRODUCT>

<RTCODE>ACC1200</RTCODE>

<MFPARTNO />

<DESCRIPTION>Remote Bob 24000-00-20</DESCRIPTION>

<PRICE>12.81</PRICE>

<PRICE BREAK="">12.81</PRICE>

<PRICE BREAK="">12.81</PRICE>

<PRICE BREAK="">12.81</PRICE>

<PRICE BREAK="">12.81</PRICE>

<CATEGORY>Accessories----ATI--</CATEGORY>

<STOCK>0</STOCK>

<WEIGHT>0.01</WEIGHT>

 

any help?

 

richard

[Guest]

yes, you will need to create the php script to do that. I could not see a ready one in the contributions.