Custom Product Importer

[manoj_malviya]

Hi all,

As my effort to give back to this great prestashop community, I want to share prestashop product importer.

I have developed some php classes, that can be used to push product data in prestashop from any source.

So far I have tested it with csv and xml, by virtually it can be used to import data from any source. Since It is developed
in OOP way, you can customize/ extend it to suit your need.

Note that I haven't developed them as a module but rather it will work as an standalone tool, and can be invoke via command line or url.

If anybody need/want to review. please let me know.

[misa]

I am interested. Is this for 1.3?

[manoj_malviya]

I never worked on 1.3

Don't know if it work with 1.3.

Also not that, it will not work out of box. you may need to adjust some code according to your data source.

[optiplex1]

how to i find older version solutions

[cha]

Hi,

Very Interested how can I get it?


Chavone.

[manoj_malviya]

Here you go.

Should be straight forward to understand

BaseClass : ProductImporter

Child Class : AccessoryImporter (an example import class)(work for xml data source)

AccessoryImporter Can be invoked via command line.

ini_set('max_execution_time', 600); //600 seconds = 10 minutes

require(dirname(__FILE__).'/../../config/config.inc.php');
require_once('ProductImport.php');
require_once('AccessoryImporter.php');
require_once('Logger.php');

$accessories = Simple_XML_Load('path to xml');

foreach($accessories ->accessory as $acc){
       $accessroyImport = new AccessoryImporter();
       $accessroyImport ->SetProductSource($acc);
       $accessroyImport ->Save();
   }

ProductImporter.php

AccessoryImporter.php

[cha]

Any suggestions on how to add download_file support (for download products)?

Thanx

[manoj_malviya]

Should be doable. But will need to look into prestashop core, how that work.

[JulianM]

Ok, this sounds very exciting. I will try to use it for 1.4.5.1 and see if it works. I have a db of 1000 products to import from a csv and need to update it periodically.

 

Well, I Am assuming that require_once('ProductImport.php'); actually means ProductImporter.php

[numeric69]

hello, how I can add a product from a module with such class?

[Nozonda]

Even though it is a while ago that this is posted.. I just want to say thank you! Works great I am connecting an web service to get the products and your classes saved me a lot of time.

[websku]

Hi! Thank you for the scripts, I do have few questions.

How can I use your script to bulk insert 1000 products with random attributes? I want to test Prestashop stability and performance and I can't find any code to help me import a single product from an external script uploaded to server.

 

If you help a bit, I can share the tests results. Thank you!

[Nozonda]

Little bit like his example, but then:

for($i=0;$i<1000;$i++){
$accessroyImport = new AccessoryImporter();
$accessroyImport ->SetProductSource(array());
$accessroyImport ->Save();
}

And then edit AccessoryImporter.php to make some random values. Like:

protected function GetName(){
return "this is a random title ".rand(100000,999999);
}

You have to change almost every function in there to return something.

 

For features you could use:

protected function GetFeatures(){
return array('test'=>'bla','sfdsfd'=>'fsfd');
}

Attributes is currently not supported, but shouldn't be too complicated to make if you look at the function AddFeature in ProductImporter.php.

 

Good luck.

[websku]

hi.

 

It didn't work, so I found the built-in csv importer and was ok. Thanks anyway!

[webxtor]

Thanks!

This helped me to complete a project I am working on.

I know, most of the functions are from AdminImportController.php but still a good job has been done!

[ovoce]

Hay, yo !! Thank You very much ! It is good to get know, how the things works.

 

You save "my life" !!

[giancarlo.spadini]

Very interesting.

 

But you have a schema for XML file with products to import?

Where I can find an XML file as example?

 

When you write this:

$accessories = Simple_XML_Load('path to xml');

[giancarlo.spadini]

A little contribution.

 

ProductImporter.php line 452 uses a deprecated function:

imageResize($newimage, $path.'-'.stripslashes($imageType['name']).'.jpg', $imageType['width'], $imageType['height']);

 

can be replaced with:

ImageManager::resize($newimage, $path.'-'.stripslashes($imageType['name']).'.jpg', $imageType['width'], $imageType['height']);

 

So you can also remove line 3 that is no more necessary:

 

include_once(PS_ADMIN_DIR.'/../images.inc.php');

Edited August 7, 2013 by giancarlo.spadini (see edit history)

[dan.pascu]

Very interesting.

 

But you have a schema for XML file with products to import?

Where I can find an XML file as example?

 

When you write this:

$accessories = Simple_XML_Load('path to xml');

Hi Giancarlo,

 

Did you fint the xml schema for this script? Can you share it please?

 

Thank you.

[giancarlo.spadini]

Hi Giancarlo,

 

Did you fint the xml schema for this script? Can you share it please?

 

Thank you.

 

No, i haven't found a valid xml for this script.

I have solved creating an array (the product) with the fields needed by the calls in function AddUpdated().

 

If your shop is in Italy, Portugal or Spain we have completed a module to start selling over 10.000 products from our dropshipping wholesales.

[Galanid]

Hi,

 

Someone know how to integrat this class in a script in order to import csv containing product ? I need to use a comand line way to import my base product and the only way to do it on my server is commande line as i dont have time out issue with command line environement. ( while if i use the built in csv function it fails)

 

cheers

[atef1987]

hi nozonda,

 

i'm in the same situation, if you can explain to me how to do fix the situation.