[Skip to main content](#vessel-content) # Showing All Products in an Easy-to-Scan Listing ## - **[cmb](/forum/user/9805-cmb "View cmb's Profile")** - [![cmb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9805-cmb "View cmb's Profile") Topic Author - [ Offline](/forum/user/9805-cmb) Less More - Posts: 46 - Thank you received: 6 - - 1 year 10 months ago [\#365087](#365087) by [cmb](/forum/user/9805-cmb "View cmb's Profile") *[Showing All Products in an Easy-to-Scan Listing](/forum/44-mass-actions/909002-showing-all-products-in-an-easy-to-scan-listing#365087 "-- HikaShop version -- : 5.1.2 -- Joomla version -- : 4.4.9 -- PHP version -- : 8.2.26 -- Browser(s) name and version -- : Firefox 133.0.3 -- Error-message(debug-mod must be tuned on) -- : none I'm working on a website with over 1,000 products. The business owner should be provided a full listing of all products in the database along with their characteristics, variants and prices. It would be an onerous task to proofread the entire catalog by visiting individual web pages; a summary listing can be perused more easily. My attempts at a Mass Action solution have been unsuccessful. (The HikaShop Export function works well for other purposes but doesn't render the suitable output for a quick scan by a human.) One solution suggested was the use of the plugin. Unfortunately a demonstration page for the plugin doesn't exist and I haven't been able to find a comprehensive demonstration of its features. What I am hoping for in the output are lines in a spreadsheet or PDF file that list the details of each product. An example: product_name Characteristic Variant price_value E36 M Technic Steering Wheel Black Alcantara fabric with black stitching White Alcantara $290.00 E36 M Technic Steering Wheel Black Alcantara fabric with black stitching No Stripe $265.00 E36 M Technic Steering Wheel Two-Tone Option White Alcantara $320.00 Is it possible to construct such a report using a Mass Action? If not, will the HikaSerial Massaction Display & Export plugin work as desired?")* was created by *[cmb](/forum/user/9805-cmb "View cmb's Profile")* -- HikaShop version -- : 5.1.2 -- Joomla version -- : 4.4.9 -- PHP version -- : 8.2.26 -- Browser(s) name and version -- : Firefox 133.0.3 -- Error-message(debug-mod must be tuned on) -- : none I'm working on a website with over 1,000 products. The business owner should be provided a full listing of all products in the database along with their characteristics, variants and prices. It would be an onerous task to proofread the entire catalog by visiting individual web pages; a summary listing can be perused more easily. My attempts at a Mass Action solution have been unsuccessful. (The HikaShop Export function works well for other purposes but doesn't render the suitable output for a quick scan by a human.) One solution suggested was the use of the [ HikaSerial Massaction Display & Export](https://extensions.joomla.org/extension/hikaserial-massaction-display-export-for-hikashop/) plugin. Unfortunately a demonstration page for the plugin doesn't exist and I haven't been able to find a comprehensive demonstration of its features. What I am hoping for in the output are lines in a spreadsheet or PDF file that list the details of each product. An example: | *product\_name* | *Characteristic* | *Variant* | *price\_value* | |---|---|---|---| | E36 M Technic Steering Wheel | Black Alcantara fabric with black stitching | White Alcantara | $290.00 | | E36 M Technic Steering Wheel | Black Alcantara fabric with black stitching | No Stripe | $265.00 | | E36 M Technic Steering Wheel | Two-Tone Option | White Alcantara | $320.00 | Is it possible to construct such a report using a Mass Action? If not, will the HikaSerial Massaction Display & Export plugin work as desired? --- Charles Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkwMDItc2hvd2luZy1hbGwtcHJvZHVjdHMtaW4tYW4tZWFzeS10by1zY2FuLWxpc3Rpbmc/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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 1 year 10 months ago [\#365088](#365088) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Showing All Products in an Easy-to-Scan Listing](/forum/44-mass-actions/909002-showing-all-products-in-an-easy-to-scan-listing#365088 "-- HikaShop version -- : 5.1.2 -- Joomla version -- : 4.4.9 -- PHP version -- : 8.2.26 -- Browser(s) name and version -- : Firefox 133.0.3 -- Error-message(debug-mod must be tuned on) -- : none I'm working on a website with over 1,000 products. The business owner should be provided a full listing of all products in the database along with their characteristics, variants and prices. It would be an onerous task to proofread the entire catalog by visiting individual web pages; a summary listing can be perused more easily. My attempts at a Mass Action solution have been unsuccessful. (The HikaShop Export function works well for other purposes but doesn't render the suitable output for a quick scan by a human.) One solution suggested was the use of the plugin. Unfortunately a demonstration page for the plugin doesn't exist and I haven't been able to find a comprehensive demonstration of its features. What I am hoping for in the output are lines in a spreadsheet or PDF file that list the details of each product. An example: product_name Characteristic Variant price_value E36 M Technic Steering Wheel Black Alcantara fabric with black stitching White Alcantara $290.00 E36 M Technic Steering Wheel Black Alcantara fabric with black stitching No Stripe $265.00 E36 M Technic Steering Wheel Two-Tone Option White Alcantara $320.00 Is it possible to construct such a report using a Mass Action? If not, will the HikaSerial Massaction Display & Export plugin work as desired?")* Hi, I don't see a way to output something exactly like this with any tools available in or around HikaShop. Supposing that products can have 0, 1 or several characteristics linked to them, it makes outputting a table like in your message impractical. For example, for a variant, the "product_name" of the variant is usually empty in the database, since HikaShop actually displays the "product_name" of the main product on the frontend. And if the product of the variant has 2 characteristics attached to it ( like color and shoe size in this example: [ demo.hikashop.com/index.php/en/hikashop/...with-characteristics](https://demo.hikashop.com/index.php/en/hikashop/product-page/with-characteristics) ), then you can't have just one "characteristic" column with one "variant" column. Also, the price of a variant might not be provided in the variant. In that case, the variant will inherit from the price of the main product on the frontend. And products and variants can each have several prices for different currencies or zones or user groups. All of this needs to be taken care of to output a clean table with relevant information. Not everything might apply to your situation, but that means that having a generic system to output exactly what you want is difficult. The best would be to develop a small plugin to output the data the way you need it. With the mass actions system: You could create a mass action with an action "display the results" with the columns "product_name", "price_value", and the characteristics you want to take into account: [ i.imgur.com/lZVEcxm.png](https://i.imgur.com/lZVEcxm.png) And that will output something like this once you press on the "process" button : [ i.imgur.com/nC6uZjG.png](https://i.imgur.com/nC6uZjG.png) You have first the product_name column, which contains the product_name of the product or variant of the row. So this can be empty if a variant doesn't have a product_name (which is usually the case). Then, you have the "price_value" column with the prices linked to the product / variant. This can also be empty if the variant inherits from the price of the main product. Then, you have one column for each characteristic. So, if you have many characteristics, you will have many columns there. The "HikaSerial Massaction Display & Export plugin" has nothing to do with what you want to do. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDkwMDItc2hvd2luZy1hbGwtcHJvZHVjdHMtaW4tYW4tZWFzeS10by1zY2FuLWxpc3Rpbmc/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.049 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)