jdietrich Posted March 13, 2013 Share Posted March 13, 2013 Hello all, Just starting out with Prestashop, and was wondering if there was a built in method or module to display a page listing all the product attachments to end-users. For instance under "Customer Service", we want a "Product Manuals" page. Ideally this wouldn't be hard-coded links … rather, we would prefer some code to dynamically spit them out as links to the page (with product name as the link text, not a GUID). Link to comment Share on other sites More sharing options...
Jmfioris Posted May 7, 2013 Share Posted May 7, 2013 (edited) My issue is similar, I want to locate the id's of the products that a user has purshased over the time by a Sql query Edited May 7, 2013 by Jmfioris (see edit history) Link to comment Share on other sites More sharing options...
Jmfioris Posted May 8, 2013 Share Posted May 8, 2013 I think that with this query you'll obtain the data that your searching SELECT *, ( SELECT osl.`name` FROM `ps_order_state_lang` osl WHERE osl.`id_order_state` = o.`current_state` AND osl.`id_lang` = 2 LIMIT 1 ) AS `state_name` FROM `ps_orders` o LEFT JOIN `ps_customer` c ON (c.`id_customer` = o.`id_customer`) WHERE 1 AND o.id_shop IN (1) ORDER BY o.`date_add` DESC 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts