Cannot import categories

Hi all!

I'm experiencing a new problem after upgrading to hikashop 2. Its, when importing products from a csv file, using:

"product_code";"categories"
"000000000001";"category01;category02;category03"

no categories imported at all. Of course, I have ticked the "create categories.." checkbox, only one category is created,
no multi category import was done.

How can I carry out this problem?
Thanks in advance

Hi there,

Do you have any error message which could help us to found the source of this problem?
Maybe you can try to import again with the Joomla debug mode activated, it may help us

Hi!
I turned the debugging on, hikashop admin is not accessible. Error 500,

JDatabaseMySQLi::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND category_type='status' LIMIT 1' at line 1 SQL=SELECT category_id FROM um3y8_hikashop_category WHERE category_parent_id= AND category_type='status' LIMIT 1

We have this site on localhost, we wanted to launch this week finaly. Before the update everything was fine, till today.

Thanks in advance,

Hi,
Finally I decided to make a clean install of hikashop on my localhost. Deleted all hikashop tables in phpmyadmin, uninstalled everything from Joomla 2.5.8 backend and also deleted some language files left behind after uninstall. I reinstalled hikashop, everything is imported now fine. The only thing is, I created taxation categories after I made the import, checked the tax codes, and I wanted to reimport my data only using :
"product_code";"product_tax_id"
"000000000001";"1"
"000000000002";"2"
to update the tax categories of them, but it did not update, in the product editing pane in the backend still not calculated the price with tax value, and no tax category assigned to the products.
The strange is that, if I export the products, default currency id and tax_category is exported fine as it should appear for the products.
How the products are deleted from the database, because I noticed that when I delete some products from the hika admin the products are still in the database ( not a problem, specially when someone mistakenly deletes something) but how can they be properly deleted not to affect the other parts of the shop, just to make a complete product cleanup?

Thanks

Now I tried importing this string in "import from text" screen:

product_code,price_value_with_tax
00000000001,2000
00000000002,5000

but gives this error:

JDatabaseMySQLi::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE category_type='tax' AND category_published=1 ORDER BY category_id ASC' at line 1 SQL=SELECT category_id FROM WHERE category_type='tax' AND category_published=1 ORDER BY category_id ASC
and also

product_code,product_tax_id
00000000001,1
00000000002,1

also does not updates the products tax category.

Thanks.

Ok, It was my fault. I just wanted to substitute the tax category IDs with the TAx rate IDs, which is wrong, of course the import engine searched it with no success, because they are different. I figured it out finaly.
Thanks and regards