Fields in #__hikashop_category, left and right?

-- HikaShop version -- : 2.3.3
-- Joomla version -- : 3.3.4

I import categories with a custom script and everything is ok. but i try to add a product to this cateogry then is category path wrong:http://prntscr.com/4s0zwi, i seen in database, in the table for cateogries are two fields and they are everytime different:
"category_left and category_right", which type of values how i to generate to have true category path?
At the moment are my all values on: 0 prntscr.com/4s0zcu

Hi,

Left/Right is coming from the "b tree" algorithm, also use in Joomla for they tree structures.
It's not related to HikaShop.

en.wikipedia.org/wiki/B-tree

Regards,

Ok. many thanks, can you please give me a guide, which values have i to insert, are they a auto values as primary key? A read this but technical i have no idea...

Hi,

HikaShop has a built-in function to regenerate all the left/right/level fields of all the categories. It's done when you click on the "rebuild" button of the categories listing in the backend.
So you could simply call that same code from your script.
You can look at the rebuild() function of administrator/components/com_hikashop/controllers/category.php

I implemented it in my script, works well, thank you...