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

  • Profile Image
    Asked on September 01, 2014 at 02: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?


  • Profile Image
    Answered on September 01, 2014 at 03: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:

    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.

  • Profile Image
    Answered on September 02, 2014 at 04:49 PM


    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.