Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Magmi Import Issues, Please help! (Categories and not importing all products.)
 
jrsteensen
Jr. Member
 
Total Posts:  11
Joined:  2011-06-06
 

Got turned onto Magmi, a database importer - runs waaaaay faster than dataflow. Trying to import a file with 18k products, and will be importing a delta every night with up to 15k changes.

Categories Issue
Seems to import perfectly, except for my multiple categories that I am importing to. Seems to be going to any old random place. Any help would be great - trying to get this guys site up and live by New Years.

Plugins enabled:

Import Report Mail Notifier v1.0.0
Magmi Optimizer v1.0.5
Magmi Magento Reindexer v1.0.2

Semicolon Delimited file sample below: (Note that I am trying to assign it to the 2, 35, and 36 categories in the 5th (category_ids) field.)

store;websites;attribute_set;type;category_ids;sku;has_options;name;image;small_image;thumbnail;url_key;url_path;page_layout;options_container;msrp_enabled;msrp_display_actual_price_type;gift_message_available;rsr_pn;manufacturer_pn;price;cost;weight;msrp;manufacturer;status;is_recurring;visibility;enable_googlecheckout;tax_class_id;description;short_description;qty;min_qty;use_config_min_qty;is_qty_decimal;backorders;use_config_backorders;min_sale_qty;use_config_min_sale_qty;max_sale_qty;use_config_max_sale_qty;is_in_stock;notify_stock_qty;use_config_notify_stock_qty;manage_stock;use_config_manage_stock;stock_status_changed_auto;use_config_qty_increments;qty_increments;use_config_enable_qty_inc;enable_qty_increments;is_decimal_divided;stock_status_changed_automatically;use_config_enable_qty_increments;product_name;store_id;product_type_id
admin
;base;Default;simple;2,35,36;511-40011-010-L;0;5.11 HOLSTER SHIRT L WHITE;/5/1/511-40011-010-L_1.jpg;/5/1/511-40011-010-L_1.jpg;/5/1/511-40011-010-L_1.jpg;511-40011-010-L;511-40011-010-L.html;No layout updates;Block after Info Column;Use config;Use config;No;511-40011-010-L;40011;74.99;50.88;5;74.99;5.11 Tactical;Enabled;No;CatalogSearch;Yes;Taxable Goods;5.11 Tactical Short Sleeve Shirt L White Holster Shirt Crew 40011;5.11 Tactical Short Sleeve Shirt L White Holster Shirt Crew 40011;4;0;1;0;0;1;1;1;0;1;1;0;1;0;1;0;1;0;1;0;0;0;1;5.11 HOLSTER SHIRT L WHITE;0;simple

All products Issue

Seems to be hanging after 2-3k products. Does them in about 2 minutes, then seems to hang forever!

Thanks so much for any help you can provide!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Designcomplex
Member
 
Avatar
Total Posts:  34
Joined:  2009-07-12
Hamburg
 

check your webserver configuration.
If you’re using php-fpm and nginx try to set fastcgi_buffers higher than defaults.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top