I need a PHP script that I can interface with to Insert/Update products and categories daily via CRON. I currently have a script that downloads the products/categories XML from my distributor. I just need a script that will insert that information into the Magento database. Our current shopping cart which we intend on switching from is CubeCart and my current script directly injects that data into the database. However, Magento’s database is more complex to deal with directly. Currently I have a cron job that once a day grabs the updated XML file, parses it, and inserts into the database. This file updated once a day with updated quantities and any cost updates.
Currently we have over 2600 items that are included in our distributors xml file. This tool must also have the ability to update not just add records. We are a wireless accessory company. We currently have categories and sub categories (phone models are currently represented by categories)... a category structure example is: Apple>iPhone>Batteries or Apple>iPhone>Car Chargers, etc. One product may be compatible with multiple phones so a car charger for example may be compatible with upto 50 phone models.