[MODULE] Fast CSV or XML import of thousands products in a few seconds
Started by presta-dyr, May 29 2010 07:49 AM
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
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
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?
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
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
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
/Kjeld
From 1275369627:
Actually, there is an option for exactly that (i.e. preserve categories).
Cheers,
Kjeld
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.
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
/Kjeld
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.
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.
www.degrootste.be
powered by PrestaShop
powered by PrestaShop
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
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
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.



Back to top











