Can anybody help me to write a little wiki about importing products from csv to determined subcategory?

[raptorsmile]

I made subcategories, but after importing products from csv, they are under home. I wrote only the category ID to the csv, not the category name. I tried a lot of advise but no result. Can anybody, who use more subcategories in a webshop, write me a full description of importing csv?

[Mobius2000]

Hi there, it has been a while since you asked this but I thought I'd reply anyway (give a little back to the community).

You will need to add a column in your CSV called Parent Category, in the column you put the id of the subcategory you want that item to appear in.

sub category:
id  name  
1   sub1
2   sub2
3   sub3
4   sub4

Then your item will be:

id    name    parent id
55   item1    1
56   item2    1
57   item3    1
58   item1    2
59   item2    2
60   item3    2

See how the parent id column points to the category id set in the first block of code?

[raptorsmile]

Hi, thanks for your reply. I'm very glad of sy can help me. So I think I understand what you would like to do, but I don't know how. It is simple to add a new column in the CSV, but how can I set a new column name in the importing menu of BO to categorize the CSV-s columns?

[Mobius2000]

Oh, I see now, sorry... Unfortunately that's going way over my head at this point.

I have someone on the forum about to release a work around for me to display RRP which I will end up needing to do the same thing you are doing (ie: custom import field). Once I get some support to achieve this I will be sure to write back with my solutionime for you.

Richard.