Import not working for us at all........

-- HikaShop version -- : 6.2.1
-- Joomla version -- : 3.5.8
-- Error-message(debug-mod must be tuned on) -- : Notice

I have combed over the import doc, used examples from the forums, switched between comma and semicolon delimited CSV files, you name it. Every time the import never works correctly. Whats happening is in the category column we have the categories listed as "Product Category,ADL,Hook and Loop" and when the import happens, Hika is creating top level categories for everything in that field vs cat,subcat,subcat. I even tried changing the comma's to semicolon's for the categories and same results. LOTS of top level categories and no new subcats.

Thank goodness for NaviCat and being able to export Hika tables the reimporting.

Im attaching the two CSV files we have tried to use without any luck.

Thanks

Thanks for the advice! It looks like we're getting closer but, still having issues getting subcats created automatically.

ADL is the new top category with 2 subcategories and listed below.

ADL (new parent) -> Hook and Loop (subcat of ADL) -> Webbing Back Hook and Loop Fastener (subcat of Hook and Loop)

Just to keep things sane, I started with 1 product this time to get the hang of this instead of 1700

Fixed the product import error by changing that column to product_code (duh)...

** The only thing not working correctly is the subcat;subcat creation when I have more than 1 level listed above.

Also, my prices are importing correctly but, the Retail Price value is still 0. Is there a field label to set that field value?

I tried many variations from the doc page and it didn't work either.

Importing product categories

Then, you can also have a categories column where you can put a list of categories id or a list of categories namekey.
For example:
product_code,product_name,categories
my_product_1,My first product,"2,13"

This will add one product with 2 categories attached: the category with the id 2 and the one with the id 13. You can find ids of categories on the category listing in the column called ID on the right of the listing.
You can import a tree of categories which will be created if they don't exist already in HikaShop with the option "Create automatically missing categories" set to "yes". For example, you could have something like:
parent_category,categories
product category,main category 1;main category 2;main category 3
main category 1,sub category 1;sub category 2

You could also mix both products and categories in the CSV:
product_code,parent_category,categories
,main category 1,sub category 2
my_product_1,main category 1,sub category 2

Thanks for the field ID!

As for the auto creation of subcat->subcat vs cat,cat, we have not gotten that problem worked out per this thread.

www.hikashop.com/forum/import-export-csv...s-at-all.html#228614

We've tried commas and semi-colons in the categories field like this.

Parent_category -> ADL
Categories -> Hook and Loop,Webbing Back Hook and Loop Fastener

Instead of creating a category tree like:

ADL
- Hook and Loop
-- Webbing Back Hook and Loop Fastener

The import creates categories like:
ADL
- Hook and Loop
- Webbing Back Hook and Loop Fastener

Per the doc, HIKA shows it should create nested sub-categories?

Thats how I have it in the attached CSV but, Hika isn't importing the categories as subcat->subcat.

All I can think is that there's a bug?