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?
Accepted Answer
Pending Moderation
Hello,
You will need to use a spreadsheet to get those numbers.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!