ssir Posted June 24, 2013 Share Posted June 24, 2013 Hi, How I can do to make Prestashop load stock information from an external application? The stock system can export every hour one asci file. How can I tell Prestashop to update and modify the quantities of products automatically loading this file? Thank you! Link to comment Share on other sites More sharing options...
vekia Posted June 24, 2013 Share Posted June 24, 2013 if you're familiar with php - you can write a module for prestashop and run it with cron job for every hour. 1) download asci file with stock qunatity (and product id) 2) run sql query to update stock quantity based on product id Link to comment Share on other sites More sharing options...
ssir Posted June 24, 2013 Author Share Posted June 24, 2013 if you're familiar with php - you can write a module for prestashop and run it with cron job for every hour. 1) download asci file with stock qunatity (and product id) 2) run sql query to update stock quantity based on product id Thanks for the answer! I am not familiar with PHP. Do you know if there is any module that can do this, or any tutorial? Thanks! Link to comment Share on other sites More sharing options...
vekia Posted June 24, 2013 Share Posted June 24, 2013 it's not as easy as it seems, because everything depends on file format that you've got from external application. you need also possibility to set up cron jobs on your webhosting service. In this case i don't know any tutorial which shows how to create it. I can give you some tips how to create module like this. but in my opinion - if you aren't familiar with programming - it's better to hire someone. Link to comment Share on other sites More sharing options...
ssir Posted June 24, 2013 Author Share Posted June 24, 2013 I guess I will. The problem is I don't know who. I'll look for in this site. If you have nyone to recommend, will be welcome! Link to comment Share on other sites More sharing options...
vekia Posted June 24, 2013 Share Posted June 24, 2013 give us more information about what you exactly expect, what prestashop version you use and how the ASCI file looks like. Then i will move this thread to the paid / job offers section Link to comment Share on other sites More sharing options...
ssir Posted June 24, 2013 Author Share Posted June 24, 2013 (edited) give us more information about what you exactly expect, what prestashop version you use and how the ASCI file looks like. Then i will move this thread to the paid / job offers section I'm using 1.5.4.0 The file is not an issue. I can ask for any file I want. And it can be ASCI, CSV, or many others. I just need to change the stock according to the system they use. Teh can export the data in any way I ask. Thanks! Edited June 24, 2013 by ssir (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted June 24, 2013 Share Posted June 24, 2013 the most important things are: csv file must contain id_product field products in your store must have the same id_product as in the csv file quantity field additional quesiton: have you got quantities to combinations etc. ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now