Categories
View Replies (2)

Resolved When exporting virtuemart orders, how can I make each order appear only once?

  1. loppis
    loppis
  2. RO CSVI
  3. Sunday, 05 January 2020
  4.  Subscribe via email
Hi!

Have tried all possible combinations I can come up with, but still haven't managed to solve this one :).

I'm on Joomla 3.9.14, VM 3.4.5 and CSVI 7.14.0 with updated plugins.

I need a list of all coupons used for a certain period. I chose the Virtuemart "Order" operation.

I only have these 3 fields :
virtuemart_order_id
discount_coupon
coupon_code

Still, each order appears on several lines (duplicates). I a customer ordered 10 products, the order appears on 10 lines.

I can see that this makes sense if I also chose to export data about the individual products, but this time I don't.

This is the result I'm getting now :
csv_1.png

But what I want is obviously this :
csv2.png

Any ideas what could be wrong here?

Truly grateful for your help :).

Thanks

Best wishes

Peter

EDIT : I also attached the template I'm using in the example above :).
Attachments (3)
csv_1.png csv_1.png
csv2.png csv2.png
csvi_templates_www.dietrecords.org_20200105.xml
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Have a look at Group by and Sort by fields document to avoid duplicates on export. As per your screenshot you should use virtuemart_order_id in group by fields. Let me know if that helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
loppis
loppis
Accepted Answer Pending Moderation
Wow, I had completely missed that feature.

Works great now.

Thanks for your quick reply :).

Best

Peter
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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