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

[TUTORIAL] How to import any CSV with images into Magento, no Magmi at all, 100% working
 
pesst
Jr. Member
 
Total Posts:  7
Joined:  2011-11-22
 

Hi! oh thank God! after days of working and searcing for info that fails, I\’ve found out how to import correctly a CSV file to a Spanish (or any language, or not) magento with images, from a new installation + template.

1º) To Install magento go to your hosting panel via simplescripts (or create db and upload files manually etc...), go to system>my account and change to adminshop354 or something and strong password for security reasons

2º) To set the currency in Euros: Go to system→configuration→currency and choose euro, save (I\’m Spanish, we have Euros -for now lol-)

3º) To set language to spanish: http://www.elblogdemagento.com/instalar-idioma-en-magento/ set the backend to spanish or any other language with the dropbox in the bottom, Go to system>config>etc… set all to spanish, the frontend has already spanish language

4º) To import the CSV file:
- Upload your images folder’s content to “/media/import”
- Create all categories manually as part of subcategory of one called shop (which is precisely your shop\’s name)
- If you dont have to track stock you have to shut it off completely from system>config>inventory so now can see all products
- Create 1 product with all attributes, asign it to a category
- Install module http://connect20.magentocommerce.com/community/Import_Products_categories__multiple_images_and_custom_options via magento connect
- Use its CSV file and edit it with your csv info http://www.megafileupload.com/en/file/271786/Import-Products-Sample-csv.html
- Import profile→all products, wait like an hour

My fully woring CSV file has more than 1600 products, example: http://dpaste.com/666880/

5º) To set a cool template, you have only 1 chance, if fail go to phpmyadmin and set manually in talbe: mgn_design_change
You better use a template from magento_connect cuz manually added dont work (at least for me, perhaps version issue....)

Hope this helps!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
WotWorkz
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2011-10-28
 

I’m kind of missing the point?  You said it yourself..... “Wait like an hour” to import 1600 items!!  No thanks.  We have a catalogue of over 60 thousand items!!  And we don’t wait anything like an hour (with images) with Magmi.  I’m upset if I have to wait 5 min!!  We recently did an upload of a new line consisting of 2000 configurable items totaling about 10000 simple products with images being pulled from our suppliers site.  That took an hour due to the image downloads.  What exactly is it you are trying to achieve?  The whole point of Magmi is to directly act on the database and get FAST uploads and FAST updating of inventory without bogging down your server.

 
Magento Community Magento Community
Magento Community
Magento Community
 
pesst
Jr. Member
 
Total Posts:  7
Joined:  2011-11-22
 

I’m sorry buddy, is this any kind of contest, marathon or Guiness award winning stuff?

I was trying out Magmi and other stuff to import images and didn’t work, giving error msgs that none could ever fix…

Who cares about how fast the info is processed since do it well? I mean, I can go sleep leaving the process and have thousands of products added the following day before I have breakfast, since this process is not the one you do every day or even every month… it doesnt really matter.

 
Magento Community Magento Community
Magento Community
Magento Community
 
WotWorkz
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2011-10-28
 

Ahh !! If you were not able to get Magmi set up and operating it makes a little more sense.  I couldn\’t help but notice that the only question you ever asked in relation to Magmi was not even on the Magmi thread and so it went unanswered.  It does take a little more knowledge and time to understand and set up but it\’s time well invested.  You might like trying to post future questions on this thread http://www.magentocommerce.com/boards/viewthread/201210/ or at the Magmi forum on Source Forge here http://sourceforge.net/projects/magmi/support you\’ll have a lot more success getting the answers you need there.

And no it\’s not a contest, it\’s an absolute necessity for many.  This is a process that does have to be done every day or even more frequently for a lot of high volume stores.  Using Magento\’s or your method my catalogue would take over 40 hours to update for us.  That\’s providing it didn\’t crash in the process.  The native update process also sucks system resources and dramatically impacts server speed.  It\’s just simply not an option for big stores.

It\’s well worth the effort to persevere with Magmi, the rewards once it\’s set up properly and you have working csv files are HUGE!!  The trouble is that there is no one size fits all set up or CSV format so understanding what is going on is essential to success.

 
Magento Community Magento Community
Magento Community
Magento Community
 
tortora
Member
 
Total Posts:  31
Joined:  2014-01-18
 

We have an application that offers an easier way to import a csv file with images and addresses some of these issues.  You can get more info on it at www.ClaraStream.com and feel free to email me at info@clarastream.com if you have any questions.

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