Importing Categories and Product Files, via the inbuilt import feature mystery solved

[Xuthus]

Ok I have been looking at this for approx two weeks now, and have come to the conclusion, there is a lot of confusion out there in the forums, when it comes to using the inbuilt import feature, use excel, don't use excel etc....yada yada, other threads giving you some sort of guidance but never quite hitting the mark, and the most frustrating is the amount of peeps wanting payment for assisting you, thought this was "free" open source, and the community helps each other out, idealistic world Oh well

Ok then semi rant over -

Categories - See Attached

The key to all of this is using the "Parent category" Column D, it is relational to the "ID" Column A

First Example BareBones

Main Cat "BareBones" Sub Cat "Asus"

Second Example goes down to three levels

Main Cat "Flash" 1st Sub Cat "Flash Drives" 2nd Sub Cat "Patriot & Peak"

Product File

Ok, it's all explained in the attached file, but what I would really like to point out is this in the import file is column "Image URLs (x,y,z...)" Column AD, After reading several threads saying you have to put 'www.DomainName.co.uk/upload/img.jpg', nah don't work, all you need is '../upload/img.jpg' minus the quotes, make sure you have the correct number of leading dots (2). People were over complicating it presta just need to look inside its self

On the above regarding products you must of first of all uploaded your images to the upload directory, within the attached "PrestaImportBuild_Update Example", there are four examples for you to look at with different scenarios

Hope this helps

PrestaImportBuild_Update Example.xls

CatsNew.csv

[Gil Mobile Online]

Good job, man!



I will follow the steps when the import file will be again needed!

Bravo!

[ADICorp]

I am still lost, why is there no categories button or link for creating parent categories like every other cart?

[Xuthus]

Unfortunately there is not, but if you look at my attached cat file, you will get the gist on how to build your cats outside the shop, then import them

[mamandis]

I wanna import CSV file with images (one product + 2 or 3 images).

and I wanna look to Your, Xuthus, attachements how IMG URLs should be written in CSV - what punctuation mark should be between urls.

 

help me please with this..

 

 

Thank You very much