Download as Excel > Product List: Split Products into separate columns

I am researching Jotforms to be a potential e-commerce/ordering form for our small business, The Dinner Shoppe. The way our business is set up: We offer fully prepped meal kits by packages. The more meals someone orders (i.e. 3 meals, 6 meals, 12 meals), the better price they are getting. I really like the simplicity andlayouts of your forms but I am having trouble with a couple things.

1. I can't figure out how to make the total calculate accurately to provide a discount based on the amount of meals someone is ordering. For example, if someone orders between 1-3 meals in a certain serving size, the price would be x amount per meal and if they order 4-6 meals in a certain serving size, the price would be y amount per meal. Is there a way to do this? I've tried asking your AI but it seems to confuse quantity per meal vs. quantity per order.
2. It seemed like the best and easiest way to add all of our products was through the product list but that means when the order form is downloaded on excel, all products are in the same column. Is there a way to modify the table for the order forms so that each product has it's own column on an excel sheet?

Thank you. I am looking forward to your reply and hopefully being able to use your forms for our business.

Hi Kelseywinecoff,

Thanks for reaching out to JotForm Support. Your understanding is correct, the easiest way to conditinally give discounts are through Special Pricing. Are you working on this form? I see you've already enabled Special Pricing to meet your needs to conditionally provide a discount based on the amount of emails someone is ordering. As for the Product List being downloaded on Excel in the same column, I'm afraid there's no workaround available on our end, but you can play around with Excel's Split to Text function to be able to split different products in different columns.

Let me also escalate the idea of spreading the Product List selections in multiple columns in Excel to our developers as Feature Request.  Keep in mind, though, that exactly when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

Thanks for your patience and understanding, we appreciate it.