stopthis Posted December 20, 2011 Share Posted December 20, 2011 Hi everyone, I am just wondering if anyone here has ever created an automatic prestshop import script? The reason I ask is because we have a CSV that needs to be grabbed from an external site and imported. But the CSV on their site is updated every 4 hours, so we need to update our prestashop every 4 hours. I can download the file and upload it to my prestashop install every 4 hours if needed, I've created that script. But I need to know the query? What query/queries do I have to run to insert the products into the database (as I know Prestashop has many rows in the database that handle products) Any help would be brilliant! Thanks in advance Link to comment Share on other sites More sharing options...
sokpet Posted December 21, 2011 Share Posted December 21, 2011 if you made the script for upload, why do not you use cron to run it every 4 hours? Link to comment Share on other sites More sharing options...
guillenqn Posted May 15, 2012 Share Posted May 15, 2012 Hi, i'm looking for the same solution. Any luck? Thanks! 1 Link to comment Share on other sites More sharing options...
helldog2004 Posted May 15, 2012 Share Posted May 15, 2012 Hey guillenqn, yes there is a program for automatic import of .csv documents. Prestashop manager is a program to import .csv documents from your own desktop and has an extra add-on for automatic import of .csv documents. You can find the trial download of prestashop manager here: http://www.prestashopmanager.com/free-download The extra add-on you can find here which u can also try out first: http://www.prestashopmanager.com/prestashop-automated-product-import Let me know if this is anything for you. Link to comment Share on other sites More sharing options...
OnlineTrader Posted June 3, 2012 Share Posted June 3, 2012 Hi, I have a same problems with supplier's ~2500 products... daily I need to Update many-many prices and product stock statuses to show accurate Info in my WebShop. Is there any free presta solution for this? Best regards, OnlineTrader Link to comment Share on other sites More sharing options...
mary21b Posted June 20, 2012 Share Posted June 20, 2012 Hi guys, I've found this: http://www.file2cart.com/ and it seems to be exactly what you need. This is an online service for product import to a store from a feed or .csv file. And they also have a plan where you can set up your own scheduled import plan according to your wishes. So, I think that's easy this way. You just create your schedule for import, no matter if you need it done every day or every other hour and provide them with a feed or file and that's it. Have a look yourselves: http://www.file2cart.com/app/estimator And it seems pretty cheap. Anyway, let me know how all this ends) Hope this helps you Cheers Link to comment Share on other sites More sharing options...
Recommended Posts