Project to write a web based routine that gets the stock status from our vendor (bestlink netware) and posts to our database.
We can get stock status updates from this page:
[url removed, login to view]
It would just need to match the SKU# from the vendor site to the SKU in our database and update to In-stock or out of stock accordingly. Any new items on the vendor website would be ignored and any removed or missing items would change the stock status on our site to "out of stock".
If possible it would be ideal to have a password protected webpage on our server that we could navigate to when we want to run the script. This way we can manage the updates remotely.
Let me know if you have any questions and keep in mind the website is now live with a couple users on at a time!
Also, may have to refresh cache or stock inventory from the cache page in magento to test that it works.
Please take a backup of the database before making any preliminary tests. We have lots of orders and additional information that would be hard to recover since its changing frequently now.