Jump to content

Fetch and display products by their ID


Recommended Posts



I'm creating a page which selects products based on id_feature_value and then listing them.


The SQL works but I'm wondering what information you need to send to the product-list.tpl file. I've tried to look in different templates using product-list.tpl but can't figure out what information they're sending/the template file needs to display my products.


E.g. it will be a customized product page and I would like the same functionality as the regular one (AJAX, compare etc).


SELECT *, GROUP_CONCAT(`id_feature_value` SEPARATOR ', ') as features FROM shop_product_lang pl JOIN shop_feature_product fp ON pl.id_product = fp.id_product WHERE pl.id_lang = $id_lang AND `id_feature_value` IN ($attribsJoined) GROUP BY pl.id_product


Is there a function to fetch all the information for several products at once when provided with their IDs?

Then I could just use that and send all information as $products to the template file?


I hope this explains enough, otherwise please feel free to ask for more information.


Thank you in advance!


Best regards


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...