CSV import 3 level deep categories

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.2
-- PHP version -- : 7

I have a CSV file with products that looks like this:

When I import the CSV file to hikashop I want to use the category structure as you see above in the file:

3 level deep categories.

I know that I can import 2 level deep categories.

It it possible to import and make hikashop auto create 3 level deep categories ? and if so, what should I change the category columns to in the CSV file ?

I know the first column category should me named "parent_category" and the second "categories", what should the 3 level category column be called ?

tnx

Hi,

The import system doesn't have limit on the levels of categories you can import.
For example you could have that CSV: As you can see here, the first few lines allow you to configure the structure of the categories.
The next lines allow you to specify the product data and in which leaf category should the products be.

OK this sounds good.

Im trying to make standard form in excel (CSV) which I can use for all import.

Please look at my image below, is this the correct way to write the product categories in the CSV file ?



I want to categories in the Root;product category folder (standard hikashop structure)

No, that's not correct.
Please use the lines I gave you as CSV.
Write them in a text file, rename it with the csv extension and open it with excel and you'll see how it should look like.
You can also create some categories in your backend and export the products and you'll get the categories lineslike I gave you at the top of the csv.

Tnx it works.

Now I only have one small case related to import of products using a CSV file.

I have a custom field in table/product, field type checkbox. It has only one value.

Deiverytime: 6-9 days.

I have placed the label "deliverytime" in the CSV, with value 1 in the rows beneath.

But I can't get it to auto select the value: 6-9 days.

I have to manually do this on each product after import. And that's to much work.

Any adivce ?

Hi,

If the value is "6-9 days" in your custom field, then you need to use that value in the CSV if you want HikaShop to be able to match it.

So back to categories.....


OK, so this is my category path for "product A" (it's 4 levels deep)

product category/Women/Women`s Lingereie/Bra/Push Up Bras

I want "product A" only to be placed in the last category "Push Up Bras"

And at the same same time "during CSV import" create the category path as above.
I need the category path to be like above with: "Women" as first category level and "Women`s Lingereie" as second level category etc.

Any advice on how to write it in the CSV file ?

Or do I have to create the category order in advance before I import.

I've already given an example in a previous message:
www.hikashop.com/forum/import-export-csv...tegories.html#251262
It's the same...