[Skip to main content](#vessel-content) # Report with products ## - **[khashiz](/forum/user/61259-khashiz "View khashiz's Profile")** - [![khashiz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/61259-khashiz "View khashiz's Profile") Topic Author - [ Offline](/forum/user/61259-khashiz) Less More - Posts: 240 - Thank you received: 13 - - 3 months 1 week ago [\#372772](#372772) by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") *[Report with products](/forum/36-reports-statistics/910702-report-with-products#372772 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 Hi when i export sales report, i have the information of each order. how can i have the products bought on each order as well ? and is there any way that i can choose which columns to have in csv file ? now the report has all the info which lots of them is not needed. i want to have only the order id, customer namee, price and orders he/she bought for example thank in advance for your help")* was created by *[khashiz](/forum/user/61259-khashiz "View khashiz's Profile")* -- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 Hi when i export sales report, i have the information of each order. how can i have the products bought on each order as well ? and is there any way that i can choose which columns to have in csv file ? now the report has all the info which lots of them is not needed. i want to have only the order id, customer namee, price and orders he/she bought for example thank in advance for your help Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MTA3MDItcmVwb3J0LXdpdGgtcHJvZHVjdHM/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: 86323 - Thank you received: 14283 - - 3 months 1 week ago [\#372776](#372776) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report with products](/forum/36-reports-statistics/910702-report-with-products#372776 "-- HikaShop version -- : 6.5.2 -- Joomla version -- : 6.1.2 -- PHP version -- : 8.3 Hi when i export sales report, i have the information of each order. how can i have the products bought on each order as well ? and is there any way that i can choose which columns to have in csv file ? now the report has all the info which lots of them is not needed. i want to have only the order id, customer namee, price and orders he/she bought for example thank in advance for your help")* Hi, The sales report export is order based and its columns are fixed, so it cannot list the products of each order nor let you pick the columns. For what you want, use a Mass action with a CSV export instead, it lets you choose exactly the columns, and it can output the products of each order. Here is how to set it up: 1) In your HikaShop control panel, open the Mass actions page (System menu, Mass actions) and create a new one. 2) For the area (the table it works on), choose "Order". 3) In the "Actions" area, add an action and choose "Export a csv file". 4) The export action then shows the available columns as checkboxes, grouped by the Order, Order products, Address and User tables. Tick only the ones you need, for example: - Order: order_id (and order_full_price if you want the order total) - Address: address_lastname and address_firstname (the customer name) - Order products: order_product_name, order_product_price, order_product_quantity 5) Tick the "One product per row" option (it appears for the Order area). This is the key part: it exports one line per product of each order, so you get the products bought on each order instead of a single line per order. 6) Choose the format "CSV". You can leave the "Export path" and "To address" fields empty to simply download the file, or fill them to save it on the server and receive it by email. 7) Save the mass action, then run it with the "Process" button to generate and download the CSV. If you only want part of your orders (for instance a date range or a given status), add a filter to the mass action before processing and only the matching orders will be exported. The following user(s) said Thank You: [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MTA3MDItcmVwb3J0LXdpdGgtcHJvZHVjdHM/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.078 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)