I have a webshop with several products using custom options (using the Advanced Product Options extension from Mageworx). I need a way to show/export/report product orders with it's filled in custom options.
So what I need is a table/report showing an ordered product per row with the colomns: product sku, custom option 1, custom option 2, custom option 3.
It would be great if I could export it to csv. It would also be great if tou could order this table/report by custom options.
It's of great importance that all the ordered products show their filled in custom options. Overcoming this problem ([url removed, login to view]).
To add to the description:
It's for a website that sells tournament registrations (and barbecue registrations).
You can buy a registration for location A for a team playing 2x2 or buy a registration for location A for a team playing 4x4. You can do the same for location B. So far so good, all this are just seperate products with different SKU's.
Assigned to these products are custom options a customer has to fill in.
(I assign a custom product options template using the Magento extension Advanced Product Options by Mageworx. Basically what this does is you create templates with a couple of custom product options and assign those to a product. You could achieve the same result using normal custom options. This is just a time saver.)
For a team registration of 2x2 there are the options (Team gender: [man, woman, mixed]; Team Level: [high, medium, low]; Team name [field]; Player 2 name: [field]; Player 2 e-mail [field]. For a 4x4 team there are some options (with the same name, but different possible values)
There are also some other products using a couple of other custom product options.
So far so good, everything they fill in is shown in the order.
What I need is create a custom report for product orders (inside Magento admin reports>products>products ordered or something like that.)
See the added attachment.
- Every product order on a line (so if a customer orders two products at once these product orders should go on a seperate line.)
- The columns: product sku, product name, custom option 1, custom option 2 etc (these are just based on the name I give them.)
- Custom options (the names, not the values) that are the same should merge into one column
- if possible let me order the product orders by custom option.
- if possible let me export to csv.
It's very important that every value entered by the customer is shown. There seems to be a problem that custom options are only shown for one of the products, because of some group id problem? http://stackoverflow.com/questions/9273375/custom-product-options-in-magento-products-ordered-report