alexk345 Posted June 29, 2015 Share Posted June 29, 2015 I imported 100000 rows of pricing combinations and front end product page froze. It seems like prestashop is not designed properly. Even import was bad , i just customized import to add comination per product. It worked for 1000combinations though. It seems like the whole combination logic is very badly implemented. I will fix it though. I will scrap prestashop product controller and disable combination stored in array. May be in few days i fix it to handle infinite number of combination. I really wonder why prestashop implemented this way. Even woocommerce was this mess. I fixed it in woocommerce to handle unlimited combination ( its called variations in woocommerce) Also i find prestashop super slow and it does not have to be. It is slimmer than bloated wordpress. So some thing fishy going on with prestashop core code. I will fix that as well once i fix my price issues. Link to comment Share on other sites More sharing options...
alexk345 Posted June 30, 2015 Author Share Posted June 30, 2015 Ok i solved it with one line change. I can handle unlimited number of combinations. I do not load combination in memory like prestashop does. That is the difference. Link to comment Share on other sites More sharing options...
alexk345 Posted June 30, 2015 Author Share Posted June 30, 2015 But Admin page tabs froze. I think prestashop designed for T shirt store. They load combination assuming its only few 100-1000. So if anyone have 10000 combination its not right product to use. I am hacking admin page and disabling combination from admin tabs. Lots of work. There is no other choice now. I need to do in less time . Otherwise i would build my own custom store. I am kinda prestashop noob now...probably at end of this project i know enough to stay away from prestashop in some big complex project. I definitely use prestashop for colorful less combination product store like cloth to various retail store. I really like import screen , it just need ajax progress bar and batch upload for large data. There should be a way to disable combination from admin pages. i need only all configuration for product not its child variation. Anyways... Link to comment Share on other sites More sharing options...
Storgaard Posted July 1, 2015 Share Posted July 1, 2015 Could you please share what to change so it can handle unlimited number of variations?? I need to add 16000 variations to a single product, but it freezes every time I try to do it and it messes up the product, so I have to delete the product completely. Regards, Storgaard Link to comment Share on other sites More sharing options...
alexk345 Posted July 1, 2015 Author Share Posted July 1, 2015 hi You have to hack prestashop. 1. Changes to adminproductcontroller , product.php - wherever product_attribute used , you have to look at that to see whether you need the query. You just limit the result 1 by adding limit 1 , so you do not need to break too much. All you are doing is basically make admin tabs load faster. 2. Import all combinations. I created custom import for my use. I just by pass prestashop import. EVen 100000 memory out of error with sql. So there may need batch import with update or new( clear existing prdduct combination everytime) . Divide csv for partial imports. 16000 you do not need to do that. for me 100000 took some time like 15min. 3. Front end product.js and product.tpl has to be changed. 4. You have to get price through ajax call by passing prestashop. Lots of work it took 3 days breaking my head and learning new stuff . Its easy once you know prestashop but i have zero knowledge of its workflow so it took some time. Also there is search index line you have to comment for admin tab to save anything. I did n't look through it . i think its saving all combination when you save in backend Also disable suppliers , price and quantities tabs. Not needed for my use. Basically you have to disable lots of things that do not need it in your business. Lots of small small changes. I have not fully tested system yet. I just started on prestashop last wednesday first time ever. So at present i am all over as i want to learn shortest possible time. Thats all info . I am kinda busy now as i have deadline...i can help after week if you still need it. Link to comment Share on other sites More sharing options...
Storgaard Posted July 6, 2015 Share Posted July 6, 2015 Thanks for your reply. It helped a lot :-) Link to comment Share on other sites More sharing options...
Recommended Posts