Categories
View Replies (1)

Resolved Export VM order items, using group by, not showing correct total product_quantity

  1. New
  1. Anonymous User
  2. RO CSVI
  3. Wednesday, 15 October 2025
  4.  Subscribe via email
Hi,

I am trying to export VM order items, and I am using group by to combine order_item_sku to show the total product_quantity per sku.
Unfortunately, this is not giving the right quantity, because individual orders can have line items with quantity > 1.
Example records:
order_number order_status_name order_item_sku order_item_name product_quantity product_item_price
2025-02-23-000074 Shipped HT-6513 Tachometer Plug 2 8,26 € 16,52
2025-02-28-000104 Shipped HT-6513 Tachometer Plug 1 8,26 € 8,26

Example output using group by on order_item_sku. It counts 2, but it should show 3?
HT-6513 Tachometer Plug 2 8,26

Basically, I need to have an overview: unique products shipped, showing the product name, quantity, and product_item_price.
Any idea how to solve this?

Kind regards, Paul
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Paul,
Example output using group by on order_item_sku. It counts 2, but it should show 3?

Group by and Sort by are not used to find the total of any data. They are used to avoid duplicates in export or sort export data based on selected field. There is no option in RO CSVI to find the total of any column. You can either create an override for export or write a custom rule plugin to write custom code to do the total.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 12 hours ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!