I'm running an eCommerce store and I am being provided with a daily data feed of info like Item Number, Price, Description, Inventory Status, etc.
Some notes:
- I know the URL of the .xls file
- I need to modify the Item Number on the .xls for all products to add two letters to the beginning
- Price and Inventory Status on the website database need to be updated daily for each item, matched up by Item Number
- If Item Number does not exist, new item is created with all information contained in the excel sheet
- This all needs to be fully automated (this is the part I need the most assistance with)
I used to have a company that took care of this for $50/month, but I now have access to the data myself. My programming experience is limited to web languages (PHP, HTML, etc.) and some basic C++. A side question would be whether or not it's worth taking this responsibility upon myself or if I should continue working with a company who has systems in place to handle this already.