Try the Demo

Magento Forum

   
How do I: Import a .cvs file into my attributes Label/Options
 
Xionicfire
Member
 
Total Posts:  38
Joined:  2008-05-07
 

Hi, we just ran into the following problem.

We need to add a LOT of attribute labels into an attribute.

we currently have an excell CSV sheet that we could export to CSV in any format we would wish.

How can we use this CSV sheet to import the attribute label data wihout having to do it all by hand.

were talking 540 different possible labels, in 3 different languages..

Our CSV already reads something like

RaETs, Firma, RaETs

So technically if magento would have something like “import CSV file with values” added on to the attribute label page it would be great.... but i knot it does not have it.

How could we go around doing something like this manually? would just importing it into the MySQL fields mess it all up? or is there any other safe way to do this?

Any help would be greatly apreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kacie
Jr. Member
 
Total Posts:  20
Joined:  2008-12-28
 

Hello, any solution for above question??  I have the same issue. i have many attributes i cant insert all in by hand. can we import attributes or any solution for this kind or any mysql queries?

Any help would be greatly apreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mage4Frank
Jr. Member
 
Avatar
Total Posts:  18
Joined:  2008-09-13
Düsseldorf, NRW, Germany
 

Hi Kacie,
have a look at Import Bulk Attributes
http://www.magentocommerce.com/boards/viewthread/9391/P0/

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kacie
Jr. Member
 
Total Posts:  20
Joined:  2008-12-28
 

Hi Mage4Frank,
Thanks for replying. Yes i have ried this and this is suitable for importing attributes options not attributes as whole. for eg., shirt_size is an attribute, large,medium,small are the options. The thread is very useful to import the attrtibute options(like large,medium,small). Can we import attributes?(like shirt_size,shirt_color)?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kacie
Jr. Member
 
Total Posts:  20
Joined:  2008-12-28
 

Hi Mage4Frank,
Thanks for replying. Yes i have tried this and this is suitable for importing attributes options not attributes as whole. for eg., shirt_size is an attribute, large,medium,small are the options. The thread is very useful to import the attrtibute options(like large,medium,small). Can we import attributes?(like shirt_size,shirt_color)?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ownsecurity
Member
 
Avatar
Total Posts:  36
Joined:  2008-08-04
South of France
 

Hi Kacie,

Have you managed to export/import attributes? (Not bulk attributes like on other post).

I’m having the same problem as you to import attributes.

Bye

 Signature 

http://www.easy-securite.com
http://www.ecare-security.com

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kacie
Jr. Member
 
Total Posts:  20
Joined:  2008-12-28
 

Hi,

Not attributes, i have managed to import attribute options. As i have said in the previous post. Now i dont have time to look at it, but if there is any solution please let me know.

Thanks..

 
Magento Community Magento Community
Magento Community
Magento Community
 
ownsecurity
Member
 
Avatar
Total Posts:  36
Joined:  2008-08-04
South of France
 

You have been able to import attribute options one by one? Or the whole attributes options at the same time? Because I could manage to create all attributes if it’s easy to import options…

Hope this is the second solution

 Signature 

http://www.easy-securite.com
http://www.ecare-security.com

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kacie
Jr. Member
 
Total Posts:  20
Joined:  2008-12-28
 

Go through this thread and try it, you will come to know.

 
Magento Community Magento Community
Magento Community
Magento Community
 
bolasevich
Sr. Member
 
Avatar
Total Posts:  235
Joined:  2008-03-04
Newington, CT USA
 

i have a beta in development that is now importing all attributes and attribute options via magentos dataflow technology. It uses your standard CSV to import all attributes and assoicated attribute options. This has been great for sites that have hundreds if not thousands of attributes to import before you can begin importing products. Ive wrriten both a import bulk products module (grouped / configurable/simple/bundle/virtual products) and now this the import attributes module. The attributes is still in beta testing anyone who would like to help test it before it becomes stable please email me at PM me here

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