Database nested set model problems in category tab

-- HikaShop version -- : latest

Backend: "Check Database" returns "ok". "Rebuild" category doesn't fix this.

Under __hikashop_category, several categories are set to 0 for category_left and _right.

There are also a number of categories that display at the root tree even though their parent is set correctly.

A category is set up with a category_order of 2 of 4 but has a left/right value indicating that it is placed last in the tree:
Category / Order / Left / Right
Cat A / 1 / 100 / 101
Cat B* / 2 / 106 / 107
Cat C / 3 / 102 / 103
Cat D / 4 / 104 / 105

So in the above example, Category B is ordered 2nd but has a left/right nest that places it at the end of the model structure.

SO: I am hoping I can do something like deleting the left/right values in the database, then hitting rebuild on the backend ui and have the database fix itself. Or perhaps you have a script that will do this for me - I can just make one, but figured I'd ask first.

Thanks