Can Prestashop Handle 2 Million Products?

[sneakypete92]

Can PrestaShop handle over 2 million products (no combinations though) - if this is even possible???

We're struggling with importing the products and expect issues with search indexation.

If anyone can give us some advice on how to achieve this we would love to know what issues to look out for, what modifications are required, what hosting is required, etc.

Thanks

[doekia]

Handling that number of products is totally feasible with stock PrestaShop (all version).

Managing them (i.e back-office actions) is more at stake and mostly unfeasible w/o 3rd party tools (specially in 1.6+).

Importing more than a few thousand thru off-the-self import mechanism is a definite no-no (specially in 1.6+).

 

Specific import script are required to achieve the goal.

Indexing (search) feature need some adjustement and most of the time need to be pruned-off the solution.

Be carefull sql cache should you go clustering for load distribution. It has numerous design flaw that require coding adjustment. DbPDO may not be your friend with 1.6+.

All features involving rand need to be pruned off or to have cleaver redesign.

Every modules - including natives should be reviewed with performance/volume in mind.

Another area that requires attention is audience, specially with the so called "cache" which are mainly performance killers soon you have more than a few visitors per day. Caching 2M products means 2M cache files roughly speaking (disable such soon you go production and that is my advise for everyone).

 

 

Currently I have an install with 1.3Million products another with 400K and yet another with 80K + 15 combinations average per product.

[selectshop.at]

Yes possible, but not really a question, if a software can or not. Mainly this depends on the hardware used (this for every software available on the market). Prestashop has some bottle necks (database and software) on his native layered navigation tool. If you refrain to use and use any other paid JS based filter, than of course Prestashop is speedy enough to handle 2 Mio products or more (provided you have a boosted hardware).

 

If you only wanto to import ONCE you products than give a try to Presta Store Manager (paid addon you can use free for 30 days, than after you don't need to buy or extend license ) This tool don't use the Prestashop scripting and easily imports all direct to database with own scripts

Edited December 6, 2015 by selectshop.at (see edit history)