Database updates

Having trouble coming up with a good way to make quantity updates to the database on a schedule. We have a csv file that we get from our distributor that is updated every 10 minutes. The update file contains just the sku and the updated quantity. Our database has 15,000 items currently and we have been trying many ideas to automate this. Just wondering how this is being handled by other users of opencart. Great software and great user forum!

Todd

It certainly can be done with a bit of scripting

How large is the csv file ?

Do the sku in it match your sku's (or another field for your products) ?

How often would you want to run it ?

Can your server run cron jobs ?

Feel free to contact me for a quote to do this.

CSV file is 2 column with no column headers. First column is SKU and second column is Quantity. About 13,000 rows (pretty small file).

The CSV file's SKUs match the SKUs in our database.

We would want to run every 15 minutes and our server allows for a 1 line cron command and it will handle my 15minute scheduling requirement.

Thanks for your reply and look forward to hearing from you.

Forgot to mention. CSV file is on an ftp site but we can set to have it be on our home directory of our server every 15 minutes already. We would like to work with you and would have more work after this.

Thank you!