I need to write a cron job to update my products inventory and price hourly.
The variables are these.
I have 6000 products with their own IDs which my accounting system uses (not magento).
These 6000 turn into 31,000 products. The reason for this is they are car parts, so a Mazda 3 may use the same part as a Honda civic, users on my site will be searching by make, model, and year (all attributes). The only way I could figure out how to do this by importing 31,000 different parts (so they have 31,000 magento IDs).
So I have also imported my accounting system ID as an attribute (my_part_id) which all products have.
So I would like my cron to search for all products which have my_part_id and update the qty and price.
Can someone please point me in the right direction to get this done? I am very comfortable using PHP and MYSQL, I just don't fully understand the Magento Database yet and don't want to mess up any table relationships that I don't know about.