Report with products

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.