Magento custom product order report with custom options

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

Kemahiran: Magento, MySQL, PHP

Lihat lagi: magento advanced product options sku report, magento custom order report, magento custom product order, magento order report, custom report magento orders, custom report order magento, custom ordered report magento, report products products ordered magento, magento products ordered report product, magento ordered product options report, custom options custom option sku, magento custom report sku, order product report magento, magento export orders custom options, product option order table magento, report custom option magento, custom magento report orders, products ordered report options, magento report orders products, magento custom order export, magento report show product custom options, magento report products ordered, tou, product sku, magento products export

Tentang Majikan:
( 1 ulasan ) Gouda, Netherlands

ID Projek: #1542903

Dianugerahkan kepada:


Hi please check pmb for my proposal.

$200 USD dalam 0 hari
(20 Ulasan)

4 pekerja bebas membida secara purata $231 untuk pekerjaan ini


Here are Magento Experts , please check Our Latest Magento work and Let me start your work , Thanks

$250 USD dalam 3 hari
(80 Ulasan)

Hello, we carry heavy experience in custom reports for Magento. Please check PMB for further details.

$250 USD dalam 4 hari
(38 Ulasan)

Hello, I had gone through your requirement and we are capable to do your project. For more detail information check your private message. Thanks

$225 USD dalam 5 hari
(0 Ulasan)