Converting all orders into an item fulfillment list

[apottruff]

I’m nearly done building a monthly subscription box ordering application, but I’m having trouble pulling all of the items sold from All Orders into a general “fulfillment list”.

Every order has a “List of Items Included In Subscription” (which renews monthly) as well as a “List of Add-On Items” (a-la-carte purchases).

I’m trying to create a section in my Admin Dashboard that shows a list of products and the quantity sold - ideally as a repeating group that I could filter by Month.

Any idea how I can accomplish pulling these items from the Order into a “fulfillment list”?

[cmarchan]

Perhaps consider adjusting your dB model to have a data-type called “line item”. This object would house the product, the qnty and the price. It could be the data source you need.