Jump to content

Auto-import of csv-file


Recommended Posts

Hi

 

I am looking for a solution for my new webshop. I'm going to use Dropshipping from my supplier and therfore I need a module of some kind which can auto-import a CSV-file which my supplier uploads to my FTP-host every morning.

 

The file contains:

- Product names

- Stock quantity

- My purchasing price before taxes

- Productnumber
- Description

 

I am searching for a module that can handle automaticaly import of such a file into Prestashop every morning around 6am. Is that possible?

 

I have the following request for the module

- New products should be set to disabled in the webshop the first time they're imported.

- Existing products should only be uploadet with stock quantity and my purchasing price.

Link to comment
Share on other sites

Hello Anders,
 

There is such module that can handle automaticaly import of CSV file into Prestashop every time period you want. Store Manager for Prestashop and its addon called Automated Product Import allows you to set up update of your inventory from your supplier. It gives a possibility to handle import using the remote file from your partner (you need to have http or FTP link with access details to the file). Just set up import once and further all will be done automatically.

 

Concerning your request for the module:

On the last step of importing you can disable products that are not listed in .csv

- You can update quantity and purchasing price. In your case you have to determine product ID, Quantity and Price fileds in order to make updates.

 

Check this article -

http://www.prestashopmanager.com/useful-articles/how-to/how-to-accomplish-prestashop-cron-import-with-automated-product-import-addon/

Edited by Constantino (see edit history)
Link to comment
Share on other sites

Hello Anders,

 

There is such module that can handle automaticaly import of CSV file into Prestashop every time period you want. Store Manager for Prestashop and its addon called Automated Product Import allows you to set up update of your inventory from your supplier. It gives a possibility to handle import using the remote file from your partner (you need to have http or FTP link with access details to the file). Just set up import once and further all will be done automatically.

 

Concerning your request for the module:

- On the last step of importing you can disable products that are not listed in .csv

- You can update quantity and purchasing price. In your case you have to determine product ID, Quantity and Price fileds in order to make updates.

 

Check this article -

http://www.prestashopmanager.com/useful-articles/how-to/how-to-accomplish-prestashop-cron-import-with-automated-product-import-addon/

 

Hi and thanks a lot for the tip. I have tried Shopmanager, but it does not work for me. It's to expensive and complex for me and the task I want to run.

 

I was thinking if it was possible to make a cronjob in some way that just runs in the background automaticaly every morning. The big issue is, that the file I get is ending it's name with the date every day, so the filename will not be the same.

Link to comment
Share on other sites

  • 1 year later...
×
×
  • Create New...