Order & OrderDetails Database Shipping Fulfilment Reports
With Web Developer Suite, mySQL, and php…
Currently my eCart shopping area is completed and the Admin backend has the pages created for the report/detail/update/insert/search pages specific for one table or the other (orders & orderDetails).
Now I need to create reports for shipping and accounting that combine the customer order information from the two data base tables (orders & orderDetails) into one report. At this point I do not need graphic results, just show it on the screen and/or printed details. WebAssist probably has something in the works but I think it would be a fantastic additional module.
With our eCart up and running, we urgently need a report that can be used to prepare shipments. At the moment I am just writing it down manually so that we can keep up. Basically we need to know who ordered what. (Similar to a packing list or purchase order) For our purposes this could be a separate page for each customer order. I think that this might be the easiest to start with.
I am assuming this would involve using DataAssist to pull up the order with a repeating region for the order details? It might be similar to how I did the parents profile that shows the kids profiles under their account. I am not sure if this entry should be under eCart or DataAssist. What is my best approach and how would I proceed? Some clear direction is needed. Thank you.