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

Product Import CSV
 
Karl456
Jr. Member
 
Total Posts:  28
Joined:  2013-01-10
 

Hello,

I’m trying to import products via a CSV, but I have an issue.

How can I set which category the product is assigned to?

In the CSV, there’s a title called _category, but how can I set a product to more than one category?

I’ve tried 3|10|22, with | being a delimiter but I’m not sure if it works off category ID’s or names, or how to set multiples.

Any ideas?

Regards,
Karl

 
Magento Community Magento Community
Magento Community
Magento Community
 
MagneticOneTeam
Sr. Member
 
Avatar
Total Posts:  253
Joined:  2008-04-02
USA
 

Hi Karl,
yes, you’ve guessed right. It may look like this:
“Category1|Category2”
or
“Category1/Subcategory1|Category2/Subcategory2”
being:
| - separator delimiter
/ - path delimiter

Just specify them properly and there shouldn’t be any issues.

Follow this link if you need more info on that matter: http://bit.ly/YVCsOC or contact us with any questions.

Cheers

 
Magento Community Magento Community
Magento Community
Magento Community
 
Karl456
Jr. Member
 
Total Posts:  28
Joined:  2013-01-10
 

Thanks for the reply.

I’ve just tried that but I still receive the error:
Category does not exists in rows: 1, 2, 3

When I’ve typed out the category names correctly. Do you include spaces in the category names?

Such as:
“Category One|Category One/Sub Category”

 
Magento Community Magento Community
Magento Community
Magento Community
 
yoxo
Member
 
Total Posts:  35
Joined:  2012-07-20
 

I also get an error,
I think it has something to do with the set of character Set I use in Open Office.
I use:
Character Set: Unicode (UTF-8)
Language: English
Is that correct? Should I use anything else?

When opening the file what I should check as “separated by”?

- TAB
- COMMA
- OTHER
- SEMICOLON
- SPACE
- MERGE DELIMITER

Which one I should chekc to make it work correctly?

Has anyone experience in import/export using open office????

 
Magento Community Magento Community
Magento Community
Magento Community
 
Karl456
Jr. Member
 
Total Posts:  28
Joined:  2013-01-10
 

Perfect Monty22! Thank you so much.

EDIT:

Or maybe not, I’ve changed the data and the Check Data options says everything is fine, but when I import the categories aren’t assigned…

Images are also not added..

The way Magento imports and exports is terrible, I’ve never had this issue with OpenCart before.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Karl456
Jr. Member
 
Total Posts:  28
Joined:  2013-01-10
 

When using the import profile it says “image does not exist” for each of the 3 items I’m testing with.

When I know the images are in /media/catalog/product and I know their names.

So in the CSV, image is set to “/1/_/1.jpg”

Which is definitely in the product folder, any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
yoxo
Member
 
Total Posts:  35
Joined:  2012-07-20
 
Karl456 - 07 February 2013 02:31 AM

When using the import profile it says “image does not exist” for each of the 3 items I’m testing with.

When I know the images are in /media/catalog/product and I know their names.

So in the CSV, image is set to “/1/_/1.jpg”

Which is definitely in the product folder, any ideas?

Seem like none use IMPORT in magento and they edit products one by one smile))

 
Magento Community Magento Community
Magento Community
Magento Community
 
Karl456
Jr. Member
 
Total Posts:  28
Joined:  2013-01-10
 

After a bit of research it turns out you need to create a folder in media called import and upload all your images there.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Karl456
Jr. Member
 
Total Posts:  28
Joined:  2013-01-10
 
yoxo - 07 February 2013 01:56 AM

I also get an error,
I think it has something to do with the set of character Set I use in Open Office.
I use:
Character Set: Unicode (UTF-8)
Language: English
Is that correct? Should I use anything else?

When opening the file what I should check as “separated by”?

- TAB
- COMMA
- OTHER
- SEMICOLON
- SPACE
- MERGE DELIMITER

Which one I should chekc to make it work correctly?

Has anyone experience in import/export using open office????

CSV (Comma Separated Values) files are separated with commas, so you should check that.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Store_Manager
Enthusiast
 
Avatar
Total Posts:  867
Joined:  2012-07-09
 

Hi there,

Yes, images should be located in media/import folder, also here are a few more tips to check about images import -
http://www.mag-manager.com/useful-articles/tipstricks/what-to-check-if-you-cannot-upload-magento-images

Hope it helps.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ec0mmerce
Sr. Member
 
Avatar
Total Posts:  242
Joined:  2013-01-17
 

Hi

- The default options in an excel file you can look through following SYSTEM->IMPORT/EXPORT->EXPORT->Entity type(choose “PRODUCTS")

- If you would like to add extra options (which were provided in the excel sheet), you should follow CATALOG->ATTRIBUTES->MANAGE ATTRIBUTES and there is an option to “Add New Attribute”. Here you can add as much attributes as you need and fill them up with your custom values for the configurator.
- Once the necessary attributes have been added on this step, you should go through CATALOG->ATTRIBUTES->MANAGE ATTRIBUTE SETS. Click “Default” and then you will see the page of 3 columns http://screencast.com/t/uuOMbRREWG0 Your newly created custom attributes will be displayed in the “Unassigned Attributes” column. You should drag over the attributes from “Unassigned Attributes” to “Groups” column in order to enable them. Then click “Save Attribute Set”.

 
Magento Community Magento Community
Magento Community
Magento Community
 
newbie91
Jr. Member
 
Total Posts:  14
Joined:  2012-10-14
 

i already tried all your instruction above, basicly i understand well how to import manually using IMPORT/EXPORT

but i get confused where should i place my image on directory ?? you said on “media/import”

But, where can i find these directory ?? i just find “my-site-directory-com/media” no “import” directory ??

Ok, fine i create that one, so it’s look like this => “my-site-directory-com/media/import” , than i set file permission to 755

so, is that true directory to place my Import image ??? (including file permission ?? )

Now, i got other problem ,.. how i write the directory image file on my CSV file ??

should i write “ import/test-image.jpg” or “media/import/test-image.jpg” or just like this => “test-image.jpg” without any /// ??

please your help............

 
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 products from a csv file and addresses some of these issues.  You can get more info on it at http://www.ClaraStream.com and feel free to email me at if you have any questions.

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