How to add price to the collection?

Created by Robin Hoang, Modified on Tue, 31 Oct, 2017 at 6:25 PM by Robin Hoang

Question:

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?


Answer:

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article