VectorSix Posted May 18, 2006 Share Posted May 18, 2006 Rather than re-inventing the wheel, I am wondering if anyone has done development or reserch into auto updating prices into mySql from a csv file? I extract my data from my ERP system into a csv file, auto ftp it to my web server, now I need to figure out how to schedule it to run a script to run the price updates. Is there a batch update script for mySql that anyone has created that they would care to share? Link to comment Share on other sites More sharing options...
rwalker Posted May 19, 2006 Share Posted May 19, 2006 See the Easypopulate contribution http://www.oscommerce.com/community/contributions,500 R Walker Rather than re-inventing the wheel, I am wondering if anyone has done development or reserch into auto updating prices into mySql from a csv file? I extract my data from my ERP system into a csv file, auto ftp it to my web server, now I need to figure out how to schedule it to run a script to run the price updates. Is there a batch update script for mySql that anyone has created that they would care to share? Link to comment Share on other sites More sharing options...
VectorSix Posted May 23, 2006 Author Share Posted May 23, 2006 Not exactly what I had in mind. I mean something more along the lines of using INFILE or MYSQLIMPORT. There must be people running stored reports that create CSV file that are imported into mySQL for their inventory or pricing. Unless everyone in this forum does it manually ?? That's whacky. I have over 14,000 SKU's, so that isn't going to happen. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.