Resolved Order Expirt - item quantity

Hello,
Try using VirtueMart order items export and group by order_item_sku or virtuemart_product_id.

Hello,

I've tried different "group by" options but i don't get it to work.

Not sure which fields you have tried but in the same Virtuemart order export, did you try group by order_item_sku or virtuemart_product_id?

Hey Tharuna,

i tried both. But i think that the field product_quantity shows only how often the product was sold and not the amount of product sold.

Hello,

i tried both. But i think that the field product_quantity shows only how often the product was sold and not the amount of product sold.

I don't think thats correct, product_quantity is the count of a product ordered. To be more specific, i entered quantity as 4 in my cart for a product and that is saved in product_quantity in order items table. Which version of VirtueMart are you using?

Hello,
The problem could be because of grouping by fields, what if you group by virtuemart_order_id or order_number instead of order_item_sku and virtuemart_product_id?

I've tried grouping by both fields and did a lot of testing with other fields and combinations. I think that is not posible until a function is implemented to make a total of product_quantity

Hello,
You can create an Override file for export as explained in the link document and add your custom code to get the product_quantity field as needed.

Thanks for the reply Tharuna.

I will have a look at the template override. But i'm not good at programming.

The template files have been moved? Because directorys descripte doesn't exist...

Hello,

Calculating totals is not something CSVI can do. As CSVI is an export tool and not a reporting tool. You could run the export and do the calculations you want to do in a spreadsheet. In case you do you want to write a report function, you can create the override as mentioned by Tharuna.

The paths are located in plugins/csviaddon/virtuemart/com_virtuemart/model and there you will find the import and export routines. I have updated the document to reflect the new changes.