How to get better reporting (Excel/CSV) on products orders?

  • mendysas
    Asked on September 1, 2014 at 2:26 PM

    In the submissions report it combines all products in one field.

    As it is now, it is not possible to see how many of the same product were ordered.   All you see is that each order has multiple items in the same field.

    How can I get a report showing each product separately?

     

  • Mike_T Jotform Support
    Replied on September 1, 2014 at 3:36 PM

    Thank you for contacting us.

    You can either doubleclick on the product cell to wrap the text, or select the product cells and use the Excel Wrap Text option. In this way, you will get the products listed on their separate lines:

    How to get better reporting (Excel/CSV) on products orders? Image 1 Screenshot 20

    In case you would like to see a single product per cell, please consider a workaround from the following thread:

    Separating payment info or products into each column

    I will also attach a feature request ticket to see if we can add some improvements in order to avoid these extra manipulations with the Excel reports.

    We will let you know if we have any updates on this.

  • alp_deniz
    Replied on September 2, 2014 at 4:49 PM

    Hello,

    You may also like to try JotForm's visual reports to see which products or answers were chosen. Creating is possible via forms->reports->visual reports.

    Thanks!