[MODULE] Fast CSV or XML import of thousands products in a few seconds

[presta-dyr]

I offer a module that can import XML (and CSV) files. I have been working with files that import thousands of products.

One of the big problems when importing is that resizing the images takes way too long time. Typically the server can resize only 1 image per second. I have found a way to handle this.

Features
* Fast import of products from CSV og XML files.
* Support for multiple languages.
* Support for multiple images.
* Support for multiple suppliers
* Support for attributes.
* Support for features.
* ISO-8859-1 or UTF-8.
* Possible to automatically calculate the sale price based on wholesale price.
* Possible to specify delimiter for categories and sub-categories.
* Option that allows alphabetically grouping of sub-categories (useful if there are a lot of them).
* Installs as a tab under "Tools" in the back office.
* Possible to resume the import if the maximum run time is exceeded.
* Automatically creates categories and sub-categories.
* Setup for mapping of CSV or XML fields are saved in the database.
* Images are fetched and resized on demand.
* A cron job can handle the resizing of the images at nights.
* Comes with manual in PDF format.
* Possible to update existing products.

Notes
* Products, categories etc. should not be deleted but you may automatically deactivate products that are no longer in the CSV/XML file you get from your supplier.
* It is possible to delete all images from a specific supplier from the back office.
* It is possible to delete all products from a specific supplier from the back office.
* It is possible to delete all empty categories.
* It is possible to delete all products, categories etc. if you really want to start all over.

If you have a lot of categories, PrestaShop (1.2 and 1.3) tends to load slowly. I have posted a fix for this.

The price is $100.

Edit 2010-10-20: Updated with new features like multi-supplier.
Edit 2011-05-21: Works with PrestaShop 1.4.

/Kjeld

[Prestashopic]

That is great module. I think it will be helpful for everyone.

[SpyrosT]

From 1275115759:

Notes
* All products, manufacturers and categories are deleted when importing.

The price is $100.
/Kjeld

Nice module, but what about if someone needs only to import products into existing categories?

[presta-dyr]

Actually, there is an option for exactly that (i.e. preserve categories).

Cheers,
Kjeld

[Rhobur]

Hi,
Can you send a demo to robertino.m@gmail.com so I can be sure it's working ?
I'm using Presta 1.3 btw.
Thanks

[SmartiesKiller]

is there any demo to see exaclty what it does ?

[presta-dyr]

Yes, send me an e-mail so I can create a login for you.

/Kjeld

[Mohegan]

Id like to see a demo if possible also - do you also have a sample cvs file for me to review..

[presta-dyr]

Sure, I have a bunch of (authentic) CSV and XML files I have used for test. I guess you are looking for something specific? I mean a simple, short CSV file works fine with the existing import function.

/Kjeld

[Rhobur]

I have sent you a mail on your .dk domain but it was rejected by server.
Robert

[presta-dyr]

Hi Robert.

I sent you an e-mail at 11:34. Didn't you get it?

/Kjeld

[Rhobur]

No, not yet, something must be wrong. Email is robertino.m@gmail.com ?

[presta-dyr]

Hi Robert.

I have sent you a PM.

/Kjeld

[SpyrosT]

From 1275369627:

Actually, there is an option for exactly that (i.e. preserve categories).

Cheers,
Kjeld

Is there an option so that you can only add products?
I have my categories and I have 500 products which I need to keep them.

[presta-dyr]

Currently it is not possible to add products to an existing base. It is much faster just to add products from scratch than to update products. But I have an idea how it can be made...

/Kjeld

[SpyrosT]

Sure... go for it, and give as much options as you can.

[deech123]

Presta-dyr

look at my post : http://www.prestasho..._a_xml_importer

two files (one xml example, other is a field setting document)

can your importer do this?
ps : product can NOT be deleted when starting import.
only when the status code <>"NORMAL" then you can delete a product.

this because I have two suppliers.
one small (over 450 articles) I've added manualy those products.
the other over 15000 articles I must update/delete/add every week/night.

look at my post and I'll hear it back from you.

[presta-dyr]

Hi deech123.

Currently the module does not support appending or updating products. But if you're willing to pay for it I can make a special version that suits your needs.

I have sent you an e-mail.


/Kjeld

[Rhobur]

I'll be interested too in this module supporting appending and updates; so far i haven't had the time to fully test this module due to the countless problems I have after upgrading presta to last version; I hope that I'll finish this in a few days and get back to testing because god knows I'm in great need of a such working module.

[Mohegan]

where are the open source submitters..? lets get on it for the benefit of all!!!