Previously, collection from magento using catalog_product_index_price, your module is using catalog_product_index_price_store. So normal, I would do something like $collection->addFinalPrice() to add final price to the collection as I want to sort by final_price.
With your new table, how would I do this?
In order to add final price to the collection, could you please replace the attached file with the corresponding one in this folder: app/code/local/Bss/MultiStoreViewPricingPriceGroupTierStore/Model/Resource/Product, then use the command $collection->addFinalPrice() ?
For more information about product, please refer Multiple Store View Pricing page.
If you need any further assistance, please feel free to contact us.
Please visit our site for more useful Magento 1 Extensions: https://bsscommerce.com/extensions.html