Use sql to update the paths entry?
So for instance if you know the parent path you’d use something like this:
update catalog_category_entity set [category_path] = ‘parentdirect’&’/’&[category_field] where 1=1
or whatever your criteria is for knowing which data is yours
This also assumes that the category_field data is in the same table as the field you are updating . .
Correction: Looks like mysql uses its own concat function . . it _appears_ you’d use this . . .
Update catalog_category_entity set [category_path] = CONCAT(’parentdirectory’, ‘/’ ,[category_field]) where 1=1
[category_path] above is whatever the name of the field is you want to update
CAUTION: using 1=1 above will update every record in the database - I’m not sure that’s what you want. The alternative is to use a data field or something else to let you delineate your records from whatever was there in the first place.