Magento

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

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

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”

Hi Karl,

Please do fallowing steps

1) Go to Admin > System > Import/export > Data Profiles > Export all products >Edit > Run profiles
2) Log in to FTP > Download File from Var/Export then you can find the file export_all_products.csv
3) Download to local
4) Update your data according to the columns in the csv file.
5) Before updating or importing file open the file in note pad then File > save as > export_all_products.csv select character set to UTF-8
OK
6) Now make sure you have all images in media/import/YOURFOLDER/ (same page you need to give in export image column like /YOURFOLDER/xxxx.jpg
7) Then Go to Admin > System > Import/export > Data Profiles >Import all products >Edit
8) Go to Upload file tab > Upload your file and SAVE AND CONTINUE
9) Go to run profile > select the file and Run Profile.

If you can\’t see the products please refresh your index.

if you still face any issue, you can contact us as we are one of the magento extension developers.

Thanks

Monty
iLoveMage

No1 Web DeVelopment and Magento Extension store.

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????

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.

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?

Karl456 - 07 February 2013 03: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 ))

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

yoxo - 07 February 2013 02: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.

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.

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”.

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............