The slow speed and limited selection of importable columns has driven me to write an import script to suit the CSV file I’m trying to import (CSV has tier pricing, configurable products, customization text).
My first idea was to inject the product information directly into the database. However, after looking at the database diagram and some experimentation, it appears that this would require a massive amount of variables to be written to be many different tables. This high number of variables isn’t obvious from the back office pages because they’re tagged on behind the scenes after a product is saved. Tracing the dependincies and ensuring you don’t corrupt the database by failing to inject one value is a huge task.
Therefore, I was hoping to go one level above direct database injection and try to manipulate the functions employed on the “create product page”. I was hoping to setup all the necessary variables for the function that’s called when the “Save” button is pushed and then call the “Save” function. on the product page and then Going this way would be safer because Magento would be responsible for generating all of its necesary administration data which accompanies all the user generated data.
First of all though, does anyone know which file these functions are stored in? After that, how do I setup my personal php script so that I can access these Magento functions?