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

import categories, how ? 
 
Brightondan
Jr. Member
 
Total Posts:  1
Joined:  2012-02-26
 
Den Markin - 24 November 2011 12:15 AM

opacons - 29 September 2011 10:01 PM
I’m trying to get this extension working with 1.6. The export seems to work fine, but when I import the csv file, as exported, I get the error “Path provided is not a valid one.” for each category.

Any ideas?

Your root category should be active and has the same name as in source store. This extension uses path traversing by category name matching, so if it doesn’t find parent category by name, it fails.

Hi,

Firstly, a massive thank you to Santhosh and the other advice given - it’s helped me get on in leaps and bounds and I’m very grateful. If ever there was a newbie, I’m it!

But...now I’m getting exactly the same ‘Path provided is not a valid one’ result as quoted above each time I try to import categories and I believe I’ve followed all the advice correctly. Did you ever solve the problem?

Any input would be appreciated, thank you.

Brightondan

 
Magento Community Magento Community
Magento Community
Magento Community
 
Maddis
Jr. Member
 
Total Posts:  13
Joined:  2010-08-18
 

@Brightondan
Lets take this example:

You have a computer store, so you have these root categories in your magento store:
Hardware
-> displays
-> keyboards
Software
-> operating systems

So with your CSV you want to import some categories “LG Displays” (displays) and “Logitech” (keyboards) into hardware and “Microsoft” into software:

So that’s what a basic CSV could look like:

NamePath"Is Active"
"LG Displays"
"Hardware/displays""Yes"
"Logitech"
"Hardware/keyboards""Yes"
"Microsoft"
"Software/operating systems""Yes"

That is what you get in the magento backend:

Hardware
-> displays
------> LG Displays
-> keyboards
------> Logitech
Software
-> operating systems

------> Microsoft

 
Magento Community Magento Community
Magento Community
Magento Community
 
yisyang
Jr. Member
 
Total Posts:  1
Joined:  2012-02-02
 

Thanks Santhosh!

Worked on 1.6.2

I had to do a minor change in this file:
app\code\local\Santhosh\Import\Block\Adminhtml\Import.php

I changed the three occurrences of the javascript variable import to import1
so it works with the latest Firefox.

 
Magento Community Magento Community
Magento Community
Magento Community
 
hankgerard
Jr. Member
 
Total Posts:  16
Joined:  2011-01-20
 

Hello All -

I’m new to magento and about to tackle this extension. But before I do, does it allow me to import the url key, full description, page title, meta keywords and meta description fields?

 
Magento Community Magento Community
Magento Community
Magento Community
 
riffrömer
Jr. Member
 
Total Posts:  27
Joined:  2010-06-01
 
hankgerard - 23 April 2012 03:46 PM

Hello All -

I’m new to magento and about to tackle this extension. But before I do, does it allow me to import the url key, full description, page title, meta keywords and meta description fields?

Hello,

yes, all include,
fields;
Name,Path,Is Active,Url Key,Description,Image,Page Title,Meta Keywords,Meta Description,Include In Menu,Display Mode,CMS Block,Is Anchor,Availabe Sort By,Default Sort By,Page Layout,Custom Layout Update

after install and export (.../magento.../var/export/catergory/catergories.csv) or import (/...magento.../var/import/catergory/catergories.csv)

 
Magento Community Magento Community
Magento Community
Magento Community
 
hankgerard
Jr. Member
 
Total Posts:  16
Joined:  2011-01-20
 

Thank you for your response!

 
Magento Community Magento Community
Magento Community
Magento Community
 
hankgerard
Jr. Member
 
Total Posts:  16
Joined:  2011-01-20
 

hello all..can someone help me fnd Categories.csv file?  a file with that name does not exist on my machine and I dont seem to see one on the forum.

 
Magento Community Magento Community
Magento Community
Magento Community
 
hankgerard
Jr. Member
 
Total Posts:  16
Joined:  2011-01-20
 

in other words, i dont know to format the csv...what column names, layout of file, etc..

 
Magento Community Magento Community
Magento Community
Magento Community
 
empepavel
Jr. Member
 
Total Posts:  5
Joined:  2011-12-28
 

i love this extension it is a must for anyone working with thousands of sku’s/cats.  i use it on a few sites including enterprise, just installed it on 1.7 as well and have no issues.

 
Magento Community Magento Community
Magento Community
Magento Community
 
davidgrun
Sr. Member
 
Total Posts:  245
Joined:  2008-07-10
 

Hello All!

I downloaded Santhosh’s zip folder with the module.
Copied all the files from the folder in the same exact locations as suggested.
Deleted cache.
Refreshed the dataflow import page in admin.

And I see NO link to import the categories.

Am I missing a step? Is there something that needs to be tweaked?

Using ver. 1.6.2.0

THANK YOU!!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
davidgrun
Sr. Member
 
Total Posts:  245
Joined:  2008-07-10
 

I figured it out… I had placed the app/design/adminhtml/santhosh folder in default7default instead of just under default.
Worked like a charm.
The only think that didn’t work for me is it didn’t keep the tree structure.

 
Magento Community Magento Community
Magento Community
Magento Community
 
crizregala
Jr. Member
 
Total Posts:  7
Joined:  2012-03-04
 
Den Markin - 24 November 2011 12:15 AM

opacons - 29 September 2011 10:01 PM
I’m trying to get this extension working with 1.6. The export seems to work fine, but when I import the csv file, as exported, I get the error “Path provided is not a valid one.” for each category.

Any ideas?

Your root category should be active and has the same name as in source store. This extension uses path traversing by category name matching, so if it doesn’t find parent category by name, it fails.

what will i do then? please help me? thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
shilpashr
Member
 
Total Posts:  36
Joined:  2011-10-30
 

Hi, i have installed the extension and refreshed the cache. I’m using magento 1.4.1.1 .. I do not see ‘import categories’ in admin Import/export profiles. Please somebody help me with this. Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
shilpashr
Member
 
Total Posts:  36
Joined:  2011-10-30
 

Hi, i have installed the extension and refreshed the cache. I’m using magento 1.4.1.1 .. I do not see ‘import categories’ in admin Import/export profiles. Please somebody help me with this. Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
shilpashr
Member
 
Total Posts:  36
Joined:  2011-10-30
 

Export is working fine. Import shows “saving..” and it does not proceed :( i changed the file permissions of all the files too. Please someone help me with this

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