category in product page

go to the back end at categories you click on the "root" top left and it shows you " product category, tax category, order status, brand, συγγραφεις"
the last one "συγγραφεις"=writers click it and there are 98714 categories

can you please give me some more info:

In the category table in mysql joomla db, there are the following tree fields:

category_left
category_right

what is the logic of those fields? which category (id I guess) is the left and right?

also, there is a category_namekey (as far as I can remember) field. I tried to decode the data, ok, it starts from the category kind, then after the first underscore it is the integer date of the date created, but after the second underscore what is this integer? where does it come from?

Thank you so much in advanced.

hello
we insert the data from another database with a custom script so we must insert the right the left and the main key so there is no auto insert
so this has to do with the right and left object ? or just give me an example on how to insert them "manually" if possible
and what about the name key integer ? since i insert everything manually .. what could i do with that also ????
thanks

Thanks for your reply, I will check out the link you provided.

and what about the namekey second integer?

Hello
another thing i need your help with is this:

i want to add a general discount of 10% to all products
so i created a discount set it to 10% and tried 0 categories or assigned the general product category including the subcategories
i enabled Show discounted price and Price display method
but i can see no discount on the product

there is a link of a product for example to see what happens
ubook.igrouphost.com/index.php?option=co...ow&cid=83&Itemid=289

it shows 0€/χχχ€
the zero should be the original price (in the link above 4.15) and the xxx should be the discounted price (in our case 4.15-10%=3.735)

thanks

Hi gili,

Can you show with some screenshots of how did you configured your discount ? and of this product page setting ?

Thanks.

ok instead of taking screenshots
i want to do this
www.prosperus.gr/books/product_info.php?...47m8vr6h5ramfebidap1
its in greek but you can understand the red is the discounted price and the grey is the original price and the last is the discount amount

give me instructions on how to do this

thanks

hello
ok so if i delete that field then it will work ?????

Yes it should work.