tresseh Posted June 16, 2003 Posted June 16, 2003 Hey guys, I'm working on a store that has roughly 15,000 products through 14 or so categories. In some of these categories there are in excess of 3,000 products. When attempting to administrate these categories, It is becoming uncontrollable due to the sheer amount of results returned from the database. Waiting for 3,000 listings to download every time you select a new product is nigh-on impossible to tolerate, and in some cases can even time-out. I cant be the only one with this issue, has anyone looked at 'paging' the results returned in admin/categories.php to list a set amount of products per page? Any help would be greatly appreciated, starting to lose my hair at the early age of 21... Cheers. Regards, Jay.
shaky Posted June 16, 2003 Posted June 16, 2003 I can't help but I have the same problem... What about using the dhtml menu contrib on the categories box? No I guess that would't work as 1500 prods per cats would go beyond your screen. If you find out let me know.
tresseh Posted June 16, 2003 Author Posted June 16, 2003 Hi Shaky - thanks for your contribution, but its not the screen space i'm worried about. Even with a clever DHTML menu, the system would still need to process thousands of product information - which is the direct cause of the problem. I am going to look at adapting the product listing module from the catalog side to work in the admin - but I wondered if anyone else had done it before I got started. Regards, Jay.
loxly Posted June 16, 2003 Posted June 16, 2003 My suggestion is to break your categories into sub categories. I have 5000+ photographs to offer as/on 80+ products. It will not be pretty, easy populate is my best friend and I will be creating html pages to point to specific sections. I will also be looking at any and all search contributions to make it easier for my customers to find what they are looking for. In the meantimes, I plan to keep categories down to approximately 200-300 products, and have several levels of sub categories. example: Posters/NYC/Landmarks/Statue of Liberty/Night and second category Day [no external urls in signatures please, kthanks]
tresseh Posted June 17, 2003 Author Posted June 17, 2003 Hi Deb :) Long time no speak! Thanks for the suggestion, but unfortunately it's not viable in my case. The client already has the category structure from an existing setup, and is adament about keeping it. It cant be too hard to 'page' the results - I was just wondering if anyone has done it yet. Regards, Jay.
loxly Posted June 17, 2003 Posted June 17, 2003 LOL, gotta love the client. I have been brain dead and just re-read the post. I am sure that there is a way to page category results. http://coolnycgifts.com If that isn't what you mean then I claim to still be brain dead. (I STILL want to make a header menu like yours just havne't had the time. I started one in fireworks) [no external urls in signatures please, kthanks]
tresseh Posted June 17, 2003 Author Posted June 17, 2003 On the catalog side of things everything is fine, I've managed to manipulate the system a lot to give him the listings he was after - its the administration within the admin console thats the problem. The code will quite happily iterate through thousands and thousands of records - provided the script doesnt time out before then. Maybe some core developers would like to comment? I'm sure this would be an extremely valuable feature to integrate into the core? Regards, Jay.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.