How do I separate my ordered items on reports?

  • Profile Image
    smcfarlane
    Asked on July 08, 2020 at 03: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? 

  • Profile Image
    Amin
    Answered on July 08, 2020 at 06: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.