Script To Run As A Cron Job To Update My Products.

[JOEFTE]

I need help writing a php script to run as a cron job once a day to update my products. My supplier has a datafeed in csv format that has stock information. I need a script to read that file and update the products in my database so that they can be enabled if in stock or not active if out of stock.

[Knowband Plugins]

Don't you need to update quantity or just want to change product status?

[JOEFTE]

Just need to set available for order or turn it off. I am using a drop shipping wholesale. Their data feed has a list of orders that are in stock and another list of items not in stock.

[im_presto]

Hi, I have developed a few modules of cron job for product's add/update and inventory synchronize based on different drop shipping data feed (XML, JSON & CSV). I can help you out in your cron script.

[Knowband Plugins]

You can write PHP script to read CSV sheet from supplier server once per day. Script can be write in such a way to automatically make changes in order status as per stock availability information in the sheet.

 

To read CSV sheet use below code:

 

$file = fopen("./sample.csv","r");

 

while(! feof($file))

  {

  $line[]=fgetcsv($file);

 

  }

echo '<pre>';print_r($line[0]);echo '</pre>';

fclose($file);

 

If you are interested we can write this script for you. Contact us to get quote.

[NeedZoom]

Hi,

after i write this csript php  where i put this for calling in cron jobs of prestashop?

if any tuto for this? thanks

[Knowband Plugins]

If you are writing it as plain php file, you can place it in root directory of your store.