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
-
Anonymous User
- RO CSVI
- Wednesday, 15 October 2025
- Subscribe via email
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!