Example Category Import File Please

[Axari]

Presta Community,

 

Can someone please attach an example category import that has sub categories, that you know works? (Doesn't matter if it's from a real store or not. I just need to see an example)

 

 

No matter what I seem to do, I get "parent category does not exist" so I must be doing something wrong. (I took the categories from the database, in a working shop. But i need to change all the images, so I have to re-import. I tried leaving 'home' and removing it. Still no love from the shop though....)

 

 

Prestashop: 1.4.4

 

 

Many thanks!

[Danman]

I need this to. Oddly enough the "Sample Categories file" in 1.4.5 do not contain any sub-categories. How stupid is that for an example file! I can´t figure how the sub-catgories should be configured.

 

Do you Axari now have an example csv-file with sub-categories? Or any one else?

 

Thanks a lot for any help!

[Axari]

No, I'm still waiting for an example.

 

Hoping someone see's our plea soon

[Axari]

Figured out my problem!

 

Tip: Presta apparently processes the categories your adding, in the order they're in the import file. I assumed it just inserted them into the database, but it also checks to see if the parent category already exists or not. So make sure your import file follows the order of your categories.

 

I created an example import with sub categories, in case others might find it helpful.

 

And since I can't attached .csv or .xls files;

 

 

active|ID|Parent|Name|Desc|Image URL

1|1|0|Home||

1|2|1|Top Category 1|Description|../img/import/cat1.jpg

1|3|2|Sub Category A|Description|../img/import/cat2.jpg

1|4|3|Sub-Sub Category B|Description|../img/import/cat3.jpg

1|5|3|Sub-Sub Category C|Description|../img/import/cat4.jpg

1|6|2|Sub Category B|Description|../img/import/cat5.jpg

 

Copy that into a text editor and save it with a .csv extension. Then you can import it into your shop, excel, etc.

 

Attached image shows you what you should see.

 

NOTE: I use | (bar) as a field seperator as my descriptions have ; and , etc in them. So make sure to change (at the import screen for categories) your field seperator to the bar if you playing with this example.

 

Tested import on Prestashop 1.4.4.1