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


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