Import category and subcategory

  • Posts: 25
  • Thank you received: 0
7 years 5 months ago #271717

-- 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.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 5 months ago #271730

Hi,

You can do like that:

product_code;parent_category;categories
;main category;subcategory-1
product;subcategory-1;subcategory-2

Please Log in or Create an account to join the conversation.

  • Posts: 25
  • Thank you received: 0
7 years 5 months ago #271817

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?

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 25
  • Thank you received: 0
7 years 5 months ago #271879

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.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 5 months ago #271848

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

Please Log in or Create an account to join the conversation.

  • Posts: 25
  • Thank you received: 0
7 years 5 months ago #271957

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

thank you.

Please Log in or Create an account to join the conversation.

Time to create page: 0.069 seconds
Powered by Kunena Forum