Forum PrestaShop

Il Forum di PrestaShop è lo spazio in cui puoi condividere con la comunità di PrestaShop consigli pratici sull'e-commerce e trovare la risposta a tutte le domande tecniche e funzionali.

Forum PrestaShop

Jump to content

 

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

259 replies to this topic
#1
presta-dyr

    PrestaShop Fanatic

  • Moderators
  • 1045 posts
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

#2
Prestashopic

    PrestaShop Apprentice

  • Members
  • PipPip
  • 352 posts
That is great module. I think it will be helpful for everyone.

#3
SpyrosT

    PrestaShop Apprentice

  • Members
  • PipPip
  • 305 posts

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?

#4
presta-dyr

    PrestaShop Fanatic

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

Cheers,
Kjeld

#5
Rhobur

    PrestaShop Apprentice

  • Members
  • PipPip
  • 314 posts
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

#6
SmartiesKiller

    PrestaShop Addict

  • Members
  • PipPipPip
  • 542 posts
is there any demo to see exaclty what it does ?

#7
presta-dyr

    PrestaShop Fanatic

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

/Kjeld

#8
Mohegan

    PrestaShop Newbie

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

#9
presta-dyr

    PrestaShop Fanatic

  • Moderators
  • 1045 posts
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

#10
Rhobur

    PrestaShop Apprentice

  • Members
  • PipPip
  • 314 posts
I have sent you a mail on your .dk domain but it was rejected by server.
Robert

#11
presta-dyr

    PrestaShop Fanatic

  • Moderators
  • 1045 posts
Hi Robert.

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

/Kjeld

#12
Rhobur

    PrestaShop Apprentice

  • Members
  • PipPip
  • 314 posts
No, not yet, something must be wrong. Email is robertino.m@gmail.com ?

#13
presta-dyr

    PrestaShop Fanatic

  • Moderators
  • 1045 posts
Hi Robert.

I have sent you a PM.

/Kjeld

#14
SpyrosT

    PrestaShop Apprentice

  • Members
  • PipPip
  • 305 posts

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.

#15
presta-dyr

    PrestaShop Fanatic

  • Moderators
  • 1045 posts
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

#16
SpyrosT

    PrestaShop Apprentice

  • Members
  • PipPip
  • 305 posts
Sure... go for it, and give as much options as you can.

#17
deech123

    PrestaShop Apprentice

  • Members
  • PipPip
  • 149 posts
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.
www.degrootste.be
powered by PrestaShop

#18
presta-dyr

    PrestaShop Fanatic

  • Moderators
  • 1045 posts
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

#19
Rhobur

    PrestaShop Apprentice

  • Members
  • PipPip
  • 314 posts
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.

#20
Mohegan

    PrestaShop Newbie

  • Members
  • Pip
  • 7 posts
where are the open source submitters..? lets get on it for the benefit of all!!!