Now that you think you have things correct ...

Be sure that you have proper matching records:
products
products_description

categories
categories_description

products_to_categories (at least 1 record per product, you will have more if you have Linked Products)

Check that you have master_categories_id in each product record ... if not, run the Update master_categories_id ... NOTE: if you use Linked Products, the lowest categories_id is used for the master_categories_id ...

Run the Update Products Price Sorter ... note: run this AFTER the master_categories_id exist to set the prices correctly ...