import function that really works
It would be great if the import/export really worked.
Like importing bundle and configurable products.
Lui Pan commented
The import mainly depends on the project features and usually opens some good opportunities for optimization. These opportunities are possible to use regardless Magento extension for product import specification applied. We also know that the clean import time is just a little part of the whole execution time that is required, so the idea posted below would be great news for Magento Family members.
Hung Nguyen commented
This extension allows you to direct transfer all data from magento to magento without the need of import/export:
Magento tutorial commented
This is extension about importing bundle and configurable products which works well here http://www.magestore.com/magento-extensions/magento-affiliate.html
There are a lot of different extensions for import. So why not to use for example this one http://www.magentocommerce.com/magento-connect/file2cart-magento-product-import-9633.html? I use it and import became like a leisure for me now. There are a lot of useful info about import on their site also.
Store Manager (http://www.mag-manager.com) allows to Import/Export configurable and bundle products without any efforts. Please find useful article for details:
Now it can actually be done with this store manager for magento extension: http://www.mag-manager.com/magento-automated-product-import. It really works
Years later and not much has changed. If you're running 1.4.x.x below version 22.214.171.124 and you're feeling oppressed and disheartened, there's a massive memory leak, go search the Magento Community Forums and you'll find how to backport if you're not in a position to upgrade to 126.96.36.199 or greater. It almost gets your 1.3.x.x performance back. If you're running a real e-commerce website with the need to not fark around with chopping your large SKU database down into smaller chunks to do simple sitewide mass pricing changes, have a look at MagMI (Magento Mass Importer) which uses SQL to do the updates. http://sourceforge.net/projects/magmi/
This is crucial and I would of thought a high priority for any store owner. The current feature is hit and miss. Any large uploads are a waste of time be because errors are not reported. What's the point of that!
Flip Vernooij commented
Every webshop that will ever use magento will wanna import their products using csv or xml (manual creation of 500 products is insane!)
How can you release a webshop that has such a minimal support for imports?
I need to import configurable products straight from CSV and I do know I'm not the only one
Dataflow is a joke. Sorry but there's no other way of putting it. Not only do we need all of the above ideas implementing but also import of multiple images and tiered pricing too.
One of the most absurd things that Dataslow does is serialize all the import data from the csv file, permanently storing it in the dataflow_batch_import table. The same is done with the export data (to a batch export table). That is absolute nonsense. I see no real reason for such data to be continually duplicated during import/export, even when those records may not actually import due to errors or what not. It's especially maddening that there isn't even an option to bypass such insanity.
Furthermore, it's ludicrous that thousands of records can be both serialized and then saved to that same dataflow_batch_import table in a matter of seconds (even if it is 60 seconds). Yet it can take upwards of an hour for that data to then become re-unserialized, and then translated to the other sections of the database that contain the relevant data.
Just stop with the tom-foolery already! Imports should take mere seconds, not hours!!
I would give heavy speed improvements all 10 of my UV points if I could.
... Aside from that, the import profile runner (/admin/system_convert_gui/run/id/3/files/somefile.csv/) needs a complete overhaul. Seriously lacking on the page are any sense of time (via timestamps). It would be helpful to know when the import started, when it finished, and for each error or other message that posts from the ajax calls.
Errors are often grossly vague and inhuman.
There needs to be a record ID and timestamp for all errors that post. And their location is not ideal.
Errors should be last on the page. They should never be sandwiched between the "Starting" and "Processed" progress bar. All important information, ESPECIALLY the import progress data, should remain fixed at the top. This is especially true because when several errors (or in my case, blank lines skipped due to "required field 'sku' not defined") can cause the information to become "pushed" off the visible region of the page continuously. Very annoying for those importing a lot of records, especially when using blank lines as visual organization for groups of grouped products and their simple sub-products.
Magento is so buggy, and so cumbersome to use (usability is fatally flawed), I honestly don't see how big companies use it... let alone pay tens of thousands per year to do so. How asinine!
Well, the least Varien could do with that money is hire better developers and spend some serious time improving the clumsy and cumbersome workflow that comes with Magento.
Scott Showalter commented
It would also help to get some errors to print out when they (all too frequently) occur. The AJAX import ...well, it's beyond words just how bad it really is.
Scott Showalter commented
...and let's not forget categories. Category import is a must!
will be extremely useful if we can import categories, attribute dropdown values, either by themselves or with a product.
basically all data input should be able to be done via import function, or API
This may be the most important feature for Magento
I wish this can be done soon.
I 2nd this" When a line fails during import it would be extremely helpful if it told you what line had failed along side the notification."
Easy populate.. 3 minutes to import 20,000 products..
Magento... 1 hour down and about 7 more to go..
This is essential, especially being able to import grouped products and all attributes etc.
Category ID?? Can we use the cat name instead and if it doesn't exist can it generate it? Easy populate does this perfectly in zen cart.
A faster import is essential. Magento has to be one of the slowest at importing data, in no small part because it seems to automatically truncate certain tables with almost every import.
Also: When a line fails during import it would be extremely helpful if it told you what line had failed along side the notification.