SBKUnlimited Posted June 17, 2013 Share Posted June 17, 2013 First off - I'll be so thankful to whomever is able to help me solve this, it's really been bugging me. I'll definitely buy you a beer! I'm trying to add a product that's got a very large number of variations, color, size (diameter), size (width) and application. The end result is something like 3500 total variations. Every time I attempt to create this the product generator runs for maybe 15-20 minutes and then the page fails to finish loading. Upon inspection of the product and combinations, it appears to have added them all, but when visiting that section of my store, there is no product, no images, or description, the entire product details are all completely blank, showing only my background color. If I load the product page during the generation process, it generally shows all of the appropriate options up to about 75% completion. I've tried this on multiple PCs and even at another location. I'm also having trouble, where when adding a new product, I'm getting a the 'page not available' error. This has started today. I've tried enabling and disabling URL rewriting, as well as enabling and disabling multistore, but to no avail. My store's URL is: http://www.superbikeunlimited.com/presta/ under new products on the right hand side, you can see an "m4 y pipe" that's doing this. Please advise! Thank you! This is on Presta 1.5.3.1 Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 17, 2013 Share Posted June 17, 2013 Hi SBKUnlimited, that's a lot of variations to be loading at one time. PrestaShop will actually need to create 3500 different products so that is definitely going to take a while. It could be a memory error or max_execution error, have you turned on Error reporting in config/defines.inc.php >>> Mode_Dev set to "True".. That may give more information. Another alternative would be to break down that one product into a whole separate category. For instance, have a seperate category for that one product and break it down into subcategories using one of the Combinations. So instead of (example) Wheels, with combinations of 15inch, 16inch etc... You will have a Category of Wheels and subcategories of 15inch, 16inch etc. That will greatly reduce the number of combinations needed to be generated. Regarding the "page not available", if it started today then something somewhere must have caused that to happen. What is the parent(s) category that you are using for that product. Is it for all new added products or just this one? 1 Link to comment Share on other sites More sharing options...
SBKUnlimited Posted June 17, 2013 Author Share Posted June 17, 2013 (edited) Thanks for the rapid response. Your question about the parent category led me to try changing the 'default category' in the dropdown under attributes and it instantly resolved that issue. As for the enabling error reporting in that directory - I have not, I'm not very familiar with that kind of thing, but I can ask my webmaster to have a look at it. The subcategory idea I feel would not be suitable for the particular product and I don't want to create excess clutter - additionally, another presta-power store I'm familiar with has the same product and combinations successfully in place. I'd like to mimic that setup, ideally. Thanks again for the insight - I genuinely appreciate it. Any other suggestions for enabling the generator to finish? Edited June 17, 2013 by SBKUnlimited (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted June 17, 2013 Share Posted June 17, 2013 Even if you increase the memory, you may still run into Out of Memory issues if you'll need more attributes, and the front end will slow down, as there is a huge amount of Javascript code on the page for the combinations. Prestashop can generally handle about 1,000-3,000 combinations per product. We have created a module specifically for that, which changes the way combination are structured, and lets you use as many as you want (you do not need so many combinations, and cannot use the combination generator). You can read more about it and see a demo at http://www.prestashop.com/forums/index.php?/topic/47363-module-attribute-wizard-pro-create-an-unlimited-number-of-attributes-and-display-as-radio-button-checkbox-dropdown-textbox-teaxtarea-files/ Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 17, 2013 Share Posted June 17, 2013 I would suggest to turn on the error reporting method in the previous post. If you can access any php or apache error logs from your Cpanel or from contacting your hosting provider, that would be helpful as well. It could be a memory timeout issue in which case you can hopefully ask your hosting provider to increase it temporarily until you complete the upload process. 1 Link to comment Share on other sites More sharing options...
tomerg3 Posted June 17, 2013 Share Posted June 17, 2013 The higher memory is required not just for generating attributes, but for loading them, which happens on the product page (front and back), so anything temporary would not help. Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 17, 2013 Share Posted June 17, 2013 Hi Tomer, thanks for the insight but wouldn't you say that it requires significantly more memory to initially upload the combinations than to load them in a live store after it's uploaded. Link to comment Share on other sites More sharing options...
tomerg3 Posted June 17, 2013 Share Posted June 17, 2013 No, as there's only 1 function that is used to load all of the combinations. The issue is not with generating them, that part does not require the memory, as it simply adds records to the DB, however, when you try to read all of the, you start getting the OOM errors. Link to comment Share on other sites More sharing options...
SBKUnlimited Posted June 18, 2013 Author Share Posted June 18, 2013 Thanks for the input guys - I'm going to set up error reporting ASAP and report back. Thank you. Link to comment Share on other sites More sharing options...
SBKUnlimited Posted June 18, 2013 Author Share Posted June 18, 2013 OK - so I've reduced the number of combinations and the generator completed. However, my end result is a completely blank product page. See here: http://www.superbikeunlimited.com/presta/yamaha/98-driven-aluminum-hard-anodized-rear-sprocket.html Link to comment Share on other sites More sharing options...
tomerg3 Posted June 18, 2013 Share Posted June 18, 2013 Blank page = Out of memory error (you can turn on error reporting in /config/defines.inc.php line 28). The product page take up more memory as other modules are loaded, which is why are getting the OOM error. 1 Link to comment Share on other sites More sharing options...
SBKUnlimited Posted June 18, 2013 Author Share Posted June 18, 2013 So my solution is permanently increasing memory with my hosting provider? Link to comment Share on other sites More sharing options...
tomerg3 Posted June 18, 2013 Share Posted June 18, 2013 That is one solution, although the front end may still be a little slow. You can further reduce the number of combinations, or check out the module I suggested (which will allow you to use as many attributes are you need) Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 18, 2013 Share Posted June 18, 2013 Hi, turn on the error reporting one last time and confirm the error. Link to comment Share on other sites More sharing options...
marcis Posted November 27, 2013 Share Posted November 27, 2013 Even if you increase the memory, you may still run into Out of Memory issues if you'll need more attributes, and the front end will slow down, as there is a huge amount of Javascript code on the page for the combinations. Prestashop can generally handle about 1,000-3,000 combinations per product. We have created a module specifically for that, which changes the way combination are structured, and lets you use as many as you want (you do not need so many combinations, and cannot use the combination generator). You can read more about it and see a demo at http://www.prestashop.com/forums/index.php?/topic/47363-module-attribute-wizard-pro-create-an-unlimited-number-of-attributes-and-display-as-radio-button-checkbox-dropdown-textbox-teaxtarea-files/ Hi tomerg3, Maybe I'm wrong but your module requires the administrator to manually create all the combinations one by one... right? Regards Link to comment Share on other sites More sharing options...
tomerg3 Posted November 27, 2013 Share Posted November 27, 2013 Yes, that's correct, but the number of combinations you would need is substantially lower than you normally would with Prestashop Link to comment Share on other sites More sharing options...
mhibarra Posted June 23, 2014 Share Posted June 23, 2014 Yes, that's correct, but the number of combinations you would need is substantially lower than you normally would with Prestashop Hello With the module I can force a user to select a combination? I mean, I would like to put it as a filter to make sure that I select an attribute. example: http://jm-megamall.demo.joomlart.com/colorful-flower.html Link to comment Share on other sites More sharing options...
Recommended Posts