-
- cooper
 -
Total Posts: 20
Joined: 2008-03-31
|
jeff.d - 13 June 2008 11:20 AM cooper - 13 June 2008 10:55 AM I have imported my catategory tree (only around 160 categories). And It’s amazing!.
How did you import your categories? The direct SQL way or programatically?
Thanks
I imported the categories by SQL. For example, for each category, you can execute the following request :
insert into catalog_category_entity (entity_id, entity_type_id, attribute_set_id, parent_id, created_at, updated_at, path, position,level) values (2,3,3,0,now(),now(),'1/2',1,0);
insert into catalog_category_entity_int (entity_type_id, attribute_id, store_id, entity_id, value) values (3,30,0,2,1);
insert into catalog_category_entity_int (entity_type_id, attribute_id, store_id, entity_id, value) values (3,39,0,2,1);
insert into catalog_category_entity_int (entity_type_id, attribute_id, store_id, entity_id, value) values (3,47,0,2,1);
insert into catalog_category_entity_text (entity_type_id, attribute_id, store_id, entity_id, value) values (3,32,0,2,'');
insert into catalog_category_entity_text (entity_type_id, attribute_id, store_id, entity_id, value) values (3,35,0,2,'général catalogue');
insert into catalog_category_entity_text (entity_type_id, attribute_id, store_id, entity_id, value) values (3,36,0,2,'Général Catalogue');
insert into catalog_category_entity_text (entity_type_id, attribute_id, store_id, entity_id, value) values (3,51,0,2,'');
insert into catalog_category_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value) values (3,29,0,2,'Général Catalogue');
insert into catalog_category_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value) values (3,31,0,2,'general-catalogue');
insert into catalog_category_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value) values (3,34,0,2,'Général Catalogue');
insert into catalog_category_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value) values (3,37,0,2,'PRODUCTS');
insert into catalog_category_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value) values (3,46,0,2,'');
insert into catalog_category_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value) values (3,50,0,2,'');
Note : these request are only for version 1.1 as there are some database modifications between the 1.0 and 1.1.
You cand find in the table “eav_attribute” the signification of each attribute_id (for the categories the attribute_id involved are those with attribute_type_id setting to ‘3’).
By this way I have tested the maximum categories allowed with memomy_limit set to 64M (as it is a requirement to run Magento). I have found that 145 categories is the maximum that I can manage in the admin panel (and I have 0 products!...only categories...) More give me a fatal error : “Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 1572864 bytes)”.
I have tested this maximum with a very simple category tree : 145 categories all on the first levevel (as you can see on he first attached image) and after under a tree with two level : 10 categories on the forst level and all the others distributed into these master categories (see the second image). 145 : I’m afraid that I could not test my project in a shared server environment.....
Image Attachments
 
Click thumbnail to see full-size image
|
Sales: Call 800.374.8146 (N America)|757.278.0920 (International)
