Import category and subcategory

-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.5.32
-- Browser(s) name and version -- : firefox

Hi,
i have a problem with the category and subcategory import, i have this scenario:

main category -> subcategory-1 -> subcategory-2 -> product

I don't understand how to place the categories in csv files, i tried in this way:

product_name, product_code, parent_category, categories

but it doesn't work.

where i'm wrong?
Can you help me please?

thank you.

Hi,

You can do like that:

excuse but it's not clear for me

i have 3 category level:

main-category -> subcategory-1 -> subcategory-2
where i have to place the subcategory-1 and subcategory-2?

ok, i understand that is possible but i have to make two different import.

The first is a category tree import on two levels:

parent_category; categories
main-category, subcategory-1

then i made a 2nd import to set the sub-subcategory-1 under the subcategory-1

product_name; product_code; parent_category; categories
myproductname, myproductcode, subcategory-1, sub-subcategory-1

In this way it works.
I didn't find a way to made it in a single import.

Hi,


Copy/paste what I gave you in a text file and open it as a CSV in Excel and you'll see how that looks: monosnap.com/file/Wqq231XVhKOoHQM8fZS6X2VxHb9TaJ
In short, you need to have empty lines with just the categories to import the category tree, and then lines for the products which can reference these categories.
If you click on the "export" button of the products listing in your backend (or in the backend of our demo website) you can see a more concrete example

ok, I will try in this way, now in excel format is clear, there is an empty cell.

thank you.