Hi Roland, is it possible to export the number of products sold in a certain period?
I was trying to do this with the order export option (order_item_sku, order_item_name, product_quantity).
If I don't group the fields by sku, I get the correct product_quantity for each sale.
But when I group the fields, I only get the product_quantity for the last order.
I need the product_quantities added up, can I do that in CSVI?
Hello,
is it possible to export the number of products sold in a certain period?
That should be possible because on the order export you have the product_quantity field and you can filter the export for a specific period.
But when I group the fields, I only get the product_quantity for the last order.
In that case your ordering is incorrect and I don't think you can use any real grouping here other than order ID because each item has a different quantity.
I need the product_quantities added up, can I do that in CSVI?
No it can't, CSVI isn't a reporting tool :) You will need to use a spreadsheet to get those numbers.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Too bad but thanks!
Log in to reply to this topic.