2

I have two channels, one called Product System (product_system) and one called Product Orders (product_orders). The product system contains all the products that the company produces and the product orders contains all the products ordered in a particular order. The two channels are linked by product_id relationship field in product_orders.

What I want to be able to do is to produce a product order spreadsheet, that allows me to show the orders in rows, the products in columns and the number of products ordered, in a particular order, in the related square in the grid.

The columns must be dynamic, so that if a new product is added, it automatically appears in the grid.

5
  • Are you using a relationship fieldtype to relate products to orders? Or is it just a text field? – Jason Varga Jan 23 '13 at 0:13
  • I would recommend that you rewrite this so that the question is explicit in the body of the question, and that you provide more details such as whether you are trying to display this data in the control panel or in a template. – UltraBob Jan 23 '13 at 1:23
  • Also, post what you've already tried. – Anna_MediaGirl Jan 23 '13 at 1:24
  • You should be able to do this with the query module a template (and maybe some PHP) but you'll need some SQL chops to write a query to stitch the data together. I suspect you're using EE2.x but if not I wrote a simple 'Reports' module for EE1.x which allows you to provide clients with a nice front end for SQL query based reports - it can also handle post processing on a query before serving up a CSV (github.com/ninefour/reports.mod.ee_addon). – Nathan Pitman Feb 14 '13 at 20:46
  • I wrote up a possible solution to this (Looping Through All Channel Fields) at expressionengine.stackexchange.com/a/5711/293 – Mark J. Reeves Feb 15 '13 at 2:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.