How do I separate my ordered items on reports?

  • smcfarlane
    Asked on July 8, 2020 at 3:38 PM

    I need item breakdowns by color and quantity of individual items. 

    Is there away to pull that data? Each time I download the report (excel or CSV) it keeps the order information in one cell. I need a way to break out each item a customer ordered so I can create a master inventory list. 

    When I build a report I am only able to view the overall quantity of an item that was ordered (example 100 tshirts) - how to I break out the information to see the quantity by size and color? 

  • Amin JotForm Support
    Replied on July 8, 2020 at 6:10 PM

    The way orders are received and stored as submissions makes what you're after not possible. All respondent's orders are received as a one field submission, as it's only one order field on form.

    If you were using a different method by creating one field per order, you would easily achieve what you have in mind.

    That said, unfortunately, there's no way to aggregate how many times product X is ordered.

    You may try ditching the payment/order field entirely, then adding normal form fields and widgets such as drop-down, Inventory Widget, text input, etc.

    Then, use the Calculation widget to calculate total price of all products selected within fields. Total Price can then be passed to Payment Integration.

    Related guide: How-to-Pass-a-Calculation-to-a-Payment-Field

    If that's somehow still unclear, please inform us and we will make you a demo form to clear it all up.