We run an online oscommerce store and have received an XML feed from one of our suppliers containing an updated version of all the products we sell.
A module must be created to automatically import the data from the XML feed to our websites SQL database. It must be one or two php files that can be incorporated into our website that can be easily edited at a later stage. The XML file is obtained via a html link. There are two feeds that must be linked up to a pre existing category on the database.
Feed 1 will contain the following information, and must be updated automatically every 12 hours:
Products must be added, updated and removed automatically as the XML feed dictates.
Feed 2 will contain the following, and must be updated automatically every 30 minutes:
Stock on Hand
In addition, each XML feed will provide a unique ID code at the start of the feed. This code must be retained and used as part of the URL to obtain the next update of the feed.
If you would like any other info, please feel free to contact us.