[Skip to main content](#vessel-content) # add image thumbnails in order list back end? ## - **[Yuji](/forum/user/7438-yuji "View Yuji's Profile")** - [![Yuji's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7438-yuji "View Yuji's Profile") Topic Author - [ Offline](/forum/user/7438-yuji) Less More - Posts: 17 - Thank you received: 2 - - 14 years 3 months ago [\#57559](#57559) by [Yuji](/forum/user/7438-yuji "View Yuji's Profile") *[add image thumbnails in order list back end?](/forum/4-how-to/57559-add-image-thumbnails-in-order-list-back-end#57559 "how to add another column in order summary for image?")* was created by *[Yuji](/forum/user/7438-yuji "View Yuji's Profile")* how to add another column in order summary for image? - [ ![iamge.png](/forum/attachment/4786) ](/forum/attachment/4786 "iamge.png") [ ](/forum/attachment/4786?download=1 "iamge.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU3NTU5LWFkZC1pbWFnZS10aHVtYm5haWxzLWluLW9yZGVyLWxpc3QtYmFjay1lbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 3 months ago [\#57631](#57631) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: add image thumbnails in order list back end?](/forum/4-how-to/57559-add-image-thumbnails-in-order-list-back-end#57631 "how to add another column in order summary for image?")* The images data is not loaded there. So you can't just add a line of code to have the images displayed. You would first have to have a query to the database in order to load the images, add the images for each of the product objects and then display them. You can do that in the file "show" of the view "order" of the back end via the menu Display->Views, but it will be difficult if you're not a developer... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU3NTU5LWFkZC1pbWFnZS10aHVtYm5haWxzLWluLW9yZGVyLWxpc3QtYmFjay1lbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Yuji](/forum/user/7438-yuji "View Yuji's Profile")** - [![Yuji's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7438-yuji "View Yuji's Profile") Topic Author - [ Offline](/forum/user/7438-yuji) Less More - Posts: 17 - Thank you received: 2 - - 14 years 3 months ago [\#57652](#57652) by [Yuji](/forum/user/7438-yuji "View Yuji's Profile") Replied by *[Yuji](/forum/user/7438-yuji "View Yuji's Profile")* on topic *[Re: add image thumbnails in order list back end?](/forum/4-how-to/57559-add-image-thumbnails-in-order-list-back-end#57652 "how to add another column in order summary for image?")* can i know how to quuery the image from the database? i'm using hikashop business edition~ our client requested to add that image for ease of processing the orders Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU3NTU5LWFkZC1pbWFnZS10aHVtYm5haWxzLWluLW9yZGVyLWxpc3QtYmFjay1lbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 3 months ago [\#57717](#57717) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: add image thumbnails in order list back end?](/forum/4-how-to/57559-add-image-thumbnails-in-order-list-back-end#57717 "how to add another column in order summary for image?")* It should be something like that: SELECT * FROM #__hikashop_file WHERE file_ref_id =XXX AND file_type='product' ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC That would return you all the images data of the product with the id XXX. Then, you would have to load the image helper: $imageHelper = hikashop_get('helper.image'); And finally use it to display the image based on the data from the query, as we do in the file "show_block_img" that you can see via the menu Display->Views. Note that this is a development project which is outside the support contract included in the Business edition. I already gave you more than enough information so that a developer could do it by himself, but if you want us to do it for you, then we would ask that you request a quote for that via our contact form: [ www.hikashop.com/en/contact-us.html](http://www.hikashop.com/en/contact-us.html) The following user(s) said Thank You: [Yuji](/forum/user/7438-yuji "View Yuji's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU3NTU5LWFkZC1pbWFnZS10aHVtYm5haWxzLWluLW9yZGVyLWxpc3QtYmFjay1lbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.061 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)